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)))
