IntermediateDate & Time
Calculate invoice age with TODAY
Work out how many days old each invoice is.
TODAY
8 min25 points
Flag overdue invoices with IF and TODAY
The situation
Rather than reading day counts, Harbor Supply's collections team wants a clear Overdue or Current flag on the aged debt report.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Invoice | Invoice date | Days open | Status | |
| 2 | INV-3301 | Jul 16, 2026 | 30 | ||
| 3 | INV-3302 | Jun 30, 2026 | 46 | ||
| 4 | INV-3303 | Aug 1, 2026 | 14 | ||
| 5 | |||||
| 6 |
Functions in this exercise
Who this is for
Recommended next
Related exercises
- IntermediateDate & Time
Calculate invoice age with TODAY
Work out how many days old each invoice is.
TODAY
8 min25 points - IntermediateLogical Functions
Approve orders with AND
Require two conditions to be true at once.
IF · AND
8 min25 points - BeginnerLogical Functions
Flag reps below target with IF
Use IF to label each rep as meeting or missing their target.
IF
5 min15 points