I am a complete beginner with Excel, so please excuse me if this makes no sense !!
I have made a spreadsheet for driving hours which adds up the hours driven and gives a weekly total so I can allocate driving duties based on the UK legal limits, and have made it cover the 17 weekly period we work to using 17 worksheets (week1, week 2 etc). However, I want to check that a driver has had 1 day off per week and at least 2 consecutive days over a two week period. What I am trying to achieve is.. ...if I try to allocate a driver a duty and he has not had these breaks it returns a text string ( in column K on my sheet ). I have spent a lot of time searching and a lot of trial and error, any help would be gratefully received and stop me shouting at my PC !!