Donate SIGN UP

Excel Formula Help

Avatar Image
andyGTBristol | 16:00 Wed 24th Feb 2016 | Technology
1 Answers
Hello, I have a spreadsheet in Excel 2010 with due dates in column L, what formula could I use in column M to display an alert when the date is past due / no date is entered.

ie due date in cell L4 is 23/02/16 - Cell M4 shows overdue ?

This is probably glaringly simple but I jest can't get my head round it today.

Gravatar

Answers

Only 1 answerrss feed

Best Answer

No best answer has yet been selected by andyGTBristol. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
In M4:

=IF(TODAY()>L4,"Overdue","")

Only 1 answerrss feed

Do you know the answer?

Excel Formula Help

Answer Question >>