EOMONTH

EOMONTH(start_date, months)

Returns the date serial number of the last day of a month 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 #NUM! is returned.
* If "start_date" plus "months" yields an invalid date, then #NUM! is returned.
* If "months" is not an integer, it is truncated.
* If "months" > 0, then a date in the future is returned.
* If "months" > 12, then additional years are added on.
* If "months" < 0, then a date in the past is returned.
* If "months" = 0, then the end of the "start_date" month is returned.
* If "months" is left blank, then #N/A is returned.
* If no arguments are submitted, then #NA! is returned
* 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 EDATE function to return the date serial number that is a certain number of months before or after a date.
* You can use the TEXT function to return a number with a particular format.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=EOMONTH("01/07/2022", 0) = 44773
2	=EOMONTH("01 July 2022", 0) = 44773
3	=EOMONTH("01/07/2023", 0) = 31/07/2023
4	=EOMONTH("01/07/2022", 1) = 31/08/2022
5	=EOMONTH("01/07/2022", 2) = 30/09/2022
6	=EOMONTH("01/07/2022", -6) = 31/01/2022
7	=EOMONTH("01/01/2022", -1) = 31/12/2021
8	=EOMONTH("2022/01/30", 3) = 30/04/2022
9	=EOMONTH("30 January 2022", 3) = 30/04/2022
10	=EOMONTH("01/01/2022", 24) = 31/01/2024
11	=EOMONTH("01/01/2023", -24) = 31/01/2021
12	=EOMONTH(DATEVALUE("01/12/2022"), 2) = 28/02/2023
13	=TEXT(EOMONTH("2023/01/30", 3), "ddd-mm yyyy") = Sun-04 2023
14	=EOMONTH("2023/20/20", 3) = #VALUE!