Returns the year of a date, an integer in the range 1900-9999..
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.YEAR("3/16/2018"); oWorksheet.GetRange("C1").SetValue(ans); builder.SaveFile("xlsx", "YEAR.xlsx"); builder.CloseFile();