{"id":15551,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/tamisgunu\/"},"modified":"2021-02-25T16:32:37","modified_gmt":"2021-02-25T16:32:37","slug":"networkdays","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/networkdays\/","title":{"rendered":"TAM\u0130\u015eG\u00dcN\u00dc"},"content":{"rendered":"

\u00c7al\u0131\u015fma G\u00fcnleri Hesaplama: NETWORKDAYS Fonksiyonu Kullan\u0131m\u0131<\/h1>\n

NETWORKDAYS (TAM\u0130\u015eG\u00dcN\u00dc) fonksiyonu, Microsoft Excel ve Google E-Tablolar’da iki tarih aras\u0131ndaki tam i\u015f g\u00fcn\u00fc say\u0131s\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, hafta sonlar\u0131 ve opsiyonel olarak belirtilen tatil g\u00fcnlerini hesaba katma yetene\u011fi sayesinde, \u00e7al\u0131\u015fma planlamas\u0131 ve maa\u015f hesaplamalar\u0131 gibi i\u015flemlerde olduk\u00e7a faydal\u0131d\u0131r.<\/p>\n

Fonksiyonun S\u00f6zdizimi<\/h2>\n

NETWORKDAYS fonksiyonunun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki \u015fekildedir:<\/p>\n

  NETWORKDAYS(ba\u015flang\u0131\u00e7_tarihi, biti\u015f_tarihi, [tatiller]) <\/code> <\/pre>\n
    \n
  • ba\u015flang\u0131\u00e7_tarihi:<\/strong> \u0130\u015f g\u00fcn\u00fc hesaplamas\u0131n\u0131n ba\u015flayaca\u011f\u0131 tarih.<\/li>\n
  • biti\u015f_tarihi:<\/strong> \u0130\u015f g\u00fcn\u00fc hesaplamas\u0131n\u0131n sonlanaca\u011f\u0131 tarih.<\/li>\n
  • tatiller (iste\u011fe ba\u011fl\u0131):<\/strong> \u0130\u015f g\u00fcn\u00fc hesaplamas\u0131 s\u0131ras\u0131nda dikkate al\u0131nmas\u0131 gereken tatil g\u00fcnlerinin listesi.<\/li>\n<\/ul>\n
    \u0130\u015flevin Uygulama \u00d6rnekleri<\/h2>\n
    \u00d6rnek 1: Standart \u00c7al\u0131\u015fma G\u00fcn\u00fc Hesaplama<\/h3>\n
    1 Ocak 2023’ten 31 Ocak 2023’e kadar olan i\u015f g\u00fcn\u00fc say\u0131s\u0131n\u0131 hesaplayal\u0131m.<\/p>\n
      =NETWORKDAYS(\"2023-01-01\", \"2023-01-31\") <\/code> <\/pre>\n
    Bu form\u00fcl, belirtilen tarihler aras\u0131ndaki hafta sonlar\u0131 hari\u00e7 t\u00fcm g\u00fcnleri hesaplar. E\u011fer tatil g\u00fcnleri de hesaba kat\u0131lacaksa, tatil g\u00fcnlerinin tarihlerini i\u00e7eren bir h\u00fccre aral\u0131\u011f\u0131 da fonksiyona eklenmelidir.<\/p>\n
    \u00d6rnek 2: Tatillerle Birlikte \u00c7al\u0131\u015fma G\u00fcn\u00fc Hesaplama<\/h3>\n
    Varsayal\u0131m ki 1 Ocak 2023 ile 31 Ocak 2023 aras\u0131nda 2 tatil g\u00fcn\u00fc var: 1 Ocak (Y\u0131lba\u015f\u0131) ve 23 Ocak (\u00d6zel bir tatil). Bu tatilleri de hesaba katarak i\u015f g\u00fcn\u00fc say\u0131s\u0131n\u0131 hesaplayal\u0131m.<\/p>\n
      =NETWORKDAYS(\"2023-01-01\", \"2023-01-31\", {\"2023-01-01\", \"2023-01-23\"}) <\/code> <\/pre>\n
    Burada,{“2023-01-01”, “2023-01-23”} tatil g\u00fcnlerinin oldu\u011fu bir dizi. Fonksiyon, bu g\u00fcnleri i\u015f g\u00fcn\u00fc hesaplamas\u0131ndan \u00e7\u0131karacakt\u0131r.<\/p>\n
    Uygulama \u00c7\u00f6z\u00fcmleri ve Yorumlar<\/h2>\n
    \u0130lk \u00f6rnekte, tatil g\u00fcnleri olmadan yap\u0131lan hesaplamada Ocak ay\u0131ndaki tam i\u015f g\u00fcn\u00fc say\u0131s\u0131n\u0131 elde ederiz. \u0130kinci \u00f6rnekte ise, iki tatil g\u00fcn\u00fc fonksiyona eklenmi\u015f ve bu g\u00fcnler toplam i\u015f g\u00fcn\u00fc say\u0131s\u0131ndan d\u00fc\u015f\u00fclm\u00fc\u015ft\u00fcr. B\u00f6ylece daha ger\u00e7ek\u00e7i ve i\u015fe yarar bir \u00e7al\u0131\u015fma takvimi elde etmek m\u00fcmk\u00fcn olur.<\/p>\n
    \u00d6zellikle insan kaynaklar\u0131 ve maa\u015f hesaplama departmanlar\u0131 i\u00e7in bu fonksiyon, izin y\u00f6netimi ve maa\u015f hesaplamalar\u0131nda do\u011fruluk sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u0130ki tarih aras\u0131ndaki tam \u00e7al\u0131\u015fma g\u00fcnlerinin say\u0131s\u0131n\u0131 verir<\/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-15551","post","type-post","status-publish","format-standard","hentry","category-tarih-ve-saat"],"acf":[],"yoast_head":"\nExcel'de NETWORKDAYS (TAM\u0130\u015eG\u00dcN\u00dc) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da NETWORKDAYS (TAM\u0130\u015eG\u00dcN\u00dc) 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\/networkdays\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de NETWORKDAYS (TAM\u0130\u015eG\u00dcN\u00dc) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da NETWORKDAYS (TAM\u0130\u015eG\u00dcN\u00dc) 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\/networkdays\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:32:37+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de NETWORKDAYS (TAM\u0130\u015eG\u00dcN\u00dc) 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\/networkdays\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/networkdays\/\",\"name\":\"Excel'de NETWORKDAYS (TAM\u0130\u015eG\u00dcN\u00dc) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:32:37+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da NETWORKDAYS (TAM\u0130\u015eG\u00dcN\u00dc) 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\/networkdays\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/networkdays\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/networkdays\/#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\":\"TAM\u0130\u015eG\u00dcN\u00dc\"}]},{\"@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 NETWORKDAYS (TAM\u0130\u015eG\u00dcN\u00dc) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da NETWORKDAYS (TAM\u0130\u015eG\u00dcN\u00dc) 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\/networkdays\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de NETWORKDAYS (TAM\u0130\u015eG\u00dcN\u00dc) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da NETWORKDAYS (TAM\u0130\u015eG\u00dcN\u00dc) 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\/networkdays\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:32:37+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de NETWORKDAYS (TAM\u0130\u015eG\u00dcN\u00dc) 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\/networkdays\/","url":"https:\/\/functiontranslator.com\/tr\/networkdays\/","name":"Excel'de NETWORKDAYS (TAM\u0130\u015eG\u00dcN\u00dc) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:32:37+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da NETWORKDAYS (TAM\u0130\u015eG\u00dcN\u00dc) 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\/networkdays\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/networkdays\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/networkdays\/#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":"TAM\u0130\u015eG\u00dcN\u00dc"}]},{"@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\/15551","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=15551"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15551\/revisions"}],"predecessor-version":[{"id":26819,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15551\/revisions\/26819"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}