I have a an eight week cycle working shift pattern. What I want to do is be
able to have a mock template of the days of the week and when I enter the
week no of the eight week cycle, it returns the shifts for that week....hope
that makes sense...

Any help or ideas welcome

Thanks

Hi

this can be done using a combination of index & match

create a table with the working times of the shift pattern e.g.
- where row 1 from B1:I1 is the week number (just 1, 2, 3 etc)
- where column A from A2:A8 are the days of the week (Monday, Tuesday etc)
- and where the intersection of these contain text outlining the shift
information (ie the information you want returned)
assume this table is on sheet2

then set up another table with the days of the week starting in B1 (type
them so that they match column A in the first table)
and cell A2 is where you put the week number that you're interested in
the formula for B2 then is
=INDEX(Sheet2!$A$1:$I$8,MATCH(B$1,Sheet2!$A$1:$A$8 ,0),MATCH($A2,Sheet2!$A$1:$I$1,0))

you can then fill this formula across for the other days.

Hope this helps
Cheers
JulieD


"Xeraco" wrote in message
...
I have a an eight week cycle working shift pattern. What I want to do is be
able to have a mock template of the days of the week and when I enter the
week no of the eight week cycle, it returns the shifts for that
week....hope
that makes sense...

Any help or ideas welcome

Thanks

Thanks Julie....Worked A Treat.

"Xeraco" wrote:

I have a an eight week cycle working shift pattern. What I want to do is be
able to have a mock template of the days of the week and when I enter the
week no of the eight week cycle, it returns the shifts for that week....hope
that makes sense...

Any help or ideas welcome

Thanks

you're welcome and thanks for the feedback

"Xeraco" wrote in message
...
Thanks Julie....Worked A Treat.

"Xeraco" wrote:

I have a an eight week cycle working shift pattern. What I want to do is
be
able to have a mock template of the days of the week and when I enter the
week no of the eight week cycle, it returns the shifts for that
week....hope
that makes sense...

Any help or ideas welcome

Thanks