{"id":15715,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/isgunu-ulusl\/"},"modified":"2021-02-25T16:39:08","modified_gmt":"2021-02-25T16:39:08","slug":"workday-intl","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/workday-intl\/","title":{"rendered":"\u0130\u015eG\u00dcN\u00dc.ULUSL"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, i\u015f hayat\u0131nda s\u0131k\u00e7a kar\u015f\u0131la\u015f\u0131lan zaman planlamalar\u0131 i\u00e7in \u00e7e\u015fitli kullan\u0131\u015fl\u0131 i\u015flevler sunmaktad\u0131r. Bu i\u015flevler aras\u0131nda, Excel’de WORKDAY.INTL ve Google Sheets’te \u0130\u015eG\u00dcN\u00dc.ULUSL fonksiyonlar\u0131 bulunur. Bu fonksiyon, belirli bir ba\u015flang\u0131\u00e7 tarihinden itibaren belirlenen i\u015f g\u00fcn\u00fc say\u0131s\u0131n\u0131 ekleyerek sonucu hangi tarihe denk geldi\u011fini g\u00f6sterir. \u00d6zellikle, tatiller veya hafta sonlar\u0131 gibi \u00e7al\u0131\u015f\u0131lmayan g\u00fcnleri hesaba katarak tarih hesaplamas\u0131 yapar.<\/p>\n

Fonksiyonun S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n

WORKDAY.INTL ve \u0130\u015eG\u00dcN\u00dc.ULUSL fonksiyonlar\u0131n\u0131n s\u00f6zdizimi a\u015fa\u011f\u0131daki gibi olup, parametreleri \u015funlard\u0131r:<\/p>\n

WORKDAY.INTL(ba\u015flang\u0131\u00e7_tarihi, g\u00fcn_say\u0131s\u0131, [hafta_sonlar\u0131], [tatiller])<\/code><\/pre>\n
    \n
  • ba\u015flang\u0131\u00e7_tarihi:<\/strong> \u0130\u015f g\u00fcn\u00fc hesaplamas\u0131n\u0131n ba\u015flayaca\u011f\u0131 tarih. Bu, tarih format\u0131nda girilmelidir.<\/li>\n
  • g\u00fcn_say\u0131s\u0131:<\/strong> Ba\u015flang\u0131\u00e7 tarihinden itibaren hesaplanacak i\u015f g\u00fcn\u00fc say\u0131s\u0131d\u0131r. Pozitif say\u0131lar gelecekteki bir tarihi, negatif say\u0131lar ge\u00e7mi\u015f bir tarihi g\u00f6sterir.<\/li>\n
  • hafta_sonlar\u0131 (iste\u011fe ba\u011fl\u0131):<\/strong> Hangi g\u00fcnlerin hafta sonu kabul edilece\u011fini belirten say\u0131sal veya dize format\u0131ndaki bir kod. \u00d6rne\u011fin, standart olarak “1” (Cumartesi ve Pazar) kullan\u0131l\u0131r.<\/li>\n
  • tatiller (iste\u011fe ba\u011fl\u0131):<\/strong> \u0130\u015f g\u00fcn\u00fc hesaplamas\u0131ndan \u00e7\u0131kar\u0131lacak \u00f6zel tatil g\u00fcnlerini i\u00e7eren bir liste. Tarihler tarih format\u0131nda girilmelidir.<\/li>\n<\/ul>\n
    \u00d6rnek Uygulamalar<\/h2>\n
    Bu fonksiyon, proje planlamas\u0131 ve teslim tarihlerinin belirlenmesi gibi bir\u00e7ok alanda faydal\u0131d\u0131r. A\u015fa\u011f\u0131da iki farkl\u0131 kullan\u0131m \u00f6rne\u011fi bulunmaktad\u0131r:<\/p>\n
    Proje Teslim Tarihinin Hesaplanmas\u0131<\/h2>\n
    Bir projenin ba\u015flang\u0131\u00e7 tarihi olan 1 Ocak 2023\u2019ten ba\u015flayarak 10 i\u015f g\u00fcn\u00fc gerekti\u011fini d\u00fc\u015f\u00fcnelim. Hafta sonlar\u0131 ve tatiller i\u015f g\u00fcn\u00fc hesab\u0131na dahil edilmeyecektir.<\/p>\n
    =\u0130\u015eG\u00dcN\u00dc.ULUSL(\"2023-01-01\", 10)<\/code><\/pre>\n
    Bu form\u00fcl kullan\u0131ld\u0131\u011f\u0131nda, hafta sonlar\u0131 ve belirtilmemi\u015f di\u011fer tatiller hari\u00e7, projenin teslim tarihinin 14 Ocak 2023 oldu\u011funu g\u00f6rebiliriz.<\/p>\n
    Tatil G\u00fcnleri ile Hesaplama Yapma<\/h2>\n
    Bir di\u011fer senaryoda, ba\u015flang\u0131\u00e7 tarihi yine 1 Ocak 2023 olsun, ancak bu kez 6 Ocak\u2019taki bir tatili de dikkate alarak 10 i\u015f g\u00fcn\u00fc sonras\u0131n\u0131 hesaplayal\u0131m.<\/p>\n
    =\u0130\u015eG\u00dcN\u00dc.ULUSL(\"2023-01-01\", 10, 1, \"2023-01-06\")<\/code><\/pre>\n
    Burada yap\u0131lan hesaplama, 1 Ocak ve 6 Ocak’taki tatil dikkate al\u0131narak yap\u0131ld\u0131\u011f\u0131 i\u00e7in, sonu\u00e7 16 Ocak 2023 Pazartesi g\u00fcn\u00fc olarak belirlenir, \u00e7\u00fcnk\u00fc 15 Ocak Pazar g\u00fcn\u00fc hafta sonuna denk gelmektedir.<\/p>\n
    Bu fonksiyonlar, i\u015f takvimlerinin y\u00f6netimi ve mal teslimat s\u00fcreleri gibi de\u011fi\u015fik senaryolarda olduk\u00e7a i\u015flevsel olarak kullan\u0131lmaktad\u0131r. Fonksiyonun esnek yap\u0131s\u0131, \u00e7e\u015fitli tatil ve hafta sonu durumlar\u0131n\u0131n kolayca y\u00f6netilmesini sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Hangi g\u00fcnlerin ve ka\u00e7 g\u00fcn\u00fcn tatil g\u00fcn\u00fc oldu\u011funu belirtmek i\u00e7in belirtilen i\u015f g\u00fcn\u00fc say\u0131s\u0131n\u0131n \u00f6ncesi ve sonras\u0131ndaki tarihin seri numaras\u0131n\u0131 parametre kullanarak 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-15715","post","type-post","status-publish","format-standard","hentry","category-tarih-ve-saat"],"acf":[],"yoast_head":"\nExcel'de WORKDAY.INTL (\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 WORKDAY.INTL (\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\/workday-intl\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de WORKDAY.INTL (\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 WORKDAY.INTL (\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\/workday-intl\/\" \/>\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:08+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 WORKDAY.INTL (\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\/workday-intl\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/workday-intl\/\",\"name\":\"Excel'de WORKDAY.INTL (\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:52+00:00\",\"dateModified\":\"2021-02-25T16:39:08+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da WORKDAY.INTL (\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\/workday-intl\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/workday-intl\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/workday-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\":\"\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 WORKDAY.INTL (\u0130\u015eG\u00dcN\u00dc.ULUSL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da WORKDAY.INTL (\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\/workday-intl\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de WORKDAY.INTL (\u0130\u015eG\u00dcN\u00dc.ULUSL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da WORKDAY.INTL (\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\/workday-intl\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:39:08+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de WORKDAY.INTL (\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\/workday-intl\/","url":"https:\/\/functiontranslator.com\/tr\/workday-intl\/","name":"Excel'de WORKDAY.INTL (\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:52+00:00","dateModified":"2021-02-25T16:39:08+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da WORKDAY.INTL (\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\/workday-intl\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/workday-intl\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/workday-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":"\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\/15715","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=15715"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15715\/revisions"}],"predecessor-version":[{"id":26983,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15715\/revisions\/26983"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}