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:
Results:
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
So the Resultant Formatted table will be
- 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