Formula to return next month end date after a month end date.

Needing a formula in cell E25 that returns the next month end date after the entered month end date in cell E23. For example:

Entering 11-30-07 in cell E23, Cell E25 = 12-31-07
Entering 12-31-07 in cell E23, Cell E25 = 01-31-08
Entering 01-31-08 in cell E23, Cell E25 = 02-29-08
Entering 02-29-08 in cell E23, Cell E25 = 03-31-08
Etc.

If a problem, could live with using 02-28 instead of leap year dates 02-29.

Thanks for any help you can give me. mikeburg

Works great! Thank you so very much. I am trying! mikeburg

If E23 always has the last date of a month then to give the last day of the next month

=E23+33-DAY(E23+32)