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

Tan\u0131m ve Kullan\u0131m\u0131 \u0130\u015eG\u00dcN\u00dc Fonksiyonunun<\/h2>\n

\u0130\u015eG\u00dcN\u00dc<\/code> fonksiyonu, ba\u015flang\u0131\u00e7 tarihinden belirli bir i\u015f g\u00fcn\u00fc say\u0131s\u0131 kadar sonras\u0131n\u0131 hesaplayarak biti\u015f tarihini belirler. Fonksiyon, hafta sonlar\u0131n\u0131 ve iste\u011fe ba\u011fl\u0131 olarak belirlenen tatil g\u00fcnlerini hesaba katar.<\/p>\n

Fonksiyon S\u00f6zdizimi<\/h2>\n

Microsoft Excel ve Google Sheets’teki S\u00f6zdizimi:<\/strong><\/p>\n

\u0130\u015eG\u00dcN\u00dc(ba\u015flang\u0131\u00e7_tarihi, g\u00fcn_say\u0131s\u0131, [tatiller])<\/code><\/pre>\n
    \n
  • ba\u015flang\u0131\u00e7_tarihi<\/code>: \u0130\u015f g\u00fcn\u00fc hesaplamalar\u0131n\u0131n ba\u015flayaca\u011f\u0131 tarih. Bu tarih do\u011frudan veya ba\u015fka bir h\u00fccre referans\u0131 arac\u0131l\u0131\u011f\u0131yla girilebilir.<\/li>\n
  • g\u00fcn_say\u0131s\u0131<\/code>: Ba\u015flang\u0131\u00e7 tarihinden itibaren hesaplanacak i\u015f g\u00fcn\u00fc say\u0131s\u0131. Pozitif de\u011ferler gelece\u011fe, negatif de\u011ferler ge\u00e7mi\u015fe y\u00f6nelik hesaplamalar i\u00e7in kullan\u0131l\u0131r.<\/li>\n
  • tatiller<\/code>: Opsiyonel. Hesaplamalarda d\u0131\u015far\u0131da tutulacak tatil g\u00fcnleri listesi. Bu liste do\u011frudan tarihlerden olu\u015fan bir liste veya bir h\u00fccre aral\u0131\u011f\u0131 referans\u0131 olarak sa\u011flanabilir.<\/li>\n<\/ul>\n
    Basit Kullan\u0131m \u00d6rne\u011fi<\/h2>\n
    \u00d6rne\u011fin, 1 Aral\u0131k 2023 (1\/12\/2023) tarihinden itibaren 10 i\u015f g\u00fcn\u00fc sonras\u0131n\u0131 hesaplamak isteyelim:<\/p>\n
    =\u0130\u015eG\u00dcN\u00dc(\"1\/12\/2023\", 10)<\/code><\/pre>\n
    Bu form\u00fcl, ba\u015flang\u0131\u00e7 tarihinden sonraki 10 i\u015f g\u00fcn\u00fcn\u00fc hesaplar ve hafta sonlar\u0131n\u0131 dikkate almaz.<\/p>\n\n\n\n
    \u00d6rnek<\/th>\nSonu\u00e7<\/th>\n<\/tr>\n
    =\u0130\u015eG\u00dcN\u00dc(\"1\/12\/2023\", 10)<\/code><\/td>\n15 Aral\u0131k 2023<\/td>\n<\/tr>\n<\/table>\n
    Geli\u015fmi\u015f Kullan\u0131m: Tatil G\u00fcnleri Dahil<\/h2>\n
    10 i\u015f g\u00fcn\u00fc sonras\u0131n\u0131 hesaplarken, 5 Aral\u0131k 2023’\u00fc tatil g\u00fcn\u00fc olarak dahil etmek istedi\u011fimizi varsayal\u0131m:<\/p>\n
    =\u0130\u015eG\u00dcN\u00dc(\"1\/12\/2023\", 10, \"5\/12\/2023\")<\/code><\/pre>\n
    Bu form\u00fclle, 5 Aral\u0131k’taki tatil g\u00fcn\u00fc dikkate al\u0131narak i\u015f g\u00fcn\u00fc hesaplamas\u0131 yap\u0131l\u0131r.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    Senaryo 1: Proje Teslim Tarihini Hesaplama<\/strong><\/p>\n
    Proje ba\u015flang\u0131\u00e7 tarihi 15 Ocak 2022 ve toplamda 25 i\u015f g\u00fcn\u00fc \u00f6ng\u00f6r\u00fcl\u00fcyor. Tatil g\u00fcnleri olarak sadece ulusal bayramlar (23 Nisan, 19 May\u0131s, 30 A\u011fustos ve 29 Ekim) hesaba kat\u0131lacak. Proje teslim tarihi a\u015fa\u011f\u0131daki form\u00fclle hesaplan\u0131r:<\/p>\n
    =\u0130\u015eG\u00dcN\u00dc(\"15\/01\/2022\", 25, {\"23\/04\/2022\", \"19\/05\/2022\", \"30\/08\/2022\", \"29\/10\/2022\"})<\/code><\/pre>\n
    Bu form\u00fcl, ba\u015flang\u0131\u00e7 tarihinden itibaren 25 i\u015f g\u00fcn\u00fc sonras\u0131n\u0131, belirtilen tatil g\u00fcnlerini hari\u00e7 tutarak hesaplar.<\/p>\n
    Senaryo 2: \u0130zin Planlamas\u0131<\/strong><\/p>\n
    Bir \u00e7al\u0131\u015fan, 10 Ocak 2023 tarihinden itibaren 15 i\u015f g\u00fcn\u00fc izin kullanmay\u0131 planl\u0131yor. \u00c7al\u0131\u015fan\u0131n i\u015fe geri d\u00f6nmesi gereken tarihi hesaplay\u0131n\u0131z:<\/p>\n
    =\u0130\u015eG\u00dcN\u00dc(\"10\/01\/2023\", 15)<\/code><\/pre>\n
    Bu form\u00fcl, \u00e7al\u0131\u015fan\u0131n izin ba\u015flang\u0131\u00e7 tarihinden 15 i\u015f g\u00fcn\u00fc sonras\u0131nda i\u015fe d\u00f6nmesi gereken tarihi belirtir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Belirtilen say\u0131da \u00e7al\u0131\u015fma g\u00fcn\u00fc \u00f6ncesinin ya da sonras\u0131n\u0131n tarihinin seri numaras\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-15714","post","type-post","status-publish","format-standard","hentry","category-tarih-ve-saat"],"acf":[],"yoast_head":"\nExcel'de WORKDAY (\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 WORKDAY (\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\/workday\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de WORKDAY (\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 WORKDAY (\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\/workday\/\" \/>\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:07+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 (\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\/workday\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/workday\/\",\"name\":\"Excel'de WORKDAY (\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:52+00:00\",\"dateModified\":\"2021-02-25T16:39:07+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da WORKDAY (\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\/workday\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/workday\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/workday\/#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\"}]},{\"@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 (\u0130\u015eG\u00dcN\u00dc) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da WORKDAY (\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\/workday\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de WORKDAY (\u0130\u015eG\u00dcN\u00dc) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da WORKDAY (\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\/workday\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:39:07+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de WORKDAY (\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\/workday\/","url":"https:\/\/functiontranslator.com\/tr\/workday\/","name":"Excel'de WORKDAY (\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:52+00:00","dateModified":"2021-02-25T16:39:07+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da WORKDAY (\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\/workday\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/workday\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/workday\/#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"}]},{"@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\/15714","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=15714"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15714\/revisions"}],"predecessor-version":[{"id":26982,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15714\/revisions\/26982"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}