Used in a formula column, the MONTH() function extracts the month number from a date-type column and returns a whole number between 1 and 12. It is used to group data by month: filter records for a given month, feed a monthly pivot table.
Syntax
MONTH(date_column)
Parameters
Examples
Extract the month number
For a date in April, the formula returns 4.
MONTH($Date)
Tip: combine MONTH() with YEAR() (or use YEAR_MONTH()) to distinguish the same month across multiple years.
Go further
DAY()
Extract the day of the month instead of the month number.
Or continue with
Formula glossary
All available operators and functions, sorted by category.