EDATE, EOMONTH & WORKDAY practice exercises
5 graded problems with realistic data, from easy to medium.
Three ways to move a date forward or back by whole months, or by a number of working days. The 5 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.
New to the function? Read the EDATE, EOMONTH & WORKDAY guide first: syntax, a worked example and the mistakes people make.
In this set
- Find a subscription's renewal date, one year out
- Find next month's due date when this month ends on the 31st
- Find the last day of the current reporting month
- Find the end of the billing period, two months ahead
- Find a project deadline, 10 working days out
The exercises
A yearly subscription started on the date below. Find the date it renews, exactly 12 months later.
| A | B | |
|---|---|---|
| 1 | Start date | 2026-03-15 |
| 2 | ? |
Enter a formula in A2.
Show a hint
EDATE(start_date, months) moves a date forward (or back, with a negative number) by a number of whole months: =EDATE(B1,12).
EDATE is the right tool for "the same day, N months later": renewals, lease terms, and recurring billing all run on this, not day-counting.
A credit card bill is due on the date below, the last day of January. Find next month's due date: February is shorter, so EDATE will need to land on its last real day instead.
| A | B | |
|---|---|---|
| 1 | This month's due date | 2026-01-31 |
| 2 | ? |
Enter a formula in A2.
Show a hint
EDATE(start_date, months) moves forward by whole months. When the target month is shorter, it lands on that month's last real day instead of an invalid date: =EDATE(B1,1).
A date like the 31st does not exist in every month. EDATE handles that automatically by clamping to the real last day, so a formula built on it never produces an impossible date.
A report needs the last calendar day of the month that this date falls in, as a cutoff for including transactions.
| A | B | |
|---|---|---|
| 1 | Any date in the month | 2026-02-09 |
| 2 | ? |
Enter a formula in A2.
Show a hint
EOMONTH(start_date, 0) returns the last day of the same month as start_date; and correctly knows February 2026 has 28 days: =EOMONTH(B1,0).
EOMONTH is the standard way to get "end of this month" without hardcoding 28, 29, 30, or 31; it always gets the real last day right, leap years included.
A quarterly billing cycle closes at the end of the month, two months after the start date below. Find that closing date.
| A | B | |
|---|---|---|
| 1 | Quarter start | 2026-07-10 |
| 2 | ? |
Enter a formula in A2.
Show a hint
EOMONTH(start_date, months) moves forward (or back) by whole months first, then returns that month's last day: =EOMONTH(B1,2).
Billing, lease, and reporting periods are almost always defined as "end of some month N months out": EOMONTH is built for exactly that phrase.
A project kicks off on the date below. Find the deadline exactly 10 working days later, skipping weekends.
| A | B | |
|---|---|---|
| 1 | Kickoff date | 2026-10-05 |
| 2 | ? |
Enter a formula in A2.
Show a hint
WORKDAY(start_date, days) steps forward by working days only, skipping Saturdays and Sundays: =WORKDAY(B1,10).
WORKDAY is NETWORKDAYS in reverse: NETWORKDAYS counts working days between two dates, WORKDAY finds the date that is N working days away; the pair covers most real deadline math.
Solve these in a real grid
Type your formula, get graded instantly. Your first 10 exercises are free, no signup.
Start the EDATE, EOMONTH & WORKDAY exercises →