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

Microsoft Excel ve Google Sheets, finans, muhasebe ve genel veri analizi gibi \u00e7e\u015fitli alanlarda yayg\u0131n olarak kullan\u0131lan iki pop\u00fcler elektronik tablo program\u0131d\u0131r. Bu ara\u00e7lar, kullan\u0131c\u0131lar\u0131n veri y\u00f6netimi g\u00f6revlerini kolayla\u015ft\u0131rmak amac\u0131yla zengin i\u015flevler sunar. NETWORKDAYS.INTL<\/code> veya T\u00fcrk\u00e7e ad\u0131yla TAM\u0130\u015eG\u00dcN\u00dc.ULUSL<\/code> fonksiyonu, belirli bir ba\u015flang\u0131\u00e7 ve biti\u015f tarihi aras\u0131ndaki tam i\u015f g\u00fcn\u00fc say\u0131s\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, \u00f6zellikle i\u015f g\u00fcn\u00fc hesaplamalar\u0131 ve projelerin zaman y\u00f6netimi i\u00e7in b\u00fcy\u00fck fayda sa\u011flar.<\/p>\n

Kullan\u0131m S\u00f6zdizimi ve Parametreleri<\/h2>\n

NETWORKDAYS.INTL(ba\u015flang\u0131\u00e7_tarihi, biti\u015f_tarihi, [haftaSonlar\u0131], [tatiller])<\/code><\/p>\n

    \n
  • ba\u015flang\u0131\u00e7_tarihi:<\/strong> \u0130\u015f g\u00fcn\u00fc hesaplamalar\u0131n\u0131 ba\u015flatacak tarihi belirtir.<\/li>\n
  • biti\u015f_tarihi:<\/strong> \u0130\u015f g\u00fcn\u00fc hesaplamalar\u0131n\u0131n biti\u015f tarihini g\u00f6sterir.<\/li>\n
  • haftaSonlar\u0131 (opsiyonel):<\/strong> Hangi g\u00fcnlerin hafta sonu olarak de\u011ferlendirilece\u011fini tan\u0131mlar. \u00d6rne\u011fin, Cumartesi ve Pazar i\u00e7in “1” (varsay\u0131lan), yaln\u0131zca Pazar i\u00e7in “11” gibi bir numara veya dize kullan\u0131l\u0131r.<\/li>\n
  • tatiller (opsiyonel):<\/strong> \u0130\u015f g\u00fcn\u00fc hesaplamalar\u0131ndan \u00e7\u0131kar\u0131lacak \u00f6zel tatil g\u00fcnleri. Bu, bir h\u00fccre aral\u0131\u011f\u0131 veya tarihler listesi \u015feklinde belirtilebilir.<\/li>\n<\/ul>\n

    \u00d6rnek Kullan\u0131m:<\/p>\n

    TAM\u0130\u015eG\u00dcN\u00dc.ULUSL(\"1\/1\/2023\", \"1\/31\/2023\", 1, A2:A4)<\/code><\/pre>\n
    Bu \u00f6rnekte, Ocak 2023 boyunca olan i\u015f g\u00fcn\u00fc say\u0131s\u0131 hesaplan\u0131r; A2:A4 h\u00fccre aral\u0131\u011f\u0131nda belirtilen \u00f6zel tatiller hari\u00e7tir.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    1. Proje Zaman \u00c7izelgesi Hesaplama<\/h3>\n
    Proje y\u00f6neticileri, projelerin ba\u015flang\u0131\u00e7 ve biti\u015f tarihleri aras\u0131ndaki i\u015f g\u00fcn\u00fc say\u0131s\u0131n\u0131 tahmin etmek i\u00e7in bu fonksiyonu kullanabilirler. Diyelim ki bir proje 2 Ocak 2023’te ba\u015fl\u0131yor ve 28 \u015eubat 2023’te sona eriyor:<\/p>\n
    TAM\u0130\u015eG\u00dcN\u00dc.ULUSL(\"1\/2\/2023\", \"2\/28\/2023\")<\/code><\/pre>\n
    Bu hesaplama, Ocak ve \u015eubat aylar\u0131 i\u00e7in toplam i\u015f g\u00fcn\u00fc say\u0131s\u0131n\u0131 verir.<\/p>\n
    2. \u0130zin G\u00fcnleri Hesaplama<\/h3>\n
    \u0130nsan kaynaklar\u0131 departmanlar\u0131, \u00e7al\u0131\u015fanlar\u0131n i\u015fe ba\u015flad\u0131\u011f\u0131 tarihten itibaren ger\u00e7ekle\u015fecek toplam i\u015f g\u00fcnlerini hesaplamak i\u00e7in bu fonksiyonu kullanabilir. \u00d6rne\u011fin, bir \u00e7al\u0131\u015fan 1 Mart 2023’te i\u015fe ba\u015flam\u0131\u015f ve hesaplama tarihi olarak 31 Aral\u0131k 2023 d\u00fc\u015f\u00fcn\u00fcld\u00fc\u011f\u00fcnde:<\/p>\n
    TAM\u0130\u015eG\u00dcN\u00dc.ULUSL(\"3\/1\/2023\", \"12\/31\/2023\")<\/code><\/pre>\n
    Bu, belirtilen d\u00f6nemde toplam i\u015f g\u00fcnlerini hesaplar, \u00f6zel tatiller ise iste\u011fe ba\u011fl\u0131 olarak fonksiyona eklenebilir.<\/p>\n
    Bu fonksiyon, i\u015f g\u00fcnlerinin hesaplanmas\u0131n\u0131 kolayla\u015ft\u0131rarak zaman ve \u00e7aba tasarrufu sa\u011flar, ayr\u0131ca planlamalar\u0131n daha do\u011fru yap\u0131lmas\u0131na olanak tan\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u0130ki tarih aras\u0131ndaki hangi g\u00fcnlerin ve ka\u00e7 g\u00fcn\u00fcn tatil g\u00fcn\u00fc oldu\u011funu belirtmek i\u00e7in bu iki tarih aras\u0131ndaki tam i\u015f 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-15552","post","type-post","status-publish","format-standard","hentry","category-tarih-ve-saat"],"acf":[],"yoast_head":"\nExcel'de NETWORKDAYS.INTL (TAM\u0130\u015eG\u00dcN\u00dc.ULUSL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da NETWORKDAYS.INTL (TAM\u0130\u015eG\u00dcN\u00dc.ULUSL) 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-intl\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de NETWORKDAYS.INTL (TAM\u0130\u015eG\u00dcN\u00dc.ULUSL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da NETWORKDAYS.INTL (TAM\u0130\u015eG\u00dcN\u00dc.ULUSL) 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-intl\/\" \/>\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:40+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.INTL (TAM\u0130\u015eG\u00dcN\u00dc.ULUSL) 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-intl\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/networkdays-intl\/\",\"name\":\"Excel'de NETWORKDAYS.INTL (TAM\u0130\u015eG\u00dcN\u00dc.ULUSL) 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:40+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da NETWORKDAYS.INTL (TAM\u0130\u015eG\u00dcN\u00dc.ULUSL) 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-intl\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/networkdays-intl\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/networkdays-intl\/#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.ULUSL\"}]},{\"@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.INTL (TAM\u0130\u015eG\u00dcN\u00dc.ULUSL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da NETWORKDAYS.INTL (TAM\u0130\u015eG\u00dcN\u00dc.ULUSL) 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-intl\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de NETWORKDAYS.INTL (TAM\u0130\u015eG\u00dcN\u00dc.ULUSL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da NETWORKDAYS.INTL (TAM\u0130\u015eG\u00dcN\u00dc.ULUSL) 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-intl\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:32:40+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de NETWORKDAYS.INTL (TAM\u0130\u015eG\u00dcN\u00dc.ULUSL) 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-intl\/","url":"https:\/\/functiontranslator.com\/tr\/networkdays-intl\/","name":"Excel'de NETWORKDAYS.INTL (TAM\u0130\u015eG\u00dcN\u00dc.ULUSL) 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:40+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da NETWORKDAYS.INTL (TAM\u0130\u015eG\u00dcN\u00dc.ULUSL) 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-intl\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/networkdays-intl\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/networkdays-intl\/#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.ULUSL"}]},{"@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\/15552","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=15552"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15552\/revisions"}],"predecessor-version":[{"id":26820,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15552\/revisions\/26820"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}