how do i auto input dates

[Guest]

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...!

 

[Guest]

Just add 1 to the date value. For example, if 1/1/07 is in A1, in A2 enter
the formula:

=A1+1

then copy down as needed..

 

[T. Valko]

You would have to use formulas to do this.

"Original" cell is A1

A1 = some date manually entered.

Enter this formula in A2 and copy down as needed:

=IF(A$1="","",A$1+ROWS($1:1))

Format as DATE

Biff

 

[Anne Troy]

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
****************************

 

[Guest]

THANKS everybody, this DEFINITELY helps!