{"id":4009,"date":"2018-04-26T04:00:12","date_gmt":"2018-04-26T09:00:12","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=4009"},"modified":"2024-09-06T14:39:31","modified_gmt":"2024-09-06T19:39:31","slug":"excel-avanzado-capitulo-16","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/","title":{"rendered":"Excel Avanzado &#8211; Capitulo 16"},"content":{"rendered":"<h3 style=\"text-align: center;\"><span style=\"vertical-align: inherit;\"><span style=\"vertical-align: inherit;\">CONTROL DE FECHAS (DATE Y NOW)<\/span><\/span><\/h3>\n<div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe title=\"Curso Excel Avanzado - Capitulo 16, Administrar Fechas (Date y Now) en Macros\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/30sdqGF4vhQ?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/div>\n<p>Aprende a obtener autom\u00e1ticamente una fecha en VBA de excel, convertir texto a fecha, separar o fragmentar fechas en d\u00edas, meses, a\u00f1os, horas, minutos y segundos, sumar fechas entre si, comprobar que sea una fecha entre muchos temas que veremos en este cap\u00edtulo para despejar todas las dudas sobre este tema tan \u00abtedioso\u00bb pero sencillo \ud83d\ude09<\/p>\n<p>Este tema llegue a explicarlo muy por encima en un cap\u00edtulo anterior, sin embargo faltaba una explicaci\u00f3n m\u00e1s clara y enfocada en este tema tan importante como lo es la administraci\u00f3n de fechas desde Visual Basic de Excel.<\/p>\n<p>Espero ser claro, el v\u00eddeo se me hizo un poco largo pero creo que vali\u00f3 la pena ya que se abordan los temas necesario para trabajar fechas en los proyectos de VBA de excel.<\/p>\n<hr \/>\n<h5 style=\"text-align: center;\"><strong>DESCARGAR MATERIAL DE APOYO<\/strong><\/h5>\n<h6 style=\"text-align: center;\">Descarga el archivo que vemos en el v\u00eddeo desde los siguientes enlaces<\/h6>\n<p style=\"text-align: center;\"><a href=\"https:\/\/mega.nz\/#!mgZ2HSaa!x5h0NsTlMK-JFDO_eEzR-3jcga4qAjKV9yv_26vWbrM\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"alignnone wp-image-3936 size-full\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/icono_mega.png\" alt=\"Descargar desde Mega\" width=\"185\" height=\"47\" \/><\/a>\u00a0<a href=\"http:\/\/www.mediafire.com\/file\/3zszqrue7acs92p\/curso_excel_avanzado_capitulo_16.zip\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"alignnone wp-image-3938 size-full\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/icono_mediafire.png\" alt=\"Descargar desde MediaFire\" width=\"185\" height=\"47\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/dostinhurtado.com\/material_de_apoyo\/curso_excel_avanzado\/curso_excel_avanzado_capitulo_16.zip\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter wp-image-3937 size-full\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/icono_directa.png\" alt=\"Descarga Directa\" width=\"185\" height=\"47\" \/><\/a><\/p>\n<h6 style=\"text-align: center;\"><strong><a href=\"https:\/\/mega.nz\/#!mgZ2HSaa!x5h0NsTlMK-JFDO_eEzR-3jcga4qAjKV9yv_26vWbrM\" target=\"_blank\" rel=\"noopener noreferrer\">Mega<\/a> | <a href=\"http:\/\/www.mediafire.com\/file\/3zszqrue7acs92p\/curso_excel_avanzado_capitulo_16.zip\" target=\"_blank\" rel=\"noopener noreferrer\">MediaFire <\/a>| <a href=\"https:\/\/dostinhurtado.com\/material_de_apoyo\/curso_excel_avanzado\/curso_excel_avanzado_capitulo_16.zip\" target=\"_blank\" rel=\"noopener noreferrer\">Descarga Directa<\/a><\/strong><\/h6>\n<hr \/>\n<p style=\"text-align: center;\"><a class=\"btn btn-default\" href=\"https:\/\/dostinhurtado.com\/site\/cursos\/curso-excel-avanzado\/excel-avanzado-capitulo-15\/\">Cap\u00edtulo Anterior<\/a>\u00a0<a class=\"btn btn-primary\" href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos\/curso-excel-avanzado\/\">Lista de Cap\u00edtulos<\/a>\u00a0<a class=\"btn btn-default\" href=\"https:\/\/dostinhurtado.com\/site\/cursos\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/\">Cap\u00edtulo Siguiente<\/a><\/p>\n<hr \/>\n","protected":false},"excerpt":{"rendered":"<p>CONTROL DE FECHAS (DATE Y NOW) Aprende a obtener autom\u00e1ticamente una fecha en VBA de excel, convertir texto a fecha, [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":4376,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[60],"tags":[225,226,236,331,365,492,494,506],"class_list":["post-4009","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-curso-excel-avanzado","tag-excel","tag-excel-avanzado","tag-fechas","tag-macros","tag-office","tag-userform","tag-validaciones","tag-visual-basic"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Avanzado - Capitulo 16 - Dostin Hurtado<\/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:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Avanzado - Capitulo 16 - Dostin Hurtado\" \/>\n<meta property=\"og:description\" content=\"CONTROL DE FECHAS (DATE Y NOW) Aprende a obtener autom\u00e1ticamente una fecha en VBA de excel, convertir texto a fecha, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-26T09:00:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-06T19:39:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"376\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dostin Hurtado\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dostin Hurtado\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-16\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-16\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\"},\"headline\":\"Excel Avanzado &#8211; Capitulo 16\",\"datePublished\":\"2018-04-26T09:00:12+00:00\",\"dateModified\":\"2024-09-06T19:39:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-16\\\/\"},\"wordCount\":182,\"commentCount\":6,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-16\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/avanzado_16.jpg\",\"keywords\":[\"Excel\",\"Excel Avanzado\",\"Fechas\",\"Macros\",\"office\",\"userform\",\"Validaciones\",\"Visual Basic\"],\"articleSection\":[\"Curso de Excel Avanzado\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-16\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-16\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-16\\\/\",\"name\":\"Excel Avanzado - Capitulo 16 - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-16\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-16\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/avanzado_16.jpg\",\"datePublished\":\"2018-04-26T09:00:12+00:00\",\"dateModified\":\"2024-09-06T19:39:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-16\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-16\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-16\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/avanzado_16.jpg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/avanzado_16.jpg\",\"width\":500,\"height\":376,\"caption\":\"Curso de Excel Avanzado - Capitulo 16\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-16\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Avanzado &#8211; Capitulo 16\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\",\"name\":\"Dostin Hurtado\",\"description\":\"\u00a1El Conocimiento Es para Todos! - Cursos Gratis\",\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\",\"name\":\"Dostin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"width\":65,\"height\":14,\"caption\":\"Dostin\"},\"logo\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\"},\"sameAs\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/moderador\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Avanzado - Capitulo 16 - Dostin Hurtado","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:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/","og_locale":"es_ES","og_type":"article","og_title":"Excel Avanzado - Capitulo 16 - Dostin Hurtado","og_description":"CONTROL DE FECHAS (DATE Y NOW) Aprende a obtener autom\u00e1ticamente una fecha en VBA de excel, convertir texto a fecha, [&hellip;]","og_url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/","og_site_name":"Dostin Hurtado","article_published_time":"2018-04-26T09:00:12+00:00","article_modified_time":"2024-09-06T19:39:31+00:00","og_image":[{"width":500,"height":376,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16.jpg","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc"},"headline":"Excel Avanzado &#8211; Capitulo 16","datePublished":"2018-04-26T09:00:12+00:00","dateModified":"2024-09-06T19:39:31+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/"},"wordCount":182,"commentCount":6,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16.jpg","keywords":["Excel","Excel Avanzado","Fechas","Macros","office","userform","Validaciones","Visual Basic"],"articleSection":["Curso de Excel Avanzado"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/","url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/","name":"Excel Avanzado - Capitulo 16 - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16.jpg","datePublished":"2018-04-26T09:00:12+00:00","dateModified":"2024-09-06T19:39:31+00:00","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16.jpg","width":500,"height":376,"caption":"Curso de Excel Avanzado - Capitulo 16"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Excel Avanzado &#8211; Capitulo 16"}]},{"@type":"WebSite","@id":"https:\/\/dostinhurtado.com\/site\/#website","url":"https:\/\/dostinhurtado.com\/site\/","name":"Dostin Hurtado","description":"\u00a1El Conocimiento Es para Todos! - Cursos Gratis","publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9","name":"Dostin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","width":65,"height":14,"caption":"Dostin"},"logo":{"@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg"},"sameAs":["https:\/\/dostinhurtado.com\/site"]},{"@type":"Person","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16.jpg",500,376,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16-300x226.jpg",300,226,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16.jpg",500,376,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16.jpg",500,376,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16.jpg",500,376,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16.jpg",500,376,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16.jpg",500,376,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16.jpg",500,376,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16.jpg",500,376,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16.jpg",500,376,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16-400x376.jpg",400,376,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16.jpg",500,376,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_16-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":6,"uagb_excerpt":"CONTROL DE FECHAS (DATE Y NOW) Aprende a obtener autom\u00e1ticamente una fecha en VBA de excel, convertir texto a fecha, [&hellip;]","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/4009","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=4009"}],"version-history":[{"count":0,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/4009\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/4376"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=4009"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=4009"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=4009"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}