跳到主要内容

MONTH

Returns the month, a number from 1 (January) to 12 (December).

Syntax

expression.MONTH(arg1-);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

NameRequired/OptionalData typeDefaultDescription
arg1-RequiredApiRange | ApiName | numberA number in the date-time code.

Returns

number

Example

const worksheet = Api.GetActiveSheet();

let func = Api.GetWorksheetFunction();
let ans = func.MONTH("3/16/2018");

worksheet.GetRange("C1").SetValue(ans);