How to count consecutive dates for each employee from a listing of absence dates?

Originally Posted by FlameRetired

We are to assume weekends don't break the continuity.......Friday followed by a Monday is still one absence?

But OP shows Saturday and Sundays in Leaves List.