I want to use parse data in a piviot table by months. The data is in the format of dd/mm/yyyy. Changing the date format to mm-yy does not change the date serial number and the pivot table still sees the individual days. I need to either convert the date code to mm/yyyyy or change the format from date to text. I'd settle for either solution.

Thanks