EDATE(start_date, months)

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

start_dateThe start date.
monthsThe 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.
* 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.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* 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.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top