{"id":15358,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/gun\/"},"modified":"2021-02-25T16:25:15","modified_gmt":"2021-02-25T16:25:15","slug":"day","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/day\/","title":{"rendered":"G\u00dcN"},"content":{"rendered":"<p>Microsoft Excel ve Google Sheets, g\u00fcn\u00fcm\u00fczde veri analizi ve i\u015flemeler i\u00e7in en pop\u00fcler ve g\u00fc\u00e7l\u00fc ara\u00e7lar aras\u0131nda yer al\u0131r. Bu platformlarda, tarihlerle \u00e7al\u0131\u015fmay\u0131 kolayla\u015ft\u0131ran \u00e7e\u015fitli fonksiyonlar mevcuttur. Bu yaz\u0131da, bir tarihin g\u00fcn k\u0131sm\u0131n\u0131 nas\u0131l elde edebilece\u011finizi g\u00f6steren DAY fonksiyonunun kullan\u0131m\u0131 a\u00e7\u0131klanacakt\u0131r. Bu fonksiyon, hem Excel hem de Google Sheets&#8217;te benzer \u015fekilde i\u015flev g\u00f6r\u00fcr.<\/p>\n<h2>DAY Fonksiyonunun S\u00f6zdizimi<\/h2>\n<p>DAY fonksiyonunun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n<pre><code>=DAY(serial_number)<\/code><\/pre>\n<ul>\n<li><strong>serial_number<\/strong> &#8211; Tarih bilgisini i\u00e7eren h\u00fccre veya do\u011frudan tarih de\u011feri. Excel ve Google Sheets, tarihleri seri numaras\u0131 olarak saklar; burada 1 Ocak 1900, 1 seri numaras\u0131 olarak kabul edilir.<\/li>\n<\/ul>\n<p>\u00d6rne\u011fin, A1 h\u00fccresinde &#8220;15.11.2023&#8221; tarihi varsa a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/p>\n<pre><code>=DAY(A1)<\/code><\/pre>\n<p>Bu form\u00fcl, &#8220;15&#8221; sonucunu verecektir; \u00e7\u00fcnk\u00fc &#8220;15.11.2023&#8221; tarihinin g\u00fcn k\u0131sm\u0131 15&#8217;tir.<\/p>\n<h2>Pratik Uygulamalar<\/h2>\n<h2>G\u00fcn Bilgisini Kullanarak Rapor Olu\u015fturma<\/h2>\n<p>\u00c7o\u011fu i\u015fletme g\u00fcn baz\u0131nda raporlar haz\u0131rlar ve analizler yapar. Diyelim ki, bir i\u015fletmenin g\u00fcnl\u00fck sat\u0131\u015flar\u0131n\u0131 de\u011ferlendirmek istiyorsunuz. Sat\u0131\u015f tarihleri A s\u00fctununda, sat\u0131\u015f miktarlar\u0131 B s\u00fctununda tutuluyorsa, DAY fonksiyonu ile hangi g\u00fcnlerin daha fazla sat\u0131\u015f getirdi\u011fini analiz edebilirsiniz.<\/p>\n<pre><code>=DAY(A2)<\/code><\/pre>\n<p>E\u011fer A2 h\u00fccresi &#8220;01.12.2023&#8221; tarihini i\u00e7eriyorsa, bu form\u00fcl &#8220;1&#8221; sonucunu verecektir. Ard\u0131ndan, bu sonucu kullanarak g\u00fcn baz\u0131nda toplam sat\u0131\u015flar\u0131 hesaplayabilirsiniz.<\/p>\n<h2>Do\u011fum G\u00fcnleri ve Y\u0131ld\u00f6n\u00fcmleri<\/h2>\n<p>Bir insan kaynaklar\u0131 departman\u0131, \u00e7al\u0131\u015fanlar\u0131n do\u011fum g\u00fcnlerini ve i\u015fe ba\u015flama y\u0131ld\u00f6n\u00fcmlerini izleyebilir. Bu \u00f6zel g\u00fcnleri belirlemek i\u00e7in DAY fonksiyonundan faydalan\u0131l\u0131r. \u00d6rne\u011fin, \u00e7al\u0131\u015fanlar\u0131n do\u011fum tarihleri C s\u00fctununda saklan\u0131yorsa, \u015fu form\u00fcl kullan\u0131labilir:<\/p>\n<pre><code>=DAY(C2)<\/code><\/pre>\n<p>Bu sayede, C2 h\u00fccresinde yer alan ki\u015finin do\u011fum g\u00fcn\u00fcn\u00fcn g\u00fcn k\u0131sm\u0131n\u0131 kolayl\u0131kla belirleyebilirsiniz.<\/p>\n<p>Excel ve Google Sheets&#8217;in sunmu\u015f oldu\u011fu bu t\u00fcr fonksiyonlar, g\u00fcnl\u00fck i\u015flerimizi organize etmek ve analizler yapmak i\u00e7in b\u00fcy\u00fck kolayl\u0131klar sa\u011flar. Fonksiyonlar\u0131 etkin kullanmak, i\u015f verimlili\u011fini art\u0131rabilir ve zaman tasarrufu sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seri numaras\u0131n\u0131, ay\u0131n bir g\u00fcn\u00fcne 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-15358","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 DAY (G\u00dcN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da DAY (G\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\/day\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de DAY (G\u00dcN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da DAY (G\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\/day\/\" \/>\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:15+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 DAY (G\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\/day\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/day\/\",\"name\":\"Excel'de DAY (G\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:25:15+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DAY (G\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\/day\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/day\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/day\/#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\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 DAY (G\u00dcN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DAY (G\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\/day\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DAY (G\u00dcN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DAY (G\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\/day\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:25:15+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DAY (G\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\/day\/","url":"https:\/\/functiontranslator.com\/tr\/day\/","name":"Excel'de DAY (G\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:25:15+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DAY (G\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\/day\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/day\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/day\/#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\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\/15358","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=15358"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15358\/revisions"}],"predecessor-version":[{"id":26626,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15358\/revisions\/26626"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15358"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}