aging formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a formula that will calculate the "age" of a an entry.
Each entry will have an open date. And eventually a closed date. I would like
to be able to calculate the age, by comparing the open date and the closed
date, and if their is no closed date then compare the open date to todays
date. Thanks
 
Super! thanks. One more question, can I tweak that formula to return no data
if A1 and B1 are blank. reason being I will be averaging the case ages. And
if both cells are blank it returns 39185. I may be asking too much. but
thanks again
 
I have another question regarding this formula. I am having a similar issue if (A1 Has the date but B1 is empty the field shows 40548 is there an addition to this formula to make the field blank if only the start date has been input but not the end date?

Thanks in addvance.

Dan
 
I have another question regarding this formula. I am having
a similar issue if (A1 Has the date but B1 is empty the
field shows 40548 is there an addition to this formula to
make the field blank if only the start date has been input
but not the end date?

The following computes elapsed time only if __both__ start and end
dates are specified:

=IF(OR(B1="",A1=""),"",B1-A1)

formatted as Date.

PS: It is unwise to append a new question to an old discussion,
especially one that is nearly 4 years old. Most people will not even
see it. Just start a new discussion, and copy anything relevant from
the old discussion into yours.
 
Back
Top