Try this:

1. Type 1/2/2007 in A1
2. Select cells A1 to C1
3. Drag the fill handle to I1
4. The result should be:
A1=1/2/2007
D1=1/3/2007
G1=1/4/2007

Hope that helps!

Greetings from México!


"klt" wrote:

Formula to increment dates (Ex. Monday 4/11/2005) in one column and on
multiple (not consecutive) rows. Ex. A5, A15, A25, A32, A40, A49, A57, A68,
A79, and A90.
I don't know if there is a formula that can automatically update the dates,
but if not, maybe if the user updates the first date, the others can update
automatically. Is either a possibility or are they impossible? I am not a
programmer, so if difficult, please explain how it is done.