EOMONTH

 

What Does It Do?
This function will show the last day of the month which is a specified number of months
before or after a given date.

Syntax
=EOMONTH(StartDate,Months)

Formatting
The result will normally be expressed as a number, this can be formatted to represent
a date by using the Format,Cells,Number,Date command.