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