Sorting by month in Google Sheets is a frequent need when working with schedules, budgets, or reports that group data by time. Because month values can appear as text, dates, or numbers, choosing a dependable method matters for accuracy and repeatability. This guide explains how to sort by month using built‑in tools, custom date sorting, and formulas that work with both full dates and month names. You will find practical steps, behavior notes, and examples you can apply immediately in your own sheets.
Understanding Month Values in Sheets
Before sorting, recognize how month information is stored in your sheet. Months as part of real dates are understood by Google Sheets as serial numbers, making date-based sorting straightforward. Month names saved as plain text or chosen from a custom list require special handling because text sorts alphabetically rather than in calendar order. Recognizing the format helps you pick the right sorting technique and avoid unexpected results.
Date vs Text vs Custom List
| Type | Example | Sort Behavior Without Adjustment |
|---|---|---|
| Date | 2024-03-15 | Chronological by actual date |
| Text (month names) | March | Alphabetical (April, August, December…) |
| Number (1–12) | 3 | Numerical, correct if values 1–12 |
Sort by Month Using a Date Column
When your data includes full dates, the simplest method is to sort by the date column directly. Google Sheets interprets dates as chronological values, so rows naturally order by month within year. This method keeps related data aligned and works well for time series analysis. Use whole-row sorting to preserve relationships between columns while ordering by time.
Steps to Sort Rows by Date
- Click any cell inside your data range.
- Open the Data menu and select Sort range.
- Choose the date column as the sort column.
- Pick ascending order to go from earliest to latest months.
- Click Sort to apply the change.
Google Sheets sorts by year first, then month, then day if time elements differ. If you only care about month order across a single year, this method works reliably without extra formulas.
Sort by Month Name Using a Custom List
When month names appear as text and you want calendar order, create a custom sort order. Sheets does not know that December comes after November when values are text, so you must define the sequence. Custom lists let you map month names to an explicit rank and use them as the basis for sorting.
Define a Custom Month List
- Enter month names in calendar order on an empty area, for example in Sheet2 or in a hidden column.
- Select the range containing the ordered month names.
- Open Data > Create a new filter view or use Data > Sort range > Advanced sort.
- Under Sort by, choose the column with month names, then choose Custom sort order.
- Select your defined range that lists months in the desired order and apply the sort.
This keeps January through December in the correct sequence even though they are text. It is useful when dates are not available and month names must remain human readable.
Sort by Month Extracted from Dates
If you only have dates and need to group or sort by month independent of year, extract a sortable month value. You can display a formatted month for reporting while using a hidden helper column with a numeric month for reliable ordering. Formulas let you derive month numbers or names without altering original date values.
Use the MONTH Function for Numeric Sorting
The MONTH function returns a number from 1 to 12 from any valid date. Add a helper column with this formula, then sort by that column. Because numbers sort predictably, your rows will align by calendar month regardless of which day appears in each row.
Use the TEXT Function for Month Names
Combine TEXT with a custom format to show month names while retaining a hidden numeric key. For example, use =TEXT(A2, "MMMM") to display full month names and =MONTH(A2) as the hidden sort column. This approach keeps visual presentation clean while ensuring accurate ordering behind the scenes.
Sort by Fiscal Month or Nonstandard Calendars
Organizations that use fiscal years must align month order to their reporting calendar. Creating a mapping table and using lookup formulas lets you assign fiscal month ranks and sort accordingly. This technique is valuable when your fiscal year does not match the calendar year and simple date sorting is insufficient.
Build a Fiscal Month Mapping Table
List calendar months in one column and assign fiscal month numbers in another, shifting the sequence to match your fiscal start. Use this table with VLOOKUP or XLOOKUP to bring fiscal rank into your data, then sort by that rank. You can display either fiscal month names or calendar names while ordering follows your business cycle.
Example Mapping Concept
If your fiscal year starts in July, map July to fiscal month 1, August to 2, and so on through June as month 12. Apply this mapping as a helper column and sort by ascending fiscal rank. This preserves logical time ordering aligned to your reporting needs.
Best Practices and Limitations
Choose sorting approaches based on how your date or month data is stored. Date-based sorting is most robust because it uses native chronological values. Month numbers are reliable and easy to generate. Month names require custom lists or hidden keys to sort correctly. Keep original date values intact so you can recompute months if fiscal rules change. Avoid overwriting source dates when adding helper columns; use adjacent columns so you can update or pivot later.
Summary
Sorting by month in Google Sheets is straightforward when you match the technique to your data structure. Use direct date sorting for full dates, custom sort order for month names, and helper columns with MONTH or TEXT for flexible control. For fiscal calendars, map months to a fiscal rank and sort by that rank. With these methods, you can organize schedules, reports, and analysis by month accurately and repeatably within Sheets.