Rock the EOMONTH Function in Excel.
The EDATE function in Excel takes a date and adds specified number of months.