Forum Discussion
Date Filter on Pivot Table
Many of the cells in column H contain text values instead of dates. You can easily see this if you widen column H. The text values will be left-aligned, while the real dates will be right-aligned.
Because of this, Excel treats column H as text.
Moreover, the 'real' dates have their day and month switched.
In the attached version, I have corrected both issues using Data > Text to Columns (in two steps, one for the date values and another for the text values)
Many of the cells in column H contain text values instead of dates. You can easily see this if you widen column H. The text values will be left-aligned, while the real dates will be right-aligned.
Because of this, Excel treats column H as text.
Moreover, the 'real' dates have their day and month switched.
In the attached version, I have corrected both issues using Data > Text to Columns (in two steps, one for the date values and another for the text values)
