How to Sort By Date in Google Sheets

68

With the help of the web-based application Google Sheets, users can make, edit, and share spreadsheets online in real time. The Google product has capabilities that are common to spreadsheets, like the ability to add, delete, and sort rows and columns. However, unlike other spreadsheet applications, Google Sheets also enables a number of geographically distant people to work together on a spreadsheet at the same time and interact using an integrated instant messaging software.

Spreadsheets can be immediately uploaded by users from their computers or mobile phone. Users can see other users’ modifications while they are being made, and the application automatically saves every update. The Google Docs Editors group of free web programmes includes Google Sheets. We mentioned below are the ways to Sort By Date in Google Sheets.

Ways to Sort By Date in Google Sheets

Sort by date using the sort range tool

Using the sort range feature in Google Sheets is the quickest and simplest way to organize a dataset by date. It creates an output that is organized according to the sort date using the original dataset.

1. Open sheet with the date data to be sorted on your Windows laptop or Chromebook.
2. Highlight relevant data fields. This includes dates, names, and other data alongside their headings. It should not include the serial number.
3. Tab on the Data option in the Sheets menu bar.
4. Hover cursor over Sort range.
5. Select Advanced range sorting options. A sort range dialog box appears.
6. Choose the checkbox next to Data has header row if you highlighted the headings. Otherwise, leave this unchecked.
7. Go to box beside Sort by and select the sort column (which is Date in this example)
8. Choose A to Z (A→Z) or Z→A to sort in ascending (earliest to latest) or descending (latest to earliest) order, respectively.
9. Tab on the Sort button.

Sort by date using the sort function

For sorting data once, the sort range approach works great. The sort will need to be redone each time if you frequently update the data on your sheet. However, if you want the final data to be dynamic, you should use the sort method. In other words, the sorted data automatically updates to reflect any changes made to the original dataset. Both single columns and numerous columns can be used with it.

1. Open sheet with the data set to be sorted.
2. Place cursor in an empty column to be populated with the sorted data. This is because the sort function creates new fields instead of changing the fields with your original data.
3. Type the formula =SORT(A1:B5,1,TRUE) in the function bar (fx) at the top of the page, where A1:B5 is the sort range, 1 is the sort column (the first column in a record), and TRUE is an ascending sort order.
4. For this mapping, we use the formula =SORT(B2:C6,2,TRUE). B2:C6 excludes the serial number column and the header rows, 2 represents the sort column (date), the second of the two columns selected, and TRUE represents ascending order.
5. Press Enter key on your keyboard.

Final Words

That’s it with our article on how to Sort By Date in Google Sheets. With the help of the online spreadsheet tool Google Sheets, you can design and format spreadsheets while working with others. Google Sheets allows you to easily create and change spreadsheets in your computer browser. No further software is required. Every edit is automatically stored, multiple people can work at once, and you can view changes as they are made.