{"id":219,"date":"2023-11-11T11:20:49","date_gmt":"2023-11-11T11:20:49","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/"},"modified":"2023-12-25T10:32:52","modified_gmt":"2023-12-25T10:32:52","slug":"dias-de-cuenta-regresiva","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/","title":{"rendered":"D\u00edas de cuenta regresiva en excel"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3445938940\"><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>Para escribir una f\u00f3rmula de cuenta regresiva en Excel, debe especificar una fecha para la cual desea crear la cuenta regresiva. Adem\u00e1s de esto, debe utilizar la funci\u00f3n HOY. Cuando restas la fecha futura de la fecha de hoy, devuelve los d\u00edas restantes. Como est\u00e1s usando HOY, que es vol\u00e1til y actualiza la fecha todos los d\u00edas. Crea una cuenta regresiva para los d\u00edas restantes. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80160\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png\" sizes=\"auto, \" srcset=\"\" alt=\"cuenta regresiva\" width=\"596\" height=\"217\"><\/figure>\n<\/div>\n<p> En este tutorial, aprenderemos c\u00f3mo escribir esta f\u00f3rmula.<\/p>\n<h2 class=\"wp-block-heading\"> F\u00f3rmula de Excel para obtener la cuenta regresiva de los d\u00edas restantes.<\/h2>\n<p> Puede utilizar los pasos a continuaci\u00f3n:<\/p>\n<ol type=\"1\">\n<li> Primero, ingrese (=) es igual a en una celda para iniciar la f\u00f3rmula.<\/li>\n<li> Despu\u00e9s de eso, consulte la celda donde tiene la fecha.<\/li>\n<li> Luego, ingresa el signo (-) para restar.<\/li>\n<li> Ahora ingrese a la funci\u00f3n HOY sin ning\u00fan argumento.<\/li>\n<li> Al final, presione Enter para obtener el resultado. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80161\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-obtenir-le-compte-a-rebours-des-jours-restants.png\" sizes=\"auto, \" srcset=\"\" alt=\"obtener cuenta regresiva de los d\u00edas restantes\" width=\"535\" height=\"234\"><\/figure>\n<\/div>\n<p> Una vez que presiona Enter, devuelve la cantidad de d\u00edas restantes desde la fecha futura que especific\u00f3. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1-TODAY()<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80162\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-a-renvoye-le-nombre-de-jours.png\" sizes=\"auto, \" srcset=\"\" alt=\"devuelto-la-cuenta-de-dias\" width=\"580\" height=\"258\"><\/figure>\n<\/div>\n<p> En este ejemplo, la fecha es el 10 de febrero de 2023 y la fecha devuelta por TODAY es el 18 de enero de 2023. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80163\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-date-de-retour.png\" sizes=\"auto, \" srcset=\"\" alt=\"Fecha de regreso\" width=\"469\" height=\"224\"><\/figure>\n<\/div>\n<p> Y cuando lo descuentas de la fecha futura, obtienes los d\u00edas restantes.<\/p>\n<p> Como mencion\u00e9 anteriormente, HOY es una funci\u00f3n vol\u00e1til, y cuando la fecha cambia en su sistema, tambi\u00e9n cambia la fecha devuelta por \u00e9l, convirti\u00e9ndola en una cuenta regresiva.<\/p>\n<p> Para que el resultado de la f\u00f3rmula sea m\u00e1s significativo, puede combinarlo con el valor de la prueba. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80164\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-combiner-la-formule-avec-la-valeur-du-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"combinar-f\u00f3rmula-con-valor-de-texto\" width=\"612\" height=\"232\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1-TODAY()&amp;\" day(s) remaning.\"<\/code><\/pre>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compte-a-rebours.xlsx\" rel=\"nofollow\">Descargar<\/a><\/p>\n<\/div>\n<div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-50d07e0d\">\n<div class=\"gb-container gb-container-50d07e0d\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/agregar-la-fecha-de-la-semana\/\">Semana de suma y resta de una fecha en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/obtener-el-nombre-del-dia\/\">Obtener el nombre del d\u00eda a partir de una fecha en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/dias-del-mes\/\">Obtener el n\u00famero total de d\u00edas de meses en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/meses-dias-laborables\/\">D\u00edas laborables en un mes.<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fecha-al-texto-2\/\">Convertir fecha a texto<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-5b4a0cf9\">\n<div class=\"gb-container gb-container-5b4a0cf9\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Para escribir una f\u00f3rmula de cuenta regresiva en Excel, debe especificar una fecha para la cual desea crear la cuenta regresiva. Adem\u00e1s de esto, debe utilizar la funci\u00f3n HOY. Cuando restas la fecha futura de la fecha de hoy, devuelve los d\u00edas restantes. Como est\u00e1s usando HOY, que es vol\u00e1til y actualiza la fecha todos [&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-219","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>D\u00edas de cuenta regresiva en excel<\/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\/dias-de-cuenta-regresiva\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"D\u00edas de cuenta regresiva en excel\" \/>\n<meta property=\"og:description\" content=\"Para escribir una f\u00f3rmula de cuenta regresiva en Excel, debe especificar una fecha para la cual desea crear la cuenta regresiva. Adem\u00e1s de esto, debe utilizar la funci\u00f3n HOY. Cuando restas la fecha futura de la fecha de hoy, devuelve los d\u00edas restantes. Como est\u00e1s usando HOY, que es vol\u00e1til y actualiza la fecha todos [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:32:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.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=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/\",\"name\":\"D\u00edas de cuenta regresiva en excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png\",\"datePublished\":\"2023-11-11T11:20:49+00:00\",\"dateModified\":\"2023-12-25T10:32:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"D\u00edas de cuenta regresiva en excel\"}]},{\"@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":"D\u00edas de cuenta regresiva en excel","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\/dias-de-cuenta-regresiva\/","og_locale":"es_ES","og_type":"article","og_title":"D\u00edas de cuenta regresiva en excel","og_description":"Para escribir una f\u00f3rmula de cuenta regresiva en Excel, debe especificar una fecha para la cual desea crear la cuenta regresiva. Adem\u00e1s de esto, debe utilizar la funci\u00f3n HOY. Cuando restas la fecha futura de la fecha de hoy, devuelve los d\u00edas restantes. Como est\u00e1s usando HOY, que es vol\u00e1til y actualiza la fecha todos [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:32:52+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/","url":"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/","name":"D\u00edas de cuenta regresiva en excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png","datePublished":"2023-11-11T11:20:49+00:00","dateModified":"2023-12-25T10:32:52+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/dias-de-cuenta-regresiva\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"D\u00edas de cuenta regresiva en excel"}]},{"@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\/219","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=219"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/219\/revisions"}],"predecessor-version":[{"id":1443,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/219\/revisions\/1443"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}