Split a date according to periods

[apitos]

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.

[protonLeah]

1. Define: Global Date
2. Explain how (why) the new table is generated.

[apitos]

Hi protonLeah


At the start of each month I need to set a time for a comprehensive system of work for each agent.

Meanwhile, in the course of the month, sometimes an agent to take a rest, defined as a period with a start date and an end date.

Then the table contained only two line (two periods), will increase by an additional line, because the overall period shall be divided by the period of rest.

Thank you.

[apitos]

Hi,

Is that explanation enough?

[apitos]

Hi,

One approach to give a try?