Instant digital downloads One payment, no subscription Works as described, or we fix it or refund you Bundles save up to 43%

How do I sort data by date in Google Sheets?

Updated By ProfitDrawer

Short answer

To sort data by date in Google Sheets, select the range with every column of your rows, click Data > Sort range > Advanced range sorting options, tick Data has header row if the first row holds titles, pick the date column, choose A to Z to put the earliest dates first or Z to A for newest first, and click Sort. A ProfitDrawer bookkeeping spreadsheet totals each month with SUMIFS date tests across up to 1,000 income rows, so its totals stay the same in any row order.

Sort a range (computer):

  1. Highlight the cells to sort. Include every column of the rows, not only the date column, so each date stays with its amount and description.
  2. If there is a header row, freeze that row first.
  3. Click Data > Sort range > Advanced range sorting options.
  4. Tick Data has header row if your columns have titles.
  5. Choose the date column and an order: A to Z puts the earliest date first, Z to A the latest.
  6. To break ties, click Add another sort column, for example Client.
  7. Click Sort.

Sort a whole sheet: right-click the column letter at the top and click Sort sheet A to Z or Sort sheet Z to A. This moves every row on the tab, so use a range sort when the sheet has a title block or totals above the data.

Want the order only for yourself? A filter view (Data > Create filter view) lets you sort without changing what other editors see.

If a sort puts dates in an odd order, some cells may hold text that looks like a date rather than a real date value; retype them or apply a date format to check.

Source: Sort & filter your data: Google Docs Editors Help · Updated

Tools and spreadsheets for this

Related questions

All questions on ProfitDrawer Answers →

General information, not tax, legal or financial advice. Check the rules for your state and your situation.