Hi George

The 0th day of the month is the last day of the previous month. Using
this fact if we add 1 to the month number and take the 0 day we gat the
last day of the month.

So with 01 Jan 07 in A1
=DATE(YEAR(A1),MONTH(A1)+1,0)
will return 31 Jan 2007

--
Regards

Roger Govier


"George W. Barrowcliff" wrote in message
...
I have a series of reports that are always dated the last day of the
month.

How can I determine the last day of the month so I can have column
headings that match the reports?

TIA