Pivot on Date removes formatting

I have a date column that I'm pivoting so that the column header is the date, I've kept it as a date so that it's sorted properly. When I pivot it just shows the column as the number, how do I get it to keep the date format?

Did you leave the checkbox for Preserve formatting checked? Maybe this will help you.

As far as I know, column names can only be strings and not numeric values.

1 Like

Haha - no.... Thanks for pointing that out!