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:

     A               B           C                D
1   Team        Start Date    End Date         Overlap
2    A           12/05/2014   12/08/2014         True (Overlaps with row 5)
3    B           12/16/2014   12/22/2014
4    C           01/03/2015   02/01/2015         True (Overlaps with row 8)
5    A           12/07/2014   12/16/2014         True (Overlaps with row 2)
6    A           03/14/2015   03/19/2015
7    B           01/27/2015   02/16/2015
8    C           01/18/2015   01/23/2015         True (Overlaps with row 4)

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

Your original code sample:

=IFERROR("True (Overlaps with row " &1/(1/SUMPRODUCT(LARGE((ROW(A2)<>ROW(A$2:A$8))*(C2>(B$2:B$8))*(B2<(C$2:C$8))*ROW(A$2:A$8),1)))&")","")

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:

=SUMPRODUCT((A2=$A$2:$A$8)*((B2<=$C$2:$C$8)*(C2>=$B$2:$B$8)))>1

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:

True (Overlaps with row #)

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!!!