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 a text string, there are lots of different date formats that will be recognised.
* 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", -2) = 01/05/2022
4	=EDATE("2023/01/09", 0) = 44935
5	=TEXT(EDATE("13 Jun 2023", 3), "dd mmmm yyyy") = 13 September 2023
6	=TEXT(EDATE("01/07/2022", 0), "dd mmm yy") = 01 Jul 22
7	=EDATE(DATEVALUE("1 Dec 2023"), 1) = 01/01/2024
8	=EDATE(DATEVALUE("31 March 2023"), -1) = 28/02/2023
9	=EDATE(DATEVALUE("31 March 2024"), -1) = 29/02/2024
10	=EDATE(DATEVALUE("1 Fad 2024"), -1) = #VALUE!

1 - What is the date serial number 2 months after the 1st July 2022.
2 - What is the date 2 months after the 1st July 2022. This cell has been formatted with the number format "dd/mm/yyyy".
3 - What is the date 2 months before the 1st July 2022. This cell has been formatted with the number format "dd/mm/yyyy".
4 - What is the date serial number for the date "2023/01/09".
5 - What is the date, 3 months after 13 June 2023, displayed in a particular date format.
6 - What is the date "01/07/2022" displayed in a different format.
7 - What is the date, 1 month after the date "1 Dec 2022". This cell has been formatted with the number format "dd/mm/yyyy".
8 - What is the date, 1 month before the date "31 March 2023". This cell has been formatted with the number format "dd/mm/yyyy".
9 - What is the date, 1 month before the date "31 March 2024". 2024 was a leap year. This cell has been formatted with the number format "dd/mm/yyyy".
10 - What is the date, 1 month before the date "1 Fad 2024". The date format is not recognised.