Excel Function : EOMONTH
Date and time
Returns the serial number of the last day of the month before or after a specified number of months
Microsoft Excel Reference Page
Syntax and Description of the EOMONTH Excel Function
The syntax for the EOMONTH function in Microsoft Excel is: =EOMONTH(start_date, months) start_date is the date from which you want to calculate the end of the month. months is the number of months you want to add to the start_date.
About EOMONTH Excel Function
EOMONTH returns the last day of the month that contains the date specified in date. The syntax for the EOMONTH function is: EOMONTH( date, [months] ) The date argument is the date for which you want to find the last day of the month. The months argument is optional. If omitted, EOMONTH returns the last day of the month that contains date. If months is specified, EOMONTH returns the last day of the month that contains date plus months. For example, if date is May 3, 2009 and months is 2, EOMONTH returns July 31, 2009.