Excel-统计日期内的个数1月到12月

使用函数COUNTIFS（范围,"条件",范围,"条件"）

=COUNTIFS(Sheet!F2:F230,">=2024-01-01",sheet!F2:F230,"<=2024-01-31")
=COUNTIFS(sheet!F2:F230,">=2024-02-01",sheet!F2:F230,"<=2024-02-29")
=COUNTIFS(sheet!F2:F230,">=2024-03-01",sheet!F2:F230,"<=2024-03-31")
=COUNTIFS(sheet!F2:F230,">=2024-04-01",sheet!F2:F230,"<=2024-04-30")
=COUNTIFS(sheet!F2:F230,">=2024-05-01",sheet!F2:F230,"<=2024-05-31")
=COUNTIFS(sheet!F2:F230,">=2024-06-01",sheet!F2:F230,"<=2024-06-30")
=COUNTIFS(sheet!F2:F230,">=2024-07-01",sheet!F2:F230,"<=2024-07-31")
=COUNTIFS(sheet!F2:F230,">=2024-08-01",sheet!F2:F230,"<=2024-08-31")
=COUNTIFS(sheet!F2:F230,">=2024-09-01",sheet!F2:F230,"<=2024-09-30")
=COUNTIFS(sheet!F2:F230,">=2024-10-01",sheet!F2:F230,"<=2024-10-31")
=COUNTIFS(sheet!F2:F230,">=2024-11-01",sheet!F2:F230,"<=2024-11-30")
=COUNTIFS(sheet!F2:F230,">=2024-12-01",sheet!F2:F230,"<=2024-12-31")

原文地址：https://blog.csdn.net/michael_jovi/article/details/142525163

免责声明：本站文章内容转载自网络资源，如本站内容侵犯了原著者的合法权益，可联系本站删除。更多内容请关注自学内容网（zxcms.com）！