repeating formula on calendar

  • Thread starter Thread starter Anne Jo
  • Start date Start date
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.
 
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 ????
 
Back
Top