Analyze in Excel - Date field issue

Not to necropost, but I am currently running into this issue and have so far been unable to find a solution. A Power BI field that is typed in Power BI as a Date and formatted to show up on reports as "Tuesday, December 10, 2019" pulls into my PivotTable (from Analyze in Excel) as a String instead of a Date.

Is there any way to get Excel to treat the PivotTable date field as an actual Date?

Here's an example of what I'm talking about. If "Fiscal Day" were an actual date, Fiscal Day + 1 would be Tuesday, May 16, 2017 (or however you choose to format your dates) but because it's a string, you get an error.

This also makes things like =SUMIFS(Some Measure, Fiscal Day, ">"&DATE(2017,1,1)) not work.

Any help appreciated, although I would prefer to not make a column D in the above example that essentially has:

=DATEVALUE(
   MID(
      $A2,
      FIND(" ",$A2),
      99
   )
)