春节上班與排休 計加班天数 (12367)

E6=D$2-SUM(FREQUENCY(ROW(INDIRECT(B6&":"&C6)),B$2:C$2-{1,0})*{0;1;0})

另解=D$2-COUNT(MATCH(ROW(INDIRECT(B6&":"&C6)),ROW(INDIRECT(B$2&":"&C$2)),))

另解{=D$2-COUNT(INDIRECT("A"&B6&":A"&C6) INDIRECT("A"&B$2&":A"&C$2)*1)

另解=8-MAX(,MIN(C$2,C6)-MAX(B$2,B6)+1)