How to count dates by month and day only

[Chubba]

Hello

I have a list of dates and am trying to count the number of instances that are, for example, 3rd of May irrespective of year. Is that possible?

I tried the following, with various permutations for the year but didn't work:

=COUNTIF($A:$A,DATE(,5,3)

Many thanks

 

[Joe4]

Try this:

=SUMPRODUCT(--(MONTH($A:$A)=5),--(DAY($A:$A)=3))

Note that it will be faser/more efficient if you use a defined range and not the whole column.

 

[Fluff]

How about
=SUMPRODUCT((DAY(A1:A34)=3)*(MONTH(A1:A34)=5))

 

[Chubba]

Brilliant, many thanks both.

Agreed about the named range and is something I am using but thought it might be easier to illustrate in the formula in the question.

Many thanks again

 

[Fluff]

Glad we could help & thanks for the feedback

 

[Peter_SSs]

FWIW you can also do the day & month check at the same time.
=SUMPRODUCT(--(TEXT(A1:A34,"ddmm")="0305"))