IntermediateDate & Time
Calculate invoice age with TODAY
Work out how many days old each invoice is.
TODAY
8 min25 points
Assemble a delivery date with DATE
The situation
A supplier's export splits every delivery date across three columns. Excel treats them as three unrelated numbers, so nothing sorts and nothing can be compared to today. They need assembling into a single date before the schedule is any use.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Year | Month | Day | Delivery date | |
| 2 | 2026.00 | 10.00 | 15.00 | ||
| 3 | 2026.00 | 10.00 | 22.00 | ||
| 4 | 2026.00 | 11.00 | 3.00 | ||
| 5 | 2026.00 | 11.00 | 18.00 | ||
| 6 | 2026.00 | 12.00 | 1.00 | ||
| 7 |
Functions in this exercise
- DATE — Builds a date from separate year, month and day values.