View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LaDdIe LaDdIe is offline
external usenet poster
 
Posts: 131
Default Recurring pattern

Hi all,

Our company works around a four week pattern;

Sun Mon Tue Wed Thu Fri Sat
0 7.5 9.5 9.5 7.5 0 0
0 9.5 0 0 7.5 7.5 7.5
0 0 9.5 9.5 9.5 9.5 0
0 7.5 9.5 7.5 0 0 7.5

What can I do to automate the repetition of this pattern on a work rota,
I have a rota with months to a row under each day of the week i need to show
the work hours as above, but then to repeat itself, a month may end mid week,
so the following month needs to pick up the pattern where that last month
ended.

Tried to search for a similar question/reply without luck.

Thanks for taking time to read this, and any help is appricated.

Regards.