MONTH
function MONTH(arg1: number = null): number | string | booleanDescription
Returns the month, a number from 1 (January) to 12 (December)..
Parameters
- arg1
numberdefault: null Is a number in the date-time code used by Microsoft Excel.
Returns
number | string | booleanTry It
const oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.MONTH("3/16/2018");
oWorksheet.GetRange("C1").SetValue(ans);