MONTH

The MONTH function extracts the month value from a date. The input date should be in MM/DD/YYYY format. References are also accepted as arguments. This function is commonly used to analyze and group data by month.

Syntax

MONTH(date)

Arguments

• date: The input date.

Return value

Returns the month value from the specified date.

Example

MONTH("3/21/2023")

Returns 3.

Excel equivalent

MONTH