Hi folks

I'm looking for a formula to keep track of holidays but ignore Saturday afternoons and Sundays.

Weekly shift patern is 2 shifts per day Mon - Fri & 1 shift Saturday (AM)

staff on holiday for 1 week Monday to Saturday = 11 shifts

I have all the basics but cannot figure out how to ignore the 3 shifts if on holiday over a weekend period

e.g. on holiday from Thursday to Tuesday (inclusive) = 9 shifts

any help would be very much appreciated

Thank you