{"id":15359,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/gunsay\/"},"modified":"2021-02-25T16:25:18","modified_gmt":"2021-02-25T16:25:18","slug":"days","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/days\/","title":{"rendered":"G\u00dcNSAY"},"content":{"rendered":"<p>Microsoft Excel ve Google Sheets, g\u00fcn\u00fcm\u00fczde neredeyse herkes taraf\u0131ndan kullan\u0131lan, veri i\u015flemek ve analiz etmek i\u00e7in g\u00fc\u00e7l\u00fc ara\u00e7lard\u0131r. Bu makalede, her iki platformda da kullan\u0131lan <strong>DAYS<\/strong> (G\u00dcNSAY) fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 ve bu fonksiyonun pratik uygulamalar\u0131n\u0131 inceleyece\u011fiz.<\/p>\n<h2>S\u00f6zdizimi ve Temel Kullan\u0131m<\/h2>\n<p><strong>DAYS<\/strong> fonksiyonu, iki tarih aras\u0131ndaki g\u00fcn say\u0131s\u0131n\u0131 hesaplamak amac\u0131yla kullan\u0131l\u0131r. Genellikle, projelerin s\u00fcresini hesaplama veya farkl\u0131 tarihler aras\u0131ndaki zaman aral\u0131klar\u0131n\u0131 analiz etme gibi \u00e7e\u015fitli durumlar i\u00e7in tercih edilir.<\/p>\n<ul>\n<li><strong>S\u00f6zdizimi:<\/strong>\n<pre><code>DAYS(son_tarih, ba\u015flang\u0131\u00e7_tarih)<\/code><\/pre>\n<\/li>\n<li><strong>son_tarih:<\/strong> Aral\u0131\u011f\u0131n sonunu temsil eden tarih. Bu tarih, ba\u015flang\u0131\u00e7 tarihinden sonra olmal\u0131d\u0131r.<\/li>\n<li><strong>ba\u015flang\u0131\u00e7_tarih:<\/strong> Aral\u0131\u011f\u0131n ba\u015flang\u0131c\u0131n\u0131 temsil eden tarih.<\/li>\n<\/ul>\n<p>\u00d6rnek kullan\u0131m:<\/p>\n<pre><code>=DAYS(\"2023-12-31\", \"2023-01-01\")<\/code><\/pre>\n<p>Bu form\u00fcl, 2023 y\u0131l\u0131n\u0131n ilk g\u00fcn\u00fc ile son g\u00fcn\u00fc aras\u0131ndaki toplam g\u00fcn say\u0131s\u0131n\u0131 hesaplar ve sonu\u00e7 365 g\u00fcn olarak \u00e7\u0131kar.<\/p>\n<h2>Pratik Uygulamalar<\/h2>\n<h2>Bir Projenin S\u00fcresini Hesaplama<\/h2>\n<p>Bir projenin ba\u015flang\u0131\u00e7 ve biti\u015f tarihleri bilindi\u011finde, projenin toplam s\u00fcresini g\u00fcn olarak hesaplamak i\u00e7in <strong>DAYS<\/strong> fonksiyonu kullan\u0131labilir.<\/p>\n<p>\u00d6rnek Soru: Bir in\u015faat projesi 2023-05-01&#8217;de ba\u015flam\u0131\u015f ve 2023-12-01&#8217;de tamamlanm\u0131\u015ft\u0131r. Projenin toplam s\u00fcresini hesaplay\u0131n\u0131z.<\/p>\n<pre><code>=DAYS(\"2023-12-01\", \"2023-05-01\")<\/code><\/pre>\n<p>Bu form\u00fcl, belirtilen tarihler aras\u0131nda ge\u00e7en toplam g\u00fcn say\u0131s\u0131n\u0131 hesaplar, yani 214 g\u00fcn.<\/p>\n<h2>Tatillerin S\u00fcresini \u00d6l\u00e7me<\/h2>\n<p>Tatil sezonlar\u0131nda ka\u00e7 g\u00fcn tatil yap\u0131ld\u0131\u011f\u0131n\u0131 hesaplamak i\u00e7in <strong>DAYS<\/strong> fonksiyonu kullan\u0131labilir.<\/p>\n<p>\u00d6rnek Soru: Bir \u00e7al\u0131\u015fan\u0131n y\u0131ll\u0131k izin olarak 2023-08-01&#8217;den 2023-08-15&#8217;e kadar olan d\u00f6nemi kullanm\u0131\u015f oldu\u011funu varsayal\u0131m. \u00c7al\u0131\u015fan\u0131n toplam izin g\u00fcn say\u0131s\u0131n\u0131 hesaplay\u0131n\u0131z.<\/p>\n<pre><code>=DAYS(\"2023-08-15\", \"2023-08-01\")<\/code><\/pre>\n<p>Bu form\u00fcl, \u00e7al\u0131\u015fan\u0131n izin olarak kulland\u0131\u011f\u0131 toplam g\u00fcn say\u0131s\u0131n\u0131 g\u00f6sterir, yani 14 g\u00fcn.<\/p>\n<p>Excel ve Google Sheets ile bu fonksiyon, tarih aral\u0131klar\u0131 \u00fczerinde \u00e7al\u0131\u015f\u0131rken b\u00fcy\u00fck kolayl\u0131k sa\u011flar ve projeler, tatiller ya da herhangi bir etkinlik planlamas\u0131 yaparken i\u015fleri basitle\u015ftirir. Her iki platformda da bu fonksiyon ayn\u0131 \u015fekilde i\u015flev g\u00f6r\u00fcr ve sonu\u00e7lar\u0131 do\u011frudan tarih farklar\u0131 olarak verir.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0130ki tarih aras\u0131ndaki g\u00fcn 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-15359","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 DAYS (G\u00dcNSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da DAYS (G\u00dcNSAY) 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\/days\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de DAYS (G\u00dcNSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da DAYS (G\u00dcNSAY) 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\/days\/\" \/>\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:25:18+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 DAYS (G\u00dcNSAY) 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\/days\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/days\/\",\"name\":\"Excel'de DAYS (G\u00dcNSAY) 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:25:18+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DAYS (G\u00dcNSAY) 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\/days\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/days\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/days\/#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\":\"G\u00dcNSAY\"}]},{\"@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 DAYS (G\u00dcNSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DAYS (G\u00dcNSAY) 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\/days\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DAYS (G\u00dcNSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DAYS (G\u00dcNSAY) 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\/days\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:25:18+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DAYS (G\u00dcNSAY) 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\/days\/","url":"https:\/\/functiontranslator.com\/tr\/days\/","name":"Excel'de DAYS (G\u00dcNSAY) 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:25:18+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DAYS (G\u00dcNSAY) 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\/days\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/days\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/days\/#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":"G\u00dcNSAY"}]},{"@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\/15359","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=15359"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15359\/revisions"}],"predecessor-version":[{"id":26627,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15359\/revisions\/26627"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}