If you are counting, then why not use COUNTIF?

Here's an example: =COUNTIF(A1:A8,C1)

where A1:A8 is the range of dates and C1 is the date for which you are
testing.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"JerryS" wrote in message
...
I am trying to use the sumproduct function to count how many times a
particular date appears in a coumn and I cannot get it to work. The date
format is 6/6/2005. I must be overlooking something but I don't know what.
Anybody got an answer? Thanks
--
JerryS