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

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



--
Hope that helps.

Vergel Adriano


"sgo" wrote:

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

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

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

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

THANKS everybody, this DEFINITELY helps!


--
Hope that helps.

Vergel Adriano


"sgo" wrote:

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