Unfortunately I don't have time to do it atm (maybe in 8 hours when I am off work).
In theory how I would do it: 1. Find lowest/min date in Start Date 2. Find highest/max date in End Date 3. Make a row with Calendar | lowest Start date | highest end date 4. Concatenate with imported Excel 5. Celebrate