If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
repeating formula on calendar
I have a work calendar that is 6 days on, 3 days off throughout the year.
The first five days are 1830-0300 hours, the 6th day is 1830-0230 hours, then 3 days off. I have a 12 month calendar typed in, but can't seem to get the correct formula to have this carry forward day after day, to week after week, to month after month. |
#2
|
|||
|
|||
repeating formula on calendar
Anne Jo wrote:
I have a work calendar that is 6 days on, 3 days off throughout the year. The first five days are 1830-0300 hours, the 6th day is 1830-0230 hours, then 3 days off. I have a 12 month calendar typed in, but can't seem to get the correct formula to have this carry forward day after day, to week after week, to month after month. Maybe like this: A B 1 Date Schedule 2 1/01/2009 '1830-0300 3 =A2+1 '1830-0300 4 (fill down) '1830-0300 5 (fill down) '1830-0300 6 (fill down) '1830-0300 7 (fill down) '1830-0230 8 (fill down) off 9 (fill down) off 10 (fill down) off 11 (fill down) =B2 12 (fill down) (fill down) ....fill down as far as needed. |
#3
|
|||
|
|||
repeating formula on calendar
Its its working fine as you drag down the =B2 and your every 6th day
and 3 days will be updated accordingly ........ what type of problem you are having ???? On Apr 22, 7:02*am, smartin wrote: Anne Jo wrote: I have a work calendar that is 6 days on, 3 days off throughout the year. * The first five days are 1830-0300 hours, the 6th day is 1830-0230 hours, then 3 days off. *I have a 12 month calendar typed in, but can't seem to get the correct formula to have this carry forward day after day, to week after week, to month after month. * Maybe like this: * * *A * * * * * *B * 1 *Date * * * * Schedule * 2 *1/01/2009 * *'1830-0300 * 3 *=A2+1 * * * *'1830-0300 * 4 *(fill down) *'1830-0300 * 5 *(fill down) *'1830-0300 * 6 *(fill down) *'1830-0300 * 7 *(fill down) *'1830-0230 * 8 *(fill down) *off * 9 *(fill down) *off 10 *(fill down) *off 11 *(fill down) *=B2 12 *(fill down) *(fill down) ...fill down as far as needed. |
#4
|
|||
|
|||
repeating formula on calendar
|
Thread Tools | |
Display Modes | |
|
|