Business Days (NETWORKDAYS) Formula Generator
NETWORKDAYS calculates the number of working days between two dates, automatically excluding weekends. You can also exclude holidays.
Syntax
=NETWORKDAYS(start_date, end_date, [holidays])Try it — generate a NETWORKDAYS formula
Examples
Working days in a project
=NETWORKDAYS(A2, B2)Counts business days between start date (A2) and end date (B2), excluding weekends.
Days excluding holidays
=NETWORKDAYS(A2, B2, D2:D10)Same as above but also excludes dates listed in D2:D10 as holidays.
Tips
- ✓NETWORKDAYS excludes Saturday and Sunday by default.
- ✓Use NETWORKDAYS.INTL to specify custom weekend days (e.g., Friday-Saturday).
- ✓Create a holiday list on a separate sheet and reference it for company-wide use.
Related Formulas
SUMIFS
SUMIFS adds up values that meet multiple criteria. It's essential for financial ...
Nested IF
Nested IF formulas let you test multiple conditions and return different values ...
FILTER
FILTER returns rows from a range that meet specified conditions. It's like AutoF...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free