What it does
=EDATE(A2,12) gives the date one year after A2 and =EDATE(A2,-3) the date three months before it. The day number is kept: 15 March plus 2 months is 15 May. That is why adding 30 days to move a month is wrong; months have different lengths.
If the target month has no such day, its last day is used: 31 January plus 1 month gives the last day of February. The result is a date serial number; if the cell is not formatted as a date, you see a number such as 46387.
To go to the end of a month use EOMONTH, to add days just add them, and to add working days use WORKDAY. To build a date from parts, there is DATE.
Syntax
=EDATE(start_date, months)=SERİTARİH(başlangıç_tarihi; ay_sayısı)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
start_date | Required | The date, or the cell holding the date, to add months to. |
months | Required | The number of months to add; a negative number goes back. Any decimal part is dropped. |
Examples
1A contract's end date and last valid day
Column D adds the term in months to the start date. Column E subtracts 1 day from that and gives the contract's last valid day.
=EDATE(B2,C2)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Contract | Start | Term (Months) | End | Last Day |
| 2 | CT-101 | 1-Jan-2026 | 12 | 1-Jan-2027 | 31-Dec-2026 |
| 3 | CT-102 | 15-Mar-2026 | 6 | 15-Sep-2026 | 14-Sep-2026 |
| 4 | CT-103 | 31-Aug-2025 | 18 | 28-Feb-2027 | 27-Feb-2027 |
| 5 | CT-104 | 5-Nov-2026 | 24 | 5-Nov-2028 | 4-Nov-2028 |
- D2 (filled down to D5)
=EDATE(B2,C2) - E2 (filled down to E5)
=EDATE(B2,C2)-1
The 12-month contract starting on 1 January ends on 1-Jan-2027, and its last valid day is 31-Dec-2026. Eighteen months after 31 August lands in February, so the last day of that month is used: 28-Feb-2027.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2A six-monthly service date with a reminder a month before
Column C adds 6 months to the last service. Column D goes back with a negative number of months and gives the reminder date one month before the next service.
=EDATE(B2,6)| A | B | C | D | |
|---|---|---|---|---|
| 1 | Machine | Last Service | Next Service | Reminder |
| 2 | Compressor | 31-May-2026 | 30-Nov-2026 | 30-Oct-2026 |
| 3 | Forklift | 14-Aug-2026 | 14-Feb-2027 | 14-Jan-2027 |
| 4 | Generator | 3-Oct-2026 | 3-Apr-2027 | 3-Mar-2027 |
- C2 (filled down to C4)
=EDATE(B2,6) - D2 (filled down to D4)
=EDATE(C2,-1)
Six months after 31 May is the last day of November: 30-Nov-2026. The reminder is set one month earlier: 30-Oct-2026. The forklift's next service is 14-Feb-2027.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- Shows a number
Cause: The result appears as a number such as 46387 because the cell is not formatted as a date.
Fix: Apply a date format to the cell.
- #VALUE!
Cause: The start date is stored as text, or months is not a number.
Fix: Convert the date to a real date and make sure months is a number.
- #NUM!
Cause: The result falls outside Excel's date range, before 1 January 1900.
Fix: Check the number of months and the start date.
Good to know
- Subtract 1 to end the day before:
=EDATE(A2,12)-1; a one-year contract starting on 1 January ends on 31 December. - To see whether a warranty has run out:
=TODAY()>=EDATE(A2,24)(TODAY).
In Nexell
Get Nexell to do it from a sentence
Add an end date column to the contract list by adding the term in months to the start date
Convert to tableBring your contract list into the tool and type this. Nexell adds the end date column with real Excel formulas and shows it in the preview; in the downloaded file, the end date changes when the term does.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
How do I add months to a date in Excel?
=EDATE(A2,3) adds 3 months to A2; use a negative number to go back. To add years, multiply by 12: =EDATE(A2,12*2).