Holidays:可选的。 日期列表或序列号的数组常量,被视为非工作日。 回报值 WORKDAY函数以序列号格式返回日期。 备注 1.在此功能中,将周末定义为星期六和星期日。 如果要使用其他周末,可以尝试WORKDAY.INTL函数。 2.如果参数days是十进制值,则WORKDAY函数仅将整数添加到start_date。
WORKDAY(start_date, days, [holidays]) 其中Start_date必需代表开始日期,Days必需代表start_date 之前或之后不含周末及节假日的天数 注意:Days 为正时将生成未来日期;为负值生成过去日期。 Holidays可选,是一个可选列表,包含需要从工作日历中排除的一个或多个日期 比如我们计算下面表格的完成日期,即可以在D2单元...
The WORKDAY.INTL function adds a specified number of workdays to a start date and returns a workday in the future or past. Also, it can exclude custom holidays when calculating as you need. Syntax and arguments Formula syntaxWORKDAY.INTL (start_date, days, [weekend], [holidays])Arguments...
程序集: Microsoft.Office.Interop.Excel.dll 返回某日期(起始日期)之前或之后相隔指定工作日的某一日期的日期值。 工作日不包括周末和节假日。 在计算发票到期日、预期交货时间或工作天数时,可以使用函数 WORKDAY 来扣除周末或节假日。 C# 复制 public double WorkDay (object Arg1, object Arg2, object Arg3...
Excel WORKDAY.INTL () function : This function is used to return the serial number of the date before or after a specified number of workdays with specified custom weekend parameters, that indicate which and how many days are weekend days.
If the start date is out of range, then function returns #NUM! Error. Holidays argument must be given as array reference, not the individual dates separated using commas, the function throws too many arguments error. Hope this article about How to use the WORKDAY.INTL function in Excel is...
WORKDAY is a built-in function in Excel 2007 - 365. In earlier versions, you need to enable theAnalysis ToolPak. When using WORKDAY in Excel, you have to input the following arguments: WORKDAY(start_date, days, [holidays]) The first 2 arguments are required and the last one is option...
The number of skips is based on the second argument of the function (days). You have an option to define the holidays in the third argument, to make the function take them into account. The holidays' argument is optional, you can omit it, which is means that there are no holidays. ...
TheWORKDAYis used to add a specified number of workdays to a started date and returns the future or past date in a serial number format. Weekends and the holidays you specified are excluded when calculation. This function usually calculates the ship dates in Excel. ...
程序集: Microsoft.Office.Interop.Excel.dll 使用自定义周末参数返回指定数量的工作日之前或之后的日期的序列号。 周末参数指示哪些日期为周末以及周末的天数。 周末以及指定为节假日的任何日期都不被视为工作日。 C# 复制 public double WorkDay_Intl (object Arg1, object Arg2, object Arg3, object Arg4...