How do assign formulas to an entire column?
 

I need all the dates in Column "D" to reflect dates in Column "C" with 75
days added. The datesv in Column "C" will be different. How can I assign
the formula to affect the entire column minus the title row. Thanks.

How do assign formulas to an entire column?
 

"Danny" wrote in message
...
I need all the dates in Column "D" to reflect dates in Column "C" with 75
days added. The datesv in Column "C" will be different. How can I assign
the formula to affect the entire column minus the title row. Thanks.

You didn't need to ask twice.

In D2, enter =C2+75. Format D2 as date.
Copy D2, select D3 to whatever the foot of the column is, & Paste [or simply
drag the bottom right hand corner of D2 as far down the column as you like
to auto-fill.]
--
David Biddulph

How do assign formulas to an entire column?
 

It worked, thanks! Also apologies for the double post, it said I had an
error when I first tried it.

"David Biddulph" wrote:

"Danny" wrote in message
...
I need all the dates in Column "D" to reflect dates in Column "C" with 75
days added. The datesv in Column "C" will be different. How can I assign
the formula to affect the entire column minus the title row. Thanks.

You didn't need to ask twice.

In D2, enter =C2+75. Format D2 as date.
Copy D2, select D3 to whatever the foot of the column is, & Paste [or simply
drag the bottom right hand corner of D2 as far down the column as you like
to auto-fill.]
--
David Biddulph