Flag overdue tasks
Mark a row as Overdue when its due date has passed and it is not done.
The formula
Excel and Google Sheets
=IF(AND(C2<>"", C2<TODAY(), D2<>"Done"), "Overdue", "")How it works
C2<>""Skip rows with no due date.
C2<TODAY()The due date is before today. TODAY() updates every day.
D2<>"Done"And the status is anything other than Done.
Example
| C: Due | D: Status | E: Result |
|---|---|---|
| 2026-01-10 | Open | Overdue |
| 2026-01-10 | Done | |
| 2099-12-31 | Open |
Tips
- Pair it with a conditional formatting rule like =$E2="Overdue" to colour the whole row.