View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim[_7_] Tim[_7_] is offline
external usenet poster
 
Posts: 11
Default changing dates in a date formated column ?

Is there a function that can change the date in a column of dates by
increasing the day in month/day/year format by the value of a number
(4,12,8...etc) in the adjoining column.

If the date is 01/20/07 and the adjoining column is 7...is there a formula
that will auto modify it with in a new column with a value of 01/27/07 and
so on ?

Thanks, Tin