# How to Sort by Month in Excel – 4 Methods

This is an overview.

## Method 1 – Using a Custom Sort Option to Sort by Month in Excel

Step 1:

• Select C4:C13, and in the Home Tab, go to,

Home â†’ Editing â†’ Sort & Filter â†’ Custom Sort

• In the Sort Warning dialog box, select:

Expand the Selection â†’ Sort

• In the Sort window, select Column.
• In Sort, enter Birth Month.
• In Sort on, select Cell Values
• In Order, choose Custom List.

Step 2:

• In the Custom Lists window, select January, February, March, and April in Custom lists.
• Click OK.

• Go back to the Sort window and click OK.

• This is the output.

## Method 2 – Applying the MONTH Function to Sort by Month in Excel

Step 1:

• Select D5.
• Enter the MONTH function in the Formula Bar:
`=MONTH(C5)`

• Press Enter to get 5 as the return of the MONTH function.

• Drag down the Fill Handle to see the result in the rest of the cells.

• This is the output.

Step 2:

• Select D4:D13 and in the Data Tab, go to:

Data â†’ Sort & Filter â†’ Sort

• Click Sort.
• In the Sort window, select column.
• In Sort by, choose Month.
• In Sort on, select Cell Values.
• In Order, choose Smallest to Largest.
• Click OK.

• This is the output.

Read More: How to Sort Dates in Excel by Year

## Method 3 – Sorting by Month Using the SORTBY Function in Excel

Steps:

• Select F5.

• Enter the SORTBY function in the Formula Bar:
`=SORTBY(B5:D13, MONTH(C5:C13))`

• Press Enter to see the output.

Read More: How to Sort by Date in Excel

## Method 4 – Inserting the TEXT Function to Sort by Month in Excel

Step 1:

• Select a cell. Here, D5.

• In the Formula Bar, enter the TEXT function:
`=TEXT(C5, "MM")`
• MM is the month command.

• Press Enter to see the output.

• Drag down the Fill Handle to see the result in the rest of the cells.

Step 2:

• In the Home Tab, go to:

Home â†’ Editing â†’ Sort & Filter â†’ Sort A to Z

• Click Sort A to Z to open the Sort Warning window.
• Select Expand the selection.
• Click Sort.

• This is the output.

## Related Articles

<< Go Back to Sort by Date in Excel | Sort in ExcelÂ |Â Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF