當前位置:編程學習大全網 - 網站源碼 - EXCEL 統計該月天數公式怎麽寫

EXCEL 統計該月天數公式怎麽寫

看我的抓圖:

統計該月周壹至周四:

=SUMPRODUCT((MONTH(A$1:A$100)=MONTH(TODAY()))*(WEEKDAY(A$1:A$100,2)>0)*(WEEKDAY(A$1:A$100,2)<5))

統計該月周五:

=SUMPRODUCT((MONTH(A$1:A$100)=MONTH(TODAY()))*(WEEKDAY(A$1:A$100,2)=5))

統計該月周六日:

=SUMPRODUCT((MONTH(A$1:A$100)=MONTH(TODAY()))*(WEEKDAY(A$1:A$100,2)>5)*(WEEKDAY(A$1:A$100,2)<=7))

  • 上一篇:怎麽用Thinkphp+jquery實現ajax的提交,接收處理和返回
  • 下一篇:飛馬三朵雲是哪個成語?
  • copyright 2024編程學習大全網