MONTH function

MONTH returns the month for the given date value. The month is returned as a number 1 - 12.

Syntax

MONTH(number)

number, as a time value, is a decimal for which the month is to be returned.

Example

=MONTH(1) returns 12 as the time value 1 corresponds to 12/31/1899.

Note: The goal is for HCL Connections Docs to be as accurate and as compatible with Microsoft Excel as possible. Therefore, except for the dates 1/31/1900, 12/31/1899, and 12/30/1899, or the numeric values 32, 1, and 0, there is no difference between the two applications.