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

V

vpr

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

Ragdyer

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

SidBord

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