Count in date range
lesmickin
✭✭
I have a field - Let's say Closed Date
I am wanting a count of only those with close dates between 9/1/19 and 9/30/19. I keep trying different formulas but i keep getting the unparseable error
Comments
-
Try something like this...
=COUNTIFS([Closed Date]:[Closed Date], AND(IFERROR(MONTH(@cell), 0) = 9, IFERROR(YEAR(@cell), 0) = 2019))
This will give you the count of all dates that fall within the month of September in 2019.
.
If you need to be able to specify the dates, you can try something like this...
=COUNTIFS([Closed Date]:[Closed Date], AND(@cell >= DATE(2019, 09, 01), @cell <= DATE(2019, 09, 30)))
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives