Sort Dates in Excel in Ascending Order the Right Way

Formulas & functions · Updated November 20, 2026

To sort dates in Excel from oldest to newest, select a date cell, then choose Data > Sort Oldest to Newest. If your dates are part of a table, or sit beside other information, make sure the whole data range is sorted together so each date stays with its matching row. Before sorting, check that Excel recognizes the entries as dates rather than text.

What You’ll Need

  • An Excel workbook with a column containing the dates you want to sort.
  • Access to the full list or table, including any related columns that must stay paired with each date.
  • A header row, if your data has one. A clear header helps Excel distinguish column labels from records.

The directions below are for Microsoft Excel for Microsoft 365 on Windows. The same basic sort is available in Excel for Mac and Excel for the web, although the ribbon layout or wording can vary slightly. Save the workbook before making a large change if you may need to return to its original order.

Step-by-Step

  1. Check how your data is arranged. Find the date column and identify the first and last rows of the records. If a row contains a date plus details such as a name, invoice number, or amount, those details must move with the date. Look for a header such as Order Date at the top of the column. Avoid including unrelated notes or totals beneath the list unless they are meant to be sorted as records.
  2. Check whether Excel recognizes the values as dates. Click one date cell and look at its alignment and number format. Dates commonly align to the right by default, though alignment can be changed manually, so this is only a clue. On the Home tab, inspect the Number Format box. A date format such as Short Date or Long Date is a good sign, but formatting alone does not turn text into a real date. If a date is stored as text, Excel may sort it alphabetically instead of chronologically.
  3. Select a cell in the date column. You usually do not need to highlight every date first. Click a cell inside the list, making sure it is not the header. Excel can often detect the contiguous data range around that cell. If there are blank rows or columns splitting the list, or several separate data blocks on the sheet, select the exact range you intend to sort instead so Excel does not guess the wrong boundaries.
  4. Choose the oldest-to-newest command. On the Windows ribbon, open the Data tab. In the Sort & Filter group, choose Sort Oldest to Newest. Depending on the ribbon width, the command may appear as a date-sort icon or within a compact menu. You can also use Home > Sort & Filter > Sort Oldest to Newest. This ascending order places earlier dates before later dates; for example, January 10 comes before February 1 in the same year.
  5. Expand the selection if Excel asks. If you selected only the date column while other data sits beside it, Excel may display a Sort Warning. Choose Expand the selection, then click Sort. This moves every cell in each record’s row together. Choosing Continue with the current selection sorts only the highlighted dates and can mismatch them with their names, amounts, or other details. If the data is already an Excel table, sorting a table column ordinarily keeps each row together.
  6. Confirm that the header was handled correctly. When you use the simple oldest-to-newest command, Excel generally treats a clear header as a label, but check the result. If the header moves into the records, undo immediately with Ctrl+Z on Windows and repeat the sort with the range selected carefully. For a more controlled sort, select a cell in the list, choose Data > Sort, and use the Sort dialog. Turn on My data has headers when the top row contains column names, then choose the date column and Oldest to Newest.
  7. Review the sorted rows. Scan the first and last few dates and confirm they progress from earlier to later. Check a few records across their rows to make sure their related details stayed together. If two records have the same date, either order between those records is acceptable unless you set a second sort level. If the result looks wrong, undo before making other edits, then check the date values and selected range.

In Excel for Mac, select a cell in the list and use the Data tab’s date sort command, or open Data > Sort for the full dialog. Excel for the web has a similar Data-tab sort option. In either version, pay attention to selection prompts and verify that related columns remain aligned after the sort.

Common Mistakes

  • Sorting only the dates. This is the most serious error when the dates belong to records with other information. If Excel warns that adjacent data exists, expand the selection. For an Excel table, use the sort control in the date column header so the table records remain together.
  • Assuming a date appearance means it is a date value. A cell can display 03/04/2025 and still contain text. Changing its number format does not necessarily convert the underlying text. Mixed real dates and text dates may sort into separate groups or appear in an unexpected order.
  • Selecting the header as a record. If Excel does not identify the header, it may sort the column name along with the dates. Use the Sort dialog and set My data has headers, or select the data range with the header included and check the result immediately.
  • Expecting a particular display format to control order. Short Date, Long Date, or a custom format changes how a real date is shown, not the chronological sort order. A date displayed as 2025-03-04 can sort correctly alongside one displayed as 4-Mar-2025 if both are genuine Excel dates.
  • Including a total or note row by accident. A grand total, footnote, or section label can get moved into the body of the list. Keep those rows outside the sorted range, or put the records in an Excel table and keep summaries separate.

Tips

  • Use an Excel table for recurring lists. Select the data and choose Insert > Table, making sure the header option is correct. Table filter arrows make it easy to sort a date column, and the associated fields stay in their records. Tables are especially helpful for lists that grow over time.
  • Use the full Sort dialog for multiple criteria. Choose Data > Sort to set a primary date order and add another level, such as sorting equal dates by customer name. In the dialog, choose the date column under Sort by and set Order to Oldest to Newest. A secondary level only affects records tied on the primary date.
  • Keep dates in one consistent style when entering them. A consistent format reduces ambiguity, especially when the day and month could be confused. For example, 04/05/2025 can mean April 5 or May 4 depending on regional settings. Use an unambiguous format or confirm the workbook’s regional interpretation before sorting imported data.
  • Make a copy if the original order matters. Sorting changes the visible sequence of rows. If that sequence represents an original ranking or arrival order, add an index column before sorting or duplicate the sheet. You can then restore the initial sequence later by sorting on that index.
  • Use filter arrows carefully. If a filter is active, a sort may apply to the visible data or the full table depending on the selection and operation. Check whether rows are hidden by filters before interpreting the result, and clear filters if you need to see every record.

Troubleshooting

The dates sort alphabetically or into strange groups. This usually means some entries are text, or the column contains a mixture of text and true dates. Check a problem cell’s Number Format and compare it with a nearby date. If the dates came from a text file, select the affected column and choose Data > Text to Columns. Follow the wizard and, when prompted for the column data format, choose Date and the source order that matches the text, such as MDY or DMY. Finish the conversion, then apply a date format if needed and sort again. Make a copy first if the source data is important; a wrong MDY/DMY choice can change the interpreted dates.

The dates appear in the wrong century or month. Two-digit years and ambiguous day-month entries can be interpreted according to your regional settings. Check the actual date shown in the formula bar or temporarily apply a long date format. Correct the source entries or import them using the appropriate date order, then sort again. Do not rely on visual guesswork when dates such as 03/04/25 are ambiguous.

Some rows did not move with their dates. Undo at once with Ctrl+Z on Windows, or Command+Z on Mac. Repeat the operation by selecting the complete rectangular data range, or choose Expand the selection when prompted. If cells are separated by blank rows, select the intended records explicitly and ensure the range includes every related column.

The header moved, or a blank row split the results. Undo the sort, then open Data > Sort and set My data has headers correctly. Remove unintended blank rows inside the data block or select the full intended range manually. Keep totals and notes outside the range so the sort treats only actual records as records.

The sort command is unavailable or the result will not change. Confirm that the worksheet is not protected against sorting; a protected sheet may restrict sort operations unless the required permission was allowed. Also check for merged cells in the selected range, which can interfere with sorting. If there is only one date or all dates are identical, the order may naturally look unchanged. If filters hide some records, clear the filter to inspect the complete list.

Frequently Asked Questions

What does ascending order mean for dates in Excel?
It means chronological order from earliest to latest, also described by Excel as Oldest to Newest. A date in 2023 comes before a date in 2024, regardless of how each is formatted for display.

Can I sort dates without moving the other columns?
You can sort only a date column, but that is safe only when the other columns are not related to those dates. For a normal record list, sort the entire range or expand the selection so each row stays intact.

Why does Excel put some dates at the bottom?
Those entries may be blank, stored as text, or otherwise not recognized as date values. Inspect the cells and convert text dates to real dates before sorting. Blank cells may also appear after dated values in an ascending sort.

How do I sort dates from newest to oldest instead?
Select a date cell and choose Data > Sort Newest to Oldest. In the Sort dialog, choose Newest to Oldest in the Order list.

Will changing the date format fix a bad sort?
Not by itself. Formatting changes how a value is displayed; it does not reliably convert text into a date value. Convert text dates first, then apply the format you want and sort.

Can Excel sort dates in a table?
Yes. Use the arrow in the date column’s header and choose the oldest-to-newest option. Excel sorts the table records together, so the other columns remain connected to the correct dates.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.