{"id":5666,"date":"2025-07-15T13:34:45","date_gmt":"2025-07-15T13:34:45","guid":{"rendered":"https:\/\/functiontranslator.com\/isoweeknum\/"},"modified":"2021-02-26T09:58:33","modified_gmt":"2021-02-26T09:58:33","slug":"isoweeknum","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/isoweeknum\/","title":{"rendered":"ISOWEEKNUM"},"content":{"rendered":"

Funkce ISOWEEKNUM<\/strong> v Microsoft Excel a Google Sheets je nezbytn\u00fdm n\u00e1strojem pro zji\u0161t\u011bn\u00ed ISO \u010d\u00edsla t\u00fddne odpov\u00eddaj\u00edc\u00edho zadan\u00e9mu datu. Podle ISO normy za\u010d\u00edn\u00e1 t\u00fdden v pond\u011bl\u00ed a prvn\u00ed t\u00fdden roku je t\u00fdden obsahuj\u00edc\u00ed prvn\u00ed \u010dtvrtek nov\u00e9ho roku. Tato funkcionalita je kl\u00ed\u010dov\u00e1 pro \u00fa\u010dely finan\u010dn\u00ed anal\u00fdzy, pl\u00e1nov\u00e1n\u00ed projekt\u016f a dal\u0161\u00ed aplikace, kde je d\u016fle\u017eit\u00e9 sledovat data v souladu s mezin\u00e1rodn\u00edm standardem t\u00fddne.<\/p>\n

Syntaxe a p\u0159\u00edklady<\/h2>\n

Syntaxe funkce ISOWEEKNUM je n\u00e1sleduj\u00edc\u00ed:<\/p>\n

ISOWEEKNUM(datum)<\/code><\/pre>\n
Tady datum<\/code> p\u0159edstavuje konkr\u00e9tn\u00ed datum, pro kter\u00e9 chcete zjistit ISO \u010d\u00edslo t\u00fddne. Datum m\u016f\u017eete zadat p\u0159\u00edmo jako text ve form\u00e1tu akceptovan\u00e9m syst\u00e9mem Excel nebo Google Sheets, nebo m\u016f\u017ee b\u00fdt zad\u00e1no odkazem na bu\u0148ku obsahuj\u00edc\u00ed datum.<\/p>\n
P\u0159\u00edklad pou\u017eit\u00ed funkce:<\/p>\n
    \n
  • Pokud m\u00e1me v bu\u0148ce A1 datum 2023-12-25<\/code>, zjist\u00edme ISO \u010d\u00edslo t\u00fddne vlo\u017een\u00edm n\u00e1sleduj\u00edc\u00ed formule do bu\u0148ky B1:<\/li>\n<\/ul>\n
    =ISOWEEKNUM(A1)<\/code><\/pre>\n
    V\u00fdsledkem v bu\u0148ce B1 bude \u010d\u00edslo 52, kter\u00e9 ukazuje, \u017ee 25. prosinec 2023 spad\u00e1 do 52. t\u00fddne podle ISO standardu.<\/p>\n
    Praktick\u00e9 p\u0159\u00edklady pou\u017eit\u00ed<\/h2>\n
    P\u0159\u00edklad 1: Pl\u00e1nov\u00e1n\u00ed projektu
     P\u0159i pl\u00e1nov\u00e1n\u00ed projektu s kl\u00ed\u010dov\u00fdmi miln\u00edky m\u016f\u017eete tento n\u00e1stroj vyu\u017e\u00edt k ur\u010den\u00ed, do kter\u00e9ho t\u00fddne ka\u017ed\u00fd miln\u00edk p\u0159ipad\u00e1. To umo\u017e\u0148uje efektivn\u011bj\u0161\u00ed koordinaci \u010dasov\u00e9ho pl\u00e1nu.<\/p>\n\n\n\n\n
    Datum miln\u00edku<\/th>\nISO t\u00fdden<\/th>\n<\/tr>\n
    2023-01-15<\/td>\n=ISOWEEKNUM(„2023-01-15“)<\/td>\n<\/tr>\n
    2023-04-23<\/td>\n=ISOWEEKNUM(„2023-04-23“)<\/td>\n<\/tr>\n<\/table>\n
    Na z\u00e1klad\u011b t\u00e9to tabulky lze l\u00e9pe pl\u00e1novat zdroje a p\u0159i\u0159azovat \u00fakoly v souladu s t\u00fddny, kdy maj\u00ed miln\u00edky zarazeny.<\/p>\n
    P\u0159\u00edklad 2: T\u00fddenn\u00ed finan\u010dn\u00ed reporty
     Pokud vedete finan\u010dn\u00ed z\u00e1znamy a pot\u0159ebujete generovat t\u00fddenn\u00ed reporty, funkce ISOWEEKNUM v\u00e1m m\u016f\u017ee usnadnit identifikaci t\u00fddne roku pro ka\u017ed\u00fd z\u00e1znam, co\u017e umo\u017e\u0148uje jednodu\u0161\u0161\u00ed seskupen\u00ed transakc\u00ed podle t\u00fdden.<\/p>\n
    P\u0159\u00edklad tabulky pro zaznamen\u00e1v\u00e1n\u00ed transakc\u00ed:<\/p>\n\n\n\n\n
    Datum transakce<\/th>\nISO t\u00fdden<\/th>\n\u010c\u00e1stka<\/th>\n<\/tr>\n
    2023-03-01<\/td>\n=ISOWEEKNUM(„2023-03-01“)<\/td>\n1500 K\u010d<\/td>\n<\/tr>\n
    2023-03-08<\/td>\n=ISOWEEKNUM(„2023-03-08“)<\/td>\n2000 K\u010d<\/td>\n<\/tr>\n<\/table>\n
    Tabulka umo\u017e\u0148uje efektivn\u011b agregovat finan\u010dn\u00ed \u00fadaje a zjednodu\u0161it tvorbu t\u00fddenn\u00edch finan\u010dn\u00edch report\u016f za ur\u010dit\u00e9 obdob\u00ed.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Pro dan\u00e9 datum vr\u00e1t\u00ed \u010d\u00edslo t\u00fddne v\u00a0roce podle standardu ISO<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[293],"tags":[],"class_list":["post-5666","post","type-post","status-publish","format-standard","hentry","category-datum-a-cas"],"acf":[],"yoast_head":"\nFunkce ISOWEEKNUM v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije ISOWEEKNUM u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\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\/cs\/isoweeknum\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce ISOWEEKNUM v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije ISOWEEKNUM u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/isoweeknum\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T09:58:33+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce ISOWEEKNUM v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/isoweeknum\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/isoweeknum\/\",\"name\":\"Funkce ISOWEEKNUM v Excelu: jak funguje, primjeri kori\u0161tenja formule\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:45+00:00\",\"dateModified\":\"2021-02-26T09:58:33+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije ISOWEEKNUM u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/isoweeknum\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/isoweeknum\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/isoweeknum\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Datum a\u00a0\u010das\",\"item\":\"https:\/\/functiontranslator.com\/cs\/datum-a-cas\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ISOWEEKNUM\"}]},{\"@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\":\"cs\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@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\/cs\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funkce ISOWEEKNUM v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije ISOWEEKNUM u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","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\/cs\/isoweeknum\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce ISOWEEKNUM v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije ISOWEEKNUM u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/isoweeknum\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:45+00:00","article_modified_time":"2021-02-26T09:58:33+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce ISOWEEKNUM v Excelu: jak funguje, primjeri kori\u0161tenja formule","twitter_misc":{"Napsal(a)":"glavadmin","Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/cs\/isoweeknum\/","url":"https:\/\/functiontranslator.com\/cs\/isoweeknum\/","name":"Funkce ISOWEEKNUM v Excelu: jak funguje, primjeri kori\u0161tenja formule","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:45+00:00","dateModified":"2021-02-26T09:58:33+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije ISOWEEKNUM u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/isoweeknum\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/isoweeknum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/isoweeknum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"Datum a\u00a0\u010das","item":"https:\/\/functiontranslator.com\/cs\/datum-a-cas\/"},{"@type":"ListItem","position":3,"name":"ISOWEEKNUM"}]},{"@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":"cs"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"cs","@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\/cs\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/comments?post=5666"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5666\/revisions"}],"predecessor-version":[{"id":30804,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5666\/revisions\/30804"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}