MONTH function

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



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


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

Note: The goal is for IBM 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.

Trademarks | IBM Connections wiki