How do assign formulas to an entire column?

D

Danny

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.
 
D

David Biddulph

Danny said:
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.
Click to expand...

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.]
 
D

Danny

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

David Biddulph said:
Danny said:
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.
Click to expand...

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.]
Click to expand...
 
Top