month

Returns the month of the year (1 through 12) from the specified date. For example, the function returns:

  • 1 for January 1, 2012
  • 12 for December 31, 2012

Syntax

month(date)

Parameters

date can be any of the following:

  • Another function that returns a date.
  • A formula column that returns a date.

Examples

  • If today is January 1, 2012, the following function returns 1:
    month(today())
  • The following function returns 1:
    month(date(2013,01,01))

Related links

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
1385988576180056494
true
Search Help Center
true
true
true
true
true
5055977
false
false