=IF(INT(RIGHT(F2,2))<VLOOKUP(INT(LEFT(F2,2)),'第5周 周考 监考安排'!$A$6:$D$54,4,0),LEFT(F2,2)&"－"&IF(INT(RIGHT(F2,2))+1<10,"0"&INT(RIGHT(F2,2))+1,INT(RIGHT(F2,2))+1),IF(INT(LEFT(F2,2))+1<10,"0"&INT(LEFT(F2,2))+1,INT(LEFT(F2,2))+1)&"－"&"01")

太难了，这是个条件函数