NETWORKDAYS_INTL
function NETWORKDAYS_INTL(
arg1: any = null,
arg2: any = null,
arg3: number = null,
arg4: any = null,
): number | string | booleanDescription
Returns the number of whole workdays between two dates with custom weekend parameters.
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
numberdefault: null Is a number or string specifying when weekends occur.
- arg4
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
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.NETWORKDAYS_INTL("8/1/2017", "9/1/2017", "0000011", "8/16/2017"));