YEAR
function YEAR(arg1: number = null): number | string | booleanDescription
Returns the year of a date, an integer in the range 1900-9999..
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.YEAR("3/16/2018");
oWorksheet.GetRange("C1").SetValue(ans);