| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating a schedule
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating a schedule
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create patient schedule based on master therapist schedule | Excel Discussion (Misc queries) | |||
| Creating Machine shop part schedule using Excel | Excel Discussion (Misc queries) | |||
| creating a rate schedule | Excel Worksheet Functions | |||
| Creating a work schedule | Excel Discussion (Misc queries) | |||
| Creating an Amortization schedule ? | Excel Discussion (Misc queries) | |||
Hybrid Mode
