Excel practice · Dates & Arrays

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

  1. Find a subscription's renewal date, one year out
  2. Find next month's due date when this month ends on the 31st
  3. Find the last day of the current reporting month
  4. Find the end of the billing period, two months ahead
  5. Find a project deadline, 10 working days out

The exercises

1. Find a subscription's renewal date, one year out Medium

A yearly subscription started on the date below. Find the date it renews, exactly 12 months later.

AB
1Start date2026-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.

2. Find next month's due date when this month ends on the 31st Medium

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.

AB
1This month's due date2026-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.

3. Find the last day of the current reporting month Easy

A report needs the last calendar day of the month that this date falls in, as a cutoff for including transactions.

AB
1Any date in the month2026-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.

4. Find the end of the billing period, two months ahead Medium

A quarterly billing cycle closes at the end of the month, two months after the start date below. Find that closing date.

AB
1Quarter start2026-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.

5. Find a project deadline, 10 working days out Medium

A project kicks off on the date below. Find the deadline exactly 10 working days later, skipping weekends.

AB
1Kickoff date2026-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 →

More dates & arrays practice

All Excel practice exercises · Excel test prep