Pivot table month sort order

Rather converting to text, use a function to round the date to the end/beginning of the month:

End of month
=EOMONTH(cell,0)

Beginning of Month
=EOMONTH(cell,-1)+1

The numerical parameter is the number of months to add to the date. Adding 0 months just rounds to the end of the month; -1 months rounds back to previous month end and then adding 1 to the result gives the first of the next month.

Format the result as "mmm-yy" and you will see the same result but the dates will then sort in order as expected.

Thanks
Rob H

Alternatively, I know there is a function, but not sure how to do it, where you can group data such as dates in a Pivot Table so that you still see only the one column per month rather than a column for each day of the month.

You then wouldn't need the extra column at all.

Thanks
Rob H

Rob where to put those functions??
How to apply them? ..In source data column  or in pivot area?
 Is that used with  separate new column or existing one?

Use instead of your text conversion.

Both of them in one cell?

For not being  excel expert , Can you give me example?

Thanks a lot