{"id":1435,"date":"2018-07-04T14:56:06","date_gmt":"2018-07-04T14:56:06","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1435"},"modified":"2023-11-03T14:58:53","modified_gmt":"2023-11-03T14:58:53","slug":"weekday","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/weekday\/","title":{"rendered":"WEEKDAY function"},"content":{"rendered":"\n<p>The WEEKDAY function in Excel is a useful tool for finding the day of the week for a given date. It helps you determine whether a particular date falls on a weekday (Monday to Friday) and, if so, which day of the week it is. This function can be handy for various applications, such as scheduling, project management, and more.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Syntax<\/h2>\n\n\n\n<p><strong>WEEKDAY(serial_number, [return_type])<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Arguments<\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><strong>serial_number<\/strong><\/td><td>The date for which you want to find the day of the week.<\/td><\/tr><tr><td><strong>[return_type]<\/strong><\/td><td>(Optional) A number that specifies the type of result you want:<br><strong>1 or omitted:<\/strong> Returns numbers 1 (Sunday) through 7 (Saturday).<br><strong>2:<\/strong> Returns numbers 1 (Monday) through 7 (Sunday).<br><strong>3:<\/strong> Returns numbers 0 (Monday) through 6 (Sunday).<br><strong>11:<\/strong> Returns numbers 1 (Monday) through 7 (Sunday).<br><strong>12:<\/strong> Returns numbers 1 (Tuesday) through 7 (Monday).<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to use<\/h2>\n\n\n\n<p>The WEEKDAY function is quite straightforward to use. You provide it with a date in the <strong>serial_number<\/strong> argument, and it returns the day of the week based on the specified <strong>[return_type]<\/strong> (which is optional). Here are some examples to illustrate how to use it:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=WEEKDAY(\"2023-11-03\")<\/code><\/pre>\n\n\n\n<p>This formula will return 5 because November 3, 2023, is a Friday (assuming the default return type of 1).<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=WEEKDAY(\"2023-11-03\", 2)<\/code><\/pre>\n\n\n\n<p>Using return type 2, this formula will return 6 because November 3, 2023, is a Friday, which is represented as 6 in this context.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=WEEKDAY(\"2023-11-03\", 11)<\/code><\/pre>\n\n\n\n<p>With return type 11, this formula will also return 6, indicating that November 3, 2023, is a Friday.<\/p>\n\n\n\n<p>Remember to input your date in the proper format (in quotation marks), and you can use this function to determine the day of the week for various dates.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Examples<\/h2>\n\n\n\n<p>Let&#8217;s explore some more examples of using the WEEKDAY function:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=WEEKDAY(\"2023-11-06\")<\/code><\/pre>\n\n\n\n<p>This will return 1 because November 6, 2023, is a Sunday.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=WEEKDAY(\"2023-11-06\", 3)<\/code><\/pre>\n\n\n\n<p>Using return type 3, this formula will return 6 because November 6, 2023, is a Sunday, and it is represented as 6 in this context.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Additional Information<\/h2>\n\n\n\n<p>The WEEKDAY function is a valuable tool for date-related calculations in Excel. It helps you efficiently work with dates and identify the day of the week, which can be crucial for scheduling and data analysis. If you encounter any unfamiliar terms or need more details about date functions in Excel, you can refer to Microsoft Excel&#8217;s official documentation for further information.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The WEEKDAY function in Excel is a useful tool for finding the day of the week for a given date. It helps you&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>WEEKDAY function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/weekday\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"WEEKDAY function\" \/>\n<meta property=\"og:description\" content=\"The WEEKDAY function in Excel is a useful tool for finding the day of the week for a given date. It helps you...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/weekday\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-04T14:56:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T14:58:53+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/weekday\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/weekday\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"WEEKDAY function\",\"datePublished\":\"2018-07-04T14:56:06+00:00\",\"dateModified\":\"2023-11-03T14:58:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/weekday\/\"},\"wordCount\":353,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/weekday\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/weekday\/\",\"name\":\"WEEKDAY function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-04T14:56:06+00:00\",\"dateModified\":\"2023-11-03T14:58:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/weekday\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/weekday\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/weekday\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"WEEKDAY function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"WEEKDAY function","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/functions\/weekday\/","og_locale":"en_US","og_type":"article","og_title":"WEEKDAY function","og_description":"The WEEKDAY function in Excel is a useful tool for finding the day of the week for a given date. It helps you...","og_url":"https:\/\/officetuts.net\/excel\/functions\/weekday\/","article_published_time":"2018-07-04T14:56:06+00:00","article_modified_time":"2023-11-03T14:58:53+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/weekday\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/weekday\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"WEEKDAY function","datePublished":"2018-07-04T14:56:06+00:00","dateModified":"2023-11-03T14:58:53+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/weekday\/"},"wordCount":353,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/weekday\/","url":"https:\/\/officetuts.net\/excel\/functions\/weekday\/","name":"WEEKDAY function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-04T14:56:06+00:00","dateModified":"2023-11-03T14:58:53+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/weekday\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/weekday\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/weekday\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"WEEKDAY function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1435"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1435"}],"version-history":[{"count":4,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1435\/revisions"}],"predecessor-version":[{"id":16616,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1435\/revisions\/16616"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}