5人三班倒排班表,一个月每个人休息8天,怎么排班,最好能给出excel的表...答:中班: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), AL4=COUNTIF($D4:$AH4,$AL$1) ;总班次:AM3=SUM(AI3:AK3) , AM4=SUM(AI4...