Syntax<\/h3>\n
WEEKNUM(date, [type])<\/strong><\/span><\/p>\n Now that we have seen what each system signifies, let’s take a look at what each WEEKNUM formula type stands for. Look at the table below. It shows the week\u2019s start day and end day for each type.<\/p>\n [\/et_pb_text][et_pb_text admin_label=”Connections T – Automate between spreadsheets – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” saved_tabs=”all” global_colors_info=”{}” global_module=”50460″ theme_builder_area=”post_content”] Automate data transfers between spreadsheets Find out how<\/a>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/WEEKNUM-formula-1.png” alt=”WEEKNUM formula 1″ title_text=”WEEKNUM formula 1″ _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 To see the formula in action, take a look at the screenshot below. We have listed a series of dates in column A. The subsequent columns contain the WEEKNUM formulas applied for each available type.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/frame-generic-1.png” alt=”WEEKNUM Formula: Usage” title_text=”weeknum-formula-usage” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text admin_label=”Connections T – Automate beyond importrange – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” saved_tabs=”all” global_colors_info=”{}” global_module=”50462″ theme_builder_area=”post_content”] Automate data transfers beyond Importrange<\/span><\/p>\n Find out how<\/a>[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Let’s pick type 11 and understand how the formula works. Since this type uses System 1 to calculate week numbers, it considers the week with January 1 as week 1. And, according to the previous table, the week starts on Monday and ends on Sunday for this type. Therefore, week 1 spans from January 1, Friday to January 3, Sunday. Week 2 starts from January 4, as it is Monday, and ends on January 10, Sunday.<\/p>\n Now, let’s look at type 21. This uses System 2<\/strong>, which assumes that the week with the first Thursday of the year<\/strong>\u00a0is week 1. Taking a quick glance at the data, we know that the first Thursday of the year falls on January 8. And, looking at the table in the first screenshot, the week starts on Monday and ends on Sunday for this type as well. So, week 1 starts on Monday January 4 and ends on Sunday January 10. What about the initial three days that are not part of week 1? The WEEKNUM formula assigns them the last week number of the previous year, which is 53 in this case.<\/p>\n Do you need to check what day of the week it was on a given date? In this case, use the WEEKDAY formula in Google Sheets. Read\u00a0<\/span>this blog post<\/a>\u00a0<\/span>to learn how to use it.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" In Google Sheets, if you need to know what specific week of the year a date falls on, you can use the\u00a0WEEKNUM\u00a0formula to find out. The week numbers will range from 1 to 53. Syntax WEEKNUM(date, [type]) date\u00a0\u2013 is the input date that the formula uses to determine the week of the year. This can […]<\/p>\n","protected":false},"author":40,"featured_media":4386,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"In Google Sheets, if we need to know what specific week a date falls on, we can make use of the WEEKNUM<\/a> formula to find that out. The week numbers will range from 1 to 53.\n\n
\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/run-automatically-connect-sheet-icons.webp\"){kind=icon}
<\/p>\n![\"39\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\"){kind=icon}
<\/p>\n
\n<\/span><\/p>\nHow to use the WEEKNUM Formula<\/h3>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Add-on-sm_sheets-connected-new-connection.webp\")
<\/p>\n<\/p>\nSyntax<\/h3>\nWEEKNUM(date, [type])<\/strong><\/span>\n
\n \t
\n \t
![\"WEEKNUM](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/frame-generic.png\")
\nUsage: WEEKNUM Formula<\/h3>\nLet us dive into the practical application of the formula so that we get a clearer picture of its working. Please see the snapshot below. We have listed a series of dates column A. And, the subsequent columns contain the WEEKNUM formulas applied for each available type of those dates.\n\n
![\"WEEKNUM](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/frame-generic-1.png\")
\n\nLet us pick the type 11 and understand how the formula works. Since this type uses System 1 to calculate week numbers, it considers the week with January 1 as week # 1. And, according to the previous table, the week starts on Monday and ends on Sunday for this type. Therefore, week # 1 spans from January 1, Friday to January 3, Sunday. Week # 2 starts from January 4, as it is Monday, and ends on January 10, Sunday.\n\nNow, we will try and understand the case of type 21. This uses System 2, that assumes a week with year's first Thursday as week # 1. Taking a quick glance at the data, we know that the first Thursday of the year falls on January 8. And, going by the first snapshot, the week starts on Monday and ends on Sunday for this type as well. So, the week # 1 starts from January 4, Monday and ends on January 10, Sunday. What about the initial 3 days that are not part of week # 1? The WEEKNUM formula assigns it the previous year's last week number, which is 53 in this case.\n\n ","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-4168","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/4168","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=4168"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/4168\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/4386"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=4168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=4168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=4168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}