Buzz
Introduction to NETWORKDAYS Function: One of the widely used functions in the date and time category in Excel.
Description: This function calculates the number of complete workdays between two dates by specifying parameters to determine the number of weekend days and which day of the week.
Syntax: NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Herein lies:
- start_date: The commencement date for computing working days, a mandatory parameter.
- end_date: The conclusion date for computing working days, a mandatory parameter.
- weekend: The methodology for excluding weekends from the working day count, comprising the following values:
+ weekend = 1 or omit -> The weekend days are Saturday and Sunday.
+ weekend = 2 -> The weekend days are Sunday and Monday.
+ weekend = 3 -> The weekend days are Monday and Tuesday.
+ weekend = 4 -> The weekend days are Tuesday and Wednesday.
+ weekend = 5 -> The weekend days are Wednesday and Thursday.
+ weekend = 6 -> The weekend days are Thursday and Friday.
+ weekend = 7 -> The weekend days are Friday and Saturday.
+ weekend = 11 -> Sunday is the only weekend day.
+ weekend = 12 -> The weekend days are Monday.
+ weekend = 13 -> The weekend days are Tuesday.
+ weekend = 14 -> The weekend days are Wednesday.
+ weekend = 15 -> The weekend days are Thursday.
+ weekend = 16 -> The weekend days are Friday.
+ weekend = 17 -> The weekend days are Saturday.
- holidays: Dates to be excluded from working days, usually not fixed and are optional parameters.
Note:
- If start_date is > end_date -> The returned value will be negative, and the magnitude of the value will be the total number of complete working days.
- If the start_date or end_date value is outside the current date range -> the function returns an error value #NUM!
- If the weekend day value is invalid -> the function returns an error value #VALUE!
Example:
Calculate the total working days knowing that weekend days are not counted as working days.
In the cell where you want to calculate, enter the formula: =NETWORKDAYS.INTL(E7,F7,G7,H7).
- Press Enter -> the returned value is:
Here, the total working days are 240 days excluding Saturdays and Sundays, with a total of 40 Sundays and 40 Saturdays.
- Similarly, with an additional exceptional holiday -> the total working days are:
- Copy the formula for the remaining values to get the result:
- In case start_date is > end_date -> the returned value is less than 0 -> the actual working days in the past.
Here, the value is -270 -> the number of working days in the past is 270 days.
Above is the guide and some specific examples when using the NETWORKWEEKDAYS.INTL function in Excel.
Wishing you all success!
