Sorting dates in columns

I am trying to sort dates in a column of data. The filter does not seem to recognize date format and sorts the data by a criteria that I cannot understand. I have changed the cell format to date yet it mixes years 20/21/and 22 ? Any suggestions please

Number_vs_Text.ods (25.3 KB)

1 Like

Also see this FAQ.

1 Like