TRY NEW VERSION

NETWORKDAYS

NETWORKDAYS(arg1, arg2, arg3) → { number | string | boolean }

Returns the number of whole workdays between two dates.

Parameters:

Name Type Description
arg1 any

Is a serial date number that represents the start date.

arg2 any

Is a serial date number that represents the end date.

arg3 any

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:

Type
number | string | boolean

Example

Copy code
builder.CreateFile("xlsx");

const oWorksheet = Api.GetActiveSheet();

var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.NETWORKDAYS("3/16/2018", "12/31/2018"); 

oWorksheet.GetRange("C1").SetValue(ans);

builder.SaveFile("xlsx", "NETWORKDAYS.xlsx");
builder.CloseFile();

Resulting document