Menu
EXCEL NETWORKDAYS FUNCTION
Excel NETWORKDAYS Function Introduction
This function returns a number corresponding to the number of full working days between start date and end date. Weekends (by default, Saturday and Sunday) and any dates you specify as holidays are not considered working days.
You can use this function to calculate employee benefits that accrue based on the number of days worked during a specific term.
Description of Excel NETWORKDAYS Function
Syntax:
=NETWORKDAYS (start_date, end_date, [holidays])
Parameter list:
- start_date – the start date.
- end date – the expiration date.
- holidays – [optional] a list of one or more dates to be considered holidays.
Step By Step Guide of NETWORKDAYS Function
In this example, we are just calculating NETWORKDAYS without the third parameter to eliminate only weekends (by default Saturday and Sunday), and we are giving the two dates as holidays in the fourth case to make this function work.
These two holidays, as well as the weekend in between, will be excluded. If you wish to make a weekend out of any other days, you could use the NETWORKDAYS.INTL is an international function.
Key Points
- NETWORKDAYS returns the #VALUE! error value if any of the arguments is not a valid date.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
Share this Content
Excel Functions
Excel Formulas
Excel Shortcuts
Excel Data Analytics
- AND
- FALSE
- IF
- IFEROR
- IFNA
Excel Resources
- AND
- FALSE
- IF
- IFEROR
- IFNA