repeating formula on calendar

A

Anne Jo

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.
 
S

smartin

Anne said:
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.
Click to expand...

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.
 
M

maziz

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 ????
 
S

smartin

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 ????
Click to expand...

I think you are confusing the OP with my response.
 
Top