NETWORKDAYS Function in Excel
Intermediate
Returns the number of whole working days between start_date and end_date.
Syntax
=NETWORKDAYS(start_date, end_date, [holidays])Example
Use Case
Calculate working days to complete a project.
Common Errors to Avoid
- Assumes Saturday and Sunday as weekends (use NETWORKDAYS.INTL for custom weekends)
- Holidays list must be valid dates or a range reference
- Includes both start and end dates in count
Pro Tips
Create a separate range for company holidays and reference it. For custom weekends (e.g., Friday-Saturday), use NETWORKDAYS.INTL. Always verify the result includes the correct start/end date behavior.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →