Date format not retained after downloading in Excel
I have a couple of date dimensions as below in a straight table.
Calculated Dimension: Date1
=if([X.Payment Date]>=vDateStart,if([X.Payment Date]<=vDateEnd,[X.Payment Date])) and
date([Y.Invoice Date], 'DD/MM/YYYY').
When I download the data in excel, the dates are no longer retained as Date format. Although it looks like a date e.g.02/12/2020 but can not be sorted in the excel as it seems to be working like number.
Can you please suggest how to retain the date format after downloading in excel?