Level 2DatesPractice, 2 min
EOMONTH: due at the end of next month
The task
Invoices are due on the last day of the month after they're sent. In C2, use
EOMONTH to find the due date for the invoice dated B2.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | |
|---|---|---|---|
| 1 | Invoice | Sent | Due |
| 2 | INV-3307 | Feb 11, 2026 | |
| 3 | INV-3308 | Feb 27, 2026 |