Thread
:
I NEED A FUNCTION TO FIND IF THERE IS AN INTERSECTION BETWEEN 2 DATE RANGES
View Single Post
#
10
Harlan Grove
Posts: n/a
"KL" wrote...
Your formula can be further reduced to:
=AND(Start2<=End1,Start1<=End2)
....
Technically this wouldn't be overlap is either but not both conditions were
TRUE due to exact equality. Drop the equal signs
Reply With Quote