excel日期与周转换问题答:周三 =IF(3>=WEEKDAY(A1,2),(IF(3>WEEKDAY(A2,2),B5,B5+1)),(IF(3>WEEKDAY(A2,2),B5-1,B5)))周四 =IF(4>=WEEKDAY(A1,2),(IF(4>WEEKDAY(A2,2),B5,B5+1)),(IF(4>WEEKDAY(A2,2),B5-1,B5)))周五 =IF(5>=WEEKDAY(A1,2),(IF(5>WEEKDAY(A2,2),B5,B5+1)),...
Excel 想要实现:A列中的周一到周五,C列对应格自动显示5,A列中周六...答:如果A列是日期格式,如2012-11-5 则在B1单元格输入公式 =if(weekday(a1,2)<6,5,4)下拉填充.如果A列是文本格式的 周一,周二,周三,周四,周五,周六,周日 则在B1单元格输入公式 =if(or(a1={"周六","周日"}),4,5)下拉填充
在excel里, 比如周一, 周二, 周三分别对应6月1号, 2号, 3号, 怎样才...答:2.在B2输入公式:=IF(WEEKDAY(A2,1)=1,"星期日",IF(WEEKDAY(A2,1)=2,"星期一",IF(WEEKDAY(A2,1)=3,"星期二",IF(WEEKDAY(A2,1)=4,"星期三",IF(WEEKDAY(A2,1)=5,"星期四",IF(WEEKDAY(A2,1)=6,"星期五","星期六")))3.然后往下拖,日期和周一、周二都可以自动填空了 ...