Split a date according to periods

Hello everyone,

I want to enter dates in a table when there is a period in another, the two terminals of the global date will be broken or split to create short periods and add other times to fill the time intervals empty.

For example, I have these four periods of dates entered in my table:

01/08/2013 – 31/08/2013
05/08/2013 – 05/08/2013
12/08/2013 – 19/08/2013
15/08/2013 – 17/08/2013

The VBA code will return this table:

01/08/2013 – 04/08/2013
05/08/2013 – 05/08/2013
06/08/2013 – 11/08/2013
12/08/2013 – 14/08/2013
15/08/2013 – 17/08/2013
18/08/2013 – 19/08/2013
20/08/2013 – 31/08/2013

Thanks.