Skip to content
This repository has been archived by the owner on Oct 7, 2024. It is now read-only.
Daniel Gorman edited this page May 22, 2019 · 5 revisions

The MONTH Function

Function Group: Date

MONTH takes a date and returns an integer representing the month of the year on which it falls.

Syntax

MONTH(arg1)

  • arg1 is a date object or a function that resolves to a date object

Uses

To get the current month, we can call MONTH with an argument of a date object.

For instance, if we want to find the current month, we can call MONTH(TODAY()), with the TODAY function being the argument. This will return an integer representing the current month.

If it is the last month of the year, MONTH(TODAY()) will return 12.

Clone this wiki locally