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)
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
| Argument | Required? | What it does |
|---|---|---|
| start_date | Yes | The date to start from. |
| months | Yes | Months 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)
| A | B | C | |
|---|---|---|---|
| 1 | Start | Months | Renews |
| 2 | 1/31/2026 | 1 | 2/28/2026 |
| 3 | 3/15/2026 | 6 | 9/15/2026 |
| 4 | 3/15/2026 | -3 | 12/15/2025 |
=EDATE(A2,B2) Explain
Common mistakes
- The result shows as 46096. EDATE returns a serial number. Format the cell as Short Date.
Notes

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.