NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excel
The following article introduces you to the NETWORKDAYS function - one of the functions in the date and time group function very popular in Excel.
Description: The function returns the number of intact working days calculated between two specific dates. Working days do not include weekends and holidays specified.
Syntax: NETWORKDAYS (start_date, end_date, [holidays])
Inside:
- start_date: Start date to calculate the number of working days, is a required parameter.
- end_date: The end date to calculate the number of working days, which is a required parameter.
- holidays: Holidays need to be excluded from the working day, these days are usually not on a fixed list, is an optional parameter.
Attention:
- Excel stores the date as a serial number to facilitate the calculation process.
- If any function argument is invalid -> the function returns the #VALUE! Error value
For example:
Calculate the total number of business days for the following values:
- In the cell to calculate the total number of working days, enter the formula: = NETWORKDAYS (E7, F7, G7).
- Press Enter -> total working days is:
- Similarly copying the formula for the remaining prices results:
Here, with the same start and end dates, but since February 11, 2016 is off-company leave, the number of working days is reduced by 1.
Above are instructions and some specific examples when working with NETWORKDAYS function in Excel.
Good luck!
You should read it
- NETWORKDAYS.INTL function - The function returns the number of whole working days between 2 dates, specifying weekends in Excel
- The DAYS function - The function returns the number of days between 2 dates in Excel
- DAYS360 function - The function returns the number of days between 2 dates, based on 360 days in Excel
- YEARFRAC function - The function returns the fifth calculated by the number of whole days between two specific dates in Excel
- DATEDIF function - The function calculates the number of days, months, years between 2 dates in Excel
- The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel
- DAYS function, how to use the function to calculate the number of days between two time points in Excel
- Basic Excel functions that anyone must know
- DAYS360 function - The function finds the number of days between two dates based on a 360-day year in Excel
- The WORKDAY.INTL function - The function returns a date before or after the date starting with a custom weekend in Excel
- COUPNUM function - The function returns the number of interest payments on a security in Excel
- RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
Maybe you are interested
8 Ways to Fix Clipboard History Stopped Working in Windows 11
How to Fix RCS Not Working on iOS 18
How to fix mouse not working error in GTA Vice City on Windows 10
How to fix mechanical keyboard not working
8 Ways to Fix Windows PIN Not Working in Windows 10/11
Why is the Working hybrid model being adopted by more and more companies?