Hi Steve,

Just another one,

=SUMPRODUCT(--(A1:A20-DAY(A1:A20)=TODAY()-DAY(TODAY())))

Regards,

Daniel M.

"Steve J" wrote in message
...
Hi

I have a colum which contains dates in format mmm-yy format
In the first row, I would like to count the number of instances where the
month and year is equal to the current month and year.

Is this possible please?

Tks
S