At the time of this writing, the date is May 20, 2023.
In Excel’s date system, this is the number 45066.
The due date of March 30, 2023, is the number 45015.
We do this by checking the Paid column for an “x” as seen below.
At this point, we have not provided anything for the value if false.
This means the IF function will return FALSE when F5 is empty.
It will look like an empty cell.
IF overdue
The remaining task is to check the age of the invoice.
Notice the value 31 is a number and, therefore, not enclosed in quotes.
This number can be customized as desired.
The final step in the problem is to combine the two IF formulas above.
Else if E5 is less than 31, return “OK”, else return “Overdue”.
More than one condition can be tested by nesting IF functions.
The TODAY function takes no arguments.
you’re able to format the value returned by TODAY with a datenumber format.
If you need current date and time, use…
Related videos
The IF function
