Month()

Working with Formulas > Functions Used in Formulas > Date/Time Functions > Month()

MONTH() returns the numeric month value for a given date expression. If a null date is specified, the function returns zero.

Function Format

MONTH(date) 

Return Value

MONTH() returns an integer 

Examples

MONTH(DATE("11/22/2007")) = 11 

MONTH(DATE(2007, 7, 4)) = 7