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


--
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

Rota
 

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"
wrote in message
...

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