Mconcat based on Date Range

[Chip_Excel]

Hi,
I am trying to create a column that will denounce if a given date range falls within another.
Here is what it would look like in a perfect world with the formula in the cells of column D.
The formula would return all event instances that are shared with the start and finish date.

EVENT	Start	Finish	WHAT FORMULA WOULD CALC
EVENT 2	5/22/2013 (Wed) <tbody> </tbody>	5/22/2013 (Wed) <tbody> </tbody>
EVENT 3 <tbody> </tbody>	6/17/2013 (Mon) <tbody> </tbody>	6/19/2013 (Wed) <tbody> </tbody>	Occurs same time as: Event 3 <tbody> </tbody>
EVENT 4 <tbody> </tbody>	6/17/2013 (Mon) <tbody> </tbody>	6/18/2013 (Tue) <tbody> </tbody>	Occurs same time as: Event 2 <tbody> </tbody>
EVENT 5 <tbody> </tbody>	7/24/2013 (Wed) <tbody> </tbody>	7/31/2013 (Wed) <tbody> </tbody>	Occurs same time as: Event 5 Event 6 <tbody> </tbody>
EVENT 6 <tbody> </tbody>	7/25/2013 (Thu) <tbody> </tbody>	7/28/2013 (Sun) <tbody> </tbody>	Occurs same time as: Event 4 Event 6 <tbody> </tbody>
EVENT 7	7/26/2013 (Fri) <tbody> </tbody>	7/26/2013 (Fri) <tbody> </tbody>	Occurs same time as: Event 4 Event 5 <tbody> </tbody>
EVENT 8	9/16/2013 (Mon) <tbody> </tbody>	9/20/2013 (Fri) <tbody> </tbody>
EVENT 9	9/29/2013 (Sun) <tbody> </tbody>	10/3/2013 (Thu) <tbody> </tbody>	Occurs same time as: Event 9 <tbody> </tbody>
EVENT 10	9/26/2013 (Thu) <tbody> </tbody>	10/3/2013 (Thu) <tbody> </tbody>	Occurs same time as: Event 8 <tbody> </tbody>
EVENT 11	11/4/2013 (Mon) <tbody> </tbody>	11/7/2013 (Thu) <tbody> </tbody>
EVENT 12	12/2/2013 (Mon) <tbody> </tbody>	12/6/2013 (Fri) <tbody> </tbody>
EVENT 13	1/6/2014 (Mon) <tbody> </tbody>	1/13/2014 (Mon) <tbody> </tbody>

<tbody>
</tbody>

Let me know if you need anymore information!
Chip

 

[Chip_Excel]

Sorry, table information was slightly off. Here is corrected:

EVENT	Start	Finish	WHAT FORMULA WOULD CALC
EVENT 2	5/22/2013 (Wed) <tbody> </tbody>	5/22/2013 (Wed) <tbody> </tbody>
EVENT 3 <tbody> </tbody>	6/17/2013 (Mon) <tbody> </tbody>	6/19/2013 (Wed) <tbody> </tbody>	Occurs same time as: Event 4 <tbody> </tbody>
EVENT 4 <tbody> </tbody>	6/17/2013 (Mon) <tbody> </tbody>	6/18/2013 (Tue) <tbody> </tbody>	Occurs same time as: Event 3 <tbody> </tbody>
EVENT 5 <tbody> </tbody>	7/24/2013 (Wed) <tbody> </tbody>	7/31/2013 (Wed) <tbody> </tbody>	Occurs same time as: Event 6 Event 7 <tbody> </tbody>
EVENT 6 <tbody> </tbody>	7/25/2013 (Thu) <tbody> </tbody>	7/28/2013 (Sun) <tbody> </tbody>	Occurs same time as: Event 5 Event 7 <tbody> </tbody>
EVENT 7	7/26/2013 (Fri) <tbody> </tbody>	7/26/2013 (Fri) <tbody> </tbody>	Occurs same time as: Event 5 Event 6 <tbody> </tbody>
EVENT 8	9/16/2013 (Mon) <tbody> </tbody>	9/20/2013 (Fri) <tbody> </tbody>
EVENT 9	9/29/2013 (Sun) <tbody> </tbody>	10/3/2013 (Thu) <tbody> </tbody>	Occurs same time as: Event 10 <tbody> </tbody>
EVENT 10	9/26/2013 (Thu) <tbody> </tbody>	10/3/2013 (Thu) <tbody> </tbody>	Occurs same time as: Event 9 <tbody> </tbody>
EVENT 11	11/4/2013 (Mon) <tbody> </tbody>	11/7/2013 (Thu) <tbody> </tbody>
EVENT 12	12/2/2013 (Mon) <tbody> </tbody>	12/6/2013 (Fri) <tbody> </tbody>
EVENT 13	1/6/2014 (Mon) <tbody> </tbody>	1/13/2014 (Mon) <tbody> </tbody>

<tbody>
</tbody>