DATEDIF when second date might be blank

**aaronfly** · 07-01-2010, 12:30 PM

I have a spreadsheet for issues where there is an open date (B3) and close date (C3). I want to calculate the date difference between these two dates (D3) in days. Until the issue is closed, C3 will be blank. I have =DATEDIF(B3,TODAY(),"d") for the instance where C3 is blank and I have =DATEDIF(B3,C3,"d") for the instance where C3 has a date, but I would like 1 formula that would incorporate both circumstances.

Any help is appreciated.

**2Busy** · 07-01-2010, 12:43 PM

Please Login or Register  to view this content.

Note that TODAY() is volatile. It is best to avoid having volatile functions in many cells. If that is in more than ~1250 cells then your calculation times will suffer. You may want to just display N/A or something like that (Open, or Not Closed).

Please Login or Register  to view this content.

Looks like you may be missing some right hand parentheses, too.

**jvcolina14** · 03-14-2015, 02:27 PM

Hi, same proble As i have. I hope someone can help me. Im replying an old thread

My Spreadsheet

I have 2 dates
Date Received (E4)
Date Dispatch (G4)

As usual I want to know how many days being open if G4 is a blank cell. the formula is on H4.

what is the formula.?

what i have is =IF(G4="",E4,DATEDIF(E4,G4,"d")) but the input date is not in days. its a Date.

pleas help me.

Thanks.

**bebo021999** · 03-14-2015, 02:34 PM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.