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
|