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)?
Best Answer
If your sheet locale is Australia, your dates are dd/mmm/yyyy format order and you are using New Google Sheets the sorting should be 'sensible'.