1. Overview
Syntax
MONTH(Serial_number,Format)
Returns the month of a date. The returned value is an integer from 1 to 12.
Parameter 1
Serial_number
Represents the date that contains the month you want to find. Besides the text and date types, the Serial_number parameter can also be of the serial number type of the 1900 standard date system. For example, 35796 represents 1998-01-01.
Parameter 2
Format
For example, yyyy-MM-dd.
2. Notes
The function allows the parameters to be empty. That is to say, you can simply use MONTH(). When the parameters are empty, the function returns the month of the current system server time.
The first default parameter is of the date or text type, and the second default parameter is of the text type.
The second parameter can be of the yyyy-MM-dd format.
3. Example
MONTH()
10
The corresponding system server time is 2020-10-23 15:36:25.
MONTH("2000/1/1")
1
MONTH(35796)
MONTH("1997-04-20","yyyy-MM-dd")
4
MONTH(Serial_number)
Returns the month of the date. The returned value is an integer from 1 to 12.
Parameter
Represents the date that contains the month you want to find. The Serial_number parameter can only be of the text or date type.
The function allows the parameter to be empty. That is to say, you can simply use MONTH(). When the parameter is empty, the function returns the month of the current system server time.
The parameter can be of the date or text type by default.
Formula
Result
Note
MONTH("2000-01-01")
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy