# Google Sheets NETWORKDAYS.INTL Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/networkdays.intl-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The NETWORKDAYS.INTL function calculates the number of working days between two dates, excluding weekends and specified holidays. ``` NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the NETWORKDAYS.INTL you need in plain EnglishGenerate Formula ## Parameters **`start_date`**:\ The starting date from which to begin counting the number of working days. **`end_date`**:\ The ending date up to which to count the number of working days. **`weekend`**:\ (Optional) A string or number that specifies which days of the week are considered weekends. If omitted, the default is Saturday and Sunday. **`holidays`**:\ (Optional) A range or array of dates that should be considered as non-working days in addition to weekends. ## What is NETWORKDAYS.INTL? The *NETWORKDAYS.INTL* function in Google Sheets is a useful tool for calculating the number of working days between two dates, while allowing for the specification of weekends and holidays. This function is particularly beneficial for project management, payroll calculations, and any scenario where understanding the number of business days is essential. In simpler terms, NETWORKDAYS.INTL helps you determine how many weekdays fall between two dates, taking into account custom weekends and holidays. ## A Practical Example Imagine you are managing a project timeline and need to calculate the number of working days between the project start and end dates: ### Project Timeline: | Task | Start Date | End Date | | - | - | - | | Task A | 2023-10-01 | 2023-10-10 | | Task B | 2023-10-05 | 2023-10-15 | You want to find out how many working days are available for each task, considering that your weekends are Saturday and Sunday. ## NETWORKDAYS.INTL Formula To achieve this, you would use the NETWORKDAYS.INTL function as follows: ``` =NETWORKDAYS.INTL(B2, C2, 1) ``` In this formula: - `B2` is the cell containing the Start Date of the task. - `C2` is the cell containing the End Date of the task. - `1` indicates that Saturday and Sunday are considered weekends. ## Result of the Formula When you apply the NETWORKDAYS.INTL formula to the Project Timeline, the output would look like this: | Task | Start Date | End Date | Working Days | | - | - | - | - | | Task A | 2023-10-01 | 2023-10-10 | 7 | | Task B | 2023-10-05 | 2023-10-15 | 8 | In this case, Task A has 7 working days available, while Task B has 8 working days. ## Why Use NETWORKDAYS.INTL? NETWORKDAYS.INTL is beneficial because it provides flexibility in defining weekends and allows for the inclusion of holidays. This makes it a powerful tool for accurately calculating working days in various business contexts. Additionally, it simplifies the process of managing project timelines and resource allocation. ## Key Takeaways: - **NETWORKDAYS.INTL**: A Google Sheets function that calculates the number of working days between two dates, considering custom weekends and holidays. - **Flexibility**: Allows users to define which days are considered weekends, making it suitable for different work schedules. - **Holiday Consideration**: You can also include a list of holidays to exclude from the working day count, enhancing accuracy. - **Common Use Cases**: Ideal for project management, payroll calculations, and any scenario where tracking business days is necessary. NETWORKDAYS.INTL is an essential function for anyone managing timelines and schedules in Google Sheets, providing a reliable way to enhance project planning and execution. Happy spreadsheeting! ## Example use case You have a project timeline in a Google Sheet with start and end dates. Use NETWORKDAYS.INTL to calculate the number of working days between these dates, excluding weekends and holidays. This helps in accurate project planning and resource allocation. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Password Protect An Google Sheets File](https://betteranalyst.com/google-sheets/how-to-password-protect-an-google-sheets-file) - [How To Remove Blank Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-remove-blank-rows-in-google-sheets) - [How To Remove Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-remove-duplicates-in-google-sheets) - [How To Separate Names In Google Sheets](https://betteranalyst.com/google-sheets/how-to-separate-names-in-google-sheets) - [How To Sort In Google Sheets](https://betteranalyst.com/google-sheets/how-to-sort-in-google-sheets) - [How To Split Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-split-cells-in-google-sheets) - [How To Strikethrough In Google Sheets](https://betteranalyst.com/google-sheets/how-to-strikethrough-in-google-sheets) - [How To Subtract In Google Sheets](https://betteranalyst.com/google-sheets/how-to-subtract-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.