NETWORKDAYS
function NETWORKDAYS(arg1: any = null, arg2: any = null, arg3: any = null): number | string | booleanDescription
Returns the number of whole workdays between two dates.
Parameters
- arg1
anydefault: null Is a serial date number that represents the start date.
- arg2
anydefault: null Is a serial date number that represents the end date.
- arg3
anydefault: null Is an optional set of one or more serial date numbers to exclude from the working calendar, such as state and federal holidays and floating holidays.
Returns
number | string | booleanTry It
const oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.NETWORKDAYS("3/16/2018", "12/31/2018");
oWorksheet.GetRange("C1").SetValue(ans);