Forum Discussion
Formulas and Functions
I have the following information on a log sheet and I need to calculate the amount of days a report is Past Due based on a few criteria. I have the date information was SENT in one column (I). ...
I actually figured it out, but I think your formula is cleaner, except I'd like it to be blank if there's no date in K. Can you tell me how to add that?
Also, if it's not too much trouble, could you type out what the function means and is doing to help me learn?
Thanks SO MUCH for your help!
=IF(K2="","",MAX(IF(J2="", TODAY(), J2)-K2, 0))
The formula subtracts K2 from J2, unless J2 is blank, then it subtracts K2 from today's date.
Hi! I guess after my boss reviewed it he'd like one more change that I don't know how to make.
Right now, it's calculating the Days Past Due even after the report has been completed. Is there a way to NOT calculate this or display a "0" if there is a date in column J?
I appreciate your help.
- This is perfect - thank you!