Learn how to sort by date in Google Sheets in 4 simple steps + how to check data validity and how to sort by date.
How to Sort by Date in Google Sheets?
Before you learn how to sort by date in Google Sheets, you should learn how to check dates for validity since dates can be quite tricky to work with.
Checking Dates for Validity in Google Sheets
In order to be able to sort by date, Google Sheets has to recognize your dates as valid. Take a quick look at the dates below.
Valid dates are the ones that are right-aligned. However, sometimes it’s difficult to tell whether the date is left- or right-aligned because the content fills most of the cell.
If you think that April 7th, 2018 is valid, you are wrong. #SorryNotSorry
It’s actually left-aligned. So, how do you know for sure which of your dates are valid?
Use the DATEVALUE function (Insert – Function – Date – DATEVALUE).
With this function, all valid dates will be returned as integers that can be used in formulas, and invalid dates will be returned as a #VALUE! error.
Sorting by Date in Google Sheets
Now you can sort your results.
- First, select the cell range you’d want to sort. Then, you click on the Data tab and choose Sort Range from the drop-down menu.
- Then choose to sort by the column where your date values are.
- Now, all cells that contain #VALUE! will be together so you can easily find and fix them.
- Once you fix all the invalid dates, you can sort your cell range once again.