How to find number of overlapping days from a set of date ranges?

[chiron]

I want to find out the number of overlapping dates from a range of dates. I saw a solution posted here; Check if two ranges of dates overlap [Excel Formulas] | Chandoo.org - Learn Microsoft Excel Online but that just shows whether the date ranges overlap and not the duration. I can't seem to figure out a simple formula that returns the number of overlapping days in case of overlap. Preferably without vba because in some computers in my office they don't allow running macros.

Sample of the data is posted below;

S.No	Start	End	Duration	Overlap
1	29.11.2013	15.12.2013	16
2	16.12.2013	20.12.2013	4
3	28.12.2013	14.01.2014	17
4	17.01.2014	27.01.2014	10
5	28.01.2014	08.02.2014	11
6	09.02.2014	20.02.2014	11
7	06.03.2014	20.03.2014	14
8	25.03.2014	26.03.2014	1
9	27.03.2014	04.05.2014	38
10	06.05.2014	14.05.2014	8
11	06.05.2014	15.05.2014	9
12	10.05.2014	24.05.2014	14
13	18.05.2014	23.05.2014	5
14	20.05.2014	24.05.2014	4
15	25.05.2014	30.05.2014	5
16	17.06.2014	20.06.2014	3
17	24.06.2014	27.06.2014	3
18	24.06.2014	02.07.2014	8
19	24.06.2014	20.07.2014	26
20	30.07.2014	05.08.2014	6

<tbody>
</tbody>

 

[chiron]

I tried searching this forum also and while there are solutions to identifying whether overlap exists I can't find any that finds out the overlapping duration as well.