In Google sheets I'm trying to sort rows according to a date column. According to my experience I can use column filtering and choose to sort data from A-Z. However this will give a wrong result for dates. For example 1/7 will come before 30/6, even though it comes after it. Is there an option to store and sort the data as date type, and not string type?
Can I sort rows in Google Sheets by date?
google spreadsheets;sorting;date