MONTH() : extract the month number from a date

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

# Parameter Description

1 date_column The date-type column from which you want the month number.

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.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.