Creating a schedule

E

edc

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
 
C

CLR

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
 
E

edc

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


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

CLR

You're welcome, and post back if there are any problems...........

Vaya con Dios,
Chuck, CABGx3
 
Top