Date & Timebeginner
NETWORKDAYS for project timeline planning
=NETWORKDAYS(B2,C2)
Function reference
NETWORKDAYS in Excel & Google Sheets
NETWORKDAYS is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.
1 beginnerBuild a custom NETWORKDAYS formula →
When to use NETWORKDAYS
- Estimate project duration, delivery lead time, or turnaround windows in business days instead of calendar days.
Worked examples (1)
Common errors with NETWORKDAYS
Result seems too high
Check that the cells are real dates, not text strings that only look like dates.
Frequently asked questions
Can NETWORKDAYS exclude holidays too?
Yes. Add a third argument with a holiday range and Excel will exclude those dates from the count.
Need a custom variation?
Describe your specific NETWORKDAYS problem and get a formula written for your exact data.
Open generator with NETWORKDAYS