You're welcome. Thanks for the rep.


Why not just use a Pivot Table? You might need to add a helper column to add groups of days open.