I am exporting reports as XLS files from Salesforce. These reports have dates that I want to be able to manipulate in Excel but... Excel doesn't recognize them as dates.

The format outputted by Salesforce right now is m/d/yyyy (ie: 8/18/2022). When I go in Excel and change the format to date... the data is not recognized as a date. It seems the only thing that Excel can consume are dates configured as yyyy-mm-dd.

I tried to play with Excel formatting date form with no luck.