Creating a schedule

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

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

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

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

Vaya con Dios,
Chuck, CABGx3



"edc" wrote:

> 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