Written by Tijana Google Workplace / Sheets
When you’re using Google Sheets on a daily basis, and especially if the Sheets contain dates, organizing them properly is crucial in order to be able to keep track of all information you have.
However, due to the Sheets’ complexity, information that you enter, such as dates, need to be in a proper format.
Since Sheets is widely used due to its amazing capabilities to sort data, as well as how convenient it is to share the Sheets files, learning some shortcuts is really important.
However, when it comes to sorting out dates, it is important to know that they need to be in a certain format in order for Google Sheets to consider them as valid.
Hence, if you’re trying to make your job easier and you’re wondering how to sort your Sheets by date, you’re in the right place.
We tailored a detailed step-by-step guide to help you with the process, and no need to worry - it’s not as complex as it seems.
As we already mentioned, Sheets has a certain criteria by which it determines data validity.
Since there’s so many ways to type in a date, you’ll need to learn which ones will be accepted by Google Sheets, and which ones will not.
Sheets considers the right-aligned dates as valid, however, since it’s difficult to tell which ones are right-aligned, and which ones are left-aligned, there’s a shortcut for that as well.
To double check, you should select the columns with the dates, click on ‘Insert’ in the upper section of the sheet, click on ‘Function’, then on ‘Date’, and under ‘Date’, find the ‘DATEVALUE’ function.
After finishing the steps, all wrong formats will be shown under ‘Date Value’.
There are several different ways to sort by date when using Google Sheets.
When you’re trying to sort data in Sheets, the easiest way is to use the ‘Sort’ function. Once you do, Sheets will take the original data of the column you want to sort, and transform it into new, already sorted information.
Additionally, you can have more than one column sorted at once, which will make it less time-consuming.
As an example, if you have a date column filled with information such as this:
You will need a formula, which will convert and sort your dates appropriately:
The function to sort dates will affect three aspects:
Additionally, the column where the sorted dates are supposed to get entered needs to be empty, otherwise, Google Sheets will show you there’s an error, and the sorting function will fail.
Also, make sure to not make any changes in the columns that were a part of the formula, because if you make any adjustments, an error will pop-up.
Google Sheets also has a built-in sorting functionality that gives dynamic results, and is mostly used by people who will need to sort by date only once.
Continue reading more about how to indent in Google Sheets