# EDATE

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 DATEVALUE function to return the date serial number for a date in text format.* You can use the EOMONTH function to returns the date serial number of the last day of a month before or after a date.* You can use the TEXT function to convert a date serial number into a particular date format.* This function does not automatically change the number format of the cell.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

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

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