- Graphic and text skills
Formula syntax and usage of WORKDAY.INTL function
Returns the serial number of a date that is before or after a specified number of weekdays (using a custom weekend parameter).
The weekend parameter specifies the days of the weekend and which days they are.
Weekends and any days designated as holidays are not considered working days.
Syntax
WORKDAY.INTL(start_date, days, [weekend], [holidays])
The WORKDAY.INTL function syntax has the following parameters:
Start_date Required. Start date (will be truncated).
Days Required. Start_date The number of business days before or after. A positive value represents a date in the future; a negative value represents a date in the past; a value of zero represents a start date. Day-offset will be truncated.
weekend Optional. Indicates days of the week that are weekends and days that are not working days. Weekend is a weekend number or string that specifies the weekend day.
Weekend numbers | Weekends |
The weekend string value is seven characters long, and each character in the string represents a day of the week (starting on Monday).
1 indicates non-working days and 0 indicates working days. Only the characters 1 and 0 are allowed in the string. 1111111 is an invalid string.
For example, 0000011 results in Saturday and Sunday being the weekend.
holidays Optional. An optional set of dates representing one or more dates to exclude from the weekday calendar. holidays should be a range of cells containing the relevant dates, or an array constant consisting of sequence values representing those dates. The order of dates or sequence values in holidays can be arbitrary.
Remarks
If start_date is outside the range of the current date's base value, function WORKDAY.INTL returns the #NUM! error value.
If any of holidays
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/guo-ji-hua-gong-zuo-ri-ji-suan-WORKDAY-INTL-han-shu-ying-yong-xiang-jie.html
评论列表(196条)
测试