Google sheets | How to sort dates

Say, I have an Excel spread sheet in Google sheets. How can I sort dates in the form of dd/mm/yyyy in date order?
shaunwinginAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

what have you tried? Select the data, then click Data > Sort range.

Tick if your selection has a header, select the column to sort by and select a sort order.

google
cheers, teylyn
0
shaunwinginAuthor Commented:
We tried this but doesn't seem to sort the dates in date order. Perhaps they not formatted as dates... Help
0
Leslie BloomCorporate & Product Marketing ManagerCommented:
Go to File > Spreadsheet Settings

You should see the following prompt

Capture06.PNG
From here you can select the location which corresponds with the dd/mm/yyyy format (usually the UK is a safe bet). Then if you follow @teylyn's suggestion of sorting a data range, it should work!

Hope this helps.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

shaunwinginAuthor Commented:
The setting has been UK all along ... pleas help...

I've pasted a link to it

https://docs.google.com/spreadsheets/d/1CJfqIQRO13HjV_ZRB7WnZ8vQ6E8DzMGIIBK5sMgUfy8/edit?usp=sharing
0
Leslie BloomCorporate & Product Marketing ManagerCommented:
1. In the Spreadsheet Settings be sure you set the locale to United Kingdom.
2. Highlight the column with your dates in it.
Capture07.PNG3. Select "More Formats" from the toolbar to set the date format (this lets the sheet interpret the data correctly when trying to sort it).
Screenshot--18-.png4. Data > Sort Range to sort in ascending order (or whatever order you'd like).
5. You should now see your dates properly sorted in ascending order.
Screenshot--17-.png
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Leslie BloomCorporate & Product Marketing ManagerCommented:
Happy to have helped!
0
Rebecca GreenwellCommented:
Is there a way to sort the entire sheet by the dates that are included in one column? (In Excel, this would be done by clicking "expand range")

thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Google Apps

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.