I need a formula that change all date by putting in one date

S

sherrie

I am not real verse with formulas and I need to get a formula that if I
change one date that all the other dates following would change by one.

How would I do this?
 
R

Ron de Bruin

Dates are numbers

If you have a Date in A1 you can use this formula in B1
=A1+1 to add one day
 
O

oldchippy

Hi sherrie,

Is this what you mean?

If your date is in A1

then in A2 put

=A1+1 and copy this down

oldchippy :
 
Top