=COUNTIF(A1:A5,B1)

You don't need the =B1, it is just B1
--
Allllen


"TMF in MN" wrote:

A B C
8/1/06 8/1/06 2
8/2/06 8/2/06 1
8/3/06 8/3/06 2
8/3/06
8/1/06

I need a formula to count how many dates in the list are for 8/1, 8/2, etc.
I tried COUNTIF(A1:A5,=b1) and get 0 value