| Function Category | Date and Time |
| Volatility | Non-volatile |
| Related Functions | WORKDAY — returns the end date after a specified number of working days DATEDIF — returns the difference between dates in days, months, or years |
What Does the NETWORKDAYS Function Do
The NETWORKDAYS function calculates the number of working days between two dates. It automatically excludes weekends (Saturday and Sunday), and can also account for holidays if they are specified separately.
Function Syntax
=NETWORKDAYS(start_date, end_date[, holidays])Where:
- start_date — the start date of the period
- end_date — the end date of the period
- holidays — optional range containing holidays that should also be excluded
Example 1: Working Days Between Two Dates
=NETWORKDAYS(A1, B1)Returns the number of working days between dates in cells A1 and B1, excluding only Saturdays and Sundays.
Example 2: Including Holidays
=NETWORKDAYS(A1, B1, D1:D5)In addition to weekends, holidays specified in the range D1:D5 are also excluded from the calculation.
Features
- If the start date is greater than the end date, the result will be negative.
- The function is useful in project management, deadline calculations, and vacation planning.
- Holidays must be specified as a list of dates – this can be a separate column on the sheet.
Other Date and Time Functions
TIMEVALUE, TIME, YEAR, DATE, DATEVALUE, EDATE, DAY, WEEKDAY, YEARFRAC, EOMONTH, MONTH, MINUTE, WEEKNUM, WORKDAY, DATEDIF, TODAY, SECOND, NOW
Like the article? Help its author! Buy !SEMTools, it has lots of useful instruments to process text data.
This post is also available in RU.