Countifs by date in month?

Hello,

I would like to count the number of records that occur on the first of the month, second of the month, etc. The goal is to determine if there is a trend in which we experience lower new accounts at any point in any given month.

How can I count the number of records that fall on the first, second, third, etc.?

Thanks in advance!

You can do it with SUMPRODUCT.

Assuming A1:A10 is dates and B1:B10 are the records:

=SUMPRODUCT((DAY(A1:A10)=1)*(B1:B10))


Edit: Same solution and ranges! Creepy!