Rota

Hi all,

I'm trying to write a spreadsheet for work. It's duty rota that needs to take into account:-

1. Which of 7 staff are in.
   2 different duties available
   remaining staff left after duties sorted
   staff can't be on a duty 2 days running
   also the member of staff who did the duty the furthest date away needs to be on that duty

Hope this makes sense


Thanks