Calculating Dates :-( Help Plz

jmmarsh · May 7th, 2002, 02:35 PM

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 · May 7th, 2002, 02:39 PM

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 · May 7th, 2002, 02:44 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 02:35 PM	#1
jmmarsh New Member Join Date: May 2002 Posts: 32	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

May 7th, 2002, 02:39 PM	#2
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	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

May 7th, 2002, 02:44 PM	#3
jmmarsh New Member Join Date: May 2002 Posts: 32	Thank you so much!!! I'm saved!