Forum Discussion
Using COUNTIF to select a date
I have a column of dates and I'm trying to count all the dates in Jan, Feb ...etc. I'm trying to use COUNTIF with MONTH() but not sure how to get this to work. Pretty new to Excel so any help...
Hello,
This formula will do the job
=COUNTIFS(A2:A1000, ">="&DATE(2019,1,1), A2:A1000, "<="&DATE(2019,12,31))
The formula counts all the records between Jan 1st 2019 to Dec 31st 2019
This formula will do the job
=COUNTIFS(A2:A1000, ">="&DATE(2019,1,1), A2:A1000, "<="&DATE(2019,12,31))
The formula counts all the records between Jan 1st 2019 to Dec 31st 2019
- Thanks - it works for me! Andy
