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: