How to Sort by Date in Google Sheets

Phoebe Sanchez Avatar

Phoebe Sanchez

How to Sort by Date in Google Sheets

When the dates in a sheet are not in the chronological order or the order you want, Google Sheet allows you to sort them. Follow these steps to sort by date in Google Sheets:

    1. Select the date range you want to sort. I am selecting the range A2 to A9.

      Select range
      Select the range you wish to Sort by date.

    2. Navigate to the Data menu and choose the Sort range option. From the sub-menu, choose ascending (A to Z) or descending (Z to A).

      Sort
      From the Sort Range option, choose the ascending or descending style.

    3. This is the output:

      Output
      Cells sorted by date in Google Sheets.

Photo of author

Phoebe Sanchez

Phoebe works in HR Administration for IBM and other tech companies, and graduated with a BA in Communication and Media Studies from the University of Utah. She is a chief editor at TechObservatory.

Leave a Comment