WEEKNUM
function WEEKNUM(arg1: any = null, arg2: any = null): number | string | booleanDescription
Returns the week number in the year.
Parameters
- arg1
anydefault: null Is the date-time code used by Microsoft Excel for date and time calculation.
- arg2
anydefault: null Is a number (1 or 2) that determines the type of the return value.
Returns
number | string | booleanTry It
const oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.WEEKNUM("11/5/2018", 2);
oWorksheet.GetRange("C1").SetValue(ans);