Sick Leave Counting as an Instance

This query will not be for the faint of heart...


What I am trying to achieve is a count of instances for Sick Leave.

All sick days in a row are classed as 1 instance, even if it occurs around a weekend.
All one off sick days are classed as an instance.

Like the attached file, I am trying to find a formula that will count the instances and not just the individual "SICK" days.
As the report may be run for a year or more on multiple people, a easier way needs to be found rather than manual counting....

are you ok with helper columns

Try this array formula in E4

Please Login or Register  to view this content.

Confirm with shift+Ctrl+Enter
and simple count if formula in E5

Please Login or Register  to view this content.