# MONTH function in Excel

> MONTH returns the month of a date as a number from 1 to 12.

Source: https://spreadsheetpractice.com/functions/month · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** MONTH returns the month of a date as a number from 1 to 12.
- **Syntax:** `=MONTH(serial_number)`
- **Most common use:** `=MONTH(B2)` returns 1 (January is month 1)
- **Available in:** Every current version
- **Category:** [Date functions](https://spreadsheetpractice.com/functions/category/date)
- **Returns:** A whole number from 1 (January) to 12 (December).
- **Google Sheets:** Works the same in Google Sheets.

## What it does

MONTH returns the month of a date as a number from 1 to 12. Use it to summarize by month, to work out quarters, or to test whether a date falls in a particular month. For the month name instead of the number, use TEXT.

## Syntax

`=MONTH(serial_number)`

| Argument | Required? | What it is |
|---|---|---|
| `serial_number` | Required | The date to read, usually a cell reference. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| E2 | `=MONTH(B2)` | 1 | January is month 1 |
| E3 | `=SUMPRODUCT((MONTH(B2:B5)=2)*C2:C5)` | $1,980 | Total of the February orders |
| E4 | `=ROUNDUP(MONTH(B5)/3,0)` | 2 | The quarter for the May order |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Order | Date | Amount |  | Result |
| 2 | A-1 | 1/14/2026 | $480 |  | 1 |
| 3 | A-2 | 2/3/2026 | $1,250 |  | $1,980 |
| 4 | A-3 | 2/27/2026 | $730 |  | 2 |
| 5 | A-4 | 5/9/2026 | $915 |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Months from different years are lumped together | MONTH ignores the year, so January 2025 and January 2026 both return 1. Test the year too, or group by TEXT(date,"yyyy-mm"). |
| #VALUE! | The cell holds text that looks like a date. Convert it with DATEVALUE, then take the month. |
| The result shows as a date in January 1900 | The cell kept a date format. Change it to General. |

## Tips

- =TEXT(A2,"mmm") gives the short month name (Jan, Feb) when you need a label rather than a number.

## Related functions

- [YEAR](https://spreadsheetpractice.com/functions/year): YEAR returns the four-digit year from a date.
- [DAY](https://spreadsheetpractice.com/functions/day): DAY returns the day of the month from a date, as a number from 1 to 31.
- [TEXT](https://spreadsheetpractice.com/functions/text): TEXT turns a number or date into text in the format you choose, such as "$1,250.00" or "March 2026".
- [EOMONTH](https://spreadsheetpractice.com/functions/eomonth): EOMONTH returns the last day of the month a number of months before or after a date.

## Questions

### How do I get the month name instead of the number?

Use TEXT: =TEXT(A2,"mmmm") for the full name or =TEXT(A2,"mmm") for the three-letter version.

### How do I get the quarter from a date?

Divide the month by 3 and round up: =ROUNDUP(MONTH(A2)/3,0) returns 1 to 4.

## Practice

A graded MONTH exercise ("Year and month") is on [the MONTH page](https://spreadsheetpractice.com/functions/month). It is checked instantly, then re-checked on changed data.

Lessons that use MONTH:

- [Lesson 23: DATE, YEAR, MONTH & TEXT](https://spreadsheetpractice.com/learn/date-year-month-text) (Pro)
- [Lesson 25: Tenure, quarters & weekdays](https://spreadsheetpractice.com/learn/tenure-quarters-weekdays) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
