How to Sort by Month in Excel – 4 Methods

This is an overview.

Sort by Month in Excel


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

Step 1:

  • Select C4:C13, and go to:

Home → Editing → Sort & Filter → Custom Sort

Perform Custom Sort Options to Sort by Month in Excel

  • In the Sort Warning dialog box, select:

Expand the Selection → Sort

Perform Custom Sort Options to Sort by Month in Excel

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

Perform Custom Sort Options to Sort by Month in Excel

Step 2:

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

Perform Custom Sort Options to Sort by Month in Excel

  • Go back to the Sort window and click OK.

This is the output.

Read More: How to Sort Birthdays in Excel by Month and Day


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)

Apply the MONTH Function to Sort by Month in Excel

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

Apply the MONTH Function to Sort by Month in Excel

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

Apply the MONTH Function to Sort by Month in Excel

This is the output.

Apply the MONTH Function to Sort by Month in Excel

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.

Apply the MONTH Function to Sort by Month in Excel

Read More: How to Sort Dates in Excel by Year


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

Steps:

  • Select F5.

Perform the SORTBY Function to Sort by Month in Excel

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

Perform the SORTBY Function to Sort by Month in Excel

  • Press Enter to see the output.

Read More: How to Sort by Date in Excel


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

Step 1:

  • Select a cell. Here, D5.

Insert TEXT Function to Sort by Month in Excel

  • In the Formula Bar, enter the TEXT function:
=TEXT(C5, "MM")

MM is the month command.

Insert TEXT Function to Sort by Month in Excel

  • 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

Insert TEXT Function to Sort by Month in Excel

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

Insert TEXT Function to Sort by Month in Excel

This is the output.

Insert TEXT Function to Sort by Month in Excel

Read More: How to Sort Dates in Excel by Month and Year


Download Practice Workbook

Download this practice workbook to exercise.


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 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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo