Forum Discussion
Cannot group that selection in a pivot table
Hi there. I have a formula auto-calculating the next date to a column on which I have a pivot table. I have verified that the dates are valid based on the calendar and that there are no unallowable...
I have a similar problem and have followed the instructions that you have provided but did not get a win 
FYI Pivot table data source is set to include row 39.
Pivot table filter displays the 0 however does not recognise date format.
Simon_FishWell, the fact that the filter dialogue box says you can Sort A to Z or Z to A suggests that you are dealing with texts that merely look like dates. With real dates it will say:
Select the 'dates' in P2:P39. Then, on the Data ribbon select Text-to-columns and press Finish. So, just Finish. change nothing. That should convert the text dates into real dates. Refresh the pivot table and it shall work.
Save your file first, though, so that you don't loose your data if it goes wrong.