Finding Missing Dates In a Column of Dates

I have been requested to find the date range which my ads have been running. The only way in which I can get the raw data is to have the data broken out by date for each day of my date range (7/1/2013-2/28/2014). This is not ideal, but it's the only way I have the data. The problem I need to solve is how to determine the dates when the ad was not active (i.e. the missing dates in the list), and the end result needs to be me giving a date range for when each ad was active.

For example, if the ad has a list of dates from 7/1/2013-7/10/2013, and the list is missing 7/6/2013, I need the following end result for that ad:
7/1/2013-7/5/2013; 7/7/2013-7/10/2013

My first instinct was to create a macro using a formula to give me the missing dates and pass each ad and its list of dates into a tab with that formula, it populates the missing dates, then it gets pasted into an output tab with the missing dates transposed so it all ends up and one row. The macro then loops (loop not added to macro yet) to run through the entire list. This may not be the optimal method, but the attached document has the beginnings of this macro in it. I had trouble with getting the macro to run through the list due to issues with copy/pasting/deleting, so it may be useless.

I appreciate any insight/help or recommendations on other methods to get this accomplished. Again, the 'Data' tab shows each ad (it's a jumble, but makes sense to my needs so ignore how odd the ads look) with its list of dates and I am looking for the missing dates + compiling it into a date range of time without those missing dates.