Try this formula...

=DATE(YEAR(A1),MONTH(A1)+1,0)

--
Rick (MVP - Excel)


"tigermoth" wrote in message
...
If Cell A1 is 29/07/2008, how to I formulate cell D1 to show 31/07/2008,
15/08/2008 to 31/08/2008 etc ( ie rounding up the date in column A to show
month end date in column D.

Thanks