Filter Dates in Excel Oldest to Newest: A Step-by-Step Guide

Formulas & functions · Updated November 20, 2026

To put dates in chronological order in Excel for Microsoft 365 on Windows, select a cell in the date column, then choose Data > Sort Oldest to Newest. If you want to sort dates using a column’s filter arrow, open that arrow and choose Sort Oldest to Newest. Excel will reorder the matching rows so the earliest date appears first; make sure the complete records are included so dates stay with the correct names and details.

What You’ll Need

  • A worksheet with a column of dates and, if applicable, related information in neighboring columns.
  • A header row is helpful, though not essential. Clear column headings make it easier to identify the right field and use filters.
  • Dates that Excel recognizes as actual date values. Dates that are stored as text may not sort in true chronological order.
  • A saved copy of important data before you make a large change. Sorting can be undone with Ctrl+Z, but a backup is useful if further edits follow.

Step-by-Step

  1. Check the date column and its layout. Find the column you want to sort and confirm that each row contains one date in the same field. If the worksheet has a header, check that it clearly names the column, such as Order Date or Due Date. Look for blank rows, merged cells, or notes placed within the data; these can break up a continuous list and make sorting harder to control. If each date belongs to a person, product, or transaction, keep those fields in the same rows when you sort.
  2. Select a cell in the date column. Click one populated date cell in the list. For a normal, uninterrupted table of data, Excel can usually detect the surrounding data and sort the entire range. Do not select only the date cells if there is related information in other columns: that could move the dates without moving their corresponding records. If the data is arranged in separate blocks or has blank rows, select the complete block you want sorted instead.
  3. Sort from the Data tab. On the Windows ribbon, select Data > Sort Oldest to Newest. The command is in the Sort & Filter area. Excel arranges the dates from earliest to latest, which is ascending chronological order. If Excel asks whether to expand the selection, choose Expand the selection when neighboring columns contain information that belongs to each date, then select Sort. This keeps each record together.
  4. Use a filter arrow if the column already has filters. Select the arrow in the date column’s header, then choose Sort Oldest to Newest. This is a quick route when filter buttons are already visible. If the command says Sort Newest to Oldest, do not choose it for this task. A filter arrow can also hide records according to criteria, so sorting and filtering are related but different actions: sorting changes the order, while filtering hides rows that do not match.
  5. Turn on filter arrows if you need them. Click a cell in the data range and use Data > Filter to add dropdown arrows to the header row. On Windows, Ctrl+Shift+L is the keyboard shortcut for toggling filters. Open the date column’s arrow and select Sort Oldest to Newest. If you do not have clear headers, add them first so the arrows are easy to identify and do not treat a data row as a heading.
  6. Confirm that the full list sorted. Check a few dates near the top, middle, and bottom. The first date should be the earliest, and dates should generally progress forward as you move down the list. Also compare one or two records with another column: a name or order number that belonged to a date before sorting should still be on the same row as that date. If only one column moved, immediately use Ctrl+Z and sort again with the complete data range selected.
  7. Handle repeated dates as needed. Several records may have the same date, and that is normal. If you also want a consistent order within each date, select the data and choose Data > Sort to open the Sort dialog. Set the date field as the first sort level and choose Oldest to Newest. Add a second level, such as Customer Name or Time, if needed. Check that My data has headers is selected when your range includes a header row, then select OK.
  8. Save the workbook after checking the result. Sorting changes the row order in the worksheet. Once you have verified that dates and related fields still match, save the workbook. If the order is wrong, use Ctrl+Z before making more edits, then inspect the selected range and date values. Repeating the same sort on a list that is already in ascending order is usually harmless, but correcting the cause is better than repeatedly sorting without checking.

On Excel for Mac, the same basic approach applies: select a date cell and use the Data tab’s ascending date sort command, or use the date column’s dropdown if filters are on. Ribbon layout and shortcut behavior can vary by Mac version, so use the visible ribbon command if a Windows shortcut does not work. In Excel for the web, select the date column’s filter arrow and choose the ascending date sort option; the web ribbon may display the command in a different position.

Common Mistakes

  • Sorting only the date cells. Selecting just the date values can separate them from names, amounts, or other details. When Excel asks whether to expand the selection, expand it to include the complete records. For a deliberately selected range, include every column that must move together.
  • Confusing chronological order with alphabetic order. Dates stored as text can sort by their characters rather than by calendar value. For example, text dates written as month/day/year may appear in an order that looks plausible but is not chronological. Confirm that Excel recognizes the entries as dates before trusting the result.
  • Choosing the reverse sort command. Newest to Oldest places the latest date first. Use Oldest to Newest for ascending order, with the earliest date at the top.
  • Including the header as a date. If you select a range manually, tell Excel that it has headers in the Sort dialog. Otherwise, a heading such as Date might be sorted into the records or handled as a value.
  • Assuming a filter has deleted rows. Filter criteria hide nonmatching rows; they do not normally remove them. Clear or adjust the filter if some records seem to have disappeared, and check whether the row numbers skip while a filter is active.

Tips

  • Convert the range to an Excel table for recurring work. Select the data and choose Insert > Table, confirming that the table has headers if it does. Tables provide header dropdowns and generally include new adjacent records when the table expands. You can then sort the date column from its dropdown without selecting the range by hand.
  • Use a consistent date display. A format such as 3/8/2026 or 8-Mar-2026 controls how a recognized date appears, not the date’s underlying value. Select the date cells and use Home > Number Format to choose a date display that is clear to everyone using the workbook. Formatting alone does not turn text into real dates.
  • Use the Sort dialog for more control. A quick ascending sort is enough for one date field. The dialog is better when the range has several headers, you need a second sort key, or you want to confirm that Excel is sorting cell values rather than color or another property. Review the selected column name before applying a multi-level sort.
  • Make date conventions explicit when sharing. Entries such as 04/05/2026 can mean April 5 or May 4, depending on regional settings. If readers may use different date conventions, a display such as 5-Apr-2026 is less ambiguous. Verify that the underlying dates are correct, especially after importing a file from another system.

Troubleshooting

The dates appear out of order after sorting. First check whether the values are real dates or text. Select a suspect cell and temporarily choose General in Home > Number Format. A real Excel date normally displays as a serial number under General; a text entry remains text. Restore the desired date format afterward. If values are text, make a backup, then select the affected column and use Data > Text to Columns. In the wizard, choose Delimited, select Next twice, choose Date and the date order that matches the source data, then select Finish. Check the converted values before sorting. Choosing the wrong date order can change the meaning of ambiguous dates.

Only one column moved, or records no longer match. Use Ctrl+Z immediately on Windows, or use Edit > Undo on Mac. Select the whole data block, including all related columns, and sort again. If a prompt appears, choose Expand the selection. Avoid sorting a partial range that has been separated from its neighboring fields by blank columns or rows.

Some dates seem missing. Open the filter arrow and check whether a filter is active. Choose Clear Filter for that column, or use Data > Clear to clear filters and sort state as appropriate. Clearing a filter makes hidden rows visible again; it does not delete them. Also inspect hidden rows or collapsed groups if the list still appears incomplete.

The Sort command is unavailable or sorts the wrong field. Check that the sheet is not protected in a way that prevents sorting, that the selected cell is inside the data, and that the range has a recognizable header row. If the Sort dialog shows the wrong column, cancel it and select the intended range again. Merged cells within a data range can also interfere; unmerge them where practical and keep one value per row and column.

Dates with times are not grouped as expected. Excel date-time values contain both a date and a time, even if the cell format displays only the date. Sorting will order by the complete value, so entries on the same displayed day may be arranged by time. If that is not the intended behavior, check the underlying values and decide whether time should be retained or removed. Do not change the display format alone and assume it changes the stored time.

Frequently Asked Questions

Is Oldest to Newest the same as ascending order?

Yes. Dates increase from earlier to later as you move down the list, so Oldest to Newest is ascending chronological order. The reverse option, Newest to Oldest, is descending order.

Can I sort dates without turning on filters?

Yes. Click a date cell and use Data > Sort Oldest to Newest. Filter arrows are optional; they provide a convenient dropdown route and let you hide rows by date criteria, but you do not need them just to sort.

How do I show only dates within a certain period?

That is filtering rather than sorting. Turn on Data > Filter, open the date column’s dropdown, choose Date Filters, and select a suitable option such as a range or dates before or after a date. The exact options depend on the selected data and Excel version. To see all rows again, clear the filter.

Why are dates with the same day in an unexpected order?

The cells may include times that are not visible in the date format. Excel sorts the full date-time value, not only the part displayed. You can inspect a cell in the formula bar or apply a format that shows time to check. If a secondary order is required, use the Sort dialog to add another level.

Will sorting dates change the dates themselves?

A normal sort changes the order of rows, not the underlying date values. The date moves with its row when the full range is sorted. If you select only one column, however, the relationships between dates and neighboring data can be broken, so include the complete records.

Can I undo a date sort?

Use Ctrl+Z on Windows or Edit > Undo on Mac soon after sorting. Undo may no longer restore the original order after later actions or after closing and reopening the workbook. For a critical worksheet, save a copy or add an original-order column before sorting.

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.