EDATE Function

Returns the same day a given number of months before or after a date.

Category

Date & Time

Available in

All versions, Microsoft 365

Returns

A date (serial number)

Taught hands-on in Level 3: Intermediate Lookups & Data Summaries · Dates & Times module

Overview

EDATE moves a date forward or back by whole months — perfect for renewal dates, maturity dates and payment schedules.

When the target month is shorter, EDATE lands on its last day: one month after January 31 is February 28.

Syntax

=EDATE(start_date, months) Explain

Arguments

ArgumentRequired?What it does
start_dateYesThe date to start from.
monthsYesMonths to move: positive for later, negative for earlier. Decimals are cut off.

Examples

Example 1 — Contract renewal dates

Add each contract's term in months to its start date.

C2fx=EDATE(A2,B2)
ABC
1StartMonthsRenews
21/31/202612/28/2026
33/15/202669/15/2026
43/15/2026-312/15/2025
=EDATE(A2,B2) Explain

Example 2 — One year from today

Twelve months on from the current date.

=EDATE(TODAY(), 12) Explain

Common mistakes

  • The result shows as 46096. EDATE returns a serial number. Format the cell as Short Date.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.