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

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

Use the date function to enter the date and add the value of the cell to the
right. If the cell to the right is blank you get the date, otherwise you get
the date plus x number of days
A | B
=DATE(2007,1,1)+B1 7

The above would produce 1/8/2007
--
Kevin Backmann


"Tim" wrote:

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