{"id":15360,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/gun360\/"},"modified":"2021-02-25T16:25:21","modified_gmt":"2021-02-25T16:25:21","slug":"days360","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/days360\/","title":{"rendered":"G\u00dcN360"},"content":{"rendered":"<h2>Temel Tan\u0131m ve Yap\u0131s\u0131 G\u00dcN360 Fonksiyonu<\/h2>\n<p>Microsoft Excel ve Google Sheets&#8217;te G\u00dcN360 fonksiyonu, finansal analizlerde her ay\u0131 30 g\u00fcn olarak kabul ederek iki tarih aras\u0131ndaki g\u00fcn say\u0131s\u0131n\u0131 hesaplar. Bu fonksiyon, \u00f6zellikle muhasebe ve finans sekt\u00f6rlerinde amortisman hesaplamalar\u0131 ve kredi \u00f6deme planlamalar\u0131 gibi alanlarda yayg\u0131n olarak kullan\u0131l\u0131r.<\/p>\n<h2>S\u00f6zdizimi ve Parametreler<\/h2>\n<p><code>G\u00dcN360(ba\u015flang\u0131\u00e7_tarihi, biti\u015f_tarihi, [y\u00f6ntem])<\/code><\/p>\n<ul>\n<li><b>ba\u015flang\u0131\u00e7_tarihi:<\/b> Zaman aral\u0131\u011f\u0131n\u0131n ba\u015flad\u0131\u011f\u0131 tarihi belirtir.<\/li>\n<li><b>biti\u015f_tarihi:<\/b> Zaman aral\u0131\u011f\u0131n\u0131n sona erdi\u011fi tarihi belirtir.<\/li>\n<li><b>y\u00f6ntem (iste\u011fe ba\u011fl\u0131):<\/b> \u0130ki hesaplama y\u00f6nteminden Amerikan (US) veya Avrupai (EU) y\u00f6ntemlerinden birini se\u00e7er. E\u011fer bu parametre belirtilmezse, varsay\u0131lan olarak Amerikan y\u00f6ntemi uygulan\u0131r.<\/li>\n<\/ul>\n<pre> \u00d6rnek Kullan\u0131m: <code>=G\u00dcN360(\"2022-01-01\", \"2022-12-31\")<\/code> \u00c7\u0131kt\u0131: 360 <\/pre>\n<h2>Uygulama \u00d6rnekleri<\/h2>\n<p>A\u015fa\u011f\u0131da G\u00dcN360 fonksiyonunun pratikte nas\u0131l kullan\u0131labilece\u011fine dair iki \u00f6rnek bulunmaktad\u0131r:<\/p>\n<h2>1. Amortisman Takvimi Hesaplama<\/h2>\n<p>Bir firma, 1 Ocak 2022 tarihinde al\u0131nm\u0131\u015f bir ekipman\u0131n 3 y\u0131l s\u00fcreyle amortisman\u0131n\u0131 hesaplamak istiyor.<\/p>\n<pre> <code>=G\u00dcN360(\"2022-01-01\", \"2025-01-01\")<\/code> <\/pre>\n<p>Bu form\u00fcl, belirlenen tarihler aras\u0131ndaki toplam g\u00fcn say\u0131s\u0131n\u0131n 1080 g\u00fcn (3 y\u0131l x 360 g\u00fcn) oldu\u011funu hesaplar ve bu, ekipman\u0131n y\u0131ll\u0131k amortisman miktar\u0131n\u0131n hesaplanmas\u0131nda kullan\u0131labilir.<\/p>\n<h2>2. Kredi Taksit Planlamas\u0131<\/h2>\n<p>Bir kredi kullan\u0131c\u0131s\u0131n\u0131n, 5 y\u0131l vadeli ve y\u0131ll\u0131k 360 g\u00fcn esas\u0131na g\u00f6re hesaplanm\u0131\u015f bir kredi i\u00e7in ba\u015flang\u0131\u00e7 tarihi olarak 1 Mart 2022 ve biti\u015f tarihi olarak 1 Mart 2027&#8217;yi belirledi\u011fini d\u00fc\u015f\u00fcnelim:<\/p>\n<pre> <code>=G\u00dcN360(\"2022-03-01\", \"2027-03-01\")<\/code> <\/pre>\n<p>Bu hesaplama, toplamda 1800 g\u00fcn oldu\u011funu g\u00f6sterir. Bu bilgi, kredi taksitlerinin ne s\u0131kl\u0131kta \u00f6denece\u011fini planlamada kullan\u0131labilir.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0130ki tarih aras\u0131ndaki g\u00fcn say\u0131s\u0131n\u0131, 360 g\u00fcnl\u00fck y\u0131l\u0131 esas alarak hesaplar<\/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-15360","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 DAYS360 (G\u00dcN360) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da DAYS360 (G\u00dcN360) 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\/days360\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de DAYS360 (G\u00dcN360) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da DAYS360 (G\u00dcN360) 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\/days360\/\" \/>\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:21+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 DAYS360 (G\u00dcN360) 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=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/days360\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/days360\/\",\"name\":\"Excel'de DAYS360 (G\u00dcN360) 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:21+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DAYS360 (G\u00dcN360) 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\/days360\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/days360\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/days360\/#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\u00dcN360\"}]},{\"@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 DAYS360 (G\u00dcN360) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DAYS360 (G\u00dcN360) 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\/days360\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DAYS360 (G\u00dcN360) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DAYS360 (G\u00dcN360) 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\/days360\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:25:21+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DAYS360 (G\u00dcN360) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/days360\/","url":"https:\/\/functiontranslator.com\/tr\/days360\/","name":"Excel'de DAYS360 (G\u00dcN360) 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:21+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DAYS360 (G\u00dcN360) 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\/days360\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/days360\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/days360\/#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\u00dcN360"}]},{"@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\/15360","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=15360"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15360\/revisions"}],"predecessor-version":[{"id":26628,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15360\/revisions\/26628"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}