One of the most common data types in Google Sheets are dates. That being said, it is also one of the most sorted data types. This article will show you multiple ways that you can organize your data using dates.

Thanks to Google Sheets, sorting by date is a really intuitive and straightforward technique.

I am gonna work an example of this list of randomly assorted dates to show how you can use google sheets to sort by date. It should serve as a good example for what this article is 

Step 1: Highlight and Right Click your Data

The first step to sort by date in google sheets to highlight and right click the data range containing the dates in your spreadsheet. When you right click it, a menu will pop up. At the bottom of the menu you will see an option titled View More Cell Columns. 

Note: Make sure your dates are valid dates, as google sheets can only recognize dates in certain, valid formats. It cannot effectively sort the data if it is in an incorrect format. 

When you click that, it will open the extended menu. In that menu, click on Sort Range.

Step 2: Sort Range

You will be directed to a menu for sorting ranges, you can either manually enter it within this menu or just follow the technique I have shown.

Note: A to Z sorts the dates from oldest at the top to newest at the bottom, and vice versa. Click sort and it will do the sorting automatically.

After sorting the data from A to Z, It will sort the dates from oldest at the top and newest on the bottom.  

Bonus Technique: Using The Data Menu

You can also sort the data using the data menu in the tool ribbon. Simply select sort sheet and then how you would like to sort the column. I personally prefer the technique I showed already, but to each their own.

Leave a Reply

Your email address will not be published. Required fields are marked

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}