Copy column A to column C.

Type 20 in an unused cell.

Copy that cell.

Select column C range of dates and EditPaste SpecialAddOKEsc.

Re-format to date.


Gord Dibben MS Excel MVP

On Fri, 2 Mar 2007 20:49:11 -0800, TypeType
wrote:

Hopefully very basic question...just can't seem to figure it out.

How do I set whole column to be +20 of another column. For example - value
of A1= 1/2/2007 then C1 = 1/22/2007
A3=5/5/2006 then C1=5/25/2007

Thank you!