WEEKDAY
function WEEKDAY(arg1: number = null, arg2: number = null): number | string | booleanDescription
Returns a number from 1 to 7 identifying the day of the week of a date..
Parameters
- arg1
numberdefault: null Is a number that represents a date.
- arg2
numberdefault: null Is a number: for Sunday=1 through Saturday=7, use 1; for Monday=1 through Sunday=7, use 2; for Monday=0 through Sunday=6, use 3.
Returns
number | string | booleanTry It
const oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.WEEKDAY("11/5/2018", 2);
oWorksheet.GetRange("C1").SetValue(ans);