用Excel算出日期除去周六下午及周日相减得出天数答:如果计算A1:A18单元格日期,去除周六下午和周日的实际天数,那么输入 =SUMPRODUCT((TEXT(A1:A18,"aaa")={"一","二","三","四","五","六","日"})*{1,1,1,1,1,0.5,0})公式表示:通过TEXT(A1:A18,"aaa")将A1:A18的日期转换为星期的“一二三四五六日”,然后再与后面对应的计数方式...
日期列中的日期为星期六或星期日,则在是否加班列的单元格中显示是,否...答:表格A列的是日期格式,得用日期函数转换一下才能得到正确的结果。B3公式下拉:=IF(A3="","",IF(WEEKDAY(A3,2)>5,"是","否"))或者用这公式也行:=IF(A3="","",IF(WEEKDAY(A3,2)<6,"否","是"))