How to flag overdue dates
✓ Verified in LibreOffice 25.8.7.3Mark rows whose due date has passed — invoices, tasks, renewals.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =IF(A2<TODAY(),"Overdue","OK") | Days overdue as a number: =MAX(0,TODAY()-A2). |
| Google Sheets | =IF(A2<TODAY(),"Overdue","OK") | Identical. |
| LibreOffice Calc | =IF(A2<TODAY(),"Overdue","OK") | Identical. |
How it works
Dates compare like numbers, so due-date < today means the deadline has passed (the verification pins both dates so the result never changes; in your sheet use TODAY(), which keeps the flags current every day). Useful refinements: MAX(0,TODAY()-A2) counts days overdue without going negative for future dates, a "Due soon" tier is IFS(A2<TODAY(),"Overdue",A2<=TODAY()+7,"Due soon",TRUE,"OK"), and blank due-dates need an IF(A2="","",...) guard so empty rows don't all read Overdue.
Verified, not just documented
We ran =IF(DATE(2026,7,1)<DATE(2026,7,23),"Overdue","OK") in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned Overdue — exactly the expected result. Every formula here is confirmed by actually executing it.