Merge 2 functions - DATEDIF and IF ...

[steve4787]

Excel Date.jpg

Greetings,

I have two formulas that partially do what I want them to do, but can't figure out how to combine the two formulas to get the result I'm looking for.

Open Date I Closed Date I Days Open

First formula =DATEDIF(A1,B1,"d") Problem with this formula is a date has to be in cell B1 to function correctly, or else will get #NUM!.
Other formula =IF(A1="","",TODAY()-A1) Gives me a count of open days and will stay blank if cell A1 is empty, but if I put a closed date in cell B2, it's not going to have any effect on the Days Open cell.

What I want to happen is the ongoing count of days open, but when I add a closed date, then the count stops there.

I hope that makes sense and would love to here what the solution is.

Thanks

Steve

[NBVC]

Maybe?

=IF(B1="",IF(A1="","",TODAY()-A1),B1-A1)

[steve4787]

NBVC,

Yep, that did the trick!

Thank you!