:"Internationalized working day calculation: detailed explanation of the application of WORKDAY.INTL function"-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. "Internationalized working day calculation: detailed explanation of the application of WORKDAY.INTL function"

"Internationalized working day calculation: detailed explanation of the application of WORKDAY.INTL function"

Author: daogeziyuan • • Table skills • Views 696
The following is the rewritten content, retaining the original HTML and image address information: ```html
  • 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

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu 小飞飞 Columnist
48 196
single-end

Related Suggestion