Overlapping Dates per Name

Thanks! that sorts out the number of overlaps per name. I had to tweak the formula a little:
=SUMPRODUCT((Start<=D8)*(End>=C8)*(Name=B8))-1

would you be in a position to help me out with the others?

Namely the first line item it overlaps with and the number of days it overlaps by;

LineNumbeEmployee_Sys Start End Overlaps FirstOverlap NumberofDays
_0001 Bobette, ABN_00003 2013/04/08 2013/04/18 1 _0002 43
_0002 Bobette, ABN_00003 2013/04/17 2013/04/27 1 _0001 43
_0003 Huir, A_00006 2013/04/28 2013/05/08 1 43
_0004 Huir, A_00006 2013/05/09 2013/05/19 1 43
_0005 Huir, A_00006 2013/04/04 2013/07/13 2 43

Originally Posted by WinteE

I guess something with INDEX and MATCH, but I don't know enough of these to solve this for you.

No worries. Thanks anyway for the help