How to sort by purchase date? The table is as follows.

You have some trouble in this respect. Because your days and months are separated.

You can do this:

Fill in the blanks, no matter what you say. Consistent with other formats.

Put the first two digits of the year in order first. Then sort the last two digits of the same year.

Sorting the months with the same year before and after,

Finally, sort the dates with the same year and month.

If your date is in the same column, you don't need to bother. Select the contents to be sorted directly, and click Sort to arrange them (after clicking Sort, a dialog box will appear, and select "Expand Selected Area"). As shown in the figure.