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....