How do assign formulas to an entire column?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Danny - 11 Oct 2006 16:46 GMT

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.

Reply to this Message

David Biddulph - 11 Oct 2006 17:35 GMT

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

Signature

David Biddulph

Reply to this Message

Danny - 11 Oct 2006 18:36 GMT

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
[quoted text clipped - 6 lines]
> drag the bottom right hand corner of D2 as far down the column as you like
> to auto-fill.]

Reply to this Message