COUNTIFS per calendar month

Answers
-
Looking to use a similar function by counting up the number of times an entry is made in a calendar month. However tried just using the formula above and this doesn't work for me, any reason why not, is it the UK date ranges are different?
=COUNTIFS([Plan Date]1:[Plan Date]17, >=DATE(1, 3, 2020), [Plan Date]1:[Plan Date]17, <=DATE(31, 3, 2020))
to me this should return the amount of rows inside of March 2020
I do want to go one further and split this out by different plants, but thought if I get the date counting right the extra part should be simple.
any help is appreciated.
-
The DATE function is:
DATE(yyyy, mm, dd)
You can also use
IFERROR(MONTH(@cell), 0) = 3
IFERROR(YEAR(@cell), 0) = 2020
=COUNTIFS([Plan Date]1:[Plan Date]17, AND(IFERROR(MONTH(@cell), 0) = 3, IFERROR(YEAR(@cell), 0) = 2020))
This allows you to not worry about how many days are in the month. Just update the month number and year number, and you are set.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!