excel 三班三倒任意时间查询排班表?答:=CHOOSE(MOD(INT(($F$2-$C$2+WEEKDAY($C$2,2)-1)/7)+4-ROW(1:1),3)+1,"早","夜","中"),向右向下填充。C10输入:=CHOOSE(MOD(INT(($C$8-$C$2+WEEKDAY($C$2,2)-1)/7)+4-ROW(1:1),3)+1,"早","夜","中"),向下填充。F2:=TODAY()C9:=TEXT(C8,"aaaa")...
EXCEL排值班循环表?答:即可在D3单元格输入公式:=IF(WEEKDAY(B3)=1,"",IF(WEEKDAY(B3)=7,D2,MID("甲乙丙甲",1+FIND(LOOKUP(1,0/(D$2:D2<>""),D$2:D2),"甲乙丙"),1)))复制并下拉,即可得到B列日期的对应排班表了。其中,C3 单元格只要输入公式:=TEXT(B3,"AAAA")复制并下拉,即可………...