How To Sort By Date In Excel

To sort by date in Excel, select the column you want to sort, go to the Data tab, click on the Sort button, choose to sort by the selected column, and select the sort order (ascending or descending) for the dates.

Sorting data in Excel is a crucial skill that can greatly enhance your ability to analyze and organize information. One common sorting requirement is to arrange data in chronological order based on dates. Whether you are managing project timelines, analyzing financial data, or simply organizing a list of tasks, being able to sort by date can provide valuable insights. In this blog post, we will explore different techniques and shortcuts to efficiently sort data by date in Excel. Whether you are a beginner or an experienced Excel user, this guide will help you master the art of sorting by date and boost your productivity.

How To Sort By Date In Excel: Step-by-Step


Step 1: Open the Excel Document,

Once you have located the Excel document on your computer, simply open it to access the data you wish to sort.

Next Step

Step 2: Select Your Data,

Click and drag over the desired cells, including the relevant dates, to sort the information accordingly.

Next Step

Step 3: Navigate to the Data Tab,

Once you’ve selected your data, navigate to the “Data” tab in Excel’s toolbar. Click on it to expand a range of options for further data manipulation and analysis.

Next Step

Step 4: Click “Sort Oldest to Newest” or “Sort Newest to Oldest”,

In the “Sort & Filter” group, located under the “Data” tab, you can easily arrange your data by clicking either “Sort Oldest to Newest” or “Sort Newest to Oldest” based on the desired sorting order.

Next Step

Step 5: Confirm the Sort Range,

In Excel, after selecting data to be sorted, you’ll be prompted to “Expand the selection” or “Continue with the current selection”. Check the “My data has headers” box if necessary. Choose accordingly, though “Expand the selection” is usually suitable.

Next Step

Step 6: Execute the Sort,

Click the “Sort” button to arrange the data based on dates. Depending on your previous choice, the data will be sorted either in ascending or descending order.


In conclusion, knowing how to sort by date in Excel is a crucial skill that can greatly enhance your data organization and analysis capabilities. By following the steps detailed in this blog post, you can effortlessly arrange your data chronologically to gain valuable insights and make informed decisions. Remember to keep your dates in the proper format and set the correct options while sorting to ensure accurate results. With Excel’s powerful sorting features, you can efficiently handle large datasets and streamline your workflows. Now that you possess this knowledge, you can confidently sort your data by date and unlock the full potential of Excel for your professional and personal needs.

Table of Contents