Reports which are exported in excel has the below issue. The dates are not in the date format. The data is stored as General format and does not change properly to dates

Hello there, grishsavla.

We can fix the incorrect report by enabling Marcos. Here's how:

1. In Excel, go to the File menu.
2. Select Options.
3. Click Trust Center, then select Trust Center Settings.
4. Select Macros Settings, then select Disable all macros except digitally signed macros.
5. Select OK.
6. Re-export the report from QuickBooks Online to Excel.

If your customer gets a notification about Macros when exporting, accept the Macros. You can also check this article to learn on what to do when there are missing details when opening the report in Excel. Then, here are some articles that will guide you through modifying and memorizing reports within your QBO account.

• Learn how to get the most out of your financial reports.
• Memorise reports in QuickBooks Online. 

Please don't hesitate to post again if you have other questions. I'm here to help. Take care always.

I have experienced the same issue.  I have also resorted to creating a new column, using the "=Value()" function - with the argument being the cell with the exported date, then formatting the column as a "Short Date".  That allows my Pivot Tables to break the date up so I can get monthly totals.

Another of those wonderful things that we must find work-arounds for....

Export as CSV instead of Excel.  Date fields are automatically recognized as dates by Excel.