Excel 表格使用if函数答:=IF(M1="星期六",2,IF(M1="星期日",1,0)) 下拉复制公式即可 公式改为 =IF(MOD(M1-1,6)=0,2,IF(MOD(M1-1,7)=0,1,0))以上考虑不妥,公式改为 =IF(MOD(M1-7,7)=0,2,IF(MOD(M1-1,7)=0,1,0))再修改为 =IF(M1="",0,IF(MOD(M1-7,7)=0,2,IF(MOD(M1-1,7)=...
日期列中的日期为星期六或星期日,则在是否加班列的单元格中显示是,否...答:表格A列的是日期格式,得用日期函数转换一下才能得到正确的结果。B3公式下拉:=IF(A3="","",IF(WEEKDAY(A3,2)>5,"是","否"))或者用这公式也行:=IF(A3="","",IF(WEEKDAY(A3,2)<6,"否","是"))
excel日期自动匹配星期答:4. 如果要显示“星期六”而不是“6”,可以在公式中加入IF函数,如“=IF(WEEKDAY(A1,2)=1,"星期一",IF(WEEKDAY(A1,2)=2,"星期二",IF(WEEKDAY(A1,2)=3,"星期三",IF(WEEKDAY(A1,2)=4,"星期四",IF(WEEKDAY(A1,2)=5,"星期五",IF(WEEKDAY(A1,2)=6,"星期六","星期日")))...