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

Picture and text skills
Case

Returns the complete number of working days between parameters start_date and end_date. Working days exclude weekends and specially designated holidays.

You can use the function NETWORKDAYS to calculate an employee's accrued compensation based on the number of days they worked during a specific period.

Grammar

NETWORKDAYS(start_date,end_date,holidays)
Key points You should use the DATE function to enter dates, or enter dates as the result of other formulas or functions.

For example, use the function DATE(2008,5,23) to enter May 23, 2008. Problems arise if the date is entered as text.
Start_date is a date representing the start date.
End_date is the end date.
Holidays represents one or more days that are not in the working calendar An optional range of dates.

For example: statutory holidays of provinces/cities/autonomous regions and countries/regions and other non-statutory holidays. The list can be a range of cells containing dates, or a table

Array constant representing the serial number of the date.

Description
• WPSTable can store dates that can be used for calculations serial number. By default, the serial number for December 31, 1899 is 1, and January 1, 2008

Theserial number is 39448 because it is 39448 days from December 31, 1899.

• If any argument is an invalid date value, the NETWORKDAYS function returns the #VALUE! error 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-han-shu.html