MONTH Function in Excel, Google Sheets, Airtable & Notion
MONTH returns the month of a date as a number from 1 (January) to 12 (December).
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | MONTH(serial_number) |
| Google Sheets | ✔ Built in | MONTH(date) |
| Airtable | ✔ Built in | MONTH(date) |
| Notion | ✔ Built in | month(date)Returns 1–12 in Formulas 2.0. |
| Excel | =MONTH(DATE(2024, 3, 15)) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =MONTH(DATE(2024, 3, 15)) | open sheets.new ↗ |
| Airtable | MONTH(DATETIME_PARSE("2024-03-15", "YYYY-MM-DD")) | |
| Notion | month(parseDate("2024-03-15")) |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
date | A date, a cell containing a date, or a formula that returns one. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=MONTH(DATE(2024, 3, 15)) | 3 | ||
=ROUNDUP(MONTH(A2) / 3, 0) | Quarter (1–4) | Months 1–3 give 1, 4–6 give 2, and so on. | |
=TEXT(A2, "mmmm") | March | Not MONTH, but the usual way to get the month name. |
Examples use Excel / Google Sheets syntax unless noted.
How MONTH works
MONTH gives a number, which is what you want for sorting, grouping and arithmetic — the quarter of a date is =ROUNDUP(MONTH(A2)/3, 0). For the month name use TEXT(A2, "mmmm") (or "mmm" for “Mar”) in Excel and Google Sheets, DATETIME_FORMAT({Date}, "MMMM") in Airtable, and formatDate(prop("Date"), "MMMM") in Notion.
Grouping by MONTH alone mixes March 2023 with March 2024. To group by calendar month use the first of the month, =DATE(YEAR(A2), MONTH(A2), 1), or the month end with EOMONTH(A2, 0).
Frequently Asked Questions
- Why does my month group combine different years?
- MONTH only returns 1–12. Combine it with YEAR, or use
=EOMONTH(A2, 0)as the grouping key.