Link to home
Get AccessLog in
Avatar of Shaun Wingrin
Shaun WingrinFlag for South Africa

asked on

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?
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

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.

User generated image
cheers, teylyn
Avatar of Shaun Wingrin

ASKER

We tried this but doesn't seem to sort the dates in date order. Perhaps they not formatted as dates... Help
Avatar of Leslie Bloom
Leslie Bloom

Go to File > Spreadsheet Settings

You should see the following prompt

User generated image
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.
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
ASKER CERTIFIED SOLUTION
Avatar of Leslie Bloom
Leslie Bloom

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Happy to have helped!
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!