Forum Discussion
Formulas and Functions
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.
That fixed it, however, now it's showing a negative number on those that are not due yet... I don't think he'll like that. 😞
Is there a way to fix that too?
You certainly are a HUGE help!
- This is perfect - thank you!