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