View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomCat TomCat is offline
external usenet poster
 
Posts: 34
Default Need to count dates in a spreadsheet

I have a spreadsheet with a column containing dates formatted as mm/dd/yyy
and they are in random order. I need to count how many of the dates in the
column are in January, February, March, etc. and come up with totals in
another set of cells. I have tried various functions like COUNTIF with MONTH
but I cannot seem to get the right combination. Anybody out there ever do
this type of thing?