EOMONTH function

description:

Return the serial number of the last day of the month in future or past months.

 

syntax:

=EOMONTH( start_datemonths )

 

required arguments:

start_date A date that represents the starting date.
months The number of months before or after start_date.