MONTH function

The MONTH function is one of the date and time functions. It returns the month (a number from 1 to 12) of the date given in the numerical format (MM/dd/yyyy by default).

Syntax

MONTH(serial_number)

The MONTH function has the following argument:

Argument	Description
serial_number	The date of the month you want to find.

Notes

How to apply the MONTH function.

Examples

The figure below displays the result returned by the MONTH function.