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
Bookmarks