check if dates falling in range of other dates

I have a data of employees and I want to check if the joining and releasing dates of previous organization falling in recent organization.

so for example org1 is the recent previous organization and Org2 is previous to previous organization.

for example in image in row two the relieving date of org two falls between joining date and relieving date of org1 then it should show Yes in column H.
same as in row 5 relieving date of org2 falls between the range of joining date1 and relieving date1 then this should show as Yes in column H.

so the actual requirement is if the Joiningdate2 and relieving date2 falls between the range of joiningdate1 or relieving date1 then H column will Yes else NO.



Thanks in advance.

Capture.PNG

So, starting at #2 before leaving #1 (True/False):

Please Login or Register  to view this content.

Overlap:

Please Login or Register  to view this content.