I'm creating a new column next to date column in Excel. I use function =Datevalue and click the column where the dates are from the QBO export. This converts General/Text type into date format. At least this worked for me and I was able to group dates again in pivots etc..
