Dates on a worksheet
 

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.

Dates on a worksheet
 

Hi

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

etc.



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



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

Dates on a worksheet
 

Great! Thanks very much.


"Arvi Laanemets" wrote:

Hi

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

etc.



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



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