View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danny Danny is offline
external usenet poster
 
Posts: 148
Default 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