Count number of consecutive more than 3 days absent in a month

Hi,

Would like to identify the Teams did not attend (" ") count number times of >=3 consecutive days until today in a month
Occurances start after "Y" until today's data which highlighted in color.

I was looking at all the samples but still didn't get an idea on the count. Attached is the worksheet for your preview.

Would really appreciate your advise. It will be a great anyone can advise.

Thank you.