IntermediateDate & Time
Flag overdue invoices with IF and TODAY
Combine date arithmetic with a conditional label.
IF · TODAY
9 min25 points
Calculate invoice age with TODAY
The situation
Harbor Supply's collections team chases anything over 30 days. They need the age of each open invoice, updated automatically each morning.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Invoice | Invoice date | Days open | ||
| 2 | INV-3301 | Jun 30, 2026 | |||
| 3 | INV-3302 | Jul 17, 2026 | |||
| 4 | INV-3303 | Aug 1, 2026 | |||
| 5 | |||||
| 6 |
Functions in this exercise
- TODAY — Returns the current date, updating each time the sheet recalculates.