Syntax

MONTH(when)

Description

MONTH() interprets when (a Text value) as a Date value and returns the month of the year it specifies.

Return Value

A Number value: the month of the year as a number (1 to 12) if found in when, or 0 if not found.

Did this answer your question?