{"id":3473,"date":"2023-10-25T06:59:13","date_gmt":"2023-10-25T06:59:13","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/isdate\/"},"modified":"2023-12-03T13:06:56","modified_gmt":"2023-12-03T13:06:56","slug":"isdate","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/isdate\/","title":{"rendered":"Wie verwende ich die vba-isdate-funktion?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-2762457189\"><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>Die VBA-ISDATE-Funktion ist in der Informationskategorie \u201eVBA-Funktionen\u201c aufgef\u00fchrt. Wenn Sie es im VBA-Code verwenden, <strong>wertet es den bereitgestellten Ausdruck aus und gibt TRUE zur\u00fcck, wenn es sich um ein Datum handelt, andernfalls FALSE.<\/strong> Vereinfacht ausgedr\u00fcckt kann es pr\u00fcfen, ob der angegebene Wert ein Datum ist oder nicht, und auf dieser Grundlage TRUE oder FALSE zur\u00fcckgeben.<\/p><h2 class=\"wp-block-heading\"> Syntax<\/h2><p> <strong>IsDate(Ausdruck)<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumente<\/h2><ul><li> <strong>Ausdruck<\/strong> : Ein Ausdruck, den Sie testen m\u00f6chten, ob es sich um ein Datum handelt oder nicht.<\/li><\/ul><h2 class=\"wp-block-heading\"> Beispiel<\/h2><p> Um die Verwendung der VBA-ISDATE-Funktion praktisch zu verstehen, m\u00fcssen Sie das folgende Beispiel durchgehen, in dem wir einen VBA-Code geschrieben haben, der sie verwendet: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"Beispiel-vba-isdate-Funktion\" 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> Im obigen Code haben wir ISDATE verwendet, um zu pr\u00fcfen, ob der Wert von Zelle A1 ein Datum ist oder nicht, und es hat in Zelle B1 TRUE zur\u00fcckgegeben. Dementsprechend haben wir TRUE erhalten, weil der Wert von Zelle A1 ein Datum ist. <\/p><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Weitere 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\/de\/isarray\/\">VBA ISARRAY<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/ist-leer\/\">VBA ist leer<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/iserror\/\">VBA-FEHLER<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/wird-vermisst\/\">Fehlendes VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/ist-null\/\">VBA ISNULL<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/isnumerisch\/\">VBA IST NUMERISCH<\/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-3473","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>Wie verwende ich die VBA-ISDATE-Funktion? (Syntax + Beispiel)<\/title>\n<meta name=\"description\" content=\"Erfahren Sie, wie Sie die VBA-ISDATE-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.\" \/>\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\/de\/isdate\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie verwende ich die VBA-ISDATE-Funktion? (Syntax + Beispiel)\" \/>\n<meta property=\"og:description\" content=\"Erfahren Sie, wie Sie die VBA-ISDATE-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/isdate\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:06:56+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=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/isdate\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/isdate\/\",\"name\":\"Wie verwende ich die VBA-ISDATE-Funktion? (Syntax + Beispiel)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/isdate\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/isdate\/#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-03T13:06:56+00:00\",\"description\":\"Erfahren Sie, wie Sie die VBA-ISDATE-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/isdate\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/isdate\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/isdate\/#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\/de\/isdate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie verwende ich die vba-isdate-funktion?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wie verwende ich die VBA-ISDATE-Funktion? (Syntax + Beispiel)","description":"Erfahren Sie, wie Sie die VBA-ISDATE-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.","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\/de\/isdate\/","og_locale":"de_DE","og_type":"article","og_title":"Wie verwende ich die VBA-ISDATE-Funktion? (Syntax + Beispiel)","og_description":"Erfahren Sie, wie Sie die VBA-ISDATE-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.","og_url":"https:\/\/exceladvisor.org\/de\/isdate\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:06:56+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":{"Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/isdate\/","url":"https:\/\/exceladvisor.org\/de\/isdate\/","name":"Wie verwende ich die VBA-ISDATE-Funktion? (Syntax + Beispiel)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/isdate\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/isdate\/#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-03T13:06:56+00:00","description":"Erfahren Sie, wie Sie die VBA-ISDATE-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/isdate\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/isdate\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/isdate\/#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\/de\/isdate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie verwende ich die vba-isdate-funktion?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3473","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3473"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3473\/revisions"}],"predecessor-version":[{"id":4306,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3473\/revisions\/4306"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}