=NETWORKDAYS(start_date, end_date, [holidays])One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single NETWORKDAYS formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
start_date:
The date that marks the beginning of the period for which you want to calculate the number of working days. This can be a date value, a cell reference containing a date, or a formula that returns a date.
end_date:
The date that marks the end of the period for which you want to calculate the number of working days. This can also be a date value, a cell reference containing a date, or a formula that returns a date.
[holidays]:
An optional range of one or more dates that should be excluded from the working days calculation. This can be a range of cells containing holiday dates or an array of dates. If omitted, no holidays are considered.
The NETWORKDAYS function in Excel is a useful tool that calculates the number of working days between two dates, excluding weekends and any specified holidays. This function is particularly beneficial for project management, scheduling, and time tracking, as it helps you determine the actual number of days available for work.
In simpler terms, the NETWORKDAYS function helps you find out how many weekdays are available between two dates, making it easier to plan and manage timelines.
Imagine you are managing a project and need to determine how many working days are available between the start and end dates of the project, considering any holidays. Here’s an example of the data you might have in an Excel spreadsheet:
| Start Date | End Date | Holidays |
|---|---|---|
| 01/01/2023 | 01/15/2023 | 01/02/2023 |
| 01/16/2023 | 01/31/2023 | 01/20/2023 |
You want to find the total number of working days for the first project timeline.
To calculate the total working days for the first project timeline, you would use the NETWORKDAYS formula as follows:
=NETWORKDAYS(A2, B2, C2)When you apply the formula, it calculates the number of working days between January 1, 2023, and January 15, 2023, excluding January 2, 2023 (the holiday). The output would be:
| Total Working Days |
|---|
| 10 |
Here, the total working days are calculated as 10, considering that weekends and the specified holiday are excluded.
The NETWORKDAYS function is particularly useful when you need to calculate the number of working days for project timelines, deadlines, or any scenario where understanding the available workdays is essential. It allows you to quickly assess timeframes without manually counting days.
Understanding how to use the NETWORKDAYS function can significantly enhance your project planning capabilities in Excel, enabling you to manage timelines effectively.
Happy calculating!
You have a project timeline where Column A contains the start dates of various tasks and Column B contains the end dates. You can use the NETWORKDAYS function to calculate the number of working days required to complete each task, excluding weekends and specified holidays. This helps in effective project management by providing a clear understanding of task durations and resource allocation, ensuring that deadlines are met without the need for complex date calculations.
Beyond the NETWORKDAYS function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.