Last day of the month

[George W. Barrowcliff]

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

 

[Roger Govier]

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

 

[George W. Barrowcliff]

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

Thanks again, GWB