Count consecutive more than 3 days absent in a month/year exclude Sat/Sun/PubHol

Hi,

Would like to seek your assistance

1) In Entry sheet: Teams absent="N": count number of >=3 consecutive days in a year exclude Sat/Sun/PubHol in Column
2) In AttDashboard sheet: Teams absent="N": count number of >=3 consecutive days in a month exclude Sat/Sun/PubHol by Rows

Attached is excel sheet for your reference. Can anyone please advise how to go about this.