Comments on: How To Sort by Date in Google Sheets (6 Easy Examples)

By: Christopher Daniel

Christopher Daniel — Mon, 29 Aug 2022 12:40:53 +0000

In reply to Clairisa. Once you've sorted your data vertically. You can use the TRANSPOSE function to move a vertical table into a horizontal one.

By: Christopher Daniel

Christopher Daniel — Mon, 29 Aug 2022 12:39:47 +0000

In reply to Cam. Make sure all of your dates are formatted using the correct date format. Format > Number > Date.

By: Cam

Cam — Mon, 21 Feb 2022 16:08:34 +0000

This is very helpful! Thank you for publishing it.

One question… when I sort dates across 4 years worth of data, it groups all the Januaries together, Februaries together, etc. So I have a list of data for January 2018, January 2019, January 2020, February 2018, February 2019, February 2020, and so on.

How do I get it to sort chronologically?

By: Clairisa

Clairisa — Thu, 09 Dec 2021 14:12:36 +0000

HI thanks for the tutorial. I want to sort dates horizontally in the month for my personal budget. I cant fig out how to do this automatically? so column A, line 2 is Dec1,Line 3 is Dec 2 and so on.. thanks so much!!

By: Dennis

Dennis — Wed, 08 Dec 2021 19:13:24 +0000

Thanks for the help.:(

By: Alexa Harvey

Alexa Harvey — Tue, 31 Mar 2020 22:46:31 +0000

I found one problem I was having was that you need to have the dates to the right of the names. For example, I had products I have sold in the first column with the dates in the column on the right in the second column. When using this function, it will sort your data but sort alphabetically based on the product name but not by date. I solved this problem by moving the dates into the first column and having product names in the second column. Also, I didn’t heed your warning when you said the dates needed to be formatted properly in date form, very important!