It's because the the dates in the source data rows 269 and below are not real dates but strings which look like dates. In the attached I've converted them to real dates (using Text-to-Columns) and grouped the dates in the pivot table by years and months.
|