Date Formatting in Pivot Tables

[Jonny Edo]

Hi guys,
I have some data which i would like to pivot.
One of the columns shows the full date. From this column, I have made a new column with that date in a "mmm-yy" format.
This is the format i would like it to appear in, in my pivot table. However, when I do place it in a pivot table, the same "mmm-yy" is showing repeatedly.
I understand that this is due to the dates within the format being taken from the original full date column.
I don;t want to use the =TEXT(A1,"mmm-yy") formula, as when i sort this in the pivot table, the dates are recognised as text and will be sorted into alphabetical order, not date order.

To recap; i would like to show "mmm-yy" formatted dates in a pivot table, which retain their date format so i can sort it accordingly.

 

[ParamRay]

.
.

Rather than formatting your original column as "mmm-yy", insert a new column and use this formula: =DATE(YEAR(A1),MONTH(A1),1)
Format the new column as "mmm-yy" and then create your pivot table...

 

[Jonny Edo]

Amazing!!! Thanks mate!

.
.

Rather than formatting your original column as "mmm-yy", insert a new column and use this formula: =DATE(YEAR(A1),MONTH(A1),1)
Format the new column as "mmm-yy" and then create your pivot table...