Dates on a worksheet

[climber322]

I want to be able to input a date and have the spreadsheet automatically list
the proceeding months with the last day of the month. In other words, if in
cell A1 I enter 01/31/2008, I want to automatically see 02/28/2008 in A2,
then 03/31/2008 in A3, etc. If I key in 07/31/2008 in A1, I'd like to see
08/31/2008 in A2, 09/30,2008 in A3, etc.

 

[Arvi Laanemets]

Hi

=DATE(YEAR(A1),MONTH(A1)+2,0)
=DATE(YEAR(A1),MONTH(A1)+4,0)

etc.

 

[climber322]

Great! Thanks very much.

Hi

=DATE(YEAR(A1),MONTH(A1)+2,0)
=DATE(YEAR(A1),MONTH(A1)+4,0)

etc.