I. About the function
The NETWORKDAYS function calculates the number of working days between two dates, excluding weekends and specified holidays.
Arguments
NETWORKDAYS(start date, end date, [holidays])
- Start date (required): The starting date to be used in the calculation.
- End date (required): The ending date to be used in the calculation.
- Holidays (optional): Weekends are included by default. You can specify a date range to be considered holidays (non-working days).
Note: When you specify a date range for holidays, weekends will still be considered holidays (this setting cannot be changed).
II. Use case
Calculate the number of working days for projects
When working on multiple projects, you can calculate the actual number of working days available for each project in a single base.
- Create two tables, one for calculating the number of working days for projects and another for holidays of the year.
- In the 2022 Holidays table, enter the holidays of the year.
250px|700px|reset
- In the NETWORKDAYS Function table, fill in the start date of each project
250px|700px|reset
- In the NETWORKDAYS Function table, create a new formula field, and use the following formula: NETWORKDAYS(Start Date,End Date,[2022 Holidays].[Holiday Dates])
250px|700px|reset
III. FAQs