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