Thread: Overlapping multiple periods

Hi!

I have a problem writing a code that will give me needed results.
Here is my problem. I would appriciate any help.

I have these three periods:
- 1.1.2010 - 31.10.2010
- 1.2.2010 - 31.5.2010
- 1.3.2010 - 31.12.2010

Graphicaly it looks like this:

     |------------|
              |-------------------|
|---------------------|

In result i would like to have sections defined by dates and a number of overlapping periods like this:
1.1.2010 - 31.1.2010 (1)
1.2.2010 - 28.2.2010 (2)
1.3.2010 - 31.5.2010 (3)
1.6.2010 - 31.10.2010 (2)
1.11.2010 - 31.12.2010 (1)

Number in brackets means number of overlapping periods.
I'm getting a headache solving this problem.
Please help!