Tech News Today
  • News
  • How To
  • Buyer’s Guide
  • Hardware
    • PC Builds
    • Computer Cases
    • Motherboards
    • Peripherals
    • RAM
  • Gaming
  • Software
  • More
    • Mobile
    • Gadgets
    • Laptops
    • Reviews
Facebook Twitter Instagram
Tech News Today
  • News
  • How To
  • Buyer’s Guide
  • Hardware
    • PC Builds
    • Computer Cases
    • Motherboards
    • Peripherals
    • RAM
  • Gaming
  • Software
  • More
    • Mobile
    • Gadgets
    • Laptops
    • Reviews
Tech News Today
Home»Software»How to Sort by Date in Google Sheets

How to Sort by Date in Google Sheets

SachiBy SachiMay 4, 2022
how-to-sort-by-date-in-google-sheets

When dealing with a large dataset in your spreadsheet, your data might go haywire. For these instances, the sorting function can come in handy to keep your data organized and keep you on track. 

Thankfully, in Google Sheets, the sort feature is built into the tool. So, if you are looking for a way to sort certain dates, like your family’s birthdays, or review your monthly transactions, then this article is here to help you out. 

So, without further ado, let’s explore the different methods you can apply to sort your data by date in Google Sheets. 

Before We Begin

Please ensure that you have entered a date format that Google recognizes. The sorting function might fail to work in some cases due to the incorrect formatting entered on your dataset. So, to check whether the dates in your cells are valid, you can use the Data Validation feature on Google Sheets. Here is a step-by-step guide you can follow. 

  1. First, open up your Google Sheet.
  2. Select the Data Range you want to check the validation for.
  3. Head over to the menu bar and click on the Data option.
  4. Now, select Data Validation from the list of options.Data Validation in Google Sheets
  5. Select Date and is Valid Date from the drop-down menus in the Criteria section. 
  6. In the On invalid data section, check the option for Show Warning. 
  7. Finally, click on the Save button to save changes on your spreadsheet. Check if date is valid in Google Sheets

Now, head back to your dataset. Check to see if there are any red linings in your cells that say if it is an invalid date. If you notice any invalid dates in your range, we suggest changing them right away. 

Additionally, we recommend adjusting the text alignment to be the same throughout your dataset range, as this might also affect when sorting out your dates in Google Sheets.

How to Sort By Date In Google Sheets on PC

After checking the data validation of your dataset and making the necessary formatting changes, let us now move on to how we can sort by dates in Google Sheets. Depending on your personal preference, you can use the Sort Function or the Sort Formula on your data range. Let’s look at both of these methods in more detail down below. 

Using Sort Function 

One of the easiest ways to set and arrange by date is through the sort function. Here, you will only need to highlight the data range and apply the sort by date function. Here are some steps you can follow. 

  1. First, open up the Google Sheets you want to edit.
  2. Select the date range you want to sort. 
  3. Navigate to the menu bar and click on the Data option. 
  4. Here, from the list of options, select Sort Range. 
  5. From the drop-down menu, you can either choose to sort through A to Z or Z to A (ascending or descending order.) 
    Sort Range in Google Sheets
  6. Also, if the selected data has a header row, please ensure you check the box for it.
  7. Alternatively, you can also click on the Advanced Range Sortings option and sort the dates.
  8. To apply the changes, click on the Sort button.Sort range through advanced range setting options

You can also access the Sort function by right-clicking or clicking on the drop-down arrow on the row header and selecting your preferred sorting option.

Using Sort Formula 

Another alternative method you can apply to sort out your dataset by date is to use the Sort Formula. But, before using this formula, we suggest you make a separate column heading and label it as the Sorted Dates to avoid confusion.  

Here is the formula to be used depending upon the sorting options. 

  • For arranging data in ascending order: =SORT(Range, column number, True) 
  • For arranging data in descending order: SORT(Range, column number, False) 

If we take an example of number data, your formula should appear like: =SORT(A1:A3,1, True) or =SORT(A1:A3,1, False). 

The main advantage of this method is that if you apply any changes to a certain entry, the sorted list would also automatically change. So, you don’t have to bother manually changing each dataset which saves your time and effort.

In some instances, if you want to make changes to the formula cells, you won’t be able to edit it because of the formula and will instead receive the “Value error.” To edit, you will have to convert the data into values. Copy the data range, use the Paste Special option, and select the Values Only option.

How to Sort By Date In Google Sheets on Mobile

For mobile users, you can still use the Sort function through the app version of Google Sheets. However, the steps for sorting might vary to the PC version due to its different interface. So, here are some steps you can follow. 

  1. Open up the Google Sheets app from your device. 
  2. Navigate to the sheet you want to edit. 
  3. Tap on the header column to select all the datasets. 
  4. Now, tap on the header column again to open up the menu option. 
  5. Tap on the right arrow and continue tapping until you see the Sort options.Sort data in Google Sheets mobile app
  6. For android devices, after tapping the header row twice, click on the three vertical dots to open up the menu settings. 
  7. Now, scroll down and select SORT A-Z or SORT Z-A options to arrange your dataset in either ascending or descending options.  

Related Questions 

How to Sort Date by Month in Google Sheets? 

For sorting out dates through the month option, you will have to use a formula specific to sorting the monthly values. But, before you use the formula, we suggest you create a new column and label it to avoid confusion. 

  • To assort in ascending order = SORT(B2:B, MONTH(B2:B) ,TRUE) 
  • To assort in descending order =SORT(B2:B, MONTH(B2:B) ,FALSE)

How to Sort by Date in Microsoft Excel? 

The excel application also has a built-in sorting function, making it easier to sort data by date. Here is how you can do it.

  1. Open up the Excel application from your device. 
  2. Head over to the spreadsheet and select the date range you would like to sort. 
  3. Navigate to the Home tab and click on the Sort and Filter option.Sort and Filter in Excel 
  4. You can either select the sort oldest to newest or newest to oldest option.

How to Change Your Date Format in Google Sheets?

If you want to make all your dates shown in the cells more cohesive or if you want to switch up your date format to match your preference, then here are some steps you can follow.

  1. Open up Google Sheets and navigate to the spreadsheet you want to edit. 
  2. Head over to the menu bar and click on the Format option. 
  3. Now, select Numbers from the list of options. 
  4. From the drop-down menu, click on the Date option to change it to the default date layout.
     Change Date into default Date Layout in Google Sheets
  5. Alternatively, you can also click on the custom date and time formats option from the same drop-down menu.
  6. Here, you can select from different types of date layouts or create a custom one. 
  7. After making the formatting changes, click on the Apply button to confirm your action.
     Apply Custom Date and Time Format in Google Sheets
how-to
Sachi

An avid writer with a curious mind to explore new things.

Related Posts

outlook blocked access to the following potentially unsafe attachments

Fixed: Outlook Blocked Access to the Following Potentially Unsafe Attachments

May 22, 2022
a ubisoft service is currently unavailable

[Solved] A Ubisoft Service Is Currently Unavailable

May 20, 2022
outlook-search-by-date

How to Outlook Search by Date to Find Emails Quickly!

May 16, 2022
how-to-attach-file-in-email

How to Attach a File in Email

May 12, 2022
how-to-mute-a-tab

How To Mute A Tab On A Browser

May 11, 2022
how-to-change-outlook-view

How to Change Outlook View

May 8, 2022
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
safe mode windows 11

6 Ways to Boot Windows 11 in Safe Mode

May 23, 2022
system error 5 has occurred

How to Fix “System Error 5 Has Occurred Access Denied” Error

May 23, 2022
How To Factory Reset Windows 11

How To Factory Reset on Windows 11

May 23, 2022
You may also like
xbox port forwarding

How to Set Up Port Forwarding for Xbox Series and Xbox One?

May 23, 2022
what-is-window-server-mac

What Is WindowServer on Mac? How to Lower Its CPU Usage

May 23, 2022
network credentials not working

Network Credentials Not Working? Here’s How To Fix It

May 23, 2022
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

October 25, 2021
Facebook Twitter Pinterest
  • Home
  • About Us
  • Privacy Policy
  • Affiliate Disclosure
© 2022 TechNewsToday.

Type above and press Enter to search. Press Esc to cancel.