Try this:

=countif(A:A,"="&date(2009,1,1))

Or put the date you are looking for in a cell like b1, and use:

=countif(A:A,"="&B1)

Adjust your range to suit.

Regards,
Fred.

"D Boyles" wrote in message
...
Using Excel 2003.

I am trying to count the number of times a date (i.e. 1/1/2009 or
1/8/2009)
appears in a range of cells.

I also want to be able to count the number of times a unit/floor appears
on
a gvien date (i.e. CTUN appears 3 times on 01/1/2009 and 6 times on
1/8/2009)
the unit is in one column and the date in another column.

I have tried every kind of function - countif, sumif, count, dcount and I
cannot get the calculation to work. I am sure that it has something to do
with the syntax but I just can't get it right.

Thanks
--
D