5人三班倒排班表,一个月每个人休息8天,怎么排班,最好能给出excel的表...答:早班:AI3=COUNTIF($D3:$AH3,$AI$1), AI4=COUNTIF($D4:$AH4,$AI$1) ;中班:AJ3=COUNTIF($D3:$AH3,$AJ$1), AJ4=COUNTIF($D4:$AH4,$AJ$1) ;夜班:AK3=COUNTIF($D3:$AH3,$AK$1), AK4=COUNTIF($D4:$AH4,$AK$1) ;公休:AL3=COUNTIF($D3:$AH3,$AL$1), ...