Syntax

MONTH(when)

Arguments

  • when (Date, DateTime, or Time)

Return Value

Number: the month of the year (1 to 12) specified by when if identifiable, a fixed default month if when is a Time value, or 0 if a month is otherwise not found.

Examples

MONTH(TODAY()) : This month. See also TODAY().

MONTH(TODAY()) + 1 : Next month.

MONTH(TODAY() + 30) : Next month (unless today is the 1st of a month with 31 days, or one of the last few days of January).

MONTH(TODAY()) - 1 : Last month.

MONTH([Birthday]) : Someone's birth month.

Month Name

Convert today's month number to the month name:

INDEX(
  LIST(
    "Jan", "Feb", "Mar", "Apr", "May", "Jun",
    "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"
  ),
  MONTH(TODAY())
)
  1. LIST("Jan", "Feb", "Mar", ...) enumerates the 12 month names,
  2. MONTH(TODAY()) gets the month number (1 to 12) for today.
  3. INDEX(..., ...) gets the month name from LIST(...) corresponding to the month number returned by MONTH(...).

See also: INDEX(), LIST(), TODAY()

See Also

DAY(), YEAR()

Did this answer your question?