Counting dates in cells
 

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.

Counting dates in cells
 

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.

Counting dates in cells
 

1 =COUNTIF(A1:A21,DATE(2008,8,1))

2
=COUNTIF(A1:A21,"="&DATE(2008,8,1))-COUNTIF(A1:A21,""&DATE(2008,8,31))
--
David Biddulph

"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.