电子表格如何设置排班表随着日期而自动更换

提问：电子表格如何设置排班表随着日期而自动更换

网友回答：

B4=TEXT(TODAY()+COLUMN()-2,"m月d日")

B5=TEXT(B4,"aaaa")

B6=CHOOSE(WEEKDAY(B4,2),"B","C","C","休","A","A","B")(没看出排班规律）

公式横拖就可以了