Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11NETWORKDAYS 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!
Kareem WintersYou 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 insert pictures into Word, Excel and align images
in word 2016, in addition to the image insertion feature available on computers, it also allows inserting images directly from internet searches. - How to insert symbols, special characters in Wordguide to insert symbols, special characters using the insert symbol feature in word.
- How to set the default font in Word, Excel 2016how to set the default font in word, excel 2016 helps you not to make font settings every time you create a new file according to your own.
- How to create a chart in Word 2016specific development directions. guide you how to draw a chart in word 2016. charts are tools that help report your data visually, based on which judgment can be made.
- Shortcuts in Powerpoint need to knowyou often have to use powerpoint, the hotkeys help you save time and effort to create presentations and slideshows. the following article is a comprehensive box of keyboard shortcuts in powerpoint that you need to know.
- How to embed a Youtube video in a Powerpoint presentationthis article shows you how to insert a youtube video into a powerpoint presentation.
Office information
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
- The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel
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
The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel