How to Sort by Date in Google Sheets

Phoebe Sanchez Avatar

Phoebe Sanchez

Facebook
Twitter
LinkedIn
Share
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 is an HR assistant in her day job, but is also a web blogger that loves writing guides and sharing her experiences. When she is not out with her friends, she enjoys traveling or binge-watching Netflix. She graduated with a BA in Communication and Media Studies from the University of Utah, and is a chief editor at TechObservatory.

Leave a Comment