Returns the number of whole workdays between two dates.
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. |
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();