Thread: Date-increments
View Single Post
  #1   Report Post  
Robert Dieckmann
 
Posts: n/a
Default 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