View Single Post
  #1   Report Post  
Keith Brown
 
Posts: n/a
Default Count the occurances of a month in a range of date fields

I am needing to count the number of times each month is repeated in a column.
The column is a date field in MM/DD/YY format. I attempted to change the
format to MMMM DD, YYYY format (e.g. January 1, 2005) and count off of the
word January, but that did not work (=COUNTIF(C:C,"*January*")).

Is there way to find out how many times a month is repeated?

Thank you