{"id":14059,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/iso-num-de-semana\/"},"modified":"2021-02-26T08:52:54","modified_gmt":"2021-02-26T08:52:54","slug":"isoweeknum","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/isoweeknum\/","title":{"rendered":"ISO.NUM.DE.SEMANA"},"content":{"rendered":"<p>La funci\u00f3n ISOWEEKNUM en Microsoft Excel y \u201cISO.NUM.DE.SEMANA\u201d en Google Sheets se emplea para calcular el n\u00famero de semana del a\u00f1o de una fecha determinada, de acuerdo con la norma ISO 8601. Esta norma establece que la semana 1 es aquella que contiene al menos cuatro d\u00edas del nuevo a\u00f1o y que los lunes son considerados el primer d\u00eda de la semana. Este detalle es particularmente valioso en contextos de planificaci\u00f3n empresarial y financiera donde el seguimiento semanal es indispensable.<\/p>\n<h2>Sintaxis y Ejemplos<\/h2>\n<p>La sintaxis de esta funci\u00f3n es sencilla:<\/p>\n<ul>\n<li>En Excel: <code>ISOWEEKNUM(fecha)<\/code><\/li>\n<li>En Google Sheets: <code>ISO.NUM.DE.SEMANA(fecha)<\/code><\/li>\n<\/ul>\n<p>En ambos casos, el par\u00e1metro <code>fecha<\/code> corresponde a la fecha que se desea evaluar. Puede ser una fecha proporcionada directamente como argumento o bien una referencia a una celda que contiene una fecha.<\/p>\n<p>Ejemplo en Excel:<\/p>\n<pre> <code> =ISOWEEKNUM(\"2023-12-03\") <\/code> <\/pre>\n<p>Este ejemplo devuelve 48, se\u00f1alando que el 3 de diciembre de 2023 pertenece a la semana n\u00famero 48 de acuerdo con la norma ISO.<\/p>\n<p>Ejemplo en Google Sheets:<\/p>\n<pre> <code> =ISO.NUM.DE.SEMANA(\"2023-12-03\") <\/code> <\/pre>\n<p>Esta f\u00f3rmula retorna igualmente 48, ya que el c\u00e1lculo se basa en las mismas normas mencionadas.<\/p>\n<h2>Aplicaciones pr\u00e1cticas<\/h2>\n<p>A continuaci\u00f3n se presentan dos escenarios pr\u00e1cticos donde la funci\u00f3n ISOWEEKNUM o ISO.NUM.DE.SEMANA es particularmente \u00fatil.<\/p>\n<h2>C\u00e1lculo de la planificaci\u00f3n semanal en log\u00edstica<\/h2>\n<p>En el sector log\u00edstico, es crucial planificar las entregas y recogidas semana a semana. Imaginemos que necesitamos saber en qu\u00e9 semana del a\u00f1o caen ciertas fechas para organizar mejor las operaciones.<\/p>\n<p>Ejemplo:<\/p>\n<pre> <code> A B Fecha Semana del A\u00f1o 2023-11-01 =ISOWEEKNUM(A2) 2023-11-08 =ISOWEEKNUM(A3) 2023-11-15 =ISOWEEKNUM(A4) <\/code> <\/pre>\n<p>Simplemente incluimos las fechas en la columna A y utilizamos la funci\u00f3n ISOWEEKNUM en la columna B para determinar el n\u00famero de semana correspondiente.<\/p>\n<h2>An\u00e1lisis financiero por semanas<\/h2>\n<p>Para un analista financiero, puede resultar \u00fatil segmentar el rendimiento econ\u00f3mico semanalmente. Si disponemos de datos de ventas diarias, podr\u00edamos calcular las ventas semanales utilizando ISOWEEKNUM.<\/p>\n<p>Ejemplo:<\/p>\n<table>\n<tr>\n<th>Fecha<\/th>\n<th>Ventas<\/th>\n<th>Semana del a\u00f1o<\/th>\n<\/tr>\n<tr>\n<td>2023-11-01<\/td>\n<td>$5000<\/td>\n<td>=ISOWEEKNUM(A2)<\/td>\n<\/tr>\n<tr>\n<td>2023-11-02<\/td>\n<td>$3000<\/td>\n<td>=ISOWEEKNUM(A3)<\/td>\n<\/tr>\n<p> <!-- M\u00e1s filas seg\u00fan sea necesario --> <\/table>\n<p>Con esta informaci\u00f3n, podr\u00edamos emplear funciones adicionales para sumar las ventas de la misma semana y analizar las tendencias.<\/p>\n<p>En definitiva, la funci\u00f3n ISOWEEKNUM en Excel y su equivalente en Google Sheets son herramientas extremadamente valiosas para la gesti\u00f3n y an\u00e1lisis de datos que requieren una organizaci\u00f3n semanal seg\u00fan la norma ISO 8601.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Devuelve el n\u00famero de semana ISO del a\u00f1o para una fecha determinada<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[546],"tags":[],"class_list":["post-14059","post","type-post","status-publish","format-standard","hentry","category-fecha-y-hora"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Funci\u00f3n ISOWEEKNUM (ISO.NUM.DE.SEMANA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n ISOWEEKNUM (ISO.NUM.DE.SEMANA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/es\/isoweeknum\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n ISOWEEKNUM (ISO.NUM.DE.SEMANA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n ISOWEEKNUM (ISO.NUM.DE.SEMANA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/isoweeknum\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:52:54+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n ISOWEEKNUM (ISO.NUM.DE.SEMANA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/isoweeknum\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/isoweeknum\/\",\"name\":\"Funci\u00f3n ISOWEEKNUM (ISO.NUM.DE.SEMANA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:52:54+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n ISOWEEKNUM (ISO.NUM.DE.SEMANA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/isoweeknum\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/isoweeknum\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/isoweeknum\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fecha y hora\",\"item\":\"https:\/\/functiontranslator.com\/es\/fecha-y-hora\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ISO.NUM.DE.SEMANA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n ISOWEEKNUM (ISO.NUM.DE.SEMANA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n ISOWEEKNUM (ISO.NUM.DE.SEMANA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","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:\/\/functiontranslator.com\/es\/isoweeknum\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n ISOWEEKNUM (ISO.NUM.DE.SEMANA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n ISOWEEKNUM (ISO.NUM.DE.SEMANA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/isoweeknum\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:52:54+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n ISOWEEKNUM (ISO.NUM.DE.SEMANA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/isoweeknum\/","url":"https:\/\/functiontranslator.com\/es\/isoweeknum\/","name":"Funci\u00f3n ISOWEEKNUM (ISO.NUM.DE.SEMANA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:52:54+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n ISOWEEKNUM (ISO.NUM.DE.SEMANA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/isoweeknum\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/isoweeknum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/isoweeknum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Fecha y hora","item":"https:\/\/functiontranslator.com\/es\/fecha-y-hora\/"},{"@type":"ListItem","position":3,"name":"ISO.NUM.DE.SEMANA"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14059","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=14059"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14059\/revisions"}],"predecessor-version":[{"id":21962,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14059\/revisions\/21962"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14059"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14059"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}