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
Last edited by NBVC; 01-14-2012 at 10:03 PM.
Maybe?
=IF(B1="",IF(A1="","",TODAY()-A1),B1-A1)
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
NBVC,
Yep, that did the trick!
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks