Try these:

A1 = 1/1/2008
B1 = 1/15/2008

Count how many times 1/1/2008 appears in the range D1:D10 -

=COUNTIF(D1:D10,A1)

Count how many dates in the range D1:D10 are between 1/1/2008 and 1/15/2008
(inclusive):

=COUNTIF(D1:D10,"="&A1)-COUNTIF(D1:D10,""&B1)

--
Biff
Microsoft Excel MVP


"chrspty" wrote in message
...
How do I count how many times a date appears in a range of cells? I would
also like to count the number of times a range of dates appear in a range
of
cells.