In the newly-opened window, choose Delimited. Or, click the Browse button and use the Open Microsoft Excel File dialog box that appears (not shown) to identify the folder and workbook file. Convert it to 'single line of text' and immediately convert it back to 'date' type.
On the External Data tab, in the Export group, click Excel. The Export to Excel button is only displayed if the report contains only custom table resources.