Abstract

You need a worksheet function to test for overlapping ranges?

Overlapping_ranges

If adjacent ranges of time period may touch each other and if you want to see which range overlaps with others:

sbOverlap_Test

Note: D is the named range A2:B6

The formulas:

=REPT("Overlap! ",MMULT((INDEX(D,,1)<TRANSPOSE(INDEX(D,,2)))*(TRANSPOSE(INDEX(D,,1))<INDEX(D,,2)),INDEX(D,,1)*0+1)-1)

Alternate formula in C2 (copy down then):

=REPT("Overlap! ",SUMPRODUCT(--(A2<INDEX(D,,2));--(INDEX(D,,1)<B2))-1)