{"id":2034,"date":"2023-10-23T19:54:53","date_gmt":"2023-10-23T19:54:53","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/weekend\/"},"modified":"2023-12-06T05:48:26","modified_gmt":"2023-12-06T05:48:26","slug":"weekend","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/weekend\/","title":{"rendered":"Hoe gebruik ik de vba weekday-functie?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-3009236609\"><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 WEEKDAY VBA-functie wordt vermeld in de datumcategorie van VBA-functies. Wanneer u het in VBA-code gebruikt, <strong>retourneert het het dagnummer (vari\u00ebrend van 1 tot 7)<\/strong> met behulp van het dagnummer vanaf de opgegeven datum. In eenvoudige bewoordingen retourneert het het aantal dagen in de week.<\/p><h2 class=\"wp-block-heading\"> Syntaxis<\/h2><p> <strong>Weekdag(Datum, [EersteDagVanWeek])<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumenten<\/h2><ul><li> <strong>Datum<\/strong> : een geldige datum waarvoor u de dag van de week wilt weten.<\/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> <strong>vbUseSystemDayOfWeek<\/strong> \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><\/ul><\/li><\/ul><h2 class=\"wp-block-heading\"> Voorbeeld<\/h2><p> Om praktisch te begrijpen hoe u de VBA WEEKDAY-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-weekdag-functie\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-jour-de-la-semaine-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-weekday-function\" width=\"837\" height=\"435\"><\/figure><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_WEEKDAY() Range(\"B1\").Value = Weekday(Range(\"A1\")) End Sub<\/code><\/pre><p> In de bovenstaande code hebben we WEEKDAY gebruikt om de dag van de week te krijgen voor (woensdag 15 mei 2019) de datum die we in cel A1 hebben en in het resultaat hebben we 4 in cel B1.<\/p><p> De dag is woensdag, de vierde dag van de week (het duurde zondag als eerste dag van de week), dus het resultaat was 4.<\/p><h2 class=\"wp-block-heading\"> Opmerkingen<\/h2><ul><li> Als de opgegeven datum een andere waarde is dan een datum of een tekenreeks die niet als datum kan worden herkend, retourneert VBA runtimefout 13. <\/li><\/ul><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-20\"><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-2034","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 WEEKDAY-functie? (syntaxis + voorbeeld)<\/title>\n<meta name=\"description\" content=\"Leer hoe u de VBA WEEKDAY-functie gebruikt met syntaxis, argumenten en voorbeelden 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\/weekend\/\" \/>\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 WEEKDAY-functie? (syntaxis + voorbeeld)\" \/>\n<meta property=\"og:description\" content=\"Leer hoe u de VBA WEEKDAY-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/weekend\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:48:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-jour-de-la-semaine-vba.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\/weekend\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/weekend\/\",\"name\":\"Hoe gebruik ik de VBA WEEKDAY-functie? (syntaxis + voorbeeld)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/weekend\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/weekend\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-jour-de-la-semaine-vba.png\",\"datePublished\":\"2023-10-23T19:54:53+00:00\",\"dateModified\":\"2023-12-06T05:48:26+00:00\",\"description\":\"Leer hoe u de VBA WEEKDAY-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/weekend\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/weekend\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/weekend\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-jour-de-la-semaine-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-jour-de-la-semaine-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/weekend\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe gebruik ik de vba weekday-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 WEEKDAY-functie? (syntaxis + voorbeeld)","description":"Leer hoe u de VBA WEEKDAY-functie gebruikt met syntaxis, argumenten en voorbeelden 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\/weekend\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe gebruik ik de VBA WEEKDAY-functie? (syntaxis + voorbeeld)","og_description":"Leer hoe u de VBA WEEKDAY-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.","og_url":"https:\/\/exceladvisor.org\/nl\/weekend\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:48:26+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-jour-de-la-semaine-vba.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\/weekend\/","url":"https:\/\/exceladvisor.org\/nl\/weekend\/","name":"Hoe gebruik ik de VBA WEEKDAY-functie? (syntaxis + voorbeeld)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/weekend\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/weekend\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-jour-de-la-semaine-vba.png","datePublished":"2023-10-23T19:54:53+00:00","dateModified":"2023-12-06T05:48:26+00:00","description":"Leer hoe u de VBA WEEKDAY-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/weekend\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/weekend\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/weekend\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-jour-de-la-semaine-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-jour-de-la-semaine-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/weekend\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe gebruik ik de vba weekday-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\/2034","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=2034"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2034\/revisions"}],"predecessor-version":[{"id":2531,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2034\/revisions\/2531"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}