{"id":486,"date":"2023-10-26T11:14:40","date_gmt":"2023-10-26T11:14:40","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/"},"modified":"2023-12-25T10:30:18","modified_gmt":"2023-12-25T10:30:18","slug":"serie-de-fechas","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba dateserial?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2022990604\"><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 DATESERIAL aparece en la categor\u00eda de fecha de las funciones de VBA. Cuando lo usa en c\u00f3digo VBA, <strong>devuelve una fecha v\u00e1lida seg\u00fan el formato de fecha de VBA seg\u00fan el d\u00eda, mes y a\u00f1o proporcionados<\/strong> . En palabras simples, puedes crear una fecha con d\u00eda, mes y a\u00f1o. Es como la funci\u00f3n FECHA en la hoja de c\u00e1lculo.<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>FechaSerial(a\u00f1o, mes, d\u00eda)<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>A\u00f1o<\/strong> : un n\u00famero entero que se utilizar\u00e1 como a\u00f1o en la fecha.<\/li>\n<li> <strong>Mes<\/strong> : un n\u00famero entero que se utilizar\u00e1 como mes en la fecha.<\/li>\n<li> <strong>D\u00eda<\/strong> : un n\u00famero entero que se utilizar\u00e1 como d\u00eda en la fecha.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA DATESERIAL, 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-dateserial-funci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-fonction-dateserial.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-dateserial-function\" width=\"835\" height=\"524\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_DATESERIAL() Range(\"A1\").Value = DateSerial(2019, 5, 15) End Sub<\/code><\/pre>\n<p> En el ejemplo anterior, utilizamos DATESERIAL para crear una fecha con 2019 como a\u00f1o, 5 meses y 15 como d\u00eda y, por lo tanto, devolvi\u00f3 15-mayo-19.<\/p>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> Aseg\u00farese de utilizar el valor de cuatro d\u00edgitos durante a\u00f1os.<\/li>\n<li> Si agrega la cantidad de d\u00edas sobre la cantidad m\u00e1xima de d\u00edas en un mes, devolver\u00e1 la fecha agregando d\u00edas adicionales al mes siguiente.<\/li>\n<li> Si suma el n\u00famero del mes al n\u00famero m\u00e1ximo de meses en un a\u00f1o, devolver\u00e1 la fecha sumando los meses sobrantes al a\u00f1o siguiente. <\/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-296\">\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\/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 class=\"wp-block-column is-layout-flow\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA DATESERIAL aparece en la categor\u00eda de fecha de las funciones de VBA. Cuando lo usa en c\u00f3digo VBA, devuelve una fecha v\u00e1lida seg\u00fan el formato de fecha de VBA seg\u00fan el d\u00eda, mes y a\u00f1o proporcionados . En palabras simples, puedes crear una fecha con d\u00eda, mes y a\u00f1o. Es como la [&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-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>\u00bfc\u00f3mo utilizar la funci\u00f3n vba dateserial?<\/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\/serie-de-fechas\/\" \/>\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 dateserial?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA DATESERIAL aparece en la categor\u00eda de fecha de las funciones de VBA. Cuando lo usa en c\u00f3digo VBA, devuelve una fecha v\u00e1lida seg\u00fan el formato de fecha de VBA seg\u00fan el d\u00eda, mes y a\u00f1o proporcionados . En palabras simples, puedes crear una fecha con d\u00eda, mes y a\u00f1o. Es como la [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:30:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-fonction-dateserial.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\/serie-de-fechas\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba dateserial?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-fonction-dateserial.png\",\"datePublished\":\"2023-10-26T11:14:40+00:00\",\"dateModified\":\"2023-12-25T10:30:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-fonction-dateserial.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-fonction-dateserial.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/#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 dateserial?\"}]},{\"@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 dateserial?","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\/serie-de-fechas\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba dateserial?","og_description":"La funci\u00f3n VBA DATESERIAL aparece en la categor\u00eda de fecha de las funciones de VBA. Cuando lo usa en c\u00f3digo VBA, devuelve una fecha v\u00e1lida seg\u00fan el formato de fecha de VBA seg\u00fan el d\u00eda, mes y a\u00f1o proporcionados . En palabras simples, puedes crear una fecha con d\u00eda, mes y a\u00f1o. Es como la [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:30:18+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-fonction-dateserial.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\/serie-de-fechas\/","url":"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba dateserial?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-fonction-dateserial.png","datePublished":"2023-10-26T11:14:40+00:00","dateModified":"2023-12-25T10:30:18+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/serie-de-fechas\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-fonction-dateserial.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-fonction-dateserial.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/serie-de-fechas\/#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 dateserial?"}]},{"@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\/486","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=486"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/486\/revisions"}],"predecessor-version":[{"id":1249,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/486\/revisions\/1249"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}