I have a pivot table with Date as a label field. That field sources data from cells formatted as Dates.
When I sort the table Oldest to Newest this is the result:
| 10-Feb |
| 12-Feb |
| 13-Feb |
| 14-Feb |
| 15-Feb |
| 16-Feb |
| 19-Feb |
| 20-Feb |
| 21-Feb |
| 22-Feb |
| 26-Feb |
| 27-Feb |
| 28-Feb |
| 29-Feb |
| 7-Feb |
| 8-Feb |
| 9-Feb |
I have already combed through web posts and youtube videos and cannot find a solution to what should be pretty basic functionality.
What is missing here?
Looks like alphabetical sort, so format is not date, even if it looks like a date.
Can you upload a sample file that replicates the problem?
Hi, can't send file but the source cells are formatted date and so are the fields in the pivot table. I already posted screenshots of this but for some reason this blog has lost that reply, but believe me it is true. Excel for Mac latest version.
Hi Sean,
Cell formats are not the same as the data type being a date. You can format a cell containing text as a currency, but it will still display text. Likewise for dates. See this post on how to tell if your dates are actually formatted as text and how to fix them.
Mynda
Will check out out, thanks. Because who would think that if you're dealing with dates, that is not really what the data is ... will take a look.
