Dates to Month only

J

Jim

Quick question...

I have a list of dates mm/dd/yy
and I need to pull the data into a table that counts all
items in each month.

How can I get the dates to = month?
I know that I can change the formating, but it still
reads it as a number. and will not correspond to my table
heading.

I would like to use this formula in my table:
=countif(date,"January")
 
Top