交叉日二區間始終日期 (9982)

F3{=CHOOSE(TEXT(COUNT(MATCH(ROW(INDIRECT(B3&":"&C3)),ROW(INDIRECT(D3&":"&E3)),))-1,"1;3;2"),TEXT(MAX(B3,D3),"YYY/M/D-")&TEXT(MIN(C3,E3),"YYY/M/D"),TEXT(MODE(B3:E3),"YYY/M/D"),"無")