To sort Excel by month, select the full data range and choose Data > Sort. Sort real date values by the date column for calendar order; to group the same month across different years, add a helper column with =MONTH(A2) and sort by that column. Month names stored as text need a custom month list or a numeric helper so they do not sort alphabetically.
Choose what “sort by month” means
There are several useful meanings of sorting by month, and the right method depends on what you want to see. A list of dated transactions may need to run from the earliest date to the latest. A yearly report may need all January records together, followed by February records, regardless of year. A summary might instead need one group for each month and year, such as January 2024 followed by February 2024.
Before sorting, check whether the cells contain actual Excel dates or text that only looks like a date. Dates are stored as numeric values, so Excel can compare them chronologically even when they display as “Jan” or “January.” Text month names, by contrast, are words; an ordinary A-to-Z sort puts April before February.
- Chronological dates: sort the original date column from oldest to newest.
- Same month across years: sort using a month-number helper column.
- Month and year together: sort by the original date or a first-of-month helper date.
- Month names as text: use Excel’s custom month order or a numeric helper.
Sort actual dates in calendar order
If each row contains a genuine date, the simplest option is usually the best. Click a cell in the date column, then select Data > Sort Oldest to Newest. Excel sorts by the full stored date, including the year, month, and day. A date formatted to show only “March” still retains its year and day for sorting.
For a table with multiple columns, make sure the entire table is included. If Excel asks whether to expand the selection, choose Expand the selection; sorting only the date column can detach dates from the names, amounts, or other details in the same rows. For more control, click a cell in the data and select Data > Sort. In the Sort dialog, choose the date-column heading under Sort by, then choose Oldest to Newest under Order.
For example, sorting 12/31/2024, 1/5/2025, and 2/1/2025 from oldest to newest produces that same sequence. It does not place January 2025 before December 2024 simply because January is the first month. That is correct for a timeline, but it is different from grouping every January together across multiple years.
Group the same month across different years
To collect every January record together, create a helper column that extracts the month number from each date. With dates in A2:A20 and a helper heading in B1, enter the formula below in B2 and fill it down the rows. For a date of January 15, 2025 in A2, the result is 1; February returns 2 and December returns 12.
With dates in A2:A20 and the first helper formula in B2, use =MONTH(A2). The result for an A2 value of January 15, 2025 is 1.
Then sort the full data range by the helper column from smallest to largest. All records with a month value of 1 appear first, followed by month 2, and so on. The year is deliberately ignored by this method. If you need a defined order within each month—for example, January 2023 before January 2024—use the Sort dialog and add a second level based on the original date column, also in ascending order.
The helper values are numbers, not month labels, which is why their order is reliable. You can leave the helper column visible for transparency or hide it after sorting. If you later add rows, make sure the helper formula is copied into those rows before sorting again. An Excel Table can make this easier because calculated-column formulas generally fill through the table as it grows.
Sort month and year as one sequence
If you want monthly groups in chronological order while keeping different years distinct, sort the original date column. For example, a date column will put January 2024 before February 2024 and January 2025 after December 2024. You can display those dates as month and year without changing the underlying values: select the cells, open Format Cells, choose Custom, and use a format such as mmm yyyy or mmmm yyyy. The display changes, but the complete date remains available to Excel for sorting.
Another option is a helper column that converts each date to the first day of its month. With dates in A2:A20 and the helper formula entered in B2, use =DATE(YEAR(A2),MONTH(A2),1). For January 15, 2025, the result is the date January 1, 2025; for January 29, 2025, it is also January 1, 2025. Format the helper cells as mmm yyyy if you want month-year labels, then sort that column oldest to newest. This groups dates within the same month and year while preserving calendar order across years.
Sort month names stored as text
If a column contains words such as January, February, and March rather than date values, an ordinary ascending sort will use alphabetical order. In Excel for Microsoft 365 on Windows, select the data and go to Data > Sort. Choose the month-name column under Sort by, then open the Order list and choose Custom List. Select the built-in January-to-December list, then confirm the dialog. Excel applies calendar order to matching month names.
Short names such as Jan, Feb, and Mar can also match Excel’s abbreviated month list. If the list contains inconsistent spellings, extra spaces, or a mixture of abbreviations and full names, the custom order may not sort every entry as expected. Standardize the text first, or use a helper column that assigns each label a number from 1 to 12. A numeric helper is also a practical choice when sorting in Excel for the web and the custom-list option is not available in the interface.
Custom month order is useful when the month names are labels in a report or a manually prepared summary. It does not turn those text values into dates. If you need to calculate elapsed time, compare specific days, or sort by year as well, use genuine date values instead.
Use a helper column when the source needs to stay unchanged
A helper column is often the clearest approach for reports, imported data, and repeatable sorting. Add a new column with a descriptive heading such as Month number or Month start, put the appropriate formula beside the first record, and fill it down. Sort the entire dataset by that helper field, not just the helper cells. When the purpose is only to present a report, you can hide the helper column afterward; keeping it visible can make the sort logic easier for colleagues to understand.
Do not replace the original date values with month numbers unless losing the day and year is intentional. A month number of 1 cannot distinguish January 2023 from January 2025. Keeping the original date and using a separate helper preserves the information needed for later analysis.
Fix common sorting problems
- Dates sort alphabetically or into an unexpected order: the cells may contain text, not date values. Check a few cells by changing their number format; if they do not behave like dates, convert or re-import the values as dates before sorting.
- January is followed by April: the month names are being sorted as text. Use a custom month list or a month-number helper.
- Rows no longer match their dates: the sort may have been applied to only one column. Undo the sort if possible, then select the complete range and sort again, expanding the selection when prompted.
- Some entries appear at the bottom: blanks, errors, or misspelled month labels can affect results. Review those cells and decide whether to correct, fill, or exclude them before sorting.
- Dates are grouped incorrectly around year boundaries: decide whether you want full chronological order or month-only grouping. Sorting by the actual date includes the year; sorting by
=MONTH(A2)ignores it.
Regional settings can also affect imported date text. For instance, a text value such as 03/04/2025 can mean March 4 or April 3 depending on the date convention used by the source. Confirm the intended interpretation before converting it; sorting cannot resolve an ambiguous date safely by itself.
Keep the rows and formulas working together
When data is formatted as an Excel Table, sorting from a column’s filter arrow sorts the table rows together and helps include new records. To create a table, select the data and choose Insert > Table, making sure the header option is correct. In a regular range, select a cell within the data and use the Sort dialog so Excel can identify the connected range. Check for completely blank rows or columns that might make Excel treat part of the data as a separate block.
After sorting, review the first and last few records and verify that names, dates, and values still align. If the workbook is shared, consider leaving a clear heading on the helper column and documenting whether the report groups by month alone or by month and year. Those are different outcomes, and a visible helper makes the distinction easier to audit.
Excel on Mac and in a browser
The underlying methods work in Excel for Microsoft 365 on Windows and Mac: sort actual dates by the date column, or use a helper field for month-only grouping. On Mac, select the data and use the Data tab’s sort controls; ribbon placement and dialog details can differ slightly from Windows. Excel for the web also supports sorting data, but available custom-list controls may vary. A helper column containing month numbers is a portable fallback because it uses ordinary worksheet values and can be sorted as a standard numeric field.
Frequently Asked Questions
Can Excel sort dates by month without considering the year?
Not with a normal sort on the original date column: that sorts full dates, including years. Add a month-number helper using =MONTH(A2), fill it down, and sort the full dataset by that helper column.
Why does Excel sort January, April, August instead of calendar order?
Those entries are likely text labels being sorted alphabetically. Choose the built-in month custom list in the Sort dialog, or sort by a numeric month helper instead.
Can I show only the month but keep the full date?
Yes. Apply a date number format such as mmmm to display the month name. The underlying date remains intact, so Excel can still sort it by the complete date.
How do I sort January 2024 before February 2024?
Sort the original date column from oldest to newest, or sort a first-of-month helper date from oldest to newest. Both methods preserve the order of months and years.
Will sorting one column rearrange the whole row?
It should when Excel recognizes the connected data range or Table. If Excel asks, choose Expand the selection; sorting only one column risks pairing values with the wrong records.
Related
- Small Excel Sample Data: Examples to Copy and Use Now
- Large Excel Data: Limits, Tools, and Best Practices
- Large Excel Cheat Sheet Mouse Pad: What to Know
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel MAX Ignore Errors: Formula, Examples, and TipsTo find the largest value in Excel while ignoring error cells, use =AGGREGATE(4,6,A2:A10). In this formula, 4 selects…
- Trim Excel Column Values and Remove Extra SpacesTo trim values in an Excel column, enter =TRIM(A2) in a blank column beside the first value, fill…
- Excel Column Comparison: Formulas, Methods, and TipsTo compare two Excel columns, use a row-by-row equality test when corresponding cells should match, or check whether…
- COUNTA Function in Excel: Count Nonblank Cells CorrectlyTo count nonblank cells in Excel, use COUNTA. With five entries and two truly empty cells in A2:A8,…
- Excel Concatenate String Examples: Formulas That WorkTo concatenate strings in Excel, join cell references and text with the ampersand operator (&), or use CONCAT…
- Excel Sum Based on Criteria with SUMIF and SUMIFSIf categories are in A2:A7 and amounts are in B2:B7, use =SUMIF(A2:A7,"East",B2:B7) to add the amounts for East;…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.