Everytime I need a Pivot where columns are months I have to create a separate column in my spreadsheet with just the month (sometimes YYYY-MM). The cell referenced is a standard date number in Excel.
I hate having to do that and I'm wondering if I'm missing a feature in Excel pivots that does that automatically.
Do you know how to do it without creating another cell on the spreadsheet?
Thank you.
Bookmarks