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

Paul Newcome

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