changing dates in a date formated column ?
Tim,
If you have the date columns ( assuming A and C) formatted as mm/dd/yy, then
a simple =A1+B1 formula in C1 should give you what you want.
Rob
"Tim" wrote in message
...
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
|