{"id":15711,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/haftasay\/"},"modified":"2021-02-25T16:39:01","modified_gmt":"2021-02-25T16:39:01","slug":"weeknum","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/weeknum\/","title":{"rendered":"HAFTASAY"},"content":{"rendered":"<h2> Excel ve Google Tablolar&#8217;daki Hafta Numaras\u0131 \u0130\u015flemi<\/h2>\n<p>Excel ve Google Tablolar&#8217;da s\u0131kl\u0131kla kullan\u0131lan fonksiyonlardan biri, belirli bir tarihin bulundu\u011fu haftan\u0131n y\u0131l i\u00e7indeki numaras\u0131n\u0131 d\u00f6nd\u00fcren <code>WEEKNUM<\/code> (Excel&#8217;de) veya <code>HAFTASAY<\/code> (Google Tablolar&#8217;da) fonksiyonudur. Bu fonksiyon, \u00f6zellikle zamanla ilgili veriler \u00fczerinde raporlama ve analiz yaparken \u00e7ok i\u015fe yarar.<\/p>\n<h2> Bu Fonksiyonun Kullan\u0131m S\u00f6zdizimi <\/h2>\n<p>Fonksiyonun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n<pre><code>WEEKNUM(serial_number, [return_type]) HAFTASAY(seri_no, [d\u00f6n\u00fc\u015f_t\u00fcr\u00fc])<\/code><\/pre>\n<ul>\n<li><code>serial_number\/seri_no<\/code>: Hafta numaras\u0131n\u0131 hesaplamak istedi\u011finiz tarihi belirtir.<\/li>\n<li><code>[return_type\/d\u00f6n\u00fc\u015f_t\u00fcr\u00fc]<\/code>: Haftan\u0131n hangi g\u00fcn\u00fcnden itibaren ba\u015flayaca\u011f\u0131n\u0131 g\u00f6steren iste\u011fe ba\u011fl\u0131 bir arg\u00fcmand\u0131r (\u00d6rne\u011fin, 1 i\u00e7in hafta Pazar\u2019dan, 2 i\u00e7in Pazartesi&#8217;den ba\u015flar). Varsay\u0131lan de\u011fer 1\u2019dir.<\/li>\n<\/ul>\n<h2>\u00d6rnek Kullan\u0131mlar<\/h2>\n<p>S\u00f6zdizimini daha iyi anlamak i\u00e7in baz\u0131 \u00f6rnekler \u00fczerinden gidelim:<\/p>\n<pre><code>=HAFTASAY(\"2023-01-01\") \/\/1 d\u00f6ner, \u00e7\u00fcnk\u00fc 2023 y\u0131l\u0131n\u0131n ilk g\u00fcn\u00fc Pazar g\u00fcn\u00fcne denk gelir. =WEEKNUM(\"2023-01-01\", 2) \/\/1 d\u00f6ner, \u00e7\u00fcnk\u00fc 2023 y\u0131l\u0131n\u0131n ilk g\u00fcn\u00fc Pazar oldu\u011fu ve hafta Pazartesi'den ba\u015flad\u0131\u011f\u0131 i\u00e7in ilk haftaday\u0131z.<\/code><\/pre>\n<h2>Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n<h2>Senaryo 1: Proje Takvimi Olu\u015fturma<\/h2>\n<p>Belirli bir projenin ba\u015flang\u0131\u00e7 ve biti\u015f tarihlerini biliyorsan\u0131z, bu tarihler aras\u0131nda ka\u00e7 hafta oldu\u011funu hesaplamak i\u00e7in <code>WEEKNUM<\/code> \/ <code>HAFTASAY<\/code> fonksiyonunu kullanabilirsiniz. \u00d6rne\u011fin, projenin 2023 y\u0131l\u0131n\u0131n ilk g\u00fcn\u00fcnde ba\u015flad\u0131\u011f\u0131n\u0131 ve 150 g\u00fcn sonra bitti\u011fini varsayal\u0131m:<\/p>\n<pre><code>Ba\u015flang\u0131\u00e7 Tarihi = 1.1.2023 Biti\u015f Tarihi = DATE(2023, 5, 31) \/\/ 31 May\u0131s 2023 Ba\u015flang\u0131\u00e7 Haftas\u0131 = WEEKNUM(\"1.1.2023\") Biti\u015f Haftas\u0131 = WEEKNUM(\"31.5.2023\") Toplam Hafta = Biti\u015f Haftas\u0131 - Ba\u015flang\u0131\u00e7 Haftas\u0131 + 1<\/code><\/pre>\n<p>Bu kullan\u0131m, projektan\u0131m s\u00fcresini hafta baz\u0131nda planlamak ve analiz etmek amac\u0131yla kullan\u0131labilir.<\/p>\n<h2>Senaryo 2: Haftal\u0131k Sat\u0131\u015f Raporlar\u0131<\/h2>\n<p>Bir perakende \u015firketinin haftal\u0131k sat\u0131\u015f verilerini analiz etmek i\u00e7in hafta numaras\u0131 bilgisine ihtiya\u00e7 duyabilirsiniz. Tarihe kar\u015f\u0131l\u0131k gelen hafta numaralar\u0131n\u0131 bulmak ve hangi hafta ne kadar sat\u0131\u015f yap\u0131ld\u0131\u011f\u0131n\u0131 g\u00f6stermek i\u00e7in a\u015fa\u011f\u0131daki gibi bir kullan\u0131m m\u00fcmk\u00fcnd\u00fcr:<\/p>\n<pre><code>=HAFTASAY(A2)<\/code><\/pre>\n<p>Burada A2 h\u00fccresi, ilgili sat\u0131\u015f\u0131n yap\u0131ld\u0131\u011f\u0131 tarihi i\u00e7erir. Bu \u015fekilde, t\u00fcm sat\u0131\u015flar\u0131n yap\u0131ld\u0131\u011f\u0131 tarihler i\u00e7in hafta numaralar\u0131n\u0131 hesaplayabilir ve haftal\u0131k sat\u0131\u015f verilerini gruplayabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dizisel de\u011ferini, haftan\u0131n y\u0131l i\u00e7inde bulundu\u011fu konumu say\u0131sal olarak g\u00f6steren say\u0131ya d\u00f6n\u00fc\u015ft\u00fcr\u00fcr<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[588],"tags":[],"class_list":["post-15711","post","type-post","status-publish","format-standard","hentry","category-tarih-ve-saat"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de WEEKNUM (HAFTASAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da WEEKNUM (HAFTASAY) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\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\/tr\/weeknum\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de WEEKNUM (HAFTASAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da WEEKNUM (HAFTASAY) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/weeknum\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:39:01+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de WEEKNUM (HAFTASAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/weeknum\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/weeknum\/\",\"name\":\"Excel'de WEEKNUM (HAFTASAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:39:01+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da WEEKNUM (HAFTASAY) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/weeknum\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/weeknum\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/weeknum\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tarih ve saat\",\"item\":\"https:\/\/functiontranslator.com\/tr\/tarih-ve-saat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"HAFTASAY\"}]},{\"@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\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@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\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de WEEKNUM (HAFTASAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da WEEKNUM (HAFTASAY) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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\/tr\/weeknum\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de WEEKNUM (HAFTASAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da WEEKNUM (HAFTASAY) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/weeknum\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:39:01+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de WEEKNUM (HAFTASAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/weeknum\/","url":"https:\/\/functiontranslator.com\/tr\/weeknum\/","name":"Excel'de WEEKNUM (HAFTASAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:39:01+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da WEEKNUM (HAFTASAY) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/weeknum\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/weeknum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/weeknum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Tarih ve saat","item":"https:\/\/functiontranslator.com\/tr\/tarih-ve-saat\/"},{"@type":"ListItem","position":3,"name":"HAFTASAY"}]},{"@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":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@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\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15711","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15711"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15711\/revisions"}],"predecessor-version":[{"id":26979,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15711\/revisions\/26979"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}