{"id":483,"date":"2023-10-26T11:48:28","date_gmt":"2023-10-26T11:48:28","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/fecha-2\/"},"modified":"2023-12-25T10:28:24","modified_gmt":"2023-12-25T10:28:24","slug":"fecha-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/fecha-2\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n fecha vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2407324556\"><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 DATE aparece en la categor\u00eda de fecha de las funciones VBA. Cuando lo usas en c\u00f3digo VBA, devuelve la fecha actual seg\u00fan el sistema. Es como la <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/es\/funciones-de-fecha-de-excel\/\">funci\u00f3n HOY<\/a> que usas en la hoja de c\u00e1lculo. Las declaraciones de fecha tienen el formato mm\/dd\/aaaa o cualquier formato que usted defina.<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>Fecha()<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> No hay argumentos para definir en la funci\u00f3n.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n FECHA de VBA, debe seguir el siguiente ejemplo donde escribimos 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-funci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-date-function\" width=\"782\" height=\"538\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_DATE() Range(\"A1\").Value = Date End Sub<\/code><\/pre>\n<p> En el ejemplo anterior, utilizamos la funci\u00f3n FECHA para ingresar la fecha actual en la celda A1.<\/p>\n<p> A diferencia de la funci\u00f3n HOY (que puede usar en la hoja de c\u00e1lculo), la fecha ingresada por la funci\u00f3n FECHA VBA no es vol\u00e1til. Por lo tanto, si desea volver a ingresar la fecha actual, deber\u00e1 ejecutar el c\u00f3digo nuevamente. <\/p>\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-308\">\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\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\/valor-de-fecha\/\">VALOR 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 DATE aparece en la categor\u00eda de fecha de las funciones VBA. Cuando lo usas en c\u00f3digo VBA, devuelve la fecha actual seg\u00fan el sistema. Es como la funci\u00f3n HOY que usas en la hoja de c\u00e1lculo. Las declaraciones de fecha tienen el formato mm\/dd\/aaaa o cualquier formato que usted defina. Sintaxis Fecha() [&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-483","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 fecha vba?<\/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\/fecha-2\/\" \/>\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 fecha vba?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA DATE aparece en la categor\u00eda de fecha de las funciones VBA. Cuando lo usas en c\u00f3digo VBA, devuelve la fecha actual seg\u00fan el sistema. Es como la funci\u00f3n HOY que usas en la hoja de c\u00e1lculo. Las declaraciones de fecha tienen el formato mm\/dd\/aaaa o cualquier formato que usted defina. Sintaxis Fecha() [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/fecha-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:28:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.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\/fecha-2\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/fecha-2\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n fecha vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/fecha-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/fecha-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.png\",\"datePublished\":\"2023-10-26T11:48:28+00:00\",\"dateModified\":\"2023-12-25T10:28:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/fecha-2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/fecha-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/fecha-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/fecha-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n fecha vba?\"}]},{\"@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 fecha vba?","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\/fecha-2\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n fecha vba?","og_description":"La funci\u00f3n VBA DATE aparece en la categor\u00eda de fecha de las funciones VBA. Cuando lo usas en c\u00f3digo VBA, devuelve la fecha actual seg\u00fan el sistema. Es como la funci\u00f3n HOY que usas en la hoja de c\u00e1lculo. Las declaraciones de fecha tienen el formato mm\/dd\/aaaa o cualquier formato que usted defina. Sintaxis Fecha() [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/fecha-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:28:24+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.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\/fecha-2\/","url":"https:\/\/exceladvisor.org\/es\/fecha-2\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n fecha vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/fecha-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/fecha-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.png","datePublished":"2023-10-26T11:48:28+00:00","dateModified":"2023-12-25T10:28:24+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/fecha-2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/fecha-2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/fecha-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/fecha-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar la funci\u00f3n fecha vba?"}]},{"@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\/483","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=483"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/483\/revisions"}],"predecessor-version":[{"id":1304,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/483\/revisions\/1304"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}