MONTH (month of a date)

<< Click to Display Table of Contents >>

MONTH (month of a date)

Syntax:

MONTH(Date)

Description:

This returns the month of a date.

Example:

MONTH("09/25/2018") returns 9

MONTH("August 17") returns 8

If cell A1 contains the date value 9/25/2018 then MONTH(A1) returns 9

See also:

ISOWEEKNUM, ISOWEEK, WEEKNUM, YEAR, DAY, WEEKDAY