If I change a date in a date column how do I get the dates below .

I have a column with dates. When I change a date I want all the dates below
the one I've changed to change automatically? How would I do this in Excel?
Thanks!

One way is to enter a date in A1.
In A2 enter this formula:
=A1+1
And copy it down as far as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"vpr" wrote in message
...
I have a column with dates. When I change a date I want all the dates
below
the one I've changed to change automatically? How would I do this in
Excel?
Thanks!

You didn't specify quite enough. Do you want the dates
below the one changed to be equal to the new date?? This
seems too easy, so I must not understand. If the cell that
you put the new date into is "A1", then in subsequent date
cells in column "A" you can write =A1, i.e., just let the
others copy whatever is in cell A1.
-----Original Message-----
I have a column with dates. When I change a date I want
all the dates below
the one I've changed to change automatically? How would I
do this in Excel?
Thanks!
.