{"id":15334,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kupongun\/"},"modified":"2021-02-25T16:24:16","modified_gmt":"2021-02-25T16:24:16","slug":"coupdays","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/coupdays\/","title":{"rendered":"KUPONG\u00dcN"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, finansal analizlerde geni\u015f olanaklar sunan g\u00fc\u00e7l\u00fc tablolama ara\u00e7lar\u0131d\u0131r. Bu platformlarda bulunan COUPDAYS, yani T\u00fcrk\u00e7e kar\u015f\u0131l\u0131\u011f\u0131yla KUPONG\u00dcN fonksiyonu, bir \u00f6deme d\u00f6nemi boyunca toplam g\u00fcn say\u0131s\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, \u00f6zellikle tahvil piyasas\u0131 analizleri ve farkl\u0131 finansal zaman dilimlerindeki de\u011ferlendirmelerde tercih edilir.<\/p>\n

S\u00f6zdizimi ve Parametreler<\/h2>\n

COUPDAYS fonksiyonunun s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

COUPDAYS(ba\u015flang\u0131\u00e7, biti\u015f, d\u00f6nem_s\u0131kl\u0131\u011f\u0131, [basis])<\/code><\/pre>\n
    \n
  • ba\u015flang\u0131\u00e7:<\/strong> \u00d6deme d\u00f6neminin ba\u015flad\u0131\u011f\u0131 tarih.<\/li>\n
  • biti\u015f:<\/strong> \u00d6deme d\u00f6neminin sona erdi\u011fi tarih.<\/li>\n
  • d\u00f6nem_s\u0131kl\u0131\u011f\u0131:<\/strong> Y\u0131lda ger\u00e7ekle\u015fen kupon \u00f6deme say\u0131s\u0131. Y\u0131ll\u0131k (1), Yar\u0131 y\u0131ll\u0131k (2), \u00dc\u00e7 ayda bir (4) olarak belirlenebilir.<\/li>\n
  • [basis]:<\/strong> (Opsiyonel) G\u00fcn say\u0131m\u0131 i\u00e7in kullan\u0131lan temelin belirtildi\u011fi parametre. E\u011fer belirtilmezse veya 0 girilirse US(NASD) 30\/360, 1 girilirse Ger\u00e7ek\/ger\u00e7ek, 2 girilirse Ger\u00e7ek\/360, 3 girilirse Ger\u00e7ek\/365, 4 girilirse Avrupa 30\/360 kullan\u0131l\u0131r.<\/li>\n<\/ul>\n
    Pratik \u00d6rnekler<\/h2>\n
    \u00d6rnek 1: Tahvil \u00d6deme D\u00f6nemi Hesaplama<\/h2>\n
    Bir yat\u0131r\u0131mc\u0131, 15 Mart 2022 tarihinden itibaren yar\u0131 y\u0131ll\u0131k \u00f6demeler yapan bir tahvil i\u00e7in \u00f6deme d\u00f6nemi i\u00e7indeki g\u00fcn say\u0131s\u0131n\u0131 hesaplamak istiyor. \u00d6deme d\u00f6neminin biti\u015f tarihi 15 Mart 2023 olarak belirlenmi\u015ftir.<\/p>\n
    =COUPDAYS(\"15.03.2022\", \"15.03.2023\", 2)<\/code><\/pre>\n
    Bu form\u00fcl, s\u00f6z konusu tahvilin yar\u0131 y\u0131ll\u0131k \u00f6deme d\u00f6nemi boyunca toplam 183 g\u00fcn oldu\u011funu hesaplar. Burada d\u00f6nem s\u0131kl\u0131\u011f\u0131 olarak 2 (yar\u0131 y\u0131ll\u0131k) se\u00e7ilmi\u015ftir.<\/p>\n
    \u00d6rnek 2: \u00c7e\u015fitli Basis Parametreleri ile D\u00f6nem Hesaplama<\/h2>\n
    Ayn\u0131 tahvil i\u00e7in, farkl\u0131 g\u00fcn say\u0131m temellerini kullanarak \u00f6deme d\u00f6nemi i\u00e7indeki g\u00fcn say\u0131s\u0131n\u0131 hesaplayabiliriz. \u00d6rne\u011fin, basis olarak 1 (Ger\u00e7ek\/ger\u00e7ek) se\u00e7ene\u011finin kullan\u0131ld\u0131\u011f\u0131 bir hesaplama yapal\u0131m:<\/p>\n
    =COUPDAYS(\"15.03.2022\", \"15.03.2023\", 2, 1)<\/code><\/pre>\n
    Bu form\u00fcl, ger\u00e7ek takvim g\u00fcnlerini baz alarak hesapland\u0131\u011f\u0131nda yar\u0131 y\u0131ll\u0131k \u00f6deme d\u00f6nemi i\u00e7in 181 g\u00fcn oldu\u011funu g\u00f6sterir. Ger\u00e7ek g\u00fcn say\u0131s\u0131n\u0131 dikkate almas\u0131, baz\u0131 durumlar i\u00e7in daha do\u011fru sonu\u00e7lar sunar.<\/p>\n
    COUPDAYS fonksiyonu, tahvil yat\u0131r\u0131mlar\u0131n\u0131n y\u00f6netimi ve finansal analizlerde d\u00f6nemsel hesaplamalar yap\u0131lmas\u0131nda olduk\u00e7a etkilidir. Belirli bir d\u00f6nemdeki g\u00fcn say\u0131s\u0131n\u0131 do\u011fru bir \u015fekilde belirlemek, \u00f6deme takvimleri ve faiz hesaplamalar\u0131 i\u00e7in \u00f6nemlidir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Al\u0131\u015f tarihini de i\u00e7ermek \u00fczere, kupon s\u00fcresinde i\u00e7indeki 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":[578],"tags":[],"class_list":["post-15334","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de COUPDAYS (KUPONG\u00dcN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da COUPDAYS (KUPONG\u00dcN) 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\/coupdays\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de COUPDAYS (KUPONG\u00dcN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da COUPDAYS (KUPONG\u00dcN) 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\/coupdays\/\" \/>\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:24:16+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 COUPDAYS (KUPONG\u00dcN) 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\/coupdays\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/coupdays\/\",\"name\":\"Excel'de COUPDAYS (KUPONG\u00dcN) 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:24:16+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da COUPDAYS (KUPONG\u00dcN) 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\/coupdays\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/coupdays\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/coupdays\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finansal\",\"item\":\"https:\/\/functiontranslator.com\/tr\/finansal\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"KUPONG\u00dcN\"}]},{\"@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 COUPDAYS (KUPONG\u00dcN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da COUPDAYS (KUPONG\u00dcN) 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\/coupdays\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de COUPDAYS (KUPONG\u00dcN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da COUPDAYS (KUPONG\u00dcN) 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\/coupdays\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:24:16+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de COUPDAYS (KUPONG\u00dcN) 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\/coupdays\/","url":"https:\/\/functiontranslator.com\/tr\/coupdays\/","name":"Excel'de COUPDAYS (KUPONG\u00dcN) 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:24:16+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da COUPDAYS (KUPONG\u00dcN) 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\/coupdays\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/coupdays\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/coupdays\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Finansal","item":"https:\/\/functiontranslator.com\/tr\/finansal\/"},{"@type":"ListItem","position":3,"name":"KUPONG\u00dcN"}]},{"@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\/15334","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=15334"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15334\/revisions"}],"predecessor-version":[{"id":26602,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15334\/revisions\/26602"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}