Last day of the month

  • Thread starter George W. Barrowcliff
  • Start date
G

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
 
R

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
 
G

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
 
Top