Format column A in excel export as dates and sort in reverse chronological order automatically

[RebeccaBushby]

Describe the bug
In export of reports to excel:
Bug 1: Excel reads column A in the export as "custom", not as dates. Setting it to dates does not fix the issue (see below).
Bug 2: Dates in column A are listed in random order.

Bug 1 description:
When exporting the data from reporting to excel, excel doesn't recognize column A as dates. When selecting the column and formatting all cells as dates, it still reads it as text. Therefore, when trying to sort by date, it only gives the option to sort by A-Z, not newest-oldest.

The only manual excel fix I can make work is:

1. Select the date column. Under Data choose button Text to Columns. On first screen leave radio button on "delimited" and click Next. Unclick any of the delimiter boxes (any boxes blank; no checkmarks) and click Next. Under column data format choose Date and select MDY in the adjacent combo box and click Finish. Now you got date values (i.e. Excel has recognised your values as Date data type), but the formatting is likely still the locale date, not the mm/dd/yyyy you want.

2. To get the desired date format displayed properly you first need to select the column (if unselected) then under Cell Format - Number choose Date AND select Locale. This will give you format like "m/d/yy". Then you can select Custom and there you can either type "dd/mm/yyyy" or choose this from the list of custom strings.

To Replicate

1. Go to https://dev.cbsrc.org
2. Click on reports
3. Export to excel

Expected behavior
I would like the exported data to automatically read the dates in column A as dd/mm/yyyy, and for the dates to be automatically sorted with the most recent reports at the top (the same as when viewing in platform)