I live in Australia and when I'm putting in dates, I place the date, followed by month then the year. However when I am filtering/sorting my spreadsheet it's coming up incorrectly.
How do I edit this sort field so that I can get it to filter by year, month and then date (but how I write it)?