NETWORKDAYS
The NETWORKDAYS function calculates the number of working days between two dates, excluding weekends and optional holidays. It is useful for scheduling and project management tasks.

Example explanation
The NETWORKDAYS function is used in column D to calculate the number of working days between two given dates, excluding weekends.
Syntax 🔗
=NETWORKDAYS(Start_Date
, End_Date
, [Holidays]
)
Start_Date | The start date from which to calculate working days. |
End_Date | The end date until which to calculate working days. |
Holidays (Optional) | An optional range or array containing dates to exclude as holidays. |
About NETWORKDAYS 🔗
Use the NETWORKDAYS function in Excel to calculate the number of working days between two dates. This function helps you exclude weekends and predefined holidays from your calculation, making it useful for planning schedules and managing projects. Specify holidays to be excluded for more accurate results, accommodating different regional or organizational schedules. NETWORKDAYS assists you in effectively coordinating project timelines or estimating delivery dates.
Examples 🔗
Suppose a project starts on August 1, 2022, and ends on August 31, 2022. You want to calculate the number of working days between these dates excluding weekends. The NETWORKDAYS formula would be: =NETWORKDAYS("8/1/2022", "8/31/2022")
If you want to exclude specific holidays, let's say September 5, 2022, and October 10, 2022, from the calculation, you can modify the formula as follows: =NETWORKDAYS("8/1/2022", "8/31/2022", {"9/5/2022", "10/10/2022"})
In the case where your organization has a list of holidays stored in cells A1:A5, you can refer to this range by inputting it as the Holidays
argument: =NETWORKDAYS("8/1/2022", "8/31/2022", A1:A5)
Notes 🔗
Enter dates in a valid Excel date format or use references to cells with valid date values. Weekend days (Saturday and Sunday) are excluded from the calculation. Adjust the function parameters based on your project's or scheduling task's requirements.
Questions 🔗
No, the NETWORKDAYS function specifically calculates the number of working days between two dates, excluding weekends and optional holidays. To calculate the duration in hours or minutes, you would need to use other functions or formulas in Excel.
How does the NETWORKDAYS function handle weekends in different regions or countries?The NETWORKDAYS function automatically considers Saturday and Sunday as weekends, which aligns with the typical workweek structure in many countries. However, the function does not account for custom weekend definitions specific to certain regions or organizations.
Is it possible to use the NETWORKDAYS function to exclude custom-defined non-working days other than weekends and holidays?The NETWORKDAYS function does not provide direct support for excluding custom-defined non-working days beyond weekends and specified holidays. If you need to account for additional non-working days, you may need to explore more advanced solutions involving custom formulas or VBA programming.
Related functions 🔗
NETWORKDAYS.INTL
WORKDAY
WORKDAY.INTL
ISOWEEKNUM
WORKDAY
WORKDAY.INTL