Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to flag overdue dates in Excel and Google Sheets
Topic:Date arithmeticExcel & Google Sheets
=IF(TODAY()>A2, "Overdue", "OK")Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1A2 holds the due date.
- 2TODAY() is always the current date, so the check stays live.
- 3IF returns "Overdue" when the date has passed and "OK" otherwise.
Tips
- Guard blank cells: =IF(A2="", "", IF(TODAY()>A2, "Overdue", "OK")).
- Conditional formatting can colour overdue rows red instead of labelling them.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
How do I flag dates due within the next 7 days?
Compare to TODAY()+7: =IF(A2<=TODAY()+7, "Due soon", "OK"), optionally nested with the overdue check.
More on Date arithmetic
See all →Reference
TODAY / DATEDIF
Work with the current date and measure the gap between two dates.
How-toHow to calculate age from a date of birth
Calculate completed years at an explicit as-of date with DATEDIF and numeric DATE inputs, avoiding ambiguous date text and changing examples.
ReferenceDATEDIF
Calculates the difference between two dates in years, months, or days using a unit code string.
How-toHow to calculate days between two dates
Subtract one date from another to get the number of days, or count working days with NETWORKDAYS. Works in both apps.
How-toHow to add months to a date
Shift a date forward or back by a number of months with EDATE — it handles month lengths correctly. Works in both apps.
How-toHow to calculate age from a birthday
Use DATEDIF with TODAY() to calculate a person's exact age in years from a birth date cell in Excel and Google Sheets.