:Date and time functions NETWORKDAYS.INTL function-Table skills免费ppt模版下载-道格办公

Picture and text skills
Case

Returns the number of all working days between two dates, using parameters to indicate which days are weekends and how many are weekends.

Weekends and any days designated as holidays are not considered business days.

Grammar

NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

NETWORKDAYS.INTL function syntax has the following parameters:

￭start_date and end_date: Required, the dates whose differences are to be calculated. start_date can be earlier than, later than, or the same as end_date.

￭weekend: Optional, representing a weekend day between start_date and end_date but not included in all working days.

weekend isa weekend number or string that specifies the weekend day.

weekend value represents the following weekend days:

The weekend string value is seven characters long, and each character in the string represents a day of the week (starting on Monday).

1 means non-working days, 0 means working days. Only characters 1 and 0. Using 1111111 will always return 0.

For example, 0000011 results in Saturday and Sunday being the weekend.

￭holidays: Optional, an optional set of dates representing one or more dates to be excluded 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 serial values in holidays can be arbitrary.

Description

￭If start_date is later than end_date, the return value will be negative and the quantity will be the number of all working days.

￭If start_date is outside the range of the current date base value, please NETWORKDAYS. International returns #NUM! .

￭If end_date is not within the range of the current date base value, NETWORKDAYS. International returns #NUM! .

￭If the weekend string has an invalid length or contains invalid characters, NETWORKDAYS. International returns #VALUE! .

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/ri-qi-he-shi-jian-han-shu-NETWORKDAYS-INTL-han-shu.html