EXCEL如何避免连续7天上班 例如:5-1~5-31出现连续上7天班的警报,求大 ...答:作为辅助,AH列显示该员工当月排班的最长出勤天数。AG4=IF(MAX(LEN(TRIM(MID(SUBSTITUTE(CONCAT(IF(B4:AF4="","T",B4:AF4)),"T",REPT(" ",99)),99*(ROW($1:$31)-1)+1,99)))>6,"最长连续天数超时","")AH4=MAX(LEN(TRIM(MID(SUBSTITUTE(CONCAT(IF(B4:AF4="","T",B4:AF4...