# Google Sheets WEEKDAY Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/weekday-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 WEEKDAY function returns the day of the week as a number (1-7) for a given date, helping to identify specific weekdays. ``` WEEKDAY(date, [type]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the WEEKDAY you need in plain EnglishGenerate Formula ## Parameters **`date`**:\ The date for which you want to determine the day of the week. This can be a date value, a cell reference containing a date, or a formula that returns a date. **`type`**:\ An optional parameter that specifies the type of return value. It determines how the days of the week are numbered. If omitted, the default is 1, where Sunday is 1 and Saturday is 7. Other options include 2 (Monday is 1, Sunday is 7) and 3 (Monday is 0, Sunday is 6). ## What is a WEEKDAY Function? The *WEEKDAY* function in Google Sheets is a useful tool that returns the day of the week corresponding to a date. It can be particularly helpful for scheduling, planning, and analyzing data based on days of the week. The function can return a number representing the day, which can be customized to start the week on different days. In simpler terms, WEEKDAY allows you to determine which day of the week a specific date falls on, making it easier to organize and interpret your data. ## A Practical Example Imagine you are tracking project deadlines and want to know which day of the week each deadline falls on: ### Deadlines Table: | TaskID | TaskName | Deadline | | - | - | - | | 1 | Project A | 2023-10-02 | | 2 | Project B | 2023-10-05 | | 3 | Project C | 2023-10-07 | You want to find out the day of the week for each deadline. ## WEEKDAY Formula To achieve this, you would use the WEEKDAY function as follows: ``` =WEEKDAY(C2, 1) ``` In this formula: - `C2` is the cell containing the Deadline date. - The second argument `1` specifies that the week starts on Sunday (1 = Sunday, 2 = Monday, ..., 7 = Saturday). ## Result of the Formula When you apply the WEEKDAY formula to the Deadlines Table, the output would look like this: | TaskID | TaskName | Deadline | Day of Week | | - | - | - | - | | 1 | Project A | 2023-10-02 | 2 | | 2 | Project B | 2023-10-05 | 5 | | 3 | Project C | 2023-10-07 | 7 | In this case, the WEEKDAY function returns: - 2 for Monday (October 2, 2023) - 5 for Thursday (October 5, 2023) - 7 for Saturday (October 7, 2023) ## Why Use WEEKDAY? WEEKDAY is beneficial because it allows you to easily categorize and analyze data based on the day of the week. This can be particularly useful for scheduling tasks, tracking attendance, or analyzing trends in data over specific days. By understanding which days correspond to specific dates, you can make more informed decisions and improve your planning processes. ## Key Takeaways: - **WEEKDAY**: A Google Sheets function that returns the day of the week for a given date. - **Customizable**: You can specify which day to start the week, making it adaptable to your needs. - **Data Analysis**: Helps in organizing and interpreting data based on days of the week. - **Common Use Cases**: Ideal for project management, attendance tracking, and any scenario where day-based analysis is necessary. WEEKDAY is an essential function for anyone working with dates in Google Sheets, providing a straightforward way to enhance data organization and analysis. Happy spreadsheeting! ## Example use case You have a table with dates in Column A and want to determine the day of the week for each date. By using the WEEKDAY formula, you can quickly identify if a date falls on a weekend or a weekday, aiding in scheduling and planning tasks efficiently. ## 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 Lock A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-a-row-in-google-sheets) - [How To Lock Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-cells-in-google-sheets) - [How To Make A Copy Of An Google Sheets Sheet](https://betteranalyst.com/google-sheets/how-to-make-a-copy-of-an-google-sheets-sheet) - [How To Make A Graph In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-graph-in-google-sheets) - [How To Make A Histogram In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-histogram-in-google-sheets) - [How To Make A Line Graph In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-line-graph-in-google-sheets) - [How To Make A Pie Chart In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-pie-chart-in-google-sheets) - [How To Make A Table In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-table-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.