Excel NETWORKDAYS function

Function              NETWORKDAYS

Description        Excel NETWORKDAYS function calculate the networking days between two dates. This function is useful for project scheduling, employee benefits calculation, business day calculation etc.

Syntax  NETWORKDAYS(start_date, end_date, [holidays])

start_date is a date in serial number format, it represents the start date.

end_date is a date in serial number format, it represents the end date.

[holidays] is optional, an optional range of one or more dates to exclude from the working calendar, such as national holidays and floating holidays.

 Example: