{"id":15543,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/ay\/"},"modified":"2021-02-25T16:32:09","modified_gmt":"2021-02-25T16:32:09","slug":"month","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/month\/","title":{"rendered":"AY"},"content":{"rendered":"<p>Microsoft Excel ve Google Sheets, i\u015f ve e\u011fitim alanlar\u0131nda yayg\u0131n kullan\u0131lan iki g\u00fc\u00e7l\u00fc elektronik tablo uygulamas\u0131d\u0131r. Bu ara\u00e7larla yap\u0131lan bir\u00e7ok hesaplama ve analizin i\u00e7inde, tarih ve saat i\u015flevleri \u00f6ne \u00e7\u0131kar. Bu makalede, &#8220;MONTH&#8221; i\u015flevinin T\u00fcrk\u00e7e kar\u015f\u0131l\u0131\u011f\u0131 olan &#8220;AY&#8221; fonksiyonunun kullan\u0131m\u0131na detayl\u0131 bir g\u00f6z ataca\u011f\u0131z.<\/p>\n<h2>AY Fonksiyonu Nas\u0131l Kullan\u0131l\u0131r?<\/h2>\n<p>&#8216;AY&#8217; fonksiyonu, belirlenen bir tarih de\u011ferinin ay\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Ba\u015fka bir deyi\u015fle, bir tarih girildi\u011finde, bu fonksiyon o tarihin hangi ayda oldu\u011funu, say\u0131sal bir de\u011fer olarak (1 ile 12 aras\u0131nda) g\u00f6sterir.<\/p>\n<ul>\n<li><strong>S\u00f6zdizimi:<\/strong> AY(tarih)<\/li>\n<li><strong>Parametre:<\/strong> &#8220;tarih&#8221; &#8211; Ay bilgisini almak istedi\u011finiz tarih de\u011feri.<\/li>\n<\/ul>\n<pre> <code> =AY(\"2023-12-25\") \/\/ Sonu\u00e7: 12, \u00e7\u00fcnk\u00fc tarih Aral\u0131k ay\u0131na denk gelir. =AY(DATE(2023,3,15)) \/\/ Sonu\u00e7: 3, \u00e7\u00fcnk\u00fc belirtilen tarih Mart ay\u0131d\u0131r. <\/code> <\/pre>\n<h2>Pratik Kullan\u0131m \u00d6rnekleri<\/h2>\n<h3>\u00d6rnek 1: \u00c7al\u0131\u015fanlar\u0131n Do\u011fum G\u00fcnlerini Ay G\u00f6re S\u0131ralama<\/h3>\n<p>Bir \u015firketin insan kaynaklar\u0131 departman\u0131, \u00e7al\u0131\u015fanlar\u0131n do\u011fum g\u00fcnlerini ayl\u0131k olarak s\u0131ralamak isteyebilir. Bu sayede hangi ayda kimlerin do\u011fum g\u00fcn\u00fc oldu\u011funu kolayl\u0131kla g\u00f6rebilirler. \u0130\u015fte bu durumda &#8216;AY&#8217; fonksiyonu \u00e7ok i\u015fe yarar.<\/p>\n<ul>\n<li>\u0130lk s\u00fctun (A) \u00e7al\u0131\u015fanlar\u0131n isimlerini i\u00e7erir.<\/li>\n<li>\u0130kinci s\u00fctun (B) \u00e7al\u0131\u015fanlar\u0131n do\u011fum tarihlerini i\u00e7erir.<\/li>\n<li>\u00dc\u00e7\u00fcnc\u00fc s\u00fctun (C) ise &#8216;AY&#8217; fonksiyonu kullan\u0131larak do\u011fum ay\u0131n\u0131 hesaplar:<\/li>\n<\/ul>\n<pre> <code> =C2:=AY(B2) <\/code> <\/pre>\n<p>Bu form\u00fcl, C s\u00fctunundaki her bir h\u00fccre i\u00e7in uyguland\u0131\u011f\u0131nda, t\u00fcm \u00e7al\u0131\u015fanlar\u0131n hangi ayda do\u011fdu\u011funu g\u00f6sterir.<\/p>\n<h3>\u00d6rnek 2: Sat\u0131\u015f Raporlar\u0131n\u0131 \u00c7eyrek D\u00f6nemlere G\u00f6re Ay\u0131rma<\/h3>\n<p>Bir \u015firket, y\u0131l boyunca her \u00e7eyrek i\u00e7in sat\u0131\u015f performans\u0131n\u0131 de\u011ferlendirmek isteyebilir. Bu ama\u00e7la, sat\u0131\u015f tarihlerini \u00e7eyrek d\u00f6nemlere g\u00f6re ay\u0131rmak faydal\u0131 olacakt\u0131r.<\/p>\n<ul>\n<li>\u0130lk s\u00fctun (A) sat\u0131\u015f tarihini,<\/li>\n<li>\u0130kinci s\u00fctun (B) &#8216;AY&#8217; fonksiyonu ile tarihin hangi ayda oldu\u011funu,<\/li>\n<li>\u00dc\u00e7\u00fcnc\u00fc s\u00fctun (C) ise ay bilgisine ba\u011fl\u0131 olarak hangi \u00e7eyrekte oldu\u011funu belirleyen bir form\u00fcl i\u00e7erir:<\/li>\n<\/ul>\n<pre> <code> =B2:=AY(A2) =C2:=IF(B2&lt;=3; \"1. \u00c7eyrek\", IF(B2&lt;=6; \"2. \u00c7eyrek\", IF(B2&lt;=9; \"3. \u00c7eyrek\", \"4. \u00c7eyrek\"))) <\/code> <\/pre>\n<p>Bu yap\u0131, t\u00fcm sat\u0131\u015f tarihlerini otomatik olarak \u00e7eyrek d\u00f6nemlere g\u00f6re s\u0131n\u0131fland\u0131r\u0131r, b\u00f6ylece y\u0131l i\u00e7indeki performans de\u011fi\u015fikliklerini daha iyi analiz etme imkan\u0131 sunar.<\/p>\n<p>Her iki \u00f6rnekte de &#8216;AY&#8217; fonksiyonu, tarih verilerini nas\u0131l kategorize edilece\u011fini basit ve etkili bir \u015fekilde \u00e7\u00f6zerek veri analizi s\u00fcre\u00e7lerini kolayla\u015ft\u0131r\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seri numaras\u0131n\u0131 aya 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-15543","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 MONTH (AY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da MONTH (AY) 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\/month\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de MONTH (AY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da MONTH (AY) 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\/month\/\" \/>\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:32:09+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 MONTH (AY) 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\/month\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/month\/\",\"name\":\"Excel'de MONTH (AY) 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:32:09+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da MONTH (AY) 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\/month\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/month\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/month\/#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\":\"AY\"}]},{\"@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 MONTH (AY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da MONTH (AY) 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\/month\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de MONTH (AY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da MONTH (AY) 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\/month\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:32:09+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de MONTH (AY) 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\/month\/","url":"https:\/\/functiontranslator.com\/tr\/month\/","name":"Excel'de MONTH (AY) 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:32:09+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da MONTH (AY) 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\/month\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/month\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/month\/#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":"AY"}]},{"@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\/15543","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=15543"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15543\/revisions"}],"predecessor-version":[{"id":26811,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15543\/revisions\/26811"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}