David is correct, but the double minus also converts true/false values to 1
and 0 respectively. This allows you to sum the true/false values and get a
count of how many trues there were.

Bob Phillips has an excellent discussion on sumproduct here
http://xldynamic.com/source/xld.SUMPRODUCT.html

"Victor Delta" wrote:

"JMB" wrote in message
...
assuming your dates are in A1:A7 and todays date is in cell C1, try:

=SUMPRODUCT(--(TEXT(A1:A7,"mmyy")=TEXT(C1-DAY(C1),"mmyy")))

JMB

Many thanks. Works brilliantly!

However, the only thing I don't understand is the two hyphens at the start
of the first bracket?

Regards,

V