View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
edc
 
Posts: n/a
Default Creating a schedule

thanks I will give it a try...
--
edc


"CLR" wrote:

If you have 12/8/2005 in A1,
This formula in B1 will return 1/6/2006
=A1+29
Then, highlight A1 and left-click and drag the little black square in the
lower right corner down column a as far as you would like consecutive dates

Vaya con Dios,
Chuck, CABGx3



"edc" wrote:

I am new this excel codeing stuff... can one organize a schedule to
automatically generated dates in a colum from dates in other cells?

A1:12/8/2005
B1: 01/06/2006

A2: 12/8/2005
A3: 12/9/2005
A4: 12/10/2005
And so forth

Your input is appreciated
--
edc