{"id":487,"date":"2023-10-26T11:03:22","date_gmt":"2023-10-26T11:03:22","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/valor-de-fecha\/"},"modified":"2023-12-25T10:30:19","modified_gmt":"2023-12-25T10:30:19","slug":"valor-de-fecha","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/valor-de-fecha\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba datevalue?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1649483898\"><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>La funci\u00f3n VBA DATEVALUE aparece en la categor\u00eda de fecha de las funciones de VBA. Cuando lo usa en c\u00f3digo VBA, <strong>puede devolver una<\/strong> fecha a partir de un texto que representa una fecha. En palabras simples, puede convertir una fecha en una fecha real que se almacena como texto. Si hay una hora con esa fecha, la ignorar\u00e1. Es como la funci\u00f3n FECHAVALOR en la hoja de c\u00e1lculo.<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>FechaValor(Fecha)<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>Fecha<\/strong> : Una cadena que representa una fecha v\u00e1lida seg\u00fan VBA.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA DATEVALUE, debe seguir el siguiente ejemplo donde hemos escrito un c\u00f3digo vba us\u00e1ndola: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"ejemplo-vba-fecha-valor-funci\u00f3n\" 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>\n<\/div>\n<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>\n<p> En el ejemplo anterior, usamos DATEVALUE para convertir una fecha almacenada como texto en la celda A1 y convirti\u00f3 esos datos en una fecha real en la celda B1.<\/p>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> Si el valor especificado es un valor distinto de una fecha o una fecha que no puede reconocerse como fecha, VBA devolver\u00e1 el error de ejecuci\u00f3n 13.<\/li>\n<li> Y si la fecha es NULL, devolver\u00e1 NULL. <\/li>\n<\/ul>\n<div class=\"wp-block-group more-tutorials is-layout-flow\">\n<div class=\"wp-block-group__inner-container\">\n<h2 class=\"wp-block-heading\"> M\u00e1s tutoriales <\/h2>\n<div class=\"wp-block-columns is-layout-flex wp-container-292\">\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fecha-2\/\">FECHA VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fechaanadir\/\">VBA FECHA AGREGAR<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/parte-de-fecha\/\">PARTES DE FECHA DE VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/\">SERIE DE FECHA VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/dia\/\">D\u00cdA VBA<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA DATEVALUE aparece en la categor\u00eda de fecha de las funciones de VBA. Cuando lo usa en c\u00f3digo VBA, puede devolver una fecha a partir de un texto que representa una fecha. En palabras simples, puede convertir una fecha en una fecha real que se almacena como texto. Si hay una hora con [&hellip;]<\/p>\n","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-487","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>\u00bfc\u00f3mo utilizar la funci\u00f3n vba datevalue?<\/title>\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\/es\/valor-de-fecha\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba datevalue?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA DATEVALUE aparece en la categor\u00eda de fecha de las funciones de VBA. Cuando lo usa en c\u00f3digo VBA, puede devolver una fecha a partir de un texto que representa una fecha. En palabras simples, puede convertir una fecha en una fecha real que se almacena como texto. Si hay una hora con [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/valor-de-fecha\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:30:19+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=\"Tiempo de lectura\" \/>\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\/es\/valor-de-fecha\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/valor-de-fecha\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba datevalue?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/valor-de-fecha\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/valor-de-fecha\/#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-25T10:30:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/valor-de-fecha\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/valor-de-fecha\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/valor-de-fecha\/#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\/es\/valor-de-fecha\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba datevalue?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba datevalue?","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\/es\/valor-de-fecha\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba datevalue?","og_description":"La funci\u00f3n VBA DATEVALUE aparece en la categor\u00eda de fecha de las funciones de VBA. Cuando lo usa en c\u00f3digo VBA, puede devolver una fecha a partir de un texto que representa una fecha. En palabras simples, puede convertir una fecha en una fecha real que se almacena como texto. Si hay una hora con [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/valor-de-fecha\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:30:19+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":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/valor-de-fecha\/","url":"https:\/\/exceladvisor.org\/es\/valor-de-fecha\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba datevalue?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/valor-de-fecha\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/valor-de-fecha\/#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-25T10:30:19+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/valor-de-fecha\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/valor-de-fecha\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/valor-de-fecha\/#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\/es\/valor-de-fecha\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba datevalue?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/487","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=487"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/487\/revisions"}],"predecessor-version":[{"id":1251,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/487\/revisions\/1251"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}