Creating a schedule

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
You're welcome, and post back if there are any problems...........

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top