# EDATE function in Excel

> EDATE returns the date a given number of months before or after a start date, keeping the same day of the month.

Source: https://spreadsheetpractice.com/functions/edate · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** EDATE returns the date a given number of months before or after a start date, keeping the same day of the month.
- **Syntax:** `=EDATE(start_date, months)`
- **Most common use:** `=EDATE(B2,C2)` returns 2/28/2026 (January 31 plus one month stops at February 28)
- **Available in:** Every current version
- **Category:** [Date functions](https://spreadsheetpractice.com/functions/category/date)
- **Returns:** A date serial number. Format the cell as a date.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

EDATE returns the date a given number of months before or after a start date, keeping the same day of the month. It is the right tool for contract end dates, renewal dates and payment schedules. When the target month is shorter, it returns that month's last day instead of spilling into the next month.

## Syntax

`=EDATE(start_date, months)`

| Argument | Required? | What it is |
|---|---|---|
| `start_date` | Required | The date to count from. |
| `months` | Required | How many months to move. Negative numbers go back in time. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| E2 | `=EDATE(B2,C2)` | 2/28/2026 | January 31 plus one month stops at February 28 |
| E3 | `=EDATE(B3,C3)` | 3/15/2027 | Twelve months later, same day: March 15, 2027 |
| E4 | `=EDATE(B4,C4)` | 5/1/2026 | A negative number moves back three months |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Contract | Start | Months |  | Result |
| 2 | Acme | 1/31/2026 | 1 |  | 2/28/2026 |
| 3 | Birch | 3/15/2026 | 12 |  | 3/15/2027 |
| 4 | Cobalt | 8/1/2026 | -3 |  | 5/1/2026 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Adding 30 days instead of a month | Start date + 30 drifts away from the same day each month. EDATE(start, 1) keeps the day aligned. |
| A five-digit number instead of a date | Format the cell as a date; EDATE returns a serial number. |
| Months typed as a decimal | EDATE drops the decimal, so 1.5 months counts as 1. Use whole months, or add days separately. |

## Tips

- Use EDATE(A2, 12*B2) to move a whole number of years in B2.

## Related functions

- [EOMONTH](https://spreadsheetpractice.com/functions/eomonth): EOMONTH returns the last day of the month a number of months before or after a date.
- [DATE](https://spreadsheetpractice.com/functions/date): DATE builds a real date from a year, month and day.
- [WORKDAY](https://spreadsheetpractice.com/functions/workday): WORKDAY returns the date a given number of working days before or after a start date, skipping weekends and any holidays you list.

## Questions

### How do I add months to a date in Excel?

Use =EDATE(A2,3) to add three months. Use a negative number, like -3, to subtract months.

### What does EDATE do with January 31 plus one month?

It returns February 28 (or 29 in a leap year) because February has no 31st.

### How is EDATE different from EOMONTH?

EDATE keeps the day of the month. EOMONTH always returns the last day of the target month.

## Practice

A graded EDATE exercise ("Contract end dates") is on [the EDATE page](https://spreadsheetpractice.com/functions/edate). It is checked instantly, then re-checked on changed data.

Lessons that use EDATE:

- [Lesson 24: EDATE, EOMONTH & NETWORKDAYS](https://spreadsheetpractice.com/learn/edate-eomonth-networkdays) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
