Hi!
I have a countifs functions which has, among other criteria, to count all the dates of a certain month and year.

here the formula:

=countifs(...;[range];"=*"&month(A4)&"/"&year(A4);...)

this formula returns 0. If I change the wildcard with a specific day number, it works fine.

Any clue?