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;

[TABLE="class: grid, width: 386"]
<tbody>[TR]
[TD]
S.No[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]Duration[/TD]
[TD]Overlap[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]29.11.2013[/TD]
[TD]15.12.2013[/TD]
[TD="align: right"]16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]16.12.2013[/TD]
[TD]20.12.2013[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]28.12.2013[/TD]
[TD]14.01.2014[/TD]
[TD="align: right"]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]17.01.2014[/TD]
[TD]27.01.2014[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]28.01.2014[/TD]
[TD]08.02.2014[/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]09.02.2014[/TD]
[TD]20.02.2014[/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]06.03.2014[/TD]
[TD]20.03.2014[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]25.03.2014[/TD]
[TD]26.03.2014[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]27.03.2014[/TD]
[TD]04.05.2014[/TD]
[TD="align: right"]38[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]06.05.2014[/TD]
[TD]14.05.2014[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]06.05.2014[/TD]
[TD]15.05.2014[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]10.05.2014[/TD]
[TD]24.05.2014[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]18.05.2014[/TD]
[TD]23.05.2014[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]20.05.2014[/TD]
[TD]24.05.2014[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]25.05.2014[/TD]
[TD]30.05.2014[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]17.06.2014[/TD]
[TD]20.06.2014[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]24.06.2014[/TD]
[TD]27.06.2014[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]24.06.2014[/TD]
[TD]02.07.2014[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]24.06.2014[/TD]
[TD]20.07.2014[/TD]
[TD="align: right"]26[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]30.07.2014[/TD]
[TD]05.08.2014[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.