View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jwmillzy
 
Posts: n/a
Default using countif to add dates


I need to count the number of events in a month.
I am reading off a column of cells that have 5/1/2006,
5/11/2006, 4/27/2006, etc
I want to tally the number of events, so in the above example
the result would be May 2 and April 1
I need it to count all dates in may as one total, April as a total etc
I am having trouble because my formula will only recognize each unique date
Any suggestions, thx