MONTH

Formula Explanation

Returns the month from a date value as a sequential number. The month is an integer between 1 (January) and 12 (December).

Formula Syntax

Result column input: MONTH(column number)

The MONTH function syntax has the following argument:

• Column number (required): The date from which you want to retrieve the month. You can input the date using the DATE function or as the result of another formula or function.
• Use the function DATE(2008,5,23) to input May 23, 2008. If the date is entered as text, there may be issues.

Usage Example

Retrieve the month from the values in column DS2. Write the result in column DS3.

DS3 = MONTH(DS2)

✉️ Ask Tablize