Rota

I have been asked to create a rolling rota for 14 staff is the a way to get excel to automaticaly rotate the names or shift pattern each week

Example
Initial shift example

Name shft shift
Ben 9-6 8-5
Bill 11-8 8-5
Bob 8-5 11-8

After the completion on this week

Ben 8-5 11-8
Bill 9-6 8-5
Bob 11-8 8-5

Play about with this formula to get what you want.

=CHOOSE(MOD(WEEKNUM(TODAY())+ROW(A1),3)+1,"9-6","11-8","8-5")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"chris.howes" <[email protected]>
wrote in message
news:[email protected]...
>
> I have been asked to create a rolling rota for 14 staff is the a way to
> get excel to automaticaly rotate the names or shift pattern each week
>
> ::Example ::
> Initial shift example
>
> Name shft shift
> Ben 9-6 8-5
> Bill 11-8 8-5
> Bob 8-5 11-8
>
> After the completion on this week
>
> Ben 8-5 11-8
> Bill 9-6 8-5
> Bob 11-8 8-5
>
>
> --
> chris.howes
> ------------------------------------------------------------------------
> chris.howes's Profile:
http://www.excelforum.com/member.php...fo&userid=5660
> View this thread: http://www.excelforum.com/showthread...hreadid=564234
>