{"id":5875,"date":"2025-07-15T13:34:45","date_gmt":"2025-07-15T13:34:45","guid":{"rendered":"https:\/\/functiontranslator.com\/weeknum\/"},"modified":"2021-02-26T10:05:55","modified_gmt":"2021-02-26T10:05:55","slug":"weeknum","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/weeknum\/","title":{"rendered":"WEEKNUM"},"content":{"rendered":"

Funkce WEEKNUM v Microsoft Excel a Google Sheets umo\u017e\u0148uje zjistit \u010d\u00edslo t\u00fddne v roce pro zadan\u00e9 datum. Tato funkce m\u016f\u017ee vyu\u017e\u00edvat r\u016fzn\u00e9 konvence z\u00e1visl\u00e9 na tom, jak\u00fd den je nastaven jako za\u010d\u00e1tek t\u00fddne a jak\u00fdm zp\u016fsobem jsou t\u00fddny v roce \u010d\u00edslov\u00e1ny.<\/p>\n

Popis funkce a syntaxe<\/h2>\n

Z\u00e1kladn\u00ed syntaxe funkce WEEKNUM je n\u00e1sleduj\u00edc\u00ed:<\/p>\n

=WEEKNUM(datum, [prvn\u00ed_den_t\u00fddne])<\/code><\/pre>\n
    \n
  • datum<\/strong> – Argument specifikuj\u00edc\u00ed datum, pro kter\u00e9 chcete ur\u010dit \u010d\u00edslo t\u00fddne. M\u016f\u017ee b\u00fdt zad\u00e1n p\u0159\u00edmo ve form\u00e1tu „dd.mm.rrrr“, odkazem na bu\u0148ku, kter\u00e1 obsahuje datum, nebo jako v\u00fdsledek jin\u00e9 funkce, kter\u00e1 vrac\u00ed datum.<\/li>\n
  • prvn\u00ed_den_t\u00fddne<\/strong> (voliteln\u00fd) – \u010c\u00edseln\u00e1 hodnota ur\u010duj\u00edc\u00ed, kter\u00fd den je pova\u017eov\u00e1n za prvn\u00ed den t\u00fddne. Ve v\u00fdchoz\u00edm nastaven\u00ed (1) je to ned\u011ble, ale m\u016f\u017eete zvolit pond\u011bl\u00ed (2) nebo jin\u00fd den.<\/li>\n<\/ul>\n
    V\u011bzte, \u017ee Excel ve v\u00fdchoz\u00edm nastaven\u00ed ur\u010duje prvn\u00ed t\u00fdden roku jako t\u00fdden obsahuj\u00edc\u00ed prvn\u00ed lednov\u00fd den. Na druhou stranu, Google Sheets vyu\u017e\u00edv\u00e1 ISO 8601, evropsk\u00fd standard, podle kter\u00e9ho mus\u00ed prvn\u00ed t\u00fdden roku za\u010d\u00ednat v pond\u011bl\u00ed a obsahovat 4. ledna.<\/p>\n
    Praktick\u00e9 uk\u00e1zky pou\u017eit\u00ed funkce<\/h2>\n
    P\u0159\u00edklad 1: Zji\u0161t\u011bn\u00ed \u010d\u00edsla t\u00fddne pro aktu\u00e1ln\u00ed datum<\/b><\/p>\n\n\n\n\n
    A<\/td>\nB<\/td>\n<\/tr>\n
    Datum<\/td>\nV\u00fdpo\u010det \u010c\u00edsla T\u00fddne<\/td>\n<\/tr>\n
    12.10.2023<\/td>\n=WEEKNUM(A2)<\/td>\n<\/tr>\n<\/table>\n
    V tomto p\u0159\u00edkladu funkce WEEKNUM ur\u010d\u00ed, \u017ee \u010d\u00edslo t\u00fddne pro datum 12.10.2023 je t\u00fdden za\u010d\u00ednaj\u00edc\u00ed v ned\u011bli.<\/p>\n
    P\u0159\u00edklad 2: Pou\u017eit\u00ed voliteln\u00e9ho argumentu k ur\u010den\u00ed prvn\u00edho dne t\u00fddne<\/b><\/p>\n
    Cell A1: 01.01.2023 Cell B1: =WEEKNUM(A1, 2)<\/code><\/pre>\n
    Funkce WEEKNUM zde vypo\u010d\u00edt\u00e1 \u010d\u00edslo t\u00fddne pro datum 01.01.2023 s definic\u00ed pond\u011bl\u00ed (2) jako prvn\u00edho dne t\u00fddne, co\u017e je b\u011b\u017en\u00e9 v n\u011bkter\u00fdch kultur\u00e1ch, kde t\u00fdden za\u010d\u00edn\u00e1 pr\u00e1v\u011b v pond\u011bl\u00ed.<\/p>\n
    Rozum\u011bn\u00ed manipulaci s t\u00fddny v Excelu a Google Sheets je kl\u00ed\u010dov\u00e9 pro efektivn\u00ed organizaci, anal\u00fdzu \u010dasov\u00fdch dat a pl\u00e1nov\u00e1n\u00ed projekt\u016f \u010di ud\u00e1lost\u00ed podle t\u00fddenn\u00edch interval\u016f, co\u017e je velmi u\u017eite\u010dn\u00e9 pro t\u00fddenn\u00ed reporty a dal\u0161\u00ed pl\u00e1novac\u00ed aktivity.<\/p>\n","protected":false},"excerpt":{"rendered":"
    P\u0159evede po\u0159adov\u00e9 \u010d\u00edslo na \u010d\u00edslo p\u0159edstavuj\u00edc\u00ed \u010d\u00edselnou pozici t\u00fddne v\u00a0roce<\/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-5875","post","type-post","status-publish","format-standard","hentry","category-datum-a-cas"],"acf":[],"yoast_head":"\nFunkce WEEKNUM v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije WEEKNUM 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\/weeknum\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce WEEKNUM v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije WEEKNUM u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/weeknum\/\" \/>\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-26T10:05:55+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce WEEKNUM 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\/weeknum\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/weeknum\/\",\"name\":\"Funkce WEEKNUM 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-26T10:05:55+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije WEEKNUM u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/weeknum\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/weeknum\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/weeknum\/#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\":\"WEEKNUM\"}]},{\"@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 WEEKNUM v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije WEEKNUM 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\/weeknum\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce WEEKNUM v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije WEEKNUM u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/weeknum\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:45+00:00","article_modified_time":"2021-02-26T10:05:55+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce WEEKNUM 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\/weeknum\/","url":"https:\/\/functiontranslator.com\/cs\/weeknum\/","name":"Funkce WEEKNUM 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-26T10:05:55+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije WEEKNUM u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/weeknum\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/weeknum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/weeknum\/#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":"WEEKNUM"}]},{"@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\/5875","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=5875"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5875\/revisions"}],"predecessor-version":[{"id":31009,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5875\/revisions\/31009"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}