NETWORKDAYS in Excel: Calculate Work Days & Holidays
Returns the number of whole working days between start_date and end_date.
How to Calculate Working Days with NETWORKDAYS
The NETWORKDAYS function calculates full working days between two dates, automatically excluding Saturdays, Sundays, and optional holidays.
Syntax
=NETWORKDAYS(start_date, end_date, [holidays])
Example
=NETWORKDAYS(A2, B2, $H$2:$H$10) returns net working business days for accurate payroll and SLA tracking.
Frequently Asked Questions
Does NETWORKDAYS include weekends?
No, NETWORKDAYS automatically excludes Saturdays and Sundays. Only weekdays (Monday-Friday) are counted as working days.
How do I add holidays to NETWORKDAYS?
Add a range of holiday dates as the third argument. For example: =NETWORKDAYS(A1, B1, H1:H10) where H1:H10 contains your holiday dates.
Related Formulas
Explore related formula generators to solve similar problems
🛠️ Related Tools
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More