{"id":486,"date":"2023-10-26T11:03:22","date_gmt":"2023-10-26T11:03:22","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/valor-de-data\/"},"modified":"2023-12-06T11:43:01","modified_gmt":"2023-12-06T11:43:01","slug":"valor-de-data","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/valor-de-data\/","title":{"rendered":"Como usar a fun\u00e7\u00e3o vba datevalue?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-3241493318\"><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><div class=\"excel-before-content\" id=\"excel-165881505\"><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>A fun\u00e7\u00e3o VBA DATEVALUE est\u00e1 listada na categoria de data das fun\u00e7\u00f5es VBA. Quando voc\u00ea o usa no c\u00f3digo VBA, <strong>ele pode retornar uma<\/strong> data do texto que representa uma data. Em palavras simples, ele pode converter uma data em uma data real que \u00e9 armazenada como texto. Se houver um hor\u00e1rio com essa data, ele ir\u00e1 ignor\u00e1-lo. \u00c9 como a fun\u00e7\u00e3o DATEVALUE na planilha.<\/p><h2 class=\"wp-block-heading\"> Sintaxe<\/h2><p> <strong>DataValor(Data)<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumentos<\/h2><ul><li> <strong>Data<\/strong> : uma string que representa uma data v\u00e1lida de acordo com o VBA.<\/li><\/ul><h2 class=\"wp-block-heading\"> Exemplo<\/h2><p> Para entender de forma pr\u00e1tica como usar a fun\u00e7\u00e3o VBA DATEVALUE, voc\u00ea precisa seguir o exemplo abaixo, onde escrevemos um c\u00f3digo vba usando-a: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"exemplo-vba-datevalue-fun\u00e7\u00e3o\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-datevalue.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-datevalue-function\" width=\"821\" height=\"479\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_DATEVALUE() Range(\"B1\").Value = DateValue(Range(\"A1\")) End Sub<\/code><\/pre><p> No exemplo acima, usamos DATEVALUE para converter uma data armazenada como texto na c\u00e9lula A1 e convertemos esses dados em uma data real na c\u00e9lula B1.<\/p><h2 class=\"wp-block-heading\"> Coment\u00e1rios<\/h2><ul><li> Se o valor especificado for diferente de uma data ou uma data que n\u00e3o possa ser reconhecida como data, o VBA retornar\u00e1 o erro de tempo de execu\u00e7\u00e3o 13.<\/li><li> E se a data for NULL, retornar\u00e1 NULL. <\/li><\/ul><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Mais tutoriais <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-292\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/data-2\/\">DATA VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/data-adicionada\/\">DATA VBA ADICIONAR<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/parte-da-data\/\">DATAPARTES VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/data-em-serie\/\">DATA SERIAL VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/dia\/\">DIA DO VBA<\/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-486","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>Como usar a fun\u00e7\u00e3o VBA DATEVALUE? (Com exemplo)<\/title>\n<meta name=\"description\" content=\"Aprenda como usar a fun\u00e7\u00e3o VBA DATEVALUE com sintaxe, argumentos e exemplo com c\u00f3digo de exemplo.\" \/>\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\/pt\/valor-de-data\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como usar a fun\u00e7\u00e3o VBA DATEVALUE? (Com exemplo)\" \/>\n<meta property=\"og:description\" content=\"Aprenda como usar a fun\u00e7\u00e3o VBA DATEVALUE com sintaxe, argumentos e exemplo com c\u00f3digo de exemplo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/valor-de-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:43:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-datevalue.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/valor-de-data\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/valor-de-data\/\",\"name\":\"Como usar a fun\u00e7\u00e3o VBA DATEVALUE? (Com exemplo)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/valor-de-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/valor-de-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-datevalue.png\",\"datePublished\":\"2023-10-26T11:03:22+00:00\",\"dateModified\":\"2023-12-06T11:43:01+00:00\",\"description\":\"Aprenda como usar a fun\u00e7\u00e3o VBA DATEVALUE com sintaxe, argumentos e exemplo com c\u00f3digo de exemplo.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/valor-de-data\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/valor-de-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/valor-de-data\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-datevalue.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-datevalue.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/valor-de-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como usar a fun\u00e7\u00e3o vba datevalue?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como usar a fun\u00e7\u00e3o VBA DATEVALUE? (Com exemplo)","description":"Aprenda como usar a fun\u00e7\u00e3o VBA DATEVALUE com sintaxe, argumentos e exemplo com c\u00f3digo de exemplo.","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\/pt\/valor-de-data\/","og_locale":"pt_PT","og_type":"article","og_title":"Como usar a fun\u00e7\u00e3o VBA DATEVALUE? (Com exemplo)","og_description":"Aprenda como usar a fun\u00e7\u00e3o VBA DATEVALUE com sintaxe, argumentos e exemplo com c\u00f3digo de exemplo.","og_url":"https:\/\/exceladvisor.org\/pt\/valor-de-data\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:43:01+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-datevalue.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/valor-de-data\/","url":"https:\/\/exceladvisor.org\/pt\/valor-de-data\/","name":"Como usar a fun\u00e7\u00e3o VBA DATEVALUE? (Com exemplo)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/valor-de-data\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/valor-de-data\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-datevalue.png","datePublished":"2023-10-26T11:03:22+00:00","dateModified":"2023-12-06T11:43:01+00:00","description":"Aprenda como usar a fun\u00e7\u00e3o VBA DATEVALUE com sintaxe, argumentos e exemplo com c\u00f3digo de exemplo.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/valor-de-data\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/valor-de-data\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/valor-de-data\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-datevalue.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-datevalue.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/valor-de-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como usar a fun\u00e7\u00e3o vba datevalue?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/486","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=486"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/486\/revisions"}],"predecessor-version":[{"id":1256,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/486\/revisions\/1256"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}