NETWORKDAYS Formula — Count Working Days in Excel & Sheets (Free Tool)

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

Explore related formula generators to solve similar problems

DATEDIFNOWTODAYYEARMONTH

🛠️ Related Tools

Formula Comparator

Compare Excel formulas side by side

Remove Duplicates

Clean duplicate values from your data

GPA Calculator

Weighted & unweighted grade point average

SUMIFS Across Sheets

Sum across multiple Excel sheets

Want to become an Excel Pro?

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

Learn More