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) |