{"id":1603,"date":"2023-11-15T13:06:05","date_gmt":"2023-11-15T13:06:05","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/ayin-adi\/"},"modified":"2023-12-10T05:59:04","modified_gmt":"2023-12-10T05:59:04","slug":"ayin-adi","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/ayin-adi\/","title":{"rendered":"Bir tarihten bir ay nas\u0131l al\u0131n\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3884620491\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Tarihler verilerin \u00f6nemli bir par\u00e7as\u0131d\u0131r. Bir tarihin yaln\u0131zca bir k\u0131sm\u0131n\u0131 kullanmam\u0131z gereken birka\u00e7 durum vard\u0131r. Aydan bir \u00f6rnek verelim. Bazen bir tarihten yaln\u0131zca bir ay sonras\u0131na ihtiyac\u0131n\u0131z olur.<\/p><p> Ay, verileri \u00f6zetlemek i\u00e7in kullanabilece\u011finiz tarihin yararl\u0131 bile\u015fenlerinden biridir ve konu Excel&#8217;e geldi\u011finde, bir tarihten bir ay\u0131 elde etmek i\u00e7in farkl\u0131 y\u00f6ntemlerimiz vard\u0131r.<\/p><p> Bunun i\u00e7in toplam 5 y\u00f6ntem buldum. Ve bug\u00fcn bu makalede, bir tarihten ay almak\/\u00e7\u0131karmak i\u00e7in t\u00fcm bu y\u00f6ntemleri sizinle payla\u015fmak istiyorum. O halde hadi i\u015fimize bakal\u0131m.<\/p><h2 id=\"tab-con-4\" class=\"wp-block-heading\"> 1. AY i\u015flevi<\/h2><p> AY i\u015flevini kullanmak, bir tarihten bir ay\u0131 \u00e7\u0131karmak i\u00e7in en basit y\u00f6ntemdir. Tek yapman\u0131z gereken bu fonksiyonda ge\u00e7erli bir tarihe ba\u015fvurmak; 1 ile 12 aras\u0131nda de\u011fi\u015fen ay say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrecektir. <\/p><pre class=\"wp-block-preformatted\"> = <a href=\"https:\/\/exceladvisor.org\/fonctions-de-date-excel\/\">MONTH<\/a> (A2) <\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-mois-a-partir-dune-date-avec-la-fonction-mois-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"ay i\u015fleviyle bir tarihten ay almak\" width=\"348\" height=\"348\" data-id=\"11843\"><\/p><p> Ayr\u0131ca <a href=\"https:\/\/exceladvisor.org\/tr\/bugune-kadarki-metin\/\">do\u011fru tarih bi\u00e7imini<\/a> kullanarak i\u015fleve do\u011frudan tarih de ekleyebilirsiniz. <\/p><figure class=\"wp-block-table\"><table class=\"mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"Pro\"><div class=\"mtr-cell-content\"> Profesyonel<\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Con\"><div class=\"mtr-cell-content\"> Pislik <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Pro\"><div class=\"mtr-cell-content\">Uygulamas\u0131 kolayd\u0131r ve ba\u015fka i\u015flevlerle birle\u015ftirmeye gerek yoktur.<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Con\"><div class=\"mtr-cell-content\"> Ay numaras\u0131n\u0131n kullan\u0131m\u0131 s\u0131n\u0131rl\u0131d\u0131r, \u00e7o\u011fu zaman say\u0131lar yerine ay ad\u0131n\u0131 sunmak daha iyidir ve ay ad\u0131 istiyorsan\u0131z farkl\u0131 bir y\u00f6nteme ihtiyac\u0131n\u0131z vard\u0131r.<\/div><\/td><\/tr><\/tbody><\/table><\/figure><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> 2. MET\u0130N i\u015flevi<\/h2><p> Dedi\u011fim gibi ay numaras\u0131 yerine ay ad\u0131 kullanmak daha iyidir. MET\u0130N i\u015flevini kullanmak, bir tarihten ay ad\u0131n\u0131 \u00e7\u0131karmak i\u00e7in m\u00fckemmel bir y\u00f6ntemdir. Buradaki metin fonksiyonunun temel i\u015fi, belirli bir format\u0131 kullanarak bir tarihi aya d\u00f6n\u00fc\u015ft\u00fcrmektir. <\/p><pre class=\"wp-block-preformatted\"> <span style=\"font-family: 'Courier New', Courier, monospace;\">=<\/span> <span style=\"font-family: 'Courier New', Courier, monospace;\">TEXT<\/span> <span style=\"font-family: 'Courier New', Courier, monospace;\">(A2,\"MMM\")<\/span> <\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-mois-a-partir-dune-date-avec-la-fonction-de-texte-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"metin i\u015fleviyle bir tarihten ay almak\" width=\"421\" height=\"383\"><\/figure><\/div><p> Varsay\u0131lan olarak metin i\u015flevinde kullanabilece\u011finiz <a href=\"https:\/\/support.office.com\/en-us\/article\/TEXT-function-20d5ac4d-7b94-49fd-bb38-93d29371225c\" target=\"_blank\" rel=\"noopener noreferrer\">5 farkl\u0131 tarih bi\u00e7iminiz<\/a> vard\u0131r. Bu formatlar ay ad\u0131n\u0131 metin olarak d\u00f6nd\u00fcrecektir. Tek yapman\u0131z gereken fonksiyondaki bir tarihe ba\u015fvurmak ve bir format belirlemektir. Evet hepsi bu. Ve kulland\u0131\u011f\u0131n\u0131z tarihin Excel&#8217;in tarih sistemine g\u00f6re <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/bugune-kadarki-metin\/\">ge\u00e7erli bir tarih<\/a> olmas\u0131na dikkat edin. <\/p><figure class=\"wp-block-table\"><table class=\"has-fixed-layout mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"Pros\"><div class=\"mtr-cell-content\"> Faydalar<\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Cons\"><div class=\"mtr-cell-content\"> Dezavantajlar <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Pros\"><div class=\"mtr-cell-content\"> 5 farkl\u0131 format aras\u0131ndan bir format se\u00e7me se\u00e7ene\u011finiz vard\u0131r ve orijinal tarih s\u00fctunu ayn\u0131 kal\u0131r.<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Cons\"><div class=\"mtr-cell-content\"> Metin olacak ay ad\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr ve ay ad\u0131 i\u00e7in \u00f6zel bir k\u0131saltma kullanmak m\u00fcmk\u00fcn de\u011fildir.<\/div><\/td><\/tr><\/tbody><\/table><\/figure><h2 id=\"tab-con-3\" class=\"wp-block-heading\"> 3. Fonksiyonu SE\u00c7\u0130N<\/h2><p> Diyelim ki \u00f6zel bir ay ad\u0131 veya normal bir say\u0131 veya ad yerine farkl\u0131 bir dilde bir ad almak istiyorsunuz. Bu durumda CHOOSE i\u015flevi size yard\u0131mc\u0131 olabilir. \u0130\u015flevde 12 ay i\u00e7in \u00f6zel bir ad belirtmeniz ve tarihten itibaren ay say\u0131s\u0131n\u0131 almak i\u00e7in ay i\u015flevini kullanman\u0131z gerekir. <\/p><pre class=\"wp-block-preformatted\"> =CHOOSE(MONTH(A1),\"Jan\",\"Feb\",\"Mar\",\"Apr\",\"May\",\"Jun\",\"Jul\",\"Aug\",\"Sep\",\"Oct\",\"Nov \",\"Dec\") <\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-mois-a-partir-dune-date-avec-choisir-la-fonction-min-1.png\" sizes=\"\" srcset=\"\" alt=\"bir tarihten itibaren ay ad\u0131n\u0131 i\u00e7eren veriler\"><\/figure><\/div><p> Ay i\u015flevi tarihten itibaren bir ay numaras\u0131 d\u00f6nd\u00fcrd\u00fc\u011f\u00fcnde, i\u015flevin se\u00e7ilmesi bu say\u0131 yerine \u00f6zel ay ad\u0131n\u0131 d\u00f6nd\u00fcrecektir.<\/p><p> <strong>\u0130lgili:<\/strong> <a href=\"https:\/\/exceladvisor.org\/tr\/excel-formul-cubugu\/\">Form\u00fcl \u00c7ubu\u011fu<\/a> <\/p><figure class=\"wp-block-table\"><table class=\"has-fixed-layout mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"Pros\"><div class=\"mtr-cell-content\"> Faydalar<\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Cons\"><div class=\"mtr-cell-content\"> Dezavantajlar <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Pros\"><div class=\"mtr-cell-content\"> Bu size daha fazla esneklik sa\u011flar ve her ay i\u00e7in \u00f6zel bir ay ad\u0131 belirleyebilirsiniz.<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Cons\"><div class=\"mtr-cell-content\"> Fonksiyonun t\u00fcm de\u011ferlerinin tek tek eklenmesi zaman alan bir i\u015flemdir.<\/div><\/td><\/tr><\/tbody><\/table><\/figure><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> 4. G\u00fc\u00e7 Sorgusu<\/h2><p> Bir tarihten bir ay\u0131n ad\u0131n\u0131 ak\u0131ll\u0131 bir \u015fekilde almak istiyorsan\u0131z, o zaman g\u00fc\u00e7 sorgusu tam size g\u00f6re. Bir tarihi aya d\u00f6n\u00fc\u015ft\u00fcrmenize ve ayr\u0131ca bir tarihten bir ay numaras\u0131 veya ay ad\u0131 \u00e7\u0131karman\u0131za olanak tan\u0131r. Power Query, tarihlerle \u00e7al\u0131\u015fman\u0131za olanak tan\u0131yan eksiksiz bir pakettir. Burada a\u015fa\u011f\u0131daki verilere sahipsiniz ve burada tarihlerden aylara ihtiyac\u0131n\u0131z var.<\/p><ul><li> \u00d6ncelikle verilerinizi bir tabloya d\u00f6n\u00fc\u015ft\u00fcr\u00fcn.<\/li><li> Bundan sonra tablo h\u00fccrelerinden birini se\u00e7in ve Veri sekmesine gidin.<\/li><li> Veri sekmesinde &#8220;Tablodan&#8221; se\u00e7ene\u011fini t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-le-tableau-pour-obtenir-le-mois-a-partir-de-la-date-avec-la-requete-de-puissance-min-1.png\" sizes=\"\" srcset=\"\" alt=\"g\u00fc\u00e7 sorgusu ile tarihten itibaren ay\u0131 almak i\u00e7in tabloya t\u0131klay\u0131n\"><\/figure><\/div><ul><li> Tablonuzu Power Query D\u00fczenleyicisi&#8217;ne y\u00fckleyecektir.<\/li><\/ul><p> Buradan iki farkl\u0131 se\u00e7ene\u011finiz var; bunlardan biri, ay ad\u0131n\u0131 veya ay numaras\u0131n\u0131 i\u00e7eren yeni bir s\u00fctun eklemek veya tarihlerinizi ay ad\u0131na veya numaras\u0131na d\u00f6n\u00fc\u015ft\u00fcrmek. Yeni bir s\u00fctun eklemeden yaln\u0131zca tarihlerinizi aylara d\u00f6n\u00fc\u015ft\u00fcrmek istiyorsan\u0131z sonraki iki ad\u0131m\u0131 atlay\u0131n.<\/p><ul><li> \u0130lk \u00f6nce s\u00fctun ba\u015fl\u0131\u011f\u0131na sa\u011f t\u0131klay\u0131n.<\/li><li> Ve bundan sonra \u201cS\u00fctunu \u00c7o\u011falt\u201d a t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-une-colonne-en-double-pour-obtenir-le-mois-a-partir-dune-date-min-1.png\" sizes=\"\" srcset=\"\" alt=\"bir tarihten ay almak i\u00e7in yinelenen s\u00fctun ekleyin\"><\/figure><\/div><ul><li> Ba\u015fl\u0131ktaki yeni s\u00fctunu se\u00e7in ve sa\u011f t\u0131klay\u0131n.<\/li><li> D\u00f6n\u00fc\u015ft\u00fcr \u279c Ay \u279c Ay\u0131n veya ay\u0131n ad\u0131&#8217;na gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionnez-le-nom-du-mois-pour-obtenir-le-mois-min-1.png\" sizes=\"\" srcset=\"\" alt=\"ay\u0131 almak i\u00e7in ay ad\u0131n\u0131 se\u00e7in\"><\/figure><\/div><ul><li> Tarihleri an\u0131nda aylara d\u00f6n\u00fc\u015ft\u00fcrecektir. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-fermer-et-chargez-pour-obtenir-le-mois-a-partir-dune-date-min-1.png\" sizes=\"\" srcset=\"\" alt=\"bir tarihten ay\u0131 almak i\u00e7in kapat ve y\u00fckle'yi t\u0131klay\u0131n\"><\/figure><\/div><ul><li> Bir \u015fey daha, s\u00fctun ba\u015fl\u0131\u011f\u0131na sa\u011f t\u0131klay\u0131n ve s\u00fctunu &#8220;Ay&#8221; olarak yeniden adland\u0131r\u0131n.<\/li><li> Sonunda \u201cKapat ve Y\u00fckle\u201dye t\u0131klad\u0131\u011f\u0131n\u0131zda verileriniz bir e-tabloya y\u00fcklenecektir. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-avec-le-nom-du-mois-a-partir-dune-date-min-1.png\" sizes=\"\" srcset=\"\" alt=\"bir tarihten itibaren ay ad\u0131n\u0131 i\u00e7eren veriler\"><\/figure><\/div><figure class=\"wp-block-table\"><table class=\"has-fixed-layout mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"Pro\"><div class=\"mtr-cell-content\"> Profesyonel<\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Con\"><div class=\"mtr-cell-content\"> Pislik <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Pro\"><div class=\"mtr-cell-content\">Dinamik ve dakik bir konfig\u00fcrasyondur. Orijinal verileriniz etkilenmeyecektir.<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Con\"><div class=\"mtr-cell-content\"> Excel s\u00fcr\u00fcm\u00fcn\u00fczde bir g\u00fc\u00e7 sorgusu bulunmal\u0131d\u0131r ve ay ad\u0131 tam ad olacakt\u0131r.<\/div><\/td><\/tr><\/tbody><\/table><\/figure><h2 id=\"tab-con-0\" class=\"wp-block-heading\"> 5. \u00d6zel Bi\u00e7imlendirme<\/h2><p> Form\u00fcl y\u00f6ntemine girmek istemiyorsan\u0131z, bir tarihi aya d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in bunu kullanman\u0131n basit yolu <a href=\"https:\/\/support.office.com\/en-us\/article\/Create-or-delete-a-custom-number-format-78f2a361-936b-4c03-8772-09fab54be7f4?ui=en-US&amp;rs=en-US&amp;ad=US&amp;fromAR=1\" target=\"_blank\" rel=\"noopener noreferrer\">\u00f6zel bi\u00e7imlendirme uygulamakt\u0131r<\/a> . Bu basit ad\u0131mlar\u0131 izleyin.<\/p><ol><li> H\u00fccre aral\u0131\u011f\u0131n\u0131 veya s\u00fctunu se\u00e7in.<\/li><li> Ctrl + 1 k\u0131sayol tu\u015funa bas\u0131n.<\/li><li> Bi\u00e7im se\u00e7ene\u011finde \u201c\u00d6zel\u201d e gidin.<\/li><li> \u015eimdi \u201cTip\u201d giri\u015f \u00e7ubu\u011funa \u201cMM\u201d, \u201cMMM\u201d veya \u201cMMMMMM\u201d girin.<\/li><li> Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-mois-a-partir-dune-date-avec-des-options-de-mise-en-forme-ouvertes-de-mise-en-forme-conditionnelle-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"ko\u015fullu bi\u00e7imlendirme a\u00e7\u0131k bi\u00e7imlendirme se\u00e7enekleriyle bir tarihten itibaren ay al\u0131n\" width=\"534\" height=\"466\"><\/figure><\/div><figure class=\"wp-block-table\"><table class=\"has-fixed-layout mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"Pros\"><div class=\"mtr-cell-content\"> Faydalar<\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Cons\"><div class=\"mtr-cell-content\"> Dezavantajlar <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"Pros\"><div class=\"mtr-cell-content\"> Uygulamas\u0131 kolayd\u0131r ve tarihi de\u011fil format\u0131 de\u011fi\u015ftirir.<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Cons\"><div class=\"mtr-cell-content\"> De\u011fer tarih oldu\u011fu i\u00e7in kopyalay\u0131p ba\u015fka bir yere de\u011fer olarak yap\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda metin de\u011fil tarih olacakt\u0131r. Birisi format\u0131 de\u011fi\u015ftirirse ay ad\u0131 kaybolacakt\u0131r.<\/div><\/td><\/tr><\/tbody><\/table><\/figure><h2 class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> Yukar\u0131daki y\u00f6ntemlerin t\u00fcm\u00fc farkl\u0131 durumlarda kullan\u0131labilir. Ancak baz\u0131lar\u0131 daha s\u0131k kullan\u0131lmaktad\u0131r.<\/p><p> MET\u0130N i\u015flevi \u00e7o\u011fu durumda uygulanabilir. \u00d6te yandan, yaln\u0131zca birka\u00e7 t\u0131klamayla aylar\u0131 almak i\u00e7in bir g\u00fc\u00e7 sorgunuz da var. Bana sorarsan\u0131z metin \u00f6zelli\u011fini kullan\u0131yorum ama bu aralar g\u00fc\u00e7 sorgusuna daha \u00e7ok a\u015f\u0131\u011f\u0131m o y\u00fczden onu da kullanmak istiyorum.<\/p><p> Son olarak ihtiya\u00e7lar\u0131n\u0131za g\u00f6re bu y\u00f6ntemlerden herhangi birini kullanabilece\u011finizi s\u00f6ylemek istiyorum. Ama bana bir \u015feyi s\u00f6ylemelisin.<\/p><p> <strong>Tercih etti\u011finiz y\u00f6ntem nedir?<\/strong><\/p><p> L\u00fctfen yorum b\u00f6l\u00fcm\u00fcnde benimle payla\u015f\u0131n, sizden haber almay\u0131 \u00e7ok isterim. Ve arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Excel dosyas\u0131n\u0131 al\u0131n<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-mois-a-partir-de-la-date-2.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/p><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/formuller\/\">Excel form\u00fcllerinin listesi<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \u0130lgili form\u00fcller <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tarihe-bir-ay-eklemek-2\/\">Excel&#8217;de bir tarihe ay ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/\">Excel&#8217;de ay\u0131n biti\u015f tarihini al\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/2.-ayin-ilk-gunu\/\">Ay\u0131n ilk g\u00fcn\u00fcn\u00fc Excel&#8217;de al\u0131n (ay\u0131n ba\u015flang\u0131c\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ceyrek\/\">Excel&#8217;de bir tarihten [Mali + Takvim] d\u00f6rtte birini al\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/\">Excel&#8217;de iki tarih aras\u0131ndaki ay say\u0131s\u0131<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1603","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bir tarihten bir ay nas\u0131l al\u0131n\u0131r? (2023 K\u0131lavuzu)<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, Excel&#039;deki bir tarihten ay ad\u0131n\u0131, be\u015f farkl\u0131 y\u00f6ntem kullanarak nas\u0131l alaca\u011f\u0131n\u0131z\u0131\/\u00e7\u0131karaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/ayin-adi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bir tarihten bir ay nas\u0131l al\u0131n\u0131r? (2023 K\u0131lavuzu)\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, Excel&#039;deki bir tarihten ay ad\u0131n\u0131, be\u015f farkl\u0131 y\u00f6ntem kullanarak nas\u0131l alaca\u011f\u0131n\u0131z\u0131\/\u00e7\u0131karaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/ayin-adi\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:59:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-mois-a-partir-dune-date-avec-la-fonction-mois-min-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/ayin-adi\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/ayin-adi\/\",\"name\":\"Bir tarihten bir ay nas\u0131l al\u0131n\u0131r? (2023 K\u0131lavuzu)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/ayin-adi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/ayin-adi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-mois-a-partir-dune-date-avec-la-fonction-mois-min-1.png\",\"datePublished\":\"2023-11-15T13:06:05+00:00\",\"dateModified\":\"2023-12-10T05:59:04+00:00\",\"description\":\"Bu e\u011fitimde, Excel&#39;deki bir tarihten ay ad\u0131n\u0131, be\u015f farkl\u0131 y\u00f6ntem kullanarak nas\u0131l alaca\u011f\u0131n\u0131z\u0131\/\u00e7\u0131karaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/ayin-adi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/ayin-adi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/ayin-adi\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-mois-a-partir-dune-date-avec-la-fonction-mois-min-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-mois-a-partir-dune-date-avec-la-fonction-mois-min-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/ayin-adi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bir tarihten bir ay nas\u0131l al\u0131n\u0131r?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bir tarihten bir ay nas\u0131l al\u0131n\u0131r? (2023 K\u0131lavuzu)","description":"Bu e\u011fitimde, Excel&#39;deki bir tarihten ay ad\u0131n\u0131, be\u015f farkl\u0131 y\u00f6ntem kullanarak nas\u0131l alaca\u011f\u0131n\u0131z\u0131\/\u00e7\u0131karaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.","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:\/\/exceladvisor.org\/tr\/ayin-adi\/","og_locale":"tr_TR","og_type":"article","og_title":"Bir tarihten bir ay nas\u0131l al\u0131n\u0131r? (2023 K\u0131lavuzu)","og_description":"Bu e\u011fitimde, Excel&#39;deki bir tarihten ay ad\u0131n\u0131, be\u015f farkl\u0131 y\u00f6ntem kullanarak nas\u0131l alaca\u011f\u0131n\u0131z\u0131\/\u00e7\u0131karaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/ayin-adi\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:59:04+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-mois-a-partir-dune-date-avec-la-fonction-mois-min-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/ayin-adi\/","url":"https:\/\/exceladvisor.org\/tr\/ayin-adi\/","name":"Bir tarihten bir ay nas\u0131l al\u0131n\u0131r? (2023 K\u0131lavuzu)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/ayin-adi\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/ayin-adi\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-mois-a-partir-dune-date-avec-la-fonction-mois-min-1.png","datePublished":"2023-11-15T13:06:05+00:00","dateModified":"2023-12-10T05:59:04+00:00","description":"Bu e\u011fitimde, Excel&#39;deki bir tarihten ay ad\u0131n\u0131, be\u015f farkl\u0131 y\u00f6ntem kullanarak nas\u0131l alaca\u011f\u0131n\u0131z\u0131\/\u00e7\u0131karaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/ayin-adi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/ayin-adi\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/ayin-adi\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-mois-a-partir-dune-date-avec-la-fonction-mois-min-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-mois-a-partir-dune-date-avec-la-fonction-mois-min-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/ayin-adi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Bir tarihten bir ay nas\u0131l al\u0131n\u0131r?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1603","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1603"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1603\/revisions"}],"predecessor-version":[{"id":2293,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1603\/revisions\/2293"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}