Hello everyone, new to the forum and somewhat new to Excel. I'm creating a spreadsheet to track my files and need some help with these functions. As you can see on the "Case Manager" sheet, I've created a column to track the "Days Since Last Activity." The formula is [=DAYS360(K4,L4)]. I've also added conditional formatting to color code it for quick visual reference.
My problem is that when I add a new row for a new file, there is no date for the [=DAYS360(K4,L4)] formula so it returns a large number and the cell is red. I would like to make it so that the cell is blank until a date is added for reference. Is this possible?
Thanks for any help and guidance.
Last edited by m.arce; 06-30-2011 at 10:48 AM.
Hello & Welcome to the Board,
In M8 try...
=IF(COUNT(K8,L8)=2,DAYS360(K8,L8),"")
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
Works perfect! Thank you. Now to actually learn what you did, could break it down for me... That way i don't come back on and ask the same silly question in the future..Originally Posted by jeffreybrown
You're welcome and thanks for the feedback
Basically I am asking for a count of K8 and L8, which if both filled would be two, but since one was empty it does not equal two so it returns nothing.
The best way to understand the formula can sometimes be from evaluting the formula.
Highlight the formula >> Formulas tab >> Formula Auditing >> Evaluate formula.
Now just step through the formula to see it break down for you step-by-step
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks