Practice free

EDATE function

EDATE shifts a date by a whole number of months and returns a date serial number, keeping the day of the month where it can. It suits renewal dates, billing schedules and due dates.

Example

Read it as a sentence: take January 31, 2024 and move it forward 1 month, which gives the date serial number 45351.

Practice this in the app

Syntax

EDATE(start_date, months)

start_date (required)
The starting date.
months (required)
Months to move; positive goes forward, negative goes back.

Returns: A date serial number the given number of months away.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=EDATE(DATE(2026,1,31),1) 46081 Month-end clamps
=EDATE(DATE(2026,3,31),-1) 46081 Backwards
=EDATE(DATE(2024,1,31),1) 45351 Into leap February
=EDATE(DATE(2026,1,15),1.9) 46068 Fractional months
=EDATE("1/31/2026",1) 46081 Text date
=EDATE(DATE(2026,1,31),{1,2,3}) 46081 Array months
=EDATE("x",1) #VALUE! Bad date
=EDATE(DATE(2026,1,15),"x") #VALUE! Bad months

Watch out for

  • If the target month is shorter, the result falls on its last day (31 Jan plus 1 month is 29 Feb 2024).
  • Returns a serial number, so format the cell as a date.
  • Months is truncated, not rounded, if it has decimals.

Where it works

Excel
EDATE is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .