Exercises / Dates and deadlines · 5 of 10
Due at the end of next month
EOMONTH(start, months) returns the last day of a month: 0 for the same month, 1 for next month, -1 for last month. Finance teams use it for month-end deadlines and timelines.
Your taskInvoices are due on the last day of the month after they are issued. In C2, use EOMONTH to return the due date for the issue date in B2. It will be copied down to C7.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C |
|---|---|---|---|
| 1 | Invoice | Issued | Due |
| 2 | INV-201 | 12 Jan 2026 | |
| 3 | INV-202 | 31 Jan 2026 | |
| 4 | INV-203 | 3 Feb 2026 | |
| 5 | INV-204 | 18 Jun 2026 | |
| 6 | INV-205 | 30 Aug 2026 | |
| 7 | INV-206 | 1 Nov 2026 |