View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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.