No. I calculated TDate with the DATE function as well to rule that out. I
took the exact sample that you gave...

"TDate" "TQ7"
10/11/2004 q7= very easy
11/12/2005 q7= fairly easy
12/14/2004 q7= difficult

I then applied the formula
=SUMPRODUCT(--(TdateDATEVALUE("01/25/2005")),--(TQ7<""))

I got the correct answer of 1.

Maybe try it without the names.

"javamom" wrote:

Thanks for the response! The above returns a #NUM! error for me.

Do you think that calculating TDate with =DATE(D2,B2,C2) could be
causing a problem?