如何在Excel表格中日期列项中把其中的日期以本周、本月、今年、往年进行...答: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...