Does the subject want to ask "how to sort the dates written backwards in Excel tables"?

1, open the Excel table first, and open an Excel table that needs to be sorted by date.

2. Next, select the date and sort it in ascending order. Select the date cell in column E, click Sort, and then select Ascending.

3. Finally, click Sort. You can choose from the sorting warnings according to your own needs, and then click Sort.