Thread: I need a formula that change all date by putting in one date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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?


Reply With QuoteReply With Quote