Skip to content

Excel function · Date & time

Excel EDATE function

EDATE returns the same day a given number of months after or before a date: the end of a 12-month contract, a service date every 6 months. Near the end of a month it adjusts to shorter months by itself.

In Turkish Excel: SERİTARİH

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

English Excel=EDATE(start_date, months)
Turkish Excel=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

ArgumentRequiredDescription
start_dateRequiredThe date, or the cell holding the date, to add months to.
monthsRequiredThe 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.

D2fx=EDATE(B2,C2)
A contract's end date and last valid day: example table
ABCDE
1ContractStartTerm (Months)EndLast Day
2CT-1011-Jan-2026121-Jan-202731-Dec-2026
3CT-10215-Mar-2026615-Sep-202614-Sep-2026
4CT-10331-Aug-20251828-Feb-202727-Feb-2027
5CT-1045-Nov-2026245-Nov-20284-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.

C2fx=EDATE(B2,6)
A six-monthly service date with a reminder a month before: example table
ABCD
1MachineLast ServiceNext ServiceReminder
2Compressor31-May-202630-Nov-202630-Oct-2026
3Forklift14-Aug-202614-Feb-202714-Jan-2027
4Generator3-Oct-20263-Apr-20273-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

Type this in Nexell

Add an end date column to the contract list by adding the term in months to the start date

Convert to table

Bring 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).

Related functions

All date & time functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free