Extracted Data
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
| Formula | Result | Note |
|---|---|---|
MONTH() | 10 | The corresponding system server time is 2020-10-23 15:36:25. |
MONTH("2000/1/1") | 1 | |
MONTH(35796) | 1 | |
MONTH("1997-04-20","yyyy-MM-dd") | 4 |
Real-Time Data
1. Overview
Syntax | MONTH(Serial_number) | Returns the month of the date. The returned value is an integer from 1 to 12. |
Parameter | Serial_number | Represents the date that contains the month you want to find. The Serial_number parameter can only be of the text or date type. |
2. Notes
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.
The second parameter can be of the yyyy-MM-dd format.
3. Example
Formula | Result | Note |
MONTH() | 10 | The corresponding system server time is 2020-10-23 15:36:25. |
MONTH("2000-01-01") | 1 |
