# Google Sheets WORKDAY Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/workday-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 function calculates a date that is a specified number of working days from a start date, excluding weekends and holidays. ``` WORKDAY(start_date, num_days, [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 you need in plain EnglishGenerate Formula ## Parameters **`start_date`**:\ The date from which to start counting the workdays. This can be a date value, a cell reference containing a date, or a formula that returns a date. **`num_days`**:\ The number of workdays to add to the `start_date`. This must be a positive or negative integer that indicates how many workdays to move forward or backward. **`holidays`**:\ An optional range of one or more dates to exclude from the workdays calculation. This can be a single date, a range of dates, or an array of dates that represent holidays. ## What is a WORKDAY? The *WORKDAY* function in Google Sheets is a useful tool for calculating a date that is a specified number of working days from a start date. This function is particularly valuable for project management, scheduling, and planning, as it allows users to account for weekends and holidays when determining deadlines or timelines. In simpler terms, WORKDAY helps you find a future date by skipping over non-working days, ensuring that you only consider business days in your calculations. ## A Practical Example Imagine you are managing a project with a deadline that is based on working days: ### Project Timeline: | Task | Start Date | Duration (Days) | | - | - | - | | Task A | 2023-10-01 | 5 | | Task B | 2023-10-08 | 3 | You want to determine the end date for each task, considering only working days. ## WORKDAY Formula To achieve this, you would use the WORKDAY function as follows: ``` =WORKDAY(B2, C2) ``` In this formula: - `B2` is the cell containing the Start Date for the task. - `C2` is the cell containing the Duration in working days. ## Result of the Formula When you apply the WORKDAY formula to the Project Timeline, the output would look like this: | Task | Start Date | Duration (Days) | End Date | | - | - | - | - | | Task A | 2023-10-01 | 5 | 2023-10-08 | | Task B | 2023-10-08 | 3 | 2023-10-11 | In this case, Task A starts on October 1st and ends on October 8th, while Task B starts on October 8th and ends on October 11th. ## Why Use WORKDAY? WORKDAY is beneficial because it simplifies the process of calculating deadlines and timelines in project management. It automatically excludes weekends and can also be customized to exclude specific holidays, making it a powerful tool for accurate scheduling. ## Key Takeaways: - **WORKDAY**: A function that calculates a future date based on a specified number of working days from a start date. - **Excludes Non-Working Days**: Automatically skips weekends and can be adjusted for holidays. - **Common Use Cases**: Ideal for project management, scheduling, and any scenario where working days need to be considered. WORKDAY is an essential function for anyone involved in project planning and management, providing a straightforward way to enhance scheduling accuracy. Happy planning! ## Example use case You have a project timeline in Column A with start dates. Use the WORKDAY formula in Column B to calculate the end date for each task, excluding weekends and holidays. This helps ensure accurate scheduling and resource allocation for project completion. ## 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 Make A Table In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-table-in-google-sheets) - [How To Merge Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-merge-cells-in-google-sheets) - [How To Multiply In Google Sheets](https://betteranalyst.com/google-sheets/how-to-multiply-in-google-sheets) - [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) ## 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.