Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inMONTH(serial_number)
Google Sheets✔ Built inMONTH(date)
Airtable✔ Built inMONTH(date)
Notion✔ Built inmonth(date)
Returns 1–12 in Formulas 2.0.
Try MONTH with your own values
Result (as Excel & Google Sheets return it)
3
Your formula, ready to paste
Excel=MONTH(DATE(2024, 3, 15)) open excel.new ↗
Google Sheets=MONTH(DATE(2024, 3, 15)) open sheets.new ↗
AirtableMONTH(DATETIME_PARSE("2024-03-15", "YYYY-MM-DD"))
Notionmonth(parseDate("2024-03-15"))

Arguments

ArgumentWhat it means
dateA date, a cell containing a date, or a formula that returns one.

Examples

FormulaResultWhyCopy
=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")MarchNot 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.

Part of the Date & Time functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.