{"id":1981,"date":"2023-10-25T06:59:13","date_gmt":"2023-10-25T06:59:13","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/isdatum\/"},"modified":"2023-12-06T05:46:16","modified_gmt":"2023-12-06T05:46:16","slug":"isdatum","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/isdatum\/","title":{"rendered":"Hoe gebruik ik de vba isdate-functie?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-2610513317\"><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 ISDATE-functie wordt vermeld in de informatiecategorie VBA-functies. Wanneer u het in VBA-code gebruikt, <strong>evalueert het de opgegeven expressie en retourneert TRUE als het een datum is, anders FALSE.<\/strong> In eenvoudige bewoordingen kan het controleren of de opgegeven waarde een datum is of niet, en op basis daarvan WAAR of ONWAAR retourneren.<\/p><h2 class=\"wp-block-heading\"> Syntaxis<\/h2><p> <strong>IsDatum(Expressie)<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumenten<\/h2><ul><li> <strong>Expressie<\/strong> : een expressie waarvan u wilt testen of het een datum is of niet.<\/li><\/ul><h2 class=\"wp-block-heading\"> Voorbeeld<\/h2><p> Om praktisch te begrijpen hoe u de VBA ISDATE-functie kunt gebruiken, moet u het onderstaande voorbeeld doorlopen waarin we er een vba-code mee hebben geschreven: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"voorbeeld-vba-isdate-functie\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-fonction-vba-isdate.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-isdate-function\" width=\"838\" height=\"478\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_ISDATE() Range(\"B1\").Value = IsDate(Range(\"A1\")) End Sub<\/code><\/pre><p> In de bovenstaande code hebben we ISDATE gebruikt om te controleren of de waarde van cel A1 een datum is of niet en deze retourneerde TRUE in cel B1. Daarom kregen we TRUE omdat de waarde van cel A1 een datum is. <\/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-216\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/isarray\/\">VBA ISARRAY<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/is-leeg\/\">VBA IS LEEG<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/is-een-fout\/\">VBA-ISFOUT<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/ontbreekt\/\">ONTBREKEN VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/is-niets\/\">VBA IS NIET<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/isnumeriek\/\">VBA IS NUMERIEK<\/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-1981","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 ISDATE-functie? (Syntaxis + voorbeeld)<\/title>\n<meta name=\"description\" content=\"Leer hoe u de VBA ISDATE-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\/isdatum\/\" \/>\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 ISDATE-functie? (Syntaxis + voorbeeld)\" \/>\n<meta property=\"og:description\" content=\"Leer hoe u de VBA ISDATE-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/isdatum\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:46:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-fonction-vba-isdate.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\/isdatum\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/isdatum\/\",\"name\":\"Hoe gebruik ik de VBA ISDATE-functie? (Syntaxis + voorbeeld)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/isdatum\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/isdatum\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-fonction-vba-isdate.png\",\"datePublished\":\"2023-10-25T06:59:13+00:00\",\"dateModified\":\"2023-12-06T05:46:16+00:00\",\"description\":\"Leer hoe u de VBA ISDATE-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/isdatum\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/isdatum\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/isdatum\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-fonction-vba-isdate.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-fonction-vba-isdate.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/isdatum\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe gebruik ik de vba isdate-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 ISDATE-functie? (Syntaxis + voorbeeld)","description":"Leer hoe u de VBA ISDATE-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\/isdatum\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe gebruik ik de VBA ISDATE-functie? (Syntaxis + voorbeeld)","og_description":"Leer hoe u de VBA ISDATE-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.","og_url":"https:\/\/exceladvisor.org\/nl\/isdatum\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:46:16+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-fonction-vba-isdate.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\/isdatum\/","url":"https:\/\/exceladvisor.org\/nl\/isdatum\/","name":"Hoe gebruik ik de VBA ISDATE-functie? (Syntaxis + voorbeeld)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/isdatum\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/isdatum\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-fonction-vba-isdate.png","datePublished":"2023-10-25T06:59:13+00:00","dateModified":"2023-12-06T05:46:16+00:00","description":"Leer hoe u de VBA ISDATE-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/isdatum\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/isdatum\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/isdatum\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-fonction-vba-isdate.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-fonction-vba-isdate.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/isdatum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe gebruik ik de vba isdate-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\/1981","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=1981"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1981\/revisions"}],"predecessor-version":[{"id":2483,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1981\/revisions\/2483"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}