{"id":2035,"date":"2023-10-23T19:44:04","date_gmt":"2023-10-23T19:44:04","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/"},"modified":"2023-12-06T05:48:27","modified_gmt":"2023-12-06T05:48:27","slug":"weekdagnaam","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/","title":{"rendered":"Hoe gebruik ik de vba weekdayname-functie?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-6014961\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>De VBA-functie WEEKDAGNAAM wordt vermeld in de datumcategorie van VBA-functies. Wanneer u het in VBA-code gebruikt, <strong>retourneert het de naam van de dag (weekdag<\/strong> ) met het opgegeven gehele getal als dagnummer. In eenvoudige bewoordingen retourneert het de naam van de dag met behulp van het nummer van de dag van de week (vari\u00ebrend van 1 tot 7).<\/p><h2 class=\"wp-block-heading\"> Syntaxis<\/h2><p> <strong>Naam WeekDag(WeekDag, [Afkorten], [EersteWeekDag])<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumenten<\/h2><ul><li> <strong>Dag van de week<\/strong> : een geheel getal om de dag tussen 1 en 7 aan te geven.<\/li><li> <strong>[Afkorten]<\/strong> : een Booleaanse waarde die aangeeft of u een volledige maandnaam of een verkorte naam nodig heeft. [Dit is een optioneel argument en als dit wordt weggelaten, wordt VBA standaard FALSE].<ul><li> Gebruik TRUE voor de korte naam (bijv. \u201cJan\u201d, \u201cFeb\u201d, \u201cMar\u201d, etc.) of FALSE voor de volledige naam (bijv. \u201cJanuari\u201d, \u201cFebruari\u201d, \u201cMaart\u201d, etc.)<\/li><\/ul><\/li><li> <strong>[FirstDayOfWeek]<\/strong> : een tekenreeks om de eerste dag van de week in te stellen [Dit is een optioneel argument en als dit wordt weggelaten, neemt VBA standaard vbSunday].<ul><li> vbUseSystemDayOfWeek \u2013 Afhankelijk van systeeminstellingen.<\/li><li> vbzondag \u2013 zondag<\/li><li> vblunday \u2013 maandag<\/li><li> vbdinsdag \u2013 dinsdag<\/li><li> vbwoensdag \u2013 woensdag<\/li><li> vbDonderdag \u2013 donderdag<\/li><li> vbVrijdag \u2013 vrijdag<\/li><li> vbzaterdag \u2013 zaterdag<\/li><\/ul><\/li><\/ul><h2 class=\"wp-block-heading\"> Voorbeeld<\/h2><p> Om praktisch te begrijpen hoe u de VBA WEEKDAYNAME-functie kunt gebruiken, moet u het onderstaande voorbeeld doorlopen waarin we er een vba-code mee hebben geschreven: <\/p><figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"voorbeeld-vba-weekdagnaam-functie\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-weekdayname-function\" width=\"838\" height=\"405\"><\/figure><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_WEEKDAYNAME() Range(\"A1\").Value = WeekdayName(1, \"True\", vbMonday) End Sub<\/code><\/pre><p> In de bovenstaande code gebruikten we WEEKDAYNAME, en we gebruikten 1 om de eerste dag van de week te krijgen, TRUE om de korte naam van de dag van de week te krijgen, en vbMonday om maandag in te stellen als de eerste dag van de week. In het resultaat hebben we Mon in cel B1. <\/p><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Meer tutorials <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-16\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/datum-2\/\">DATUM VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/datumtoevoeg\/\">VBA DATUMADD<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/datumdeel\/\">VBA DATUMPARTS<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/datumserie\/\">VBA DATESERIAL<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/datumwaarde\/\">VBA DATUMWAARDE<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2035","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Hoe gebruik ik de VBA WEEKDAYNAME-functie?<\/title>\n<meta name=\"description\" content=\"Leer hoe u de VBA WEEKDAYNAME-functie gebruikt met syntaxis, argumenten en een voorbeeld met voorbeeldcode.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe gebruik ik de VBA WEEKDAYNAME-functie?\" \/>\n<meta property=\"og:description\" content=\"Leer hoe u de VBA WEEKDAYNAME-functie gebruikt met syntaxis, argumenten en een voorbeeld met voorbeeldcode.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:48:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/\",\"name\":\"Hoe gebruik ik de VBA WEEKDAYNAME-functie?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png\",\"datePublished\":\"2023-10-23T19:44:04+00:00\",\"dateModified\":\"2023-12-06T05:48:27+00:00\",\"description\":\"Leer hoe u de VBA WEEKDAYNAME-functie gebruikt met syntaxis, argumenten en een voorbeeld met voorbeeldcode.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe gebruik ik de vba weekdayname-functie?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hoe gebruik ik de VBA WEEKDAYNAME-functie?","description":"Leer hoe u de VBA WEEKDAYNAME-functie gebruikt met syntaxis, argumenten en een voorbeeld met voorbeeldcode.","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:\/\/exceladvisor.org\/nl\/weekdagnaam\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe gebruik ik de VBA WEEKDAYNAME-functie?","og_description":"Leer hoe u de VBA WEEKDAYNAME-functie gebruikt met syntaxis, argumenten en een voorbeeld met voorbeeldcode.","og_url":"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:48:27+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/","url":"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/","name":"Hoe gebruik ik de VBA WEEKDAYNAME-functie?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png","datePublished":"2023-10-23T19:44:04+00:00","dateModified":"2023-12-06T05:48:27+00:00","description":"Leer hoe u de VBA WEEKDAYNAME-functie gebruikt met syntaxis, argumenten en een voorbeeld met voorbeeldcode.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/weekdagnaam\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/weekdagnaam\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe gebruik ik de vba weekdayname-functie?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2035","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=2035"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2035\/revisions"}],"predecessor-version":[{"id":2532,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2035\/revisions\/2532"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}