Can you elaborate as to which of the suggestions didn't work for you?  There were several offered through the string of replies.   

I just double checked and the one that I offered (using the "=VALUE()" function and then formatting the resulting column as a Short Date) did.  The Pivot Table allowed the month to be separated from the date easily.