Forum Discussion

Copper Contributor

Mar 18, 2020

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

Formulas and Functions

Abiola1

MVP

Mar 18, 2020

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

andyredfern

Copper Contributor

Mar 18, 2020

Thanks - it works for me! Andy