Formula Help

  • Thread starter Thread starter Jay Gustafson
  • Start date Start date
J

Jay Gustafson

Hello,

Ok, here's the set up.

A1:C1 = Status, Date Started, Elapsed

Values the status column can have are: Saved, Lost, Pending, n/a.

In the elapsed column, I want to know how many days have elapsed from the date started column. BUT..., if the status is saved or lost, I want the elapsed column to have ' -- ' as a value.

I'd apprecaite any help on this, thank you
Jay
 
Thank you Jim.

I had posted another question to the forum. It took your formula below, but
I need it revised so that if cell B1 does not contain a date, then it will
not return an error value (#######).

I didn't realize this would happen until I seen it. Other than that small
problem, it works beautifully. I love it. And thank you very much for
helping me out.
 
Jay,

Put this in c1:

=IF(OR(A1="Saved",A1="lost")," -- ",IF(B1=0,"",NOW()-B1))

I just added a check to see if b1 is blank.

Ji
 
Back
Top