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