Pivot Table Date Errors

[Tamarissa]

I can't seem to get rid of these 2 pivot table date errors that screwed up my spreadsheet.

Error 1: Date filter has every single day of the year instead of the dates in my spreadsheet

Error 2: Can't sort by date order; it sorts by the day number only (also won't format to the format it says it is (DD-MMM-YY)). Yes, the dates in the worksheet are actual dates.

Is there a new setting somewhere in Excel that I can change? I've never seen this happen before and it's ridiculously frustrating and useless. Thanks!
Excel for Mac v16.41 (Microsoft 365)

[Exl-Noob]

Hi Tamarissa,

You probably have found a solution already, since it was posted a while back.
I fixed both errors by copying the data to a new excel spreadsheet and recreating the pivot tables.
Something is wrong with your file apparently. I couldn't fix it, I had to create a new file.

Cheers.