View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anne Jo Anne Jo is offline
external usenet poster
 
Posts: 1
Default 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.