NETWORKDAYS Formula Generator (2026) — Count Working Days | Free Excel & Sheets

Returns the number of whole working days between start_date and end_date.

Generated Formula
=NETWORKDAYS(start_date, end_date)

Learning Resources

Want to master Excel? Check out this Top-Rated Course.

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

DATEDIFNOWTODAYYEARMONTH

Want to become an Excel Pro?

Stop searching for formulas. Master Excel in 30 days with this top-rated course.

Learn More