满意回答
2022/01/16 11:56
B4=TEXT(TODAY()+COLUMN()-2,"m月d日")B5=TEXT(B4,"aaaa")B6=CHOOSE(WEEKDAY(B4,2),"B","C","C","休","A","A","B")(没看出排班规律）公式横拖就可以了
评论(0)
加载中...
匿名
其他回答(0)
0人关注该问题