MS Excel: Sort Data Conditionally

Sort by Date

To sort dates in the format dd.mm.yyyy from oldest to newest, you can use various methods depending on the context (e.g., programming language, spreadsheet software). Here are examples of a few common scenarios:

If Sort Oldest to Newest & Sort Newest to Oldest Options Not Showing

By default, the Excel shows A to Z and Zto A sorting options. Sometimes Sort by Date doesn’t show. So let’s discuss how to resolve this problem.

1. Convert Text to Date Format:
   • Select the column with the dates.
   • Go to the Data tab.
   • Click on Text to Columns.
   • In the Wizard, choose Delimited, then click Next.
   • Click Next again, then choose Date and select DMY from the dropdown. Click Finish.
2. Sort the Dates:
   • Select the column with the dates.
   • Go to the Data tab.
   • Click on Sort Oldest to Newest.