Thanks:  0
Likes:  0

# Thread: Calculating Dates :-( Help Plz

1. 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

2. 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

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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•