{"id":139,"date":"2023-11-15T11:10:08","date_gmt":"2023-11-15T11:10:08","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/"},"modified":"2023-12-25T10:25:15","modified_gmt":"2023-12-25T10:25:15","slug":"obtener-el-numero-del-dia-del-ano","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/","title":{"rendered":"\u00bfc\u00f3mo extraer d\u00edas de una fecha en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2016462584\"><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>Un a\u00f1o tiene 365 o 366 d\u00edas (a\u00f1o bisiesto). Y en este tutorial aprender\u00e1 c\u00f3mo obtener el n\u00famero de d\u00eda del a\u00f1o para una fecha. Esto significa cu\u00e1l es el n\u00famero de d\u00edas en 365 o 366 d\u00edas.<\/p>\n<h2 class=\"wp-block-heading\"> Calcular el n\u00famero de d\u00edas para una fecha.<\/h2>\n<p> Para escribir una f\u00f3rmula para obtener un n\u00famero de d\u00eda, siga los pasos a continuaci\u00f3n.<\/p>\n<ol type=\"1\">\n<li> Consulte la celda A1 donde tiene la fecha.<\/li>\n<li> Ahora escriba el signo menos (-) y luego ingrese la funci\u00f3n de fecha.<\/li>\n<li> En la funci\u00f3n de fecha, utilice m\u00e1s la funci\u00f3n de a\u00f1o y luego consulte la celda A1.<\/li>\n<li> En el segundo argumento ingrese 1 y en el \u00faltimo argumento ingrese 0.<\/li>\n<li> Ingrese los par\u00e9ntesis de cierre y presione Enter.<\/li>\n<\/ol>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1-DATE(YEAR(A1),1,0)<\/code><\/pre>\n<p> Como puede ver, tenemos el 2 de abril de 2022 en la celda A1 y la f\u00f3rmula que utilizamos arroj\u00f3 92 en el resultado. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64202\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"calcular-d\u00eda-n\u00famero-de-fecha\" width=\"416\" height=\"250\"><\/figure>\n<\/div>\n<p> Ahora entendamos esta f\u00f3rmula. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64203\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formule-pour-obtenir-le-numero-de-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"formula-para-obtener-el-numero-del-dia\" width=\"598\" height=\"217\"><\/figure>\n<\/div>\n<p> En la primera parte tenemos la funci\u00f3n de fecha que utiliz\u00f3 y que devuelve la \u00faltima fecha del a\u00f1o anterior. Entonces, como tenemos la fecha del a\u00f1o 2022, la funci\u00f3n de fecha devuelve 31 de diciembre de 2021. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64204\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-premiere-partie-de-la-formule-du-numero-de-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula de numeraci\u00f3n para la primera parte del d\u00eda\" width=\"522\" height=\"262\"><\/figure>\n<\/div>\n<p> Cuando restas el 31 de diciembre de 2021 del 02 de abril de 2022 obtienes 92 en el resultado que es el n\u00famero de d\u00eda del 02 de abril de 2022 del a\u00f1o 2022.<\/p>\n<p> Hay un punto que debes recordar: Excel almacena una fecha como un n\u00famero. Cuando ingresa 1 en una celda y le da formato de fecha, Excel lo muestra como 01 de enero de 1990.<\/p>\n<p> Ahora el n\u00famero para la fecha 02 de abril de 2022 es 44653 y para el 31 de diciembre de 2021 es 44561, y la diferencia entre ambos n\u00fameros es 92. <\/p>\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\/obtenir-le-numero-du-jour.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-anos-hasta-la-fecha\/\">Agregar a\u00f1os hasta la fecha en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contar-los-anos-entre-dos-fechas\/\">Contar a\u00f1os entre dos fechas en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/\">Obtenga a\u00f1os de servicio en Excel<\/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\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/anos-entre-fechas\/\">A\u00f1os entre fechas en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/extraer-ano-mes\/\">Extraer (Obtener) el a\u00f1o o mes de una fecha en Excel<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Un a\u00f1o tiene 365 o 366 d\u00edas (a\u00f1o bisiesto). Y en este tutorial aprender\u00e1 c\u00f3mo obtener el n\u00famero de d\u00eda del a\u00f1o para una fecha. Esto significa cu\u00e1l es el n\u00famero de d\u00edas en 365 o 366 d\u00edas. Calcular el n\u00famero de d\u00edas para una fecha. Para escribir una f\u00f3rmula para obtener un n\u00famero de [&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-139","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 extraer d\u00edas de una fecha 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\/obtener-el-numero-del-dia-del-ano\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo extraer d\u00edas de una fecha en excel?\" \/>\n<meta property=\"og:description\" content=\"Un a\u00f1o tiene 365 o 366 d\u00edas (a\u00f1o bisiesto). Y en este tutorial aprender\u00e1 c\u00f3mo obtener el n\u00famero de d\u00eda del a\u00f1o para una fecha. Esto significa cu\u00e1l es el n\u00famero de d\u00edas en 365 o 366 d\u00edas. Calcular el n\u00famero de d\u00edas para una fecha. Para escribir una f\u00f3rmula para obtener un n\u00famero de [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:25:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.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\/obtener-el-numero-del-dia-del-ano\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/\",\"name\":\"\u00bfc\u00f3mo extraer d\u00edas de una fecha en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.png\",\"datePublished\":\"2023-11-15T11:10:08+00:00\",\"dateModified\":\"2023-12-25T10:25:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo extraer d\u00edas de una fecha 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":"\u00bfc\u00f3mo extraer d\u00edas de una fecha 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\/obtener-el-numero-del-dia-del-ano\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo extraer d\u00edas de una fecha en excel?","og_description":"Un a\u00f1o tiene 365 o 366 d\u00edas (a\u00f1o bisiesto). Y en este tutorial aprender\u00e1 c\u00f3mo obtener el n\u00famero de d\u00eda del a\u00f1o para una fecha. Esto significa cu\u00e1l es el n\u00famero de d\u00edas en 365 o 366 d\u00edas. Calcular el n\u00famero de d\u00edas para una fecha. Para escribir una f\u00f3rmula para obtener un n\u00famero de [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:25:15+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.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\/obtener-el-numero-del-dia-del-ano\/","url":"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/","name":"\u00bfc\u00f3mo extraer d\u00edas de una fecha en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.png","datePublished":"2023-11-15T11:10:08+00:00","dateModified":"2023-12-25T10:25:15+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-date-numero-de-date.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/obtener-el-numero-del-dia-del-ano\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo extraer d\u00edas de una fecha 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\/139","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=139"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/139\/revisions"}],"predecessor-version":[{"id":1030,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/139\/revisions\/1030"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}