EDATE Function in Excel

EDATE Function in Excel returns the date, which is specified number of months before or after the input start date.

Syntax For EDATE Function in Excel:          

EDATE(start_date, months)

Arguments are

start_date initial date
months The number of months to add to (or subtract from) the start_date

 

Example of EDATE Function in Excel:

Formula:

EDATE Function in Excel 1

Results:

EDATE Function in Excel 2

Formatting the cells to Display Dates

If you want to display the result column in date format then select result column. On Home tab click the dropdown and select short date as shown below

EDATE Function in Excel 4

So the Resultant Formatted table will be

EDATE Function in Excel 3

  • For row number 2 the start_date is Dec-31-2016 and month is 1 so the resultant date start_date +1month which will be 31-Jan-2017
  • For row number 3 the start_date is Dec-31-2016 and month is -1 so the resultant date start_date -1month which will be Nov-30-2016
  • For row number 4 the start_date is Feb-28-2017 and month is 7 so the resultant date start_date +7months which will be Sep-28-2017
  • For row number 5 the start_date is Feb-28-2017 and month is -12 so the resultant date start_date -12months which will be Feb-28-2016

previous EDATE Function in Excel                                                                                                        next EDATE Function in Excel