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.

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.

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.

wrote:
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 ????

I think you are confusing the OP with my response.