Finding overlapping date periods for specific variables

Long time viewer, first time poster. I am normally pretty good at searching the wealth of knowledge previously posted to this site but in this instance scanning the 5500 or so search results for sumproduct, overlap, and dates did not yield an answer. Here is my issue. I have a list of teams with start and end dates for events. each time can have unlimited events. I am trying to find a way to determine if there are any overlapping events for each team.

I believe that the sumproduct function is the way to go but nothing I have seen works in my situation. All just compare all the dates with no consideration for a variable. I'm pretty sure that I need some other expression (if, sumif, etc.) to combine with sumproduct to get the right results. Example below:

Please Login or Register  to view this content.

Thank you in advance for any and all assistance on this problem.

Sean
Give a man a fish and you feed him for a day; teach a man to fish and you feed him for a lifetime.

Karedog, thank you for your reply. I entered the code that you provide and it does programatically find the overlaps based on the sample data that I provided you. However, the code still does not take in to consideration for the team.

By way of example, using my original sample data, when I copy the formula down, I am told that Row 7 overlaps with Row 4. I am ok with this overlap because it is for two different teams. I only want to know about the overlaps that occur for the same team.

I will do some disection of the code you provided to see if the LARGE function is the culprit.

Thanks, Sean

Please Login or Register  to view this content.

Ok, I have found a partial solution to my issue. I am now able to accurately identify teams with overlapping date ranges with the following code:

Please Login or Register  to view this content.

This outputs TRUE for each row were the team is equal and the start and stop dates overlap. The last part of this issue is finding a way to idenfity which rows have the overlapping date conflict. Ultimately I am looking for a way to have the following show up in the overlap column:

Please Login or Register  to view this content.

Thanks,
Sean
Give a man a fish and you feed him for a day; teach a man to fish and you feed him for a lifetime.

Karedog, adding that last checking condition did the trick. Thanks for you help. PROBLEM SOLVED!!!