To put Excel dates in order, select a cell in your data and choose Data > Sort Oldest to Newest or Data > Sort Newest to Oldest. To show only dates in a particular period, turn on filters and choose Date Filters from the date column’s dropdown. Before either action, make sure each row stays together and Excel recognizes the entries as dates, not text.
What You’ll Need
- A worksheet with a date column and any related information arranged in rows, such as order date, order number, and customer.
- A header row with a clear label for each column. Headers help Excel identify the correct field when sorting or filtering.
- Excel for Microsoft 365 on Windows for the steps below. Excel for Mac and Excel for the web have similar commands; differences are noted where useful.
Step-by-Step
- Check the layout before changing the order. Each record should occupy one row, with the date and its related details in separate columns. For example, a sheet might have Order Date in column A, Order ID in column B, and Customer in column C. Keep the column labels in a single header row and avoid completely blank rows or columns inside the list. If the dates are in a standalone list with no related columns, you can select a date cell and sort that list directly.
- Check that Excel recognizes the values as dates. Click a date cell and look at the formula bar. A genuine Excel date is stored as a number, even when it is displayed in a format such as 3/14/2026. Changing the number format changes how a real date looks; it does not turn text into a date. If entries appear left-aligned while other dates are right-aligned, or if Excel’s date filter options are missing, some entries may be text. Resolve that before sorting; see Troubleshooting below.
- Make a backup if the order matters. Sorting rearranges rows, and a mistaken selection can separate dates from their order numbers or other details. Save a copy of the workbook, or use Undo immediately if the result is wrong. If the data is important, convert the range to an Excel table with Insert > Table, confirm that My table has headers is selected, and sort using the date column’s header dropdown. Tables automatically keep each row’s fields together and include new rows more reliably.
- Choose a cell in the data. For a properly arranged continuous list, click any cell within the data rather than selecting only the date column. This lets Excel identify and sort the full range. If Excel asks whether to expand the selection, choose Expand the selection, then click Sort. Do not choose to continue with the current selection when other columns contain details belonging to each date.
- Sort from oldest to newest. On the Windows ribbon, open the Data tab and choose Sort Oldest to Newest in the Sort & Filter group. Excel puts earlier dates first and later dates last. For example, a sequence containing March 10, January 5, and February 20 will become January 5, February 20, March 10, regardless of whether the dates were originally entered in that order. If Excel asks about expanding the selection, expand it as described above.
- Sort from newest to oldest when you want recent records first. Choose Data > Sort Newest to Oldest. This is useful for reviewing recent orders, appointments, or activity. The order reverses by date; it does not remove older records. If multiple rows have the same date, Excel may keep those rows in their previous relative order, but do not rely on that for a specific tie-break. Use the full Sort dialog to add another sort level if needed.
- Use the Sort dialog for more control. Click a cell in the data and choose Data > Sort. If your range has headers, check My data has headers. Under Sort by, select the date column; set Sort On to Cell Values and Order to Oldest to Newest or Newest to Oldest. Choose Add Level to sort by a second column after the date, such as sorting equal-date records by Order ID. Click OK to apply the sort to the selected data.
- Turn on filters if you want to display only part of the list. Click inside the data and choose Data > Filter. Dropdown arrows appear in the header row. You can also use the Windows shortcut Ctrl+Shift+L to toggle filters. On Mac, use Data > Filter if that shortcut differs on your keyboard or Excel version. Filtering hides rows that do not match; it does not delete them or change the date order of the remaining records.
- Choose a date condition from the dropdown. Open the arrow in the date column’s header, point to Date Filters, and select a condition such as Before, After, or Between. For a custom period, choose Between, enter the start and end dates in the dialog, and confirm. Excel then displays dates within the chosen limits. Depending on the data and Excel version, the dropdown may also offer grouped year, quarter, or month selections.
- Combine filtering with sorting when useful. Apply a date filter first to narrow the visible rows, then choose an oldest-to-newest or newest-to-oldest sort. You can also sort first and filter afterward. For instance, filter orders to April and sort the remaining visible orders newest to oldest to see the latest April orders at the top. To show everything again, reopen the date dropdown and choose Clear Filter From followed by the column name, or use Data > Clear to clear filters across the range.
Common Mistakes
Sorting only the date cells. This is the most damaging error in a multi-column list: dates move while names, amounts, or IDs stay put. Select a cell in the list, use the full Sort dialog, and expand the selection if prompted. If the columns have already become mismatched, Undo at once rather than trying to realign rows by eye.
Expecting a filter to rearrange records. A date filter only hides records that do not meet its condition. Choose a sort command as well if you need the visible dates in chronological order. Conversely, sorting changes row order but does not limit the list to a date range.
Assuming a date-looking value is a real date. Text such as “2026-03-14” can look like a date yet behave like text if it was imported or interpreted using different regional settings. Formatting the cell as Date may not fix it. Mixed real dates and text entries can appear in the wrong places or be excluded from date-specific filter choices.
Including the header as a record. If Excel sorts a label such as “Order Date” into the data, open Data > Sort and make sure My data has headers is checked. Check that the header is in the first row of the selected range.
Using ambiguous date entries. A value such as 04/05/2026 can mean April 5 or May 4 depending on regional settings. Confirm the intended day and month before sorting or filtering; a consistent display format alone cannot resolve an incorrectly interpreted date.
Tips
Use a consistent date format for readability, such as a four-digit year, but remember that display format is separate from the underlying date value. To change appearance, select the date cells and choose a format from Home > Number Format. A format like 14-Mar-2026 makes the day and month less ambiguous to readers while preserving chronological sorting for real dates.
For recurring work, make the range an Excel table. Its header dropdowns provide sort and filter commands, and newly added rows are more likely to be included in the table’s operations. Give each column a unique, descriptive header and avoid merged cells in the data area, since merged cells can interfere with selecting and sorting a consistent range.
If you need to sort by date and then by another field, set a secondary level in Data > Sort. For example, sort by Order Date oldest to newest and then by Customer A to Z. The second level orders customers only among records with the same primary date; it does not override the date order.
Filtering is reversible. A hidden row is still in the worksheet, so check for active filter icons if records seem to have disappeared. Clear the filter to restore the full view. When sharing a workbook, consider leaving the filter state clear or telling recipients which date conditions are active.
Troubleshooting
Dates sort alphabetically or into odd groups: The column may contain text, inconsistent date formats, or a mixture of text and real dates. First check a few problematic cells individually. If the values came from a text file, use Data > Text to Columns to convert them carefully: select only the affected column, choose the appropriate options to reach the column data format step, select Date, specify the source order such as MDY or DMY, and finish. Make a copy first and verify several converted values, especially where day and month could be confused. The correct date order depends on how the original data was written, not just how you want it displayed.
Date Filters is missing or offers text filters: Excel may not recognize the whole column as dates, or the dropdown may be on a different field. Confirm you opened the date column’s arrow and check whether the cells are genuine dates. Convert text dates using the correct regional order, then reapply the filter if needed. If there are blank or invalid entries mixed into the column, correct or remove them before applying date conditions.
Rows became detached from their details: Press Ctrl+Z immediately on Windows (on Mac, use Command+Z) to undo the sort. Select the full dataset and repeat the operation, choosing Expand the selection if asked. If Undo is no longer available, restore a saved copy or use workbook version history if available; do not assume the original row relationships can be reconstructed from the sorted data.
Some records do not appear after filtering: Check the active condition and its start and end dates, including whether the boundary dates are included by the chosen option. Clear the filter to verify the records still exist. Also check for blank dates, text dates, or dates with times: a value that includes a time may fall outside a boundary if the filter’s date and time values do not match as expected.
The sort buttons are disabled or results look incomplete: Check whether the worksheet is protected, the selection includes merged cells, or the data range is split by blank rows. If you are working in Excel for the web or on Mac, use the equivalent Data tab commands and confirm that the workbook has finished syncing. Remove or address structural issues in a copy before sorting a complex range.
Frequently Asked Questions
How do I sort dates from newest to oldest in Excel?
Click a cell in the complete data range, then choose Data > Sort Newest to Oldest. If prompted, expand the selection so all details stay with their dates.
How do I filter Excel dates between two dates?
Choose Data > Filter, open the date column dropdown, select Date Filters > Between, enter the start and end dates, and confirm. This hides dates outside the chosen interval without deleting rows.
Why does Excel sort my dates incorrectly?
The entries may be text, mixed with real dates, or interpreted using the wrong day-month order. Convert the values to real Excel dates using the correct source format, then sort again.
Can I filter dates and keep them in chronological order?
Yes. Apply a date filter and then sort the visible records oldest to newest or newest to oldest. Filtering limits which rows show; sorting determines their order.
Does changing the date format fix sorting?
No. Number formatting changes how a genuine date is displayed, but it does not convert text into a date. Convert text values first, then choose a display format if needed.
Can I sort by date without moving the other columns?
Not safely when the other columns contain information for the same records. Sort the complete range so each row remains intact. Sorting only the date column can detach dates from their associated details.
Related
- How to Duplicate a Page in Excel and Keep Its Layout
- Duplicate a Sheet in Excel: Keyboard Shortcut and Steps
- How to Double Freeze Panes in Excel: Rows and Columns
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Text Handling: Formulas, Formatting, and FixesExcel text handling means entering, cleaning, combining, splitting, and displaying text without accidentally changing its meaning. In Microsoft…
- Excel MIN and MAX in the Same Formula: Examples and TipsYes. In Excel for Microsoft 365 on Windows, you can calculate both endpoints in one formula, such as…
- Excel Absolute Value Formula: How ABS Works With ExamplesIn Excel, use the ABS function to return a number’s absolute value: it removes the number’s negative sign…
- Excel Filter Including Wrong Data? Find the CauseIf an Excel filter includes the wrong data, first check that the filter covers the correct range and…
- CONCAT in Excel: Join Text and NumbersYes. Excel’s CONCAT function can join numbers with text or other values, but it does not preserve a…
- Excel Row Filter: How to Show Only Matching Data RowsTo filter rows in Excel for Microsoft 365 on Windows, select a cell in your data and choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.