MONTH

Get the month from a date.

Parameter List

Syntax
MONTH(date)
date

The date to return the month from. For example: "2019-06-29".

Examples

MONTH(A1) returns 8, as it's the month in the date.Example 1