How to count 10 consecutive week days

Hi

Could you help me count the 10 consecutive week days for each person on my list?

See the attached spreadsheet. I just need to record a yes for anyone who has 10 consecutive days in the list.

Thanks.

I just wanted to say this is a brilliant vba solution and works perfectly. thank you.