Sumproduct and sliding calender formula help

Good afternoon

I am looking for some more help on a spread sheet I am trying to create which is attached below. I am looking for a couple of different formulas:-

1. Is there a way to count when "LEAVE" (Bright Green Cells) falls on a Friday or Monday when there is "IDLE" (Black Cells) on Saturday and Sunday. I would need it to recognise different combinations e.g. If Friday is "LEAVE" and Saturday is "IDLE", that would count as 1 however if Friday is "LEAVE" and Sunday is "IDLE" then this would not count as an occurrence.

2. Is there a way to count when "LEAVE" (Bright Green Cells) fall either side or on a pay day? The pay days are highlighted orange in the dates headings. Can a formula recognise every second Wednesday or would it have to point to the specific dates?

3. With the sliding calendar, is there a way for the formulas to follow what month is selected as my formula's only point to the first 31 days in January. When I slide the calendar to February for instance, the formulas still point to January and do not follow to the next months data.

'PLT Example 2.xlsm

Is the above formula's possible? Any help with any or all three of the above formula's it would be greatly appreciated

Thanks in advance

Awesome, appreciate the help gak67

Any further help with the formula's? Any help is greatly appreciated.

Thanks in advance

Still stuck on these formulas. Thanks in advance if you are able to help or point me in the right direction

Thanks everyone