Calculating Overlapped days

[Zahed3570]

Hi All

Hope you are all well

I am trying to find a solution for the following problem. I have a range of dates and want to work the total number of dates that are overlapped in the range.

So as an example from the Date range below , how days are overlapped in the range. Is that possible and if so can anyone help and shed some light on a solution please.

Ahmed 01/01/2017 15/04/2017
Zahed 02/03/2017 30/03/2017
Bill 01/05/2017 15/05/2017
John 01/06/2017 30/06/2017
Sam 01/05/2017 15/05/2017
Hamaad 01/12/2016 31/12/2016
Zain 01/12/2016 31/12/2016
Gary 01/04/2017 30/04/2017



Much Appreciated
Sims

[ChemistB]

I created a list of dates in Column E
In E2 = MIN(B2:B9)
Then in E3 down (until I got errors)
=IF(E2+1<=MAX($C$2:$C$9), E2+1,"")
Then in F2 copied down
=COUNTIFS($B$2:$B$9,"<="&E2, $C$2:$C$9, ">="&E2)
If a 2 appears in Column F, that date is in 2 ranges,
If a 0 appears in Column F, that date is not in any range.
I'm not sure what you are looking for in a final answer.