Buzz
This article introduces the NETWORKDAYS function, one of the commonly used date and time functions in Excel.
Description: Returns the count of complete workdays between two specific dates. Workdays exclude weekends and specified holidays.
Syntax: NETWORKDAYS(start_date, end_date, [holidays])
In this context:
- start_date:
- end_date: The ending date for calculating the number of workdays, a required parameter.
- holidays: The dates of holidays to be excluded from workdays. These dates are usually not fixed and are an optional parameter.
Note:
- Excel stores dates as serial numbers for convenient calculations.
- If any argument of the function is invalid, the function returns an error value #VALUE!
Example:
Calculate the total working days for the following values:
- In the cell where you want to calculate the total working days, enter the formula: =NETWORKDAYS(E7,F7,G7).
- Press Enter -> the total working days are:
- Similarly, copy the formula for the remaining values to get the result:
Here, with the same start and end dates, considering the holiday on 2/11/2016 as a non-working day outside the company, the total working days decrease by 1.
Above is the guide and some specific examples when working with the NETWORKDAYS function in Excel.
Wishing you all success!
