BeginnerDate & Time
Assemble a delivery date with DATE
Turn separate year, month and day columns into a real date Excel understands.
DATE
5 min15 points
Find month-end due dates with EOMONTH
The situation
Harbor Supply invoices its trade customers on end-of-following-month terms: an invoice dated any day in September is due on 31 October. The accounts team has been adding 30 days, which lands early in short months and late in long ones, and two customers have queried their statements. The due date has to be a real month end.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Invoice | Invoice date | Due date | ||
| 2 | INV-3401 | Sep 14, 2026 | |||
| 3 | INV-3402 | Sep 28, 2026 | |||
| 4 | INV-3403 | Oct 5, 2026 | |||
| 5 | INV-3404 | Oct 19, 2026 | |||
| 6 |
Functions in this exercise
- EOMONTH — Returns the last day of the month a given number of months from a date. Syntax and example
Who this is for
Recommended next
Related exercises
- BeginnerDate & Time
Assemble a delivery date with DATE
Turn separate year, month and day columns into a real date Excel understands.
DATE
5 min15 points - IntermediateDate & Time
Flag overdue invoices with IF and TODAY
Combine date arithmetic with a conditional label.
IF · TODAY
9 min25 points - BeginnerDate & Time
Count complete years of service with DATEDIF
Turn a start date and a review date into whole years, the way HR counts them.
DATEDIF
5 min15 points