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?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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:

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.

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

You should see the following prompt

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.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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

I've pasted a link to it
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.

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!
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")

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.