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 have the Due Date in another column (K).
I have a column to record the date when the report is completed (J).
I am currently calculating the number of days it took to complete the report in a column (L), and I now need to calculate the number of days a report is past due if there is no date recorded in the Due Date column OR if the number of days it took to complete the report is greater than 60.
Is this possible?
Here's a screenshot of the current columns.
Any help would be appreciated!
Thanks
10 Replies
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.
