When I export an Excel with a date/time field, the format is DD/MM/YYYY 00:00pm. This is not an Excel compatible format, so you cannot sort dates chronologically. To get around this, I have to use text-to-columns to remove the time portion of the field. Once the time is removed, it becomes sortable.
Please can the export format be adjusted so that Excel knows it's a date?