Excel Sort Dates From Earliest to Latest: A Clear Guide

To sort dates in Excel from earliest to latest, select a cell in your date column, then choose Data > Sort & Filter > Sort Oldest to Newest. If the dates belong to rows of related information, sort the full table or choose Expand the selection when Excel asks, so each date stays with its matching data.

Sort a date column in a worksheet

In Excel for Microsoft 365 on Windows, the quickest approach is to use the sort command on the Data tab. Click a date cell in the column you want to arrange, open Data, and choose Sort Oldest to Newest in the Sort & Filter group. Excel arranges valid date values in chronological order, with the earliest date first.

Before you sort, check that the column has a heading and that the data forms a continuous range without completely blank rows splitting it. When your dates sit beside names, amounts, or other details, select a cell inside the data rather than selecting only the date cells. Excel usually recognizes the related range; if a prompt appears, choose Expand the selection. Sorting only the date column can leave names and other values attached to the wrong dates.

You can also select the date column or data range first and then use the same command. If Excel displays a warning asking whether to expand the selection, choose the option that keeps the rows together. Avoid choosing Continue with the current selection for a list where each row represents one record.

Use the Sort dialog for more control

The Sort dialog is useful when a worksheet has several columns, a header row, or more than one sorting rule. Click a cell in the data and choose Data > Sort. In the dialog, select the date column in Sort by, set Sort On to Cell Values, and choose Oldest to Newest under Order. If the first row contains column names, make sure My data has headers is selected.

For example, a project list might have columns for task, owner, and due date. Sorting by the due-date column places the earliest deadlines at the top while moving each complete task row. The header remains at the top when Excel recognizes it as a header. If it does not, the header may be treated as a date or moved into the sorted records, so verify the header setting before confirming.

The dialog also lets you add levels. You could sort first by due date and then by owner, so tasks with the same date are grouped by owner. Choose Add Level, select the secondary column, and specify its order. The first level remains the main chronological order; the additional level only organizes records that tie on the primary sort key.

What Excel means by a date

Excel sorts dates by their underlying values, not by how the cells look on screen. In a normal Excel date cell, the displayed date represents a serial number: later calendar dates have larger values. A cell formatted to show “14 March 2025” can therefore sort correctly even if another cell displays “3/14/25.” Changing a date format changes its appearance, not its chronological position.

This distinction explains why changing a text date’s format often does not fix sorting. A value that looks like a date may actually be text. Text such as “March 14, 2025” can sometimes be interpreted differently depending on regional settings, while an actual Excel date is stored as a numeric value. If a column mixes real dates and text, sorting may put some entries in an unexpected group rather than arranging every row in true calendar order.

Display formats can also hide useful details. A cell formatted to show only a month and year may still contain a specific day. Excel sorts by that full underlying date, not just the visible month. If two dates appear identical because the format omits the day, inspect the formula bar or temporarily apply a format that shows the full date before assuming the sort is wrong.

Fix dates that sort incorrectly

If entries do not appear in chronological order, first check whether Excel recognizes them as dates. A quick clue is alignment: numbers and dates are generally right-aligned by default, while text is often left-aligned. This is only a clue, because cell formatting and alignment can be changed manually. You can also select a suspect cell and look at the formula bar, then compare its behavior with a known valid date.

For a column of date-like text, use Data > Text to Columns to convert it. Select the affected cells, start the Text to Columns wizard, choose Delimited, and proceed through the steps without selecting a delimiter if the dates are not separated into fields. In the final step, choose Date and the order that matches the source data, such as MDY or DMY, then finish. Check the result carefully: choosing the wrong order can convert ambiguous dates incorrectly.

For instance, “04/05/2025” can mean April 5 or May 4, depending on the source’s date convention. If you do not know whether the source uses month-day-year or day-month-year, do not guess based on the displayed values alone. Confirm the source format, convert a small sample, and inspect the result before applying the conversion to the full column. Once the entries are real dates, apply a date number format if needed and sort again.

Imported data may also contain leading or trailing spaces, apostrophes, or inconsistent separators. In those cases, inspect the source and clean or re-import it using the correct regional settings. A custom display format cannot turn text into a date value by itself. If dates come from a CSV file, the import settings and the order of day, month, and year can determine whether Excel interprets them correctly.

Keep complete records together

A sort should rearrange records, not just one field. In a worksheet where each row contains a date, customer, and order total, the row is the record. If you sort only the date cells while leaving the rest of the table in place, the dates will no longer describe the right customer or order. That can create errors that are hard to notice in a large list.

Excel tables help reduce this risk. To make a table, select the data including its headers and choose Insert > Table, then confirm whether the range has headers. Table columns have filter arrows; open the date column’s arrow and choose Sort Oldest to Newest. The table sort rearranges entire records, and the table can expand when you add data directly beneath it. Check that newly added rows are included before relying on a sort for a report.

For an ordinary range, be cautious around blank rows and columns. A completely blank row can make Excel treat the data above and below it as separate ranges. Select the full range explicitly or turn it into a table if appropriate. Also check for merged cells, which can interfere with sorting and are generally best avoided in the body of a sortable data set.

Dates with times, blanks, and duplicates

Excel dates can include times. The date supplies the whole-number portion of the stored value and the time supplies a fractional portion. When you sort a column containing both, entries on the same day may be ordered by time as well as by date. For example, 9:00 a.m. will come before 3:00 p.m. on the same day, even if the cells are formatted to display only the date and the times are hidden.

If records that look like duplicates do not stay together, show the time or inspect the values more closely. They may represent different times on the same day. If the time is not meaningful for your task, decide whether to remove it or create a date-only field before sorting; simply applying a date-only format hides the time but does not remove it from the stored value.

Blank cells are not dates. In an ascending sort, blanks are generally placed after populated values, but entire blank rows and mixed data can affect how Excel identifies the range. If you need a report with missing dates handled consistently, fill or label those values appropriately, or filter them for review before sorting. Duplicate dates are valid and remain as separate records; use a second sort level if you want a predictable grouping within each date.

Sort versus filter or a separate sorted view

Sorting changes the order of records in the range. Filtering hides records that do not match criteria but does not arrange the remaining records by itself. Use a sort when you want to read or print the data chronologically; use a filter when you want to focus on a subset, such as deadlines in one month. You can use both together, but check which records are currently visible before drawing conclusions from a filtered list.

If you need to preserve the original order, make a copy of the data before sorting or work in a separate worksheet. Microsoft 365 also provides the SORT function for creating a formula-driven sorted view, but it is not necessary for an ordinary one-time sort and requires a compatible Excel version. A standard ribbon sort is usually simpler when the goal is to rearrange the existing records.

Excel for Mac and Excel for the web

The steps above describe Excel for Microsoft 365 on Windows. Excel for Mac and Excel for the web also offer ascending date sorting, although ribbon layout and command labels can differ by platform or window size. Look on the Data tab or in the date column’s filter menu for an ascending or Oldest to Newest option. In the Sort dialog, select the date field and the ascending date order.

In any version, the essential checks are the same: sort by the correct date field, confirm that Excel recognizes the values as dates, and keep each complete record together. If you are working in a shared workbook, consider whether other users are editing the same range before changing its order. If a command is not visible, check the ribbon’s overflow area or open the full Sort dialog rather than assuming the feature is unavailable.

Frequently Asked Questions

How do I sort dates in Excel from oldest to newest?
Click a date cell and choose Data > Sort & Filter > Sort Oldest to Newest. If the dates are part of records with other columns, make sure Excel sorts the entire range or table.

Why are my dates sorting alphabetically or incorrectly?
Some entries may be text rather than real Excel dates, or the column may contain mixed values. Convert text dates using the correct date order, then sort again. Check regional conventions when values such as 04/05/2025 are ambiguous.

Can I sort dates without separating names from their dates?
Yes. Sort the table or expand the selection to include all columns in each record. Do not choose to sort only the date cells when adjacent information belongs to those dates.

Does changing the cell format fix a date that sorts wrong?
No. Formatting changes how a value is displayed, but it does not convert text into a numeric Excel date. Convert the value first, then apply the date format you want.

Why do dates on the same day appear in a different order?
The cells may include times that are hidden by the current format. Excel sorts by the full date-and-time value, so show the time or inspect the values if their order matters.

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.