How 2 rotate information in a working shift pattern

[Xeraco]

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

[JulieD]

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" <Xeraco@discussions.microsoft.com> wrote in message
news:9C1A0C14-E276-4512-848F-1414A1D087DE@microsoft.com...
>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

[Xeraco]

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

[JulieD]

you're welcome and thanks for the feedback

"Xeraco" <Xeraco@discussions.microsoft.com> wrote in message
news:C1CAB74B-2C32-4C24-AB78-A65EF347C142@microsoft.com...
> 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