Count the number of occurrences of consecutive absences

Hi,

I am new to the forum and am looking for a little help. We are rolling out an attendance process that looks for individuals that meet an absence threshold of 11 days and three occurrences. Although many may be familiar with this, just to clarify we define an absence occurrence as an absence from a regularly scheduled shift. An absence for multiple consecutive days, for the same event may be regarded as a single occurrence.

So I would need my sheet to identify any single day event as 1 occurrence or any consecutive day absences as 1 occurrence. I am having difficulty capturing the number of occurrences.

Note - weekends or holidays are not part of our regularly scheduled shift so absence that occurs on Friday and then Monday would be consecutive .

I have attached an example of what the data would look like once it is pulled from our system.

Any help would be greatly appreciated!

Cheers!