In my pivot table I tried to right click the "Date" column in order to group
by month.
A message popped up "Cannot Group that Selection".
Is there another way to group by month?
Should I create another column for month in my data source?

These are my headers for data source on another worksheet in the same
workbook.
PC# DATE PAYEE DESCRIPTION CHECK AMOUNT PHASE CODE

Thanks in advance for any help.