Hi gramps,

Glad you got it working.

It was actually an adaptation of a sheet that I wrote for my daughter's CID
shifts which did more than just the shifts. For the record, if for no other
purpose, to return just the shifts you only need the date and list in column
K and then use the formula:

=INDEX($K$2:$K$36,MOD(B2-$K$1,35)+1)
in place of the VLOOKUP() formula.

Us Gramps have to stick together <g
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"gramps" wrote in message
...
Hi Sandy
Thanx a million, its working a treat. Greatly appreciated!!!
--
Al


"gramps" wrote:

We have a rolling 5 week rota with a week starting on sunday an example
of
which is shown below.
Sun Mon Tue Wed Thu Fri Sat
1 Rest Rest A2 A2 A2 A2 A2
2 Rest A1 A1 A1 A1 A1 Rest
3 Rest B2 B2 B2 B2 Rest B1
4 B1 B1 B1 Rest Rest B2 B2
5 B2 B2 Rest B1 B1 B1 Rest

Our pay period is every 4 weeks and a duty statement is submitted for
this
period. What I would like to do is that given a start date of the rota is
to
be able to enter a future date and to have my duties for the 4 next weeks
to
be displayed.
Any help would be really appreciated.
--
Al