This suggest that A1 is not a real date. What does =A1+1 return? It should
be the next day
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Susan" wrote in message
...
I too have this problem, and when trying the formula below, it gives me a
#NUM error. I'm using 2003 Excel.

Thanks,
Susan

"Rick Rothstein" wrote:

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