ISOWEEKNUM
function ISOWEEKNUM(arg1: number = null): number | string | booleanDescription
Returns the ISO week number in the year for a given date.
Parameters
- arg1
numberdefault: null Is the date-time code used by Microsoft Excel for date and time calculation.
Returns
number | string | booleanTry It
const oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.ISOWEEKNUM("9/1/2017");
oWorksheet.GetRange("C1").SetValue(ans);