C4 写公式:=COUNTIFS(E:E,">="&(TODAY()-WEEKDAY(TODAY(),1)+1),E:E,"<="&(TODAY()+(7-WEEKDAY(TODAY(),1))*1),F:F,"否")
C5写公式:=COUNTIFS(E:E,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),1),E:E,"<="&(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1),F:F,"否")
C6写公式:=COUNTIFS(E:E,">="&DATE(YEAR(TODAY()),1,1),E:E,"<="&DATE(YEAR(TODAY()),12,31),F:F,"否")
C7写公式:=COUNTIFS(E:E,"<"&DATE(YEAR(TODAY()),1,1),F:F,"否")
C13~C16的公式分别参照上述C4~C7的公式,只是将后面的条件"否"改为"是" 即可
追问
使用函数后,显示错误结果,这个什么情况
追答哪里错了?我看见你截图的第二个公式有错,tear那里。看我的答案。
追问
已经改好了,谢了兄弟