Google Sheets is perhaps the most popular spreadsheet application in the market today (along with Microsoft Excel). Google Sheets provides a rich sorting capability as part of its feature set. One of the most commonly used sorting options is the ability to sort by date.
In this blog post, we will cover how to sort data by date in Google Sheets. Each step in the process will include a screenshot so that you can see exactly how to perform each step in the process.
The easiest way to sort a column by date in Google Sheets is to do the following:
- Open the Spreadsheet in Google Sheets
- Select the Headers of the column(s) you want to sort by date (make sure the column data type is Date)
- Click Data > Create a Filter Option
- Click on the filter icon
- Click Sort A – Z or Click Z – A in sort in first to last or last to first date respectively
Before we get started with the tutorial, if you are looking to learn more about apps like Notion, Todoist, Evernote, Google Docs, or just how to be more productive (like Keep Productive’s awesome Notion course), you should really check out SkillShare. Skillshare is an online learning platform with courses on pretty much anything you want to learn. To learn more about Skillshare and its vast library of courses and get 30% off, click the link below:
If you are relatively new to Google Sheets, check out our Beginner’s Guide to Google Sheets.
How to Sort by Date in Google Sheets Using Column Filters
Before you get started trying to sort a column by date, you must make sure that all the values you are looking to sort are actually dates. You can determine this using the Data -> Data Validation option. Once you have validated that all of your cells you want to sort are dates, do the following to sort your column by date:
- Open the spreadsheet in Google Sheets
- Freeze the rows above and including your header row by selecting the row and going to View -> Freeze -> Up to current row as shown in the screenshot above
- Select any cell in the column you want to sort by date
- Click Data -> and select either Sort sheet by column, A->Z to sort oldest to newest date or select Sort sheet by column, Z->A to sort from newest to oldest
Your date column should now be sorted by date.
Looking to learn how to use conditional formatting in Google Sheets? You have to check out our Ultimate Guide to Conditional Formatting in Google Sheets.
How to Sort Using Sort Range in Google Sheets
You can also use the Sort Range function to sort a table in Google Sheet. Enclosed below are the steps to sort a table by date using Sort Range in Google Sheets:
- Open Your Spreadsheet in Google Sheets
- Select all the cells in the table except the headers
- Click Data > Sort Range
- Choose the column you want to sort on
- Select A – Z or Z – A to sort earlier date to latest or latest to earliest date
- Press the Sort button
- Your table should now be sorted by date
Open Your Spreadsheet in Google Sheets
Open the spreadsheet you want to sort in Google Sheets.
Select all the Cells in the Table Except the Headers
Select all in the cells in the table EXCEPT the headers as shown in the screenshot above. There are unsorted dates in this table.
Date Sorting Using Sort Range
Next, go to Data -> Sort Range to bring up the Sort Range menu.
Choose the Column You Want to Sort
The Sort Range menu should now be visible. Find the “Sort by” option. Click the drop-down button and select the column that contains the dates you want to sort by in your table.
Select A->Z or Z->A to Sort Table either Earliest to Latest Date or Latest to Earliest date
To the right of the “Sort by” option are two radio buttons:
A->Z sorts your table from earliest date to latest date. Z->A sorts your table from latest date to earliest date. Select the option you want.
Click the “Sort” Button to Sort the Table
Finally, click the “Sort” button to sort your table.
Your table should now be sorted by date.
Now, let’s sort a table by day of the week.
How to Sort a Table by Day of the Week in Google Sheets
Enclosed below are the steps required to sort a table by day of the week in Google Sheets:
- Open your Spreadsheet in Google Sheets
- Create two new columns and name them “Day of the Week number” and “Day of Week”
- Click first empty cell in “Day of the Week number” column and type =WEEKDAY(“your date cell“) and hit Enter
- Click and drag blue square box to auto-populate equation in the rest of your cells in your table
- In the first empty cell in the “Day of Week” column, type the following equation: =CHOOSE( weekday(your day of the week cell), “Sunday”, “Monday”, “Tuesday”, “Wednesday”, “Thursday”, “Friday”, “Saturday”) and hit Enter
- Click and drag blue square box to auto-populate equation in rest of the column
- Select all the cells in your table except the headers and go to Data->Sort Range
- Select the “Day of the Week number” column and click “Sort” button to sort table by day of week
- Your table should now be sorted by the day of the week
Open your Spreadsheet in Google Sheets
Open up the spreadsheet you want to sort by day of the week in Google Calendar.
Create Two New Columns and Name Them “Day of the Week number” and “Day of Week”
Next, we need to add two new columns to our spreadsheet:
- Day of Week in Number
- Day of Week
The reason why we need to do this is that the WEEKDAY function we will use to determine the day of the week based on our date column returns a number representing the day of the week, not the name of the day of the week. Each day of the week is numbered from 1 – 7 as follows:
|Day of the Week||Day of the Week Number|
So, as a result, we first need to figure out the day of the week number then we can assign the day of week name.
Click First Empty Cell in “Day of the Week number” column and Type =WEEKDAY(“your date cell“) and hit Enter
Now, click the first empty cell in the “Day of the Week number” column and type in the following:
Where it says YOURDATECELL, type in the address of the “Date” cell that is next to your “Day of Week in Number” column.
You should now see a number in your “Day of Week in Number” cell as shown in the screenshot above. For my example, my number is 3 which represents Tuesday.
Click and Drap the Blue Square Box in Lower Right Corner of Cell to End of Column in Table to Auto-populate Column with Formula
Next, click the blue box and drag it to the bottom of your column and release the mouse button. This will apply the same formula to the rest of the column. You should now see numeric values for each of your dates.
In the First Empty Cell in the “Day of Week” column, type the following equation: =CHOOSE( weekday(your day of the week cell), “Sunday”, “Monday”, “Tuesday”, “Wednesday”, “Thursday”, “Friday”, “Saturday”) and hit Enter
The next step involves a complicated looking formula but don’t sweat it. Click in the first empty cell in the “Day of Week” column and type in the following formula:
=CHOOSE( weekday(your day of the week cell), "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday")
Where is says “your day of the week cell), type in the address of the first cell in the “Day of Week in Number” column. In our example that is B3. Hit Enter to save your formula to the cell.
Click and drag blue square box to auto-populate equation in rest of the column
Click and drag the blue square box in the first cell to the end of the column and release the mouse button. This will apply the formula to the rest of the column. You should now see the days of the week for each date as shown in the screenshot above.
Now let’s sort the table by day of the week.
Select All of the Cells in Your Table EXCEPT the Headers and go to Data -> Sort Range
Select all of the cells in your table EXCEPT the headers.
Next, go to Data-> Sort Range to bring up the Sort Range menu.
Select the “Day of the Week number” Column and Click the “Sort” Button to Sort Table by Day of Week
In the Sort Range menu, select your “Day of Week in Number” column. Then click the “Sort” button to sort your table by the day of the week.
Your table should now be sorted by the day of the week.
I hope this tutorial was helpful to you. Good luck!
Want More Tips and Tricks? Subscribe to our Newsletter!
If you haven’t already subscribed, please subscribe to The Productive Engineer newsletter. It is filled with tips and tricks on how to get the most out of the productivity apps you use every day. We hate spam as much as you do and promise only to send you stuff we think will help you get things done.
Check Out Our YouTube Channel!
We have a YouTube channel now and we are working hard to fill it with tips, tricks, how-tos, and tutorials. Click the link below to check it out!
Do you use the same password for multiple sites? Do you have trouble remembering all your passwords? You should try 1Password! 1Password is secure and allows you to log in to sites and fill forms securely with a single click. I use 1Password for all my passwords and it really makes managing all my passwords simple.
For more information on 1Password and to get a 30-day free trial, go to 1Password at the link below:
Check out our Resources Page
Check out our resources page for the products and services we use every day to get things done or make our lives a little easier at the link below:
Looking to Get Started Blogging or on YouTube?
Getting started can seem daunting and scary (I know it was for me) but it doesn’t have to be. I was very lucky to find a program that that has helped me grow my blog to over 35,000 page views and a YouTube channel that is growing month-over-month.
Project 24 by Income School is the program that I have used. I have been a member for over a year now and just renewed my membership. I cannot recommend Project 24 enough! For more information on Income School, click the link below: