MONTH

See also A-Z Spreadsheet Function List

Description Returns the month that corresponds to the supplied date.

Syntax MONTH(serial_number)

serial_number is the date as a serial number or as text (e.g., “06-21-94” or “21-Jun-94”).

Remarks MONTH returns a number ranging from 1 (January) to 12 (December).

See Also DAY , HOUR , MINUTE , NOW , SECOND , TODAY , WEEKDAY , and YEAR functions

Examples MONTH(“06-21-94”) returns 6

         MONTH(34626) returns 10