# 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 MONTH function to return the month as an integer given a date serial number.* 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!