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

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?

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

Dates are numbers

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



--
Regards Ron de Bruin
http://www.rondebruin.nl



" wrote in message
...
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?

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

Hi sherrie,

Is this what you mean?

If your date is in A1

then in A2 put

=A1+1 and copy this down

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=569015