# Google Sheets WORKDAY.INTL Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/workday.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 WORKDAY.INTL function calculates a date that is a specified number of workdays from a start date, considering custom weekends. ``` WORKDAY.INTL(start_date, num_days, [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 WORKDAY.INTL you need in plain EnglishGenerate Formula ## Parameters **`start_date`**:\ The date from which to start counting the number of working days. This should be a valid date value. **`num_days`**:\ The number of working days to add to the `start_date`. This can be a positive or negative integer. **`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 of one or more dates that should be considered as non-working days in addition to weekends. This can be a single date, an array of dates, or a range of cells containing dates. ## What is WORKDAY.INTL? The *WORKDAY.INTL* function in Google Sheets is a specialized tool used to calculate a date that is a specified number of working days from a start date, while also allowing for customization of which days are considered weekends. This function is particularly useful for project management, scheduling, and any scenario where you need to account for non-working days in your calculations. In simpler terms, WORKDAY.INTL helps you find future dates while skipping weekends and holidays based on your specific requirements. ## A Practical Example Imagine you are managing a project timeline and need to determine the end date based on the number of working days allocated for each task: ### Project Timeline Table: | TaskID | TaskName | StartDate | WorkingDays | | - | - | - | - | | 1 | Task A | 2023-10-01 | 5 | | 2 | Task B | 2023-10-01 | 10 | You want to calculate the end date for each task, considering that your weekends are Saturday and Sunday. ## WORKDAY.INTL Formula To achieve this, you would use the WORKDAY.INTL function as follows: ``` =WORKDAY.INTL(C2, D2, "0000011") ``` In this formula: - `C2` is the cell containing the StartDate from the Project Timeline Table. - `D2` is the cell containing the number of WorkingDays for the task. - `"0000011"` is the weekend parameter, where "0" indicates a working day and "1" indicates a weekend day (in this case, Saturday and Sunday). ## Result of the Formula When you apply the WORKDAY.INTL formula to the Project Timeline Table, the output would look like this: | TaskID | TaskName | StartDate | WorkingDays | EndDate | | - | - | - | - | - | | 1 | Task A | 2023-10-01 | 5 | 2023-10-06 | | 2 | Task B | 2023-10-01 | 10 | 2023-10-13 | In this case, Task A starts on October 1, 2023, and ends on October 6, 2023, while Task B ends on October 13, 2023, after accounting for the weekends. ## Why Use WORKDAY.INTL? WORKDAY.INTL is beneficial because it provides flexibility in defining weekends, making it suitable for various business calendars. It simplifies the process of calculating future dates while considering non-working days, which is essential for accurate project planning and scheduling. ## Key Takeaways: - **WORKDAY.INTL**: A Google Sheets function that calculates a date a specified number of working days from a start date, with customizable weekends. - **Flexibility**: Allows you to define which days are considered weekends, accommodating different business needs. - **Project Management**: Ideal for scheduling tasks, project timelines, and any scenario where working days need to be calculated. - **Error Handling**: Automatically adjusts for weekends, ensuring accurate date calculations. WORKDAY.INTL is an essential function for anyone involved in project management or scheduling, providing a powerful way to enhance planning and efficiency. Happy spreadsheeting! ## Example use case You have a project timeline in Column A with start dates. Using WORKDAY.INTL, you can calculate the end date in Column B, excluding weekends and holidays. This helps in planning project deadlines accurately while considering non-working days. ## 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 Unhide Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-unhide-all-rows-in-google-sheets) - [How To Unprotect Google Sheets](https://betteranalyst.com/google-sheets/how-to-unprotect-google-sheets) - [How To Wrap Text In Google Sheets](https://betteranalyst.com/google-sheets/how-to-wrap-text-in-google-sheets) - [Google Sheets Conditional Formatting](https://betteranalyst.com/google-sheets/google-sheets-conditional-formatting) - [How To Add A Column In Google Sheets](https://betteranalyst.com/google-sheets/how-to-add-a-column-in-google-sheets) - [How To Alphabetize In Google Sheets](https://betteranalyst.com/google-sheets/how-to-alphabetize-in-google-sheets) - [How To Autofit In Google Sheets](https://betteranalyst.com/google-sheets/how-to-autofit-in-google-sheets) - [How To Calculate Percentage In Google Sheets](https://betteranalyst.com/google-sheets/how-to-calculate-percentage-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.