Returns the month, a number from 1 (January) to 12 (December)..
Name | Type | Description |
arg1 | number | Is a number in the date-time code used by Microsoft Excel. |
builder.CreateFile("xlsx"); const oWorksheet = Api.GetActiveSheet(); var oFunction = Api.GetWorksheetFunction(); var ans = oFunction.MONTH("3/16/2018"); oWorksheet.GetRange("C1").SetValue(ans); builder.SaveFile("xlsx", "MONTH.xlsx"); builder.CloseFile();