MONTH

Last update： 2022-04-03

1. Extracted data

1）Overview

Grammar	MONTH:(serial_number,format)	Returns the month in the date. A month is a number between 1 and 12.
Parameter1	serial_number	Contains the date of the requested month. In addition to text and date types, 1900 standard series numbers are supported, for example, enter "35796" as "1998-01-01".
Parameter2	Format	For example: yyyy-MM-dd

2）Matters needing attention

The MONTH(serial_number) parameter is allowed to be empty. If the parameter is empty, the value is the number of months corresponding to the current system server time.
The first default parameter is a date or text type, and the second default parameter is text.
The second parameter supports the format YYYY-MM-DD

3）Example

Formula	Result	Remark
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

2. Real-time data

1）Overview

Grammar	MONTH:(serial_number)	Returns the month in the date. A month is a number between 1 and 12.
Parameter	serial_number	Contains the date of the requested month. Only text and date types are supported.

2）Matters needing attention

The MONTH(serial_number) parameter is allowed to be empty. If the parameter is empty, the value is the number of months corresponding to the server time of the current system.
You can default the date or use a text type parameter.
The second parameter supports the format YYYY-MM-DD.

3）Example

Formula	Result	Remark
MONTH()	10	The corresponding system server time is 2020-10-23 15:36:25.
MONTH("2000-01-01")	1

Previous

Next

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

滑鼠選中內容，快速回饋問題

滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。

不再提示

10s後關閉

Get
Help

*Problem Type

Incomprehensible Content Incorrect Content Incomplete Procedure Other Content Problems Doc Page Function Feedback

Cannot be empty

Problem Description

0/1000

Cannot be empty

Submitted successfully

Network busy