Examples

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

`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(...)`.

Last Month

``(MOD((MONTH(TODAY()) - 1 + 12 - 1), 12) + 1)``
1. `MONTH(TODAY())` gets today's month number in the range 1...12.

2. `... - 1` converts month number from (1) to the range 0...11.

3. `... + 12` converts month number from (2) to the range 12...23.

4. `... - 1` steps month number from (3) back one ("last month"), giving a month number in the range 11...22. Use `... + 1` instead to step ahead one month ("next month") instead, giving a range of 13...24.

5. `MOD(..., 12)` converts the adjusted month number from (4) to the range 0...11.

6. `(... + 1)` converts the adjusted month from (5) to 1...12.

Equivalent to `MONTH(EOMONTH(TODAY(), - 1))`.

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.