[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Syntax<\/h2>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.16″ border_width_left=”4px” global_colors_info=”{}” theme_builder_area=”post_content”]=WEEKDAY(date, [type])[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
- \n
- date<\/strong> – is the input
date<\/g> that the function takes into determining the day of the week. This can be a reference to a cell that holds a date value, or a formula that returns a date or even a number that the Google Sheets can evaluate to a date.<\/li>\n - type<\/strong> – this is an optional indicator that lets the function know where to begin the week from. Valid values that we can key in for this parameter are 1, 2 and 3.\n
- \n
- 1 is the value by default. In this case, the week starts on Sunday and ends on Saturday. Therefore,
value<\/g> for Sunday is 1 and Saturday is 7.<\/li>\n - If we keyed in 2 for this parameter, the week begins on Monday and ends on Sunday. Hence,
value<\/g> for Monday is 1 and Sunday is\u00a07.<\/li>\n - Similarly, if this parameter is 3, the week begins on Monday and ends on Sunday. But the difference here is that the value for Monday is 0 and Sunday is 6.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
How to use WEEKDAY function<\/h2>\n
I\u2019ll dive into a few examples to provide a better understanding of the function\u2019s working behaviour. Please consider the snapshot below.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/12\/Weekday-image-1-1.png” alt=”weekday-function-google-sheets-1″ title_text=”weekday-function-google-sheets-1″ align=”center” _builder_version=”4.23.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
You will notice I have illustrated all types of WEEKDAY function types (as shown in column A). For the purpose of clarity, I indicated against each function type, the starting day, ending day and their corresponding WEEKDAY values in columns B and C.<\/p>\n
As per the given input type, and the day the input date evaluates to, the function accordingly returns the output (column D). The first three example cases are of type 1 and returned the values 7,4 and 6, which correspond to Saturday, Wednesday, and Friday respectively. The next three cases are of type 2 and returned 6, 3 and 5 for the same dates used in the first three cases. Similarly, the final three cases returned are of type 3. Therefore the results are 5, 2 and 4.<\/p>\n
WEEKDAY out of range<\/h3>\n
What if you enter a different type other than that mentioned above? You can be sure to see an error, of course! I\u2019ll try that here.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/12\/Weekday-image-2-1.png” alt=”weekday-function-google-sheets-2″ title_text=”weekday-function-google-sheets-2″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
You can further extend the use of the WEEKDAY function by using the value it returns as the input to another function. For instance, here\u2019s an example of an employee who needs to wear a different colored uniform each day according to the data shown below.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/12\/Weekday-image-3-1.png” alt=”weekday-function-google-sheets-3″ title_text=”weekday-function-google-sheets-3″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
WEEKDAY and VLOOKUP<\/h3>\n
The WEEKDAY function is used to determine the day of the week for a date, and then the VLOOKUP function is used to match the weekday with the corresponding uniform color. This is achieved with the formula =Vlookup(Weekday(Today(),2),A2:C8,3,False)<\/strong>.<\/p>\n
WEEKDAY and CHOOSE<\/h3>\n
What if you want to generate the day of the week for a list of dates? There is a simple way to do that using the WEEKDAY function in combination with the CHOOSE function. In the example below, this is done by typing =Choose(Weekday(A6,1),”Sunday”,”Monday”,”Tuesday”,”Wednesday”,”Thursday”,”Friday”,”Saturday”)<\/strong>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/12\/Weekday-image-4-1.png” alt=”weekday-function-google-sheets-4″ title_text=”weekday-function-google-sheets-4″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Here, the WEEKDAY function is the input to the CHOOSE function, which takes the number generated by the WEEKDAY function and uses it to select the appropriate weekday choice.<\/p>\n
Make sure to get yourself known with the TODAY function as well in the following blog posts: How to use the TODAY function in Google Sheets <\/a>and How to use the WEEKNUM formula in Google Sheets.<\/a><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.22.2″ background_color=”#f9f9ff” custom_margin=”40px||40px||false|false” custom_padding=”15px|25px|15px|25px|true|true” border_width_left=”3px” border_color_left=”#808e95″ saved_tabs=”all” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n
[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
There will be instances where we may need to know the day of the week, for a given date. In Google Sheets, the WEEKDAY function can help us with this.Syntax=WEEKDAY(date, [type]) date – is the input date that the function takes into determining the day of the week. This can be a reference to a […]<\/p>\n","protected":false},"author":40,"featured_media":29528,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"There will be instances where we may need to know the day of the week, for a given date. In Google Sheets, the WEEKDAY<\/a> formula can help us with this.\n
Syntax<\/h3>\nWEEKDAY(date, [type])<\/strong><\/span>\n
- \n \t
- date<\/strong><\/span> - is the input date that the formula takes into determining the day of the week. This can be a reference to a cell that holds a date value, or a formula that returns a date or even a number that the Google Sheets can evaluate to a date.<\/li>\n \t
- type<\/strong><\/span> - this is an optional indicator that lets the formula know where to begin the week from. Valid values that we can key in for this parameter are 1, 2 and 3.\n
- \n \t
- 1 is the value by default. In this case, the week starts on Sunday and ends on Saturday. Therefore, value for Sunday is 1 and Saturday is 7.<\/li>\n \t
- If we keyed in 2 for this parameter, the week begins on Monday and ends on Sunday. Hence, value for Monday is 1 and Sunday is\u00a07.<\/li>\n \t
- Similarly, if this parameter is 3, the week begins on Monday and ends on Sunday. But the difference here is that the value for Monday is 0 and Sunday is 6.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
Usage: WEEKDAY Formula<\/h3>\nLet us dive into a few examples to get a better understanding of the formula's working behavior. Please consider the snapshot below.\n\n
![\"WEEKDAY](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/frame-generic-18.png\")
\n\nYou will notice we have illustrated all types of WEEKDAY formula types (as shown in column A). For the purposes of elucidation, we indicated against each formula type, the starting day, ending day and their corresponding WEEKDAY values in columns B and C.\n\nAs per the given input type, and the day the input date evaluates to, the formula accordingly returns the output (column D). The first three example cases are of type 1 and returned the values 7,4 and 6, which correspond to Saturday, Wednesday, and Friday respectively. The next three cases are of type 2 and returned 6, 3 and 5 for the same dates we used in the first three cases. Similarly, the final three cases returned are of type 3. Therefore the results are 5, 2 and 4 respectively.\n\nWhat if we enter a different type other than that mentioned above? We can be sure to see an error, of course! Let's try that, here.\n\n![\"WEEKDAY](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/frame-generic-19.png\")
\n\nWe can further extend the use of the WEEKDAY formula by using the value it returns as parameter inputs in other formulas. For example, here's a use case, where an employee should wear a different colored uniform according to the tabular data shown below.\n\n![\"WEEKDAY](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/frame-generic-20.png\")
\n\nSo, based on the weekday value, we got to know the uniform color by making use of the VLOOKUP formula.\n\n ","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[55,39,28],"class_list":["post-4145","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-ben-collins","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/4145","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=4145"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/4145\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/29528"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=4145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=4145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=4145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- type<\/strong><\/span> - this is an optional indicator that lets the formula know where to begin the week from. Valid values that we can key in for this parameter are 1, 2 and 3.\n
- If we keyed in 2 for this parameter, the week begins on Monday and ends on Sunday. Hence,
- type<\/strong> – this is an optional indicator that lets the function know where to begin the week from. Valid values that we can key in for this parameter are 1, 2 and 3.\n