I have a spreadsheet that has a date column listing dates going back 3 years,
each month has about 50 line items with different days of the month, it there
a way to create a new column that lists the last day of the month for each
line item? For example if the date was August 9, 2007 the formula would
return August 31,2007.

Thanks