Countif formula using a date range
Hi,
I'm trying to count the number of rows within a specific date range and can't make this formula work:
=COUNTIFS({Date to Deactivate}@row, {Date to Deactivate}@cell >= DATE(2022,04,01), @cell <= DATE(2022,04,30))
Thanks for your help!
Answers
-
Try these adjustments...
=COUNTIFS({Date to Deactivate}, AND(@cell >= DATE(2022,04,01), @cell <= DATE(2022,04,30))
-
Hi @deb_63_hydracor,
I assume you're capturing the total in a sheet summary field or in a different column. Give this a try:
=COUNTIFS([Date To Deactivate]:[Date To Deactivate], AND(@cell >= DATE(2022, 4, 1), @cell <= DATE(2022, 4, 30)))
I just tried it in a test sheet I created and appears to be working:
I hope that helps!
-
Thanks Paul!
-
Thanks Sing!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!