Thank you so much for code, it is a lot faster but it has some issues that I am struggling to figure out.

With the following data the faster version gets...

This works great, thank you so much

Ken McKelvey (9/27/2016)

---

One way is to expand the dates with a number/tally table and then roll them up again:

-- *** Consumable Test Data ***

--...

Hi There

No there won't be any gaps, they must be continuous even if they overlap.

Thanks