Calculating Dates :-( Help Plz

[jmmarsh]

I have a "boss" request I can't solve in a very large spreadsheet.

We put "Date Opened" when a project is opened in one column. He wants the amount of days it's been opened calculated by the current date in another column (I did something like this.... =DATEDIF(F12,NOW(),"d"). However, when a "Date Closed" has been entered in another column, he wants it to calculate the time between Date Opened and Date Closed at that time. I can't seem to figure out how to make it switch to Date Closed from Current Date in the calculation.

*help* ?



Date Opened
4/19/02

Days Open
18

Date Closed

 

[IML]

assuming open date in A2, and closed date (if any) in B2, you could use
=IF(ISBLANK(B2),TODAY()-A2,B2-A2)

and format as general.

Good luck

 

[jmmarsh]

Thank you so much!!! I'm saved!