Forum Discussion
Unable to use group the pivot table with date
I was unable to group the Pivot table with date selected. I've validated the format of the date and numbers as well.
In addition, validate values, not formats. If you have texts which looks like dates and apply date format to such texts - values will remain texts, applied format changes nothing.