MONTH

Description

MONTH returns the month that corresponds to the supplied date.

Syntax

MONTH ( serial_number )

Parameter	Description
serial_number	The date as a serial number or as text (for example, 06-21-94 or 21-Jun-94).

Remarks

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

Examples

This function returns 6:

MONTH("06-21-94")

This function returns 10:

MONTH(34626)

Also, see