Date-increments
 

Is there a way to increment dates by month based off a key cell? For
example if cell A1 contains 01/01/2004 then A2 I want to be 02/01/2004; A3
to be 03/01/2004 etc. If I change cell A1 to 04/10/2004 then I want A2 to
automatically change to 05/10/2004; A3 to change to 06/10/2004 etc. I am
using Excel 2000.

Thanks.
Robert

Hi
in A2 enter
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

--
Regards
Frank Kabel
Frankfurt, Germany

"Robert Dieckmann" schrieb im Newsbeitrag
...
Is there a way to increment dates by month based off a key cell? For
example if cell A1 contains 01/01/2004 then A2 I want to be
02/01/2004; A3
to be 03/01/2004 etc. If I change cell A1 to 04/10/2004 then I want
A2 to
automatically change to 05/10/2004; A3 to change to 06/10/2004 etc.
I am
using Excel 2000.

Thanks.
Robert

With your start date in A1, use the following formula

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))



"Robert Dieckmann" wrote in message
...
Is there a way to increment dates by month based off a key
cell? For example if cell A1 contains 01/01/2004 then A2 I
want to be 02/01/2004; A3 to be 03/01/2004 etc. If I change
cell A1 to 04/10/2004 then I want A2 to automatically change to
05/10/2004; A3 to change to 06/10/2004 etc. I am using Excel
2000.

Thanks.
Robert

Hi Robert

A2:
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
fill down. Note that Excel makes a distinct choice on what January 31st + 1
month is, which may or may not fit your needs.

HTH. Best wishes Harald

"Robert Dieckmann" skrev i melding
...
Is there a way to increment dates by month based off a key cell? For
example if cell A1 contains 01/01/2004 then A2 I want to be 02/01/2004; A3
to be 03/01/2004 etc. If I change cell A1 to 04/10/2004 then I want A2 to
automatically change to 05/10/2004; A3 to change to 06/10/2004 etc. I am
using Excel 2000.

Thanks.
Robert