{"id":15685,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/bugun\/"},"modified":"2021-02-25T16:37:50","modified_gmt":"2021-02-25T16:37:50","slug":"today","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/today\/","title":{"rendered":"BUG\u00dcN"},"content":{"rendered":"

Excel ve Google Sheets, i\u015f d\u00fcnyas\u0131nda olmazsa olmaz ara\u00e7lard\u0131r ve zamanla ili\u015fkili hesaplamalar i\u00e7in bir dizi kullan\u0131\u015fl\u0131 fonksiyon sunarlar. Bu yaz\u0131da, her iki uygulamada da kullan\u0131labilen “BUG\u00dcN” fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 ayr\u0131nt\u0131l\u0131 bir \u015fekilde inceleyece\u011fiz. “BUG\u00dcN” fonksiyonu, aktif oldu\u011fu andaki tarihi d\u00f6nd\u00fcren ve zamanla ilgili dinamik hesaplamalar i\u00e7in kritik bir i\u015flevi yerine getiren bir form\u00fcld\u00fcr.<\/p>\n

Genel Bak\u0131\u015f ve S\u00f6zdizimi<\/h2>\n

“BUG\u00dcN” fonksiyonu, arg\u00fcman gerektirmeyen ve anl\u0131k tarihi elde etmenizi sa\u011flayan basit bir fonksiyondur. Hem Excel hem de Google Sheets’te kullan\u0131m\u0131 ayn\u0131d\u0131r. \u0130\u015fte fonksiyonun bir uygulama \u00f6rne\u011fi:<\/p>\n

  =BUG\u00dcN() <\/code> <\/pre>\n
Fonksiyonu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, \u00f6rne\u011fin bug\u00fcn\u00fcn tarihi 23 Aral\u0131k 2023 ise, sistemden bu tarihi al\u0131rs\u0131n\u0131z.<\/p>\n
Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
BUG\u00dcN()<\/code> fonksiyonu, zamanla ilgili dinamik de\u011ferlerin gerekli oldu\u011fu durumlar i\u00e7in idealdir. \u0130\u015fte bu fonksiyonun en yayg\u0131n iki kullan\u0131m senaryosu:<\/p>\n
    \n
  • Tarih Aral\u0131klar\u0131 Hesaplama:<\/strong> Bug\u00fcn\u00fcn tarihinden ba\u015fka bir tarihe kadar olan g\u00fcn say\u0131s\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131labilir.<\/li>\n
  • Son Tarih Uyar\u0131lar\u0131:<\/strong> Belirli bir tarihe ne kadar zaman kald\u0131\u011f\u0131n\u0131 g\u00f6stererek, proje teslim tarihleri gibi \u00f6nemli g\u00fcnleri hat\u0131rlat\u0131r.<\/li>\n<\/ul>\n
    Detayl\u0131 Uygulama \u00d6rnekleri<\/h2>\n
    Gelin “BUG\u00dcN” fonksiyonunun kullan\u0131m\u0131n\u0131 iki pratik \u00f6rnekle a\u00e7\u0131klayal\u0131m:<\/p>\n
    \u00d6rnek 1: Proje Teslim S\u00fcresi Hesaplama<\/h3>\n
    \u00d6rne\u011fin, bir projenin teslim tarihini ve bug\u00fcnden itibaren ka\u00e7 g\u00fcn kald\u0131\u011f\u0131n\u0131 hesaplamam\u0131z gerekiyor. Diyelim ki proje teslim tarihi 31 Aral\u0131k 2023. A\u015fa\u011f\u0131daki form\u00fclle kalan g\u00fcn say\u0131s\u0131n\u0131 hesaplayabiliriz:<\/p>\n
      =31\/12\/2023-BUG\u00dcN() <\/code> <\/pre>\n
    Bu form\u00fcl, teslim tarihinden bug\u00fcnk\u00fc tarihi \u00e7\u0131kararak kalan g\u00fcn say\u0131s\u0131n\u0131 hesaplar.<\/p>\n
    \u00d6rnek 2: Ya\u015f Hesaplama<\/h3>\n
    Bir ki\u015finin do\u011fum tarihi verildi\u011finde, bu ki\u015finin bug\u00fcnk\u00fc ya\u015f\u0131n\u0131 hesaplamak i\u00e7in “BUG\u00dcN” fonksiyonunu kullanabiliriz. Diyelim ki, ki\u015finin do\u011fum tarihi 1 Ocak 1990. A\u015fa\u011f\u0131daki form\u00fclle ya\u015f\u0131 hesaplayabiliriz:<\/p>\n
      =YIL(BUG\u00dcN()) - 1990 - ((AY(BUG\u00dcN()) < 1 OR (AY(BUG\u00dcN()) = 1 AND G\u00dcN(BUG\u00dcN()) < 1))*1) <\/code> <\/pre>\n
    Bu form\u00fcl, e\u011fer ki\u015finin do\u011fum g\u00fcn\u00fc hen\u00fcz ge\u00e7mediyse, do\u011fru ya\u015f\u0131 hesaplamak i\u00e7in bir y\u0131l\u0131 \u00e7\u0131kar\u0131r.<\/p>\n
    Bu fonksiyonlar\u0131 kullanarak, Excel ve Google Sheets kullan\u0131c\u0131lar\u0131 tarih ve zamanla ilgili hesaplamalar\u0131n\u0131 kolayl\u0131kla ve dinamik bir \u015fekilde ger\u00e7ekle\u015ftirebilirler.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Bug\u00fcn\u00fcn tarihini seri numaras\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fcr<\/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-15685","post","type-post","status-publish","format-standard","hentry","category-tarih-ve-saat"],"acf":[],"yoast_head":"\nExcel'de TODAY (BUG\u00dcN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da TODAY (BUG\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\/today\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de TODAY (BUG\u00dcN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da TODAY (BUG\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\/today\/\" \/>\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:37:50+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 TODAY (BUG\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\/today\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/today\/\",\"name\":\"Excel'de TODAY (BUG\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:37:50+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da TODAY (BUG\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\/today\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/today\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/today\/#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\":\"BUG\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 TODAY (BUG\u00dcN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da TODAY (BUG\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\/today\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de TODAY (BUG\u00dcN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da TODAY (BUG\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\/today\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:37:50+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de TODAY (BUG\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\/today\/","url":"https:\/\/functiontranslator.com\/tr\/today\/","name":"Excel'de TODAY (BUG\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:37:50+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da TODAY (BUG\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\/today\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/today\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/today\/#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":"BUG\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\/15685","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=15685"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15685\/revisions"}],"predecessor-version":[{"id":26953,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15685\/revisions\/26953"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}