[Solved] Count cells for a date range

[touchups]

I have a column of dates. Need to count the number of those date entries based on month and year only. Basically trying to see how many "widgets" sold per month per year. Thank you.

[acknak]

Greetings and welcome to the community forum!

If A1:A4 is the range containing the dates, and you wanted the number of dates in January of this year, something like this will work:
=SUMPRODUCT(A1:A4>=DATE(2017;1;1);A1:A4<=DATE(2017;1;31))

If you wanted to count dates that are in September of any year, maybe something like this:
=SUMPRODUCT(MONTH(A1:A4)=1)

The SUMPRODUCT here is just adding up zeroes and ones (the results of the boolean comparisons) to give a count; I used it instead of plain SUM out of convenience, since these are array formulas and SUMPRODUCT provides its own array context.

[Villeroy]

viewtopic.php?t=86377&p=403796#p403796

[thinman3]

If you wanted to count dates that are in September of any year, maybe something like this:
=SUMPRODUCT(MONTH(A1:A4)=1)

I think acknak had January on his mind( =1 ); instead of the 1 , use 9 for September.

[touchups]

Thank you for the replies. I kept working on it since my original post and came up with the sumproduct solution. Thanks again!