{"id":109,"date":"2023-11-16T09:18:33","date_gmt":"2023-11-16T09:18:33","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/"},"modified":"2023-12-25T10:26:30","modified_gmt":"2023-12-25T10:26:30","slug":"obtenga-2-anos-de-servicio","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/","title":{"rendered":"\u00bfc\u00f3mo obtengo el n\u00famero de a\u00f1os de servicio?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1271098045\"><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>Este tutorial lo guiar\u00e1 a trav\u00e9s del proceso de creaci\u00f3n de una f\u00f3rmula en Excel para calcular los a\u00f1os de servicio. La herramienta que utilizar\u00e1 para esta tarea es la funci\u00f3n DATEDIF. Si no est\u00e1s familiarizado con esta funci\u00f3n, la entender\u00e1s mejor si contin\u00faas leyendo.<\/p>\n<h2 class=\"wp-block-heading\"> Obtenga el n\u00famero de a\u00f1os de servicio.<\/h2>\n<p> En el siguiente ejemplo, tenemos una fecha de inicio y una fecha de finalizaci\u00f3n. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64911\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.png\" sizes=\"auto, \" srcset=\"\" alt=\"a\u00f1o de servicio\" width=\"478\" height=\"304\"><\/figure>\n<\/div>\n<p> Y ahora usemos los siguientes pasos:<\/p>\n<ol type=\"1\">\n<li> Escriba \u201c= <a href=\"https:\/\/exceladvisor.org\/es\/fecha-si\/\">DATEDIF<\/a> (\u201d en la celda C2.<\/li>\n<li> Consulte la fecha de inicio, que es A2, e ingrese un comando.<\/li>\n<li> Consulte la fecha de finalizaci\u00f3n, que es B2, e ingrese un comando.<\/li>\n<li> Ingrese \u00aby\u00bb, ingrese los par\u00e9ntesis de cierre y 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-64912\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-obtenir-lannee-de-service.png\" sizes=\"auto, \" srcset=\"\" alt=\"obtener a\u00f1o de servicio\" width=\"490\" height=\"465\"><\/figure>\n<\/div>\n<p> D\u00e9jame explicarte: cuando usas \u00aby\u00bb en la funci\u00f3n DATEDIF, devuelve el a\u00f1o completo que tienes entre la fecha de inicio y la fecha de finalizaci\u00f3n.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATEDIF(A2,B2,\"y\")<\/code><\/pre>\n<p> Ahora digamos que desea obtener un per\u00edodo de servicio completo entre dos fechas, incluido el a\u00f1o, el mes y las fechas. Puedes utilizar la siguiente f\u00f3rmula. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATEDIF(A2,B2,\"y\")&amp;\" year(s), \"&amp;DATEDIF(A2,B2,\"ym\")&amp;\" months(s), \"&amp;DATEDIF(A2,B2,\"md\")&amp;\" days(s).\"<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64913\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-ans-mois-date-de-service.png\" sizes=\"auto, \" srcset=\"\" alt=\"obtener-a\u00f1os-meses-fecha-de-servicio\" width=\"765\" height=\"182\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Obtenga a\u00f1os de servicio a partir de la fecha de hoy<\/h2>\n<p> Ahora digamos que desea calcular los a\u00f1os de servicio utilizando la fecha de hoy. Aqu\u00ed est\u00e1 la f\u00f3rmula que debes utilizar. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATEDIF(A2,TODAY(),\"y\")&amp;\" year(s)\"<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64914\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-obtenez-une-annee-de-service-a-partir-daujourdhui.png\" sizes=\"auto, \" srcset=\"\" alt=\"obtener-a\u00f1o-de-servicio-comenzando-hoy\" width=\"576\" height=\"430\"><\/figure>\n<\/div>\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-des-annees-de-service.xlsx\" rel=\"nofollow\">Descargar<\/a><\/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\/obtener-el-numero-del-dia-del-ano\/\">Obtener el n\u00famero de d\u00edas del a\u00f1o 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>Este tutorial lo guiar\u00e1 a trav\u00e9s del proceso de creaci\u00f3n de una f\u00f3rmula en Excel para calcular los a\u00f1os de servicio. La herramienta que utilizar\u00e1 para esta tarea es la funci\u00f3n DATEDIF. Si no est\u00e1s familiarizado con esta funci\u00f3n, la entender\u00e1s mejor si contin\u00faas leyendo. Obtenga el n\u00famero de a\u00f1os de servicio. En el siguiente [&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-109","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 obtengo el n\u00famero de a\u00f1os de servicio?<\/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\/obtenga-2-anos-de-servicio\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo obtengo el n\u00famero de a\u00f1os de servicio?\" \/>\n<meta property=\"og:description\" content=\"Este tutorial lo guiar\u00e1 a trav\u00e9s del proceso de creaci\u00f3n de una f\u00f3rmula en Excel para calcular los a\u00f1os de servicio. La herramienta que utilizar\u00e1 para esta tarea es la funci\u00f3n DATEDIF. Si no est\u00e1s familiarizado con esta funci\u00f3n, la entender\u00e1s mejor si contin\u00faas leyendo. Obtenga el n\u00famero de a\u00f1os de servicio. En el siguiente [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:26:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.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\/obtenga-2-anos-de-servicio\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/\",\"name\":\"\u00bfc\u00f3mo obtengo el n\u00famero de a\u00f1os de servicio?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.png\",\"datePublished\":\"2023-11-16T09:18:33+00:00\",\"dateModified\":\"2023-12-25T10:26:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo obtengo el n\u00famero de a\u00f1os de servicio?\"}]},{\"@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 obtengo el n\u00famero de a\u00f1os de servicio?","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\/obtenga-2-anos-de-servicio\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo obtengo el n\u00famero de a\u00f1os de servicio?","og_description":"Este tutorial lo guiar\u00e1 a trav\u00e9s del proceso de creaci\u00f3n de una f\u00f3rmula en Excel para calcular los a\u00f1os de servicio. La herramienta que utilizar\u00e1 para esta tarea es la funci\u00f3n DATEDIF. Si no est\u00e1s familiarizado con esta funci\u00f3n, la entender\u00e1s mejor si contin\u00faas leyendo. Obtenga el n\u00famero de a\u00f1os de servicio. En el siguiente [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:26:30+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.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\/obtenga-2-anos-de-servicio\/","url":"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/","name":"\u00bfc\u00f3mo obtengo el n\u00famero de a\u00f1os de servicio?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.png","datePublished":"2023-11-16T09:18:33+00:00","dateModified":"2023-12-25T10:26:30+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/obtenga-2-anos-de-servicio\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo obtengo el n\u00famero de a\u00f1os de servicio?"}]},{"@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\/109","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=109"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/109\/revisions"}],"predecessor-version":[{"id":1144,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/109\/revisions\/1144"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}