EXCEL如何跨年统计一个日期段内每月的天数答:c5公式参考:=IF(DATE(2014+INT(ROW(A13)/12),MOD(ROW(A13),12)+1,1)<$C$2,"",IF(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1)>$C$3,"",IF(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1)=DATE(YEAR($C$2),MONTH($C$2),1),NETWORKDAYS(DATE(2014+...
如何在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...