电子表格如何设置排班表随着日期而自动更换
提问：电子表格如何设置排班表随着日期而自动更换
网友回答：
B4=TEXT(TODAY()+COLUMN()-2,"m月d日")
B5=TEXT(B4,"aaaa")
B6=CHOOSE(WEEKDAY(B4,2),"B","C","C","休","A","A","B")(没看出排班规律）
公式横拖就可以了
提问：电子表格如何设置排班表随着日期而自动更换
网友回答：
B4=TEXT(TODAY()+COLUMN()-2,"m月d日")
B5=TEXT(B4,"aaaa")
B6=CHOOSE(WEEKDAY(B4,2),"B","C","C","休","A","A","B")(没看出排班规律）
公式横拖就可以了
盒子游戏,游戏玩家专属个性阅读社区