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