### EDATE(start_date, months)

Returns the date serial number that is a certain number of months before or after a date.

 start_date The start date. months The number of months before or after the "start date".

#### Remarks

 * This function can be used to calculate maturity dates or due dates that fall on the same day on the month as the date of issue.* If "start_date" is not a valid date, then #VALUE! is returned.* If "months" is not an integer, it is truncated.* If "months" > 0, then a date in the future is returned.* If "months" > 1E21, then #NUM! is returned.* If "months" < 0, then a date in the past is returned.* If "months" = 0, then "start_date" is returned.* This function respects leap years.* You can use the DATE function to return the date serial number given a year, month, day.* You can use the TEXT function to convert a date serial number into a particular date format.* You can use the DATEVALUE function to return the date serial number for a date in text format.* This function does not automatically change the number format of the cell.* For the Microsoft documentation refer to support.office.com

 A 1 =EDATE("01/07/2019",2) = 43709 2 =EDATE("01/07/2019",2) = 01/09/2019 3 =EDATE("01/07/2019",4) = 01/11/2019 4 =EDATE("01/07/2019",-2) = 01/05/2019 5 =EDATE("2020/01/09",0) = 09/01/2020 6 =TEXT(EDATE("13 Jun 2019",3),"dd mmmm yyyy") = 13 September 2019 7 =TEXT(EDATE("01/07/2019",0),"dd/mm/yy") = 01/07/19 8 =EDATE(DATEVALUE("01/12/2020"),1) = 01/01/2021 9 =EDATE(DATEVALUE("03/31/1998"),-1) = #VALUE!

 1 - What is the date serial number 2 months after the 1st July 1977.2 - What is the date serial number 2 months after the 1st July 1977. This cell has been formatted with the number format "dd/mm/yyyy".3 - What is the date 4 months after the 1st July 1977.4 - What is the date 2 months before the 1st July 1977.