How do assign formulas to an entire column?

[Guest]

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.

 

[David Biddulph]

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

 

[Guest]

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

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