Sort spreadsheet values based on date column does not work - only sort alphabetically is offered-CodePudding

Home > Software design > Sort spreadsheet values based on date column does not work - only sort alphabetically is offered

Sort spreadsheet values based on date column does not work - only sort alphabetically is offered

Time：03-16

I am trying to sort the values in my spreadsheet based on the F column (date column), but I am not able to. In excel, the option "Sort by date" does not even appear. In google spreadsheet, this seems to be not possible either. My dates are under the form: 9/5/2022 where 9 is the day, 5 is the month (May) and 2022 is the year. It seems they only offer the option to sort alphabetically from A to Z but not by date.

How can I do this?

Here is a link to my spreadsheet: