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+...