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

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

Thanks Roger, I see how that works, I added 2 to the month and it provides
exactly what I wanted.

Thanks again, GWB

"Roger Govier" wrote in message
...
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