In A2, type 1/1/07.
In A3, type =A2+1
Copy down.
You should only have to change A1 from now on.
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"sgo" wrote in message
...
I was wondering if anyone can help me figure out how to auto input dates. I
know about the fill cursor, but that doesn't do exactly what i want....
for example if i put in one cell 1/1/07, on the next cell I want to have
excel automatically input 1/2/07...but if i happen to change the original
cell to another date, it should also change the next cell. with the fill
cursor, it doesn't automatically do this function when i change the
original
date, i would have to use the fill cursor every time i change it.
THANKS for any help anyone can give me...!