當前位置:編程學習大全網 - 電腦編程 - EXCEL如何跨年統計壹個日期段內每月的天數

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+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1),$C$2),IF(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1)=DATE(YEAR($C$3),MONTH($C$3),1),NETWORKDAYS(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1),$C$3),NETWORKDAYS(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1),DATE(2014+INT(ROW(A13)/12),MOD(ROW(A13),12)+1,1)-1)))))

然後下拉實現。

  • 上一篇:揚州藝術中考加分嗎?
  • 下一篇:雙槽皮帶輪在傳遞過程中壹緊壹松不同步會產生什麽後果?
  • copyright 2024編程學習大全網