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
- 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
May be interested
- How to calculate the number of days in Excelhow many days from january 9, 2015 to june 12, 2017? if you can find results within 5 seconds, you are truly a genius. however, this is no longer a problem when you know how to use excel.
- How to calculate the number of days between two time points extremely quickly using Excelcalculating the number of days between two dates in excel is not difficult. here is a super fast way to calculate the number of days between two dates in excel that you cannot ignore.
- Basic Excel functions that anyone must knowthe basic functions in excel such as the excel function, the excel statistics function we summarized below will be very helpful for you who often have to work on excel spreadsheets, especially in the field of accounting. let's refer to offline.
- How to subtract dates, months, and years in Excel - Calculate the distance between two dates in Excelin the process of processing data in excel you need to subtract days, months and years in excel. you do not know how to calculate and use what function? so invite you and tipsmake.com to learn how to calculate the distance between two dates in excel, except for days, months and years in excel below.
- COUPNUM function - The function returns the number of interest payments on a security in Excelin the process of investing in securities, paying special interest is very important. it helps you calculate and plan a reasonable calculation and investment. the following article details the coupnum function - the function returns the number of interest payments of securities in excel.
- PERMUT function - The function returns the number of permutations of a given number of objects in Excelpermut function: the function returns the number of permutations of a given object. permutations are subsets of values where the position and number of elements in permutations are different. syntax: permut (number, number_chosen)
- RANK.AVG function - The function returns the rank of a number in a list of numbers in Excelrank.avg function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the average rank. support functions from execl 2010 version and above
- 8 little-known Excel functions that can save you a lot of workeven seasoned excel users often find themselves stuck performing tasks manually that could be automated with a few clever functions.
- ISODD function - The function returns True if the value is an odd number in Excelisodd function: the function returns true if the value is odd. application of functions to check odd and even numbers. syntax: isodd (number)
- PERMUTATIONA function - The function returns the number of permutations (can be repeated) of a given object in Excelpermutationa function: the function returns the number of permutations (can be repeated) of a given object. support functions from excel 2013 onwards. syntax: permutationa (number, number_chosen)