MONTH function

Prev Next

Description

Returns the month of the given Date.

Syntax

MONTH(Date)

Arguments

Argument

Type

Dimensions

Description

Date

(required)

Date

Any Dimensions

Date to get the month from.

Returns

Type

Dimensions

Integer

Dimensions of argument Date

Examples

Formula

Result

Description

MONTH(DATE(2020, 12, 02))

12

The date December 2nd 2020 has a month of 12 (December).

See also

Excel: MONTH

Related articles: YEAR, DAY

More of a hands-on learner?

Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace.  It includes examples of every formula and modifier in Pigment!