Returns the serial number of the date before or after a specified number of workdays.
Name | Type | Description |
arg1 | any | Is a serial date number that represents the start date. |
arg2 | any | Is the number of nonweekend and non-holiday days before or after start_date. |
arg3 | any | Is an optional array 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.WORKDAY("12/7/1981", 56); oWorksheet.GetRange("C1").SetValue(ans); builder.SaveFile("xlsx", "WORKDAY.xlsx"); builder.CloseFile();