Count number of days of the month entered in a column

Hello,

I am looking to count the number of times a day of the month (any month) appears in a column.

I was playing with the following, but it didn't work.

=SUMPRODUCT(($A$6:$A$99985<>"")*(TEXT($A$6:$A$99985,"dd")=$B1))

I have a sample attached, with expected results.

I appreciate any help on this.

Thank you,
Nick

You can use this formula in cell B2:

=SUMPRODUCT(($A$6:$A$99985<>"")*(DAY($A$6:$A$99985)=B$1))

then copy across.

Hope this helps.

Pete

Thanks Pete! I was close lol. I appreciate your help.

You're welcome, Nick - thanks for the rep.

Pete