Looking to calculate any instance within a grouping of overlap. Each grouping has a sub total. I was able to find the 1st overlap within the grouping but if there were multiple overlaps within a grouping I'm stuck.
For instance
1- 6/1/2020 6/19/2020
2- 6/1/2020 6/6/2020
3- 6/10/2020 6/30/2020
4- 6/16/2020 6/24/2020
5- 6/24/2020 6/30/2020
1 and 2 have a 7 day overlap
1 and 3 have a 10 day overlap
1 and 4 have a 4 day overlap
Would need a formula that could be broken down in a few steps as the calculations need to be validated by another person.
I'd attach the file but for some reason I'm unable to.
Bookmarks