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