How to Sort by Date in Google Sheets | Scribe

    How to Sort by Date in Google Sheets

    • 22 steps |
    • 55 seconds
    • Google SheetsGoogle Sheets

    How to Sort by Date in Google Sheets Using Filters

    1
    Navigate to [https://docs.google.com/spreadsheets](https://docs.google.com/spreadsheets/d/11yQjHlR4yOj2gag5r98eh2RO4n2HyQOptMRENdhhltU/edit?gid=1564491323#gid=1564491323) and open a new spreadsheet or the one with the data you want to sort.
    2
    Select the column or columns you wish to sort by date.
    3
    Go to the menu bar on top and click "Data"
    4
    Click "Create a filter"
    5
    Click on the filter icon at the top right in the header cell of the column.
    6
    Click "Sort A to Z" (latest date last) or “Sort Z to A” (latest date first)
    7
    Now your column is sorted.

    How to Sort by Date in Google Sheets Using the Sort Function

    information ordinal icon
    Tip! If you want to use the sorted output dynamically, you should use the SORT function. The formula is [[=SORT (range, sort_column, is_ascending)]] ‍[[range]]: range you want to sort (for example, A2:G31) [[sort_column]]: position of the column you want to sort within your defined range (for example, 2) [[is_ascending]]: can be true or false and determines if the range is sorted in an ascending way (or not) Example: [[=SORT (A2:G31, 2, true)]]
    8
    Navigate to [https://docs.google.com/spreadsheets](https://docs.google.com/spreadsheets/d/11yQjHlR4yOj2gag5r98eh2RO4n2HyQOptMRENdhhltU/edit?gid=1564491323#gid=1564491323) and open a new spreadsheet or the one with the data you want to sort.
    9
    The output of the SORT function will appear wherever you place the formula. Click on a cell.
    10
    Enter the formula. In this example, I entered [[=SORT (A2:G31, 2, true)]]
    11
    Here’s your range sorted.

    How to Sort by Date in Google Sheets Using Sort Range Feature

    12
    Navigate to [https://docs.google.com/spreadsheets](https://docs.google.com/spreadsheets/d/11yQjHlR4yOj2gag5r98eh2RO4n2HyQOptMRENdhhltU/edit?gid=1564491323#gid=1564491323) and open a new spreadsheet or the one with the data you want to sort.
    13
    Select the table that includes the column you want to sort.
    14
    On the menu bar on top, click "Data"
    15
    Click "Sort range"
    16
    Click "Advanced range sorting options"