{"id":1602,"date":"2023-11-15T13:41:10","date_gmt":"2023-11-15T13:41:10","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/ceyrek\/"},"modified":"2023-12-10T05:58:59","modified_gmt":"2023-12-10T05:58:59","slug":"ceyrek","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/ceyrek\/","title":{"rendered":"Bir randevunun \u00e7eyre\u011fi nas\u0131l al\u0131n\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2907334394\"><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>Excel&#8217;de bir tarihten \u00e7eyreklik alman\u0131n do\u011frudan bir i\u015flevi yoktur. Ancak bunun i\u00e7in bir form\u00fcl olu\u015fturabilirsiniz.<\/p><p> Evet, bir tarihten itibaren \u00e7eyre\u011fi hesaplamak i\u00e7in bir form\u00fcl kullanabilirsiniz. Hatta kullanabilece\u011finiz birden fazla y\u00f6ntem var. Tamam, bildi\u011finiz gibi y\u0131lda toplam d\u00f6rt \u00e7eyrek var ama ger\u00e7ek \u015fu ki, bir hurmadan \u00e7eyre\u011fi farkl\u0131 \u015fekillerde alabilirsiniz.<\/p><p> Birincisi, normal takvim esas\u0131na g\u00f6re bir y\u0131l\u0131, ikincisi ise vergi takvimi esas\u0131na g\u00f6re varsaymakt\u0131r. Bug\u00fcnk\u00fc yaz\u0131mda ise her iki takvimi kullanarak \u00e7eyrek say\u0131 alman\u0131n yollar\u0131n\u0131 g\u00f6sterece\u011fim ve bunun i\u00e7in birden fazla y\u00f6ntemi de sizlerle payla\u015faca\u011f\u0131m.<\/p><p> \u00d6yleyse ba\u015flayal\u0131m.<\/p><h2 id=\"0-1-get-quarter-by-using-roundup-and-month-functions\" class=\"wp-block-heading\"> 1. ROUNDUP ve AY i\u015flevlerini kullanarak \u00c7eyrek Al\u0131n<\/h2><p> ROUNDUP ve AY kombinasyonunu kullanmak, bir tarihin \u00e7eyre\u011fini bulman\u0131n en iyi yoludur. \u00c7eyre\u011fi say\u0131 olarak d\u00f6nd\u00fcr\u00fcr (1,2,3,4 gibi).<\/p><p> \u0130\u015fte form\u00fcl. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=ROUNDUP(MONTH(A1)\/3,0)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png\" sizes=\"\" srcset=\"\" alt=\"yuvarlak ay form\u00fcl\u00fcn\u00fc kullanarak excel \u00e7eyrek say\u0131s\u0131\"><\/figure><\/div><p> Burada tarih olarak 26 May\u0131s 2018&#8217;i kullan\u0131yoruz ve form\u00fcl sonu\u00e7ta 2 de\u011ferini d\u00f6nd\u00fcr\u00fcyor. \u00c7eyrek say\u0131s\u0131n\u0131n \u00f6n\u00fcne Q eklemek istiyorsan\u0131z a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=\"Q-\"&amp;ROUNDUP(MONTH(A1)\/3,0)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" class=\"wp-image-22413\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-avec-q.png\" sizes=\"\" srcset=\"\" alt=\"q ile yuvarlak ay form\u00fcl\u00fcn\u00fc kullanarak excel \u00e7eyrek numaras\u0131\"><\/figure><\/div><h3 id=\"1-how-this-formula-works-\" class=\"wp-block-heading\"> <strong>Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/strong><\/h3><p> Bu form\u00fcl \u00fc\u00e7 b\u00f6l\u00fcmde \u00e7al\u0131\u015f\u0131r.<\/p><p> <strong>\u0130lk<\/strong> b\u00f6l\u00fcmde MONTH fonksiyonunu kulland\u0131k ve ay say\u0131s\u0131n\u0131 d\u00f6nd\u00fcren tarihten bahsettik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-utilisant-la-formule-du-mois-rond-premiere-partie-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> Daha sonra <strong>ikinci<\/strong> b\u00f6l\u00fcmde bu ay say\u0131s\u0131n\u0131 3&#8217;e b\u00f6ld\u00fck, bu da bize ondal\u0131k basamakl\u0131 bir say\u0131 verdi. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-partie-seconde-1.png\" sizes=\"\" srcset=\"\" alt=\"yuvarlak ay form\u00fcl\u00fcn\u00fc kullanarak excel \u00e7eyrek numaras\u0131 ikinci b\u00f6l\u00fcm\"><\/figure><\/div><p> Son olarak <strong>\u00fc\u00e7\u00fcnc\u00fc<\/strong> b\u00f6l\u00fcmde, bize ger\u00e7ek \u00e7eyre\u011fi veren ROUNDUP fonksiyonunu (bu say\u0131y\u0131 ondal\u0131k basama\u011fa) yuvarlamak i\u00e7in kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-utilisant-la-formule-du-mois-rond-troisieme-partie.png\" sizes=\"\" srcset=\"\" alt=\"yuvarlak ay form\u00fcl\u00fcn\u00fc kullanarak excel \u00e7eyrek say\u0131s\u0131 \u00fc\u00e7\u00fcnc\u00fc b\u00f6l\u00fcm\"><\/figure><\/div><p> Ger\u00e7ek <strong>\u015fu ki<\/strong> : Biliyorsunuz 4 \u00e7eyrek ve 12 ay var. SA\u011e? Ve t\u00fcm ay say\u0131lar\u0131n\u0131 \u00fc\u00e7e b\u00f6lerseniz (evet, sadece 3 ile), a\u015fa\u011f\u0131daki gibi bir sonu\u00e7 elde edersiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/bases-de-la-formule-de-numero-de-trimestre-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"\u00e7eyrek say\u0131 form\u00fcl\u00fcn\u00fcn temelleri excel\"><\/figure><\/div><p> Ve bunlar\u0131 toplad\u0131\u011f\u0131n\u0131zda her zaman o ay\u0131n \u00e7eyrek numaras\u0131n\u0131 al\u0131rs\u0131n\u0131z.<\/p><h2 id=\"2-2-get-quarter-by-using-fiscal-calendar\" class=\"wp-block-heading\"> 2. Mali Takvimi kullanarak \u00c7eyrek Ay\u0131n\u0131 Al\u0131n<\/h2><p> Yukar\u0131daki \u00f6rnekte bir tarihten itibaren \u00e7eyre\u011fi almak i\u00e7in basit bir form\u00fcl kulland\u0131k, ancak bazen mali takvim kullanman\u0131z gerekir.<\/p><div class=\"wp-block-group is-layout-flow\"><div class=\"wp-block-group__inner-container\"><p> <em>Mali y\u0131l nedir?<\/em><\/p><p> <em>Mali y\u0131l (FY), bir i\u015fletmenin veya h\u00fck\u00fcmetin muhasebe amac\u0131yla ve mali tablo haz\u0131rlamak i\u00e7in kulland\u0131\u011f\u0131 12 ayl\u0131k bir d\u00f6nemdir. Bir mali y\u0131l, bir takvim y\u0131l\u0131na kar\u015f\u0131l\u0131k gelmeyebilir\u2026<\/em><\/p><p> <em><a href=\"https:\/\/www.investopedia.com\/terms\/f\/fiscalyear.asp\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">\u2026daha fazla bilgi edin<\/a><\/em><\/p><\/div><\/div><p> Mali takvim \u00e7eyre\u011fi hesaplamas\u0131 i\u00e7in ise farkl\u0131 bir form\u00fcl kullanmam\u0131z gerekiyor ve bu form\u00fclde SELECT ve AY fonksiyonlar\u0131n\u0131 birle\u015ftirmemiz gerekiyor.<\/p><p> \u0130\u015fte form\u00fcl: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=CHOOSE(MONTH(A1),4,4,4,1,1,1,2,2,2,3,3,3)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22418\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-a-laide-de-la-formule-de-lannee-fiscale.png\" sizes=\"auto, \" srcset=\"\" alt=\"mali y\u0131l form\u00fcl\u00fcn\u00fc kullanarak excel \u00e7eyrek say\u0131s\u0131\" width=\"576\" height=\"168\"><\/figure><\/div><p> (Burada 1 Nisan&#8217;da ba\u015flay\u0131p 31 Mart&#8217;ta biten Hindistan mali y\u0131l\u0131n\u0131 kulland\u0131m)<\/p><p> Ay\u0131n May\u0131s olmas\u0131 ve y\u0131l\u0131m\u0131z\u0131n Nisan ay\u0131ndan ba\u015flamas\u0131 ve May\u0131s ay\u0131n\u0131n ilk \u00e7eyre\u011fe denk gelen ikinci ay\u0131 olmas\u0131 nedeniyle sonu\u00e7ta 1 de\u011ferini verir.<\/p><h3 id=\"how-this-formula-works\" class=\"wp-block-heading\"> <strong>Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/strong><\/h3><p> Burada iki farkl\u0131 fonksiyonu birle\u015ftirdik ve iki par\u00e7a halinde \u00e7al\u0131\u015f\u0131yor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-a-laide-de-la-formule-de-lannee-fiscale.png\" sizes=\"\" srcset=\"\" alt=\"mali y\u0131l form\u00fcl\u00fcn\u00fc kullanarak excel \u00e7eyrek numaras\u0131 \u00e7al\u0131\u015fmalar\u0131\"><\/figure><\/div><p> <strong>\u0130lk<\/strong> b\u00f6l\u00fcmde tarihten itibaren ay say\u0131s\u0131n\u0131 almak i\u00e7in MONTH fonksiyonunu kulland\u0131k ve burada 5 de\u011ferini d\u00f6nd\u00fcr\u00fcyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-utilisant-la-premiere-partie-de-la-formule-de-lexercice-avec-la-fonction-du-mois.png\" sizes=\"\" srcset=\"\" alt=\"ay i\u015fleviyle birlikte mali y\u0131l form\u00fcl\u00fcn\u00fcn ilk b\u00f6l\u00fcm\u00fcn\u00fc kullanan excel \u00e7eyrek say\u0131s\u0131\"><\/figure><\/div><p> Daha sonra <strong>ikinci<\/strong> b\u00f6l\u00fcmde MONTH fonksiyonunun d\u00f6nd\u00fcrd\u00fc\u011f\u00fc ay say\u0131s\u0131na g\u00f6re bir say\u0131 almak i\u00e7in fonksiyonu se\u00e7iyorduk. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-de-lexercice-fiscal-deuxieme-partie-choisir.png\" sizes=\"\" srcset=\"\" alt=\"mali y\u0131l form\u00fcl\u00fcn\u00fc kullanarak excel \u00e7eyrek numaras\u0131 ikinci b\u00f6l\u00fcm\u00fc se\u00e7in\"><\/figure><\/div><p> CHOOSE hakk\u0131nda daha fazla bilgiyi buradan edinebilirsiniz.<\/p><p> Bakarsan\u0131z CHOOSE fonksiyonunda 12 farkl\u0131 say\u0131 belirttik (4,4,4,1,1,1,2,2,2,3,3,3) yani MONTH bir say\u0131 d\u00f6nd\u00fcrd\u00fc\u011f\u00fcnde CHOOSE bir say\u0131 d\u00f6nd\u00fcr\u00fcyor bu listenin.<\/p><p> \u0130\u015fte anla\u015fma:<\/p><p> \u0130lk \u00fc\u00e7 hane i\u00e7in 4&#8217;\u00fcm\u00fcz var, yani 1, 2 veya 3 (Ocak-Mart) d\u00f6nd\u00fcr\u00fcrse 4 alaca\u011f\u0131z ve sonraki \u00fc\u00e7 ay i\u00e7in 1 alaca\u011f\u0131z (\u00e7\u00fcnk\u00fc bizim y\u0131l vergimiz Nisan&#8217;dan ba\u015fl\u0131yor).<\/p><h2 id=\"3-3-convert-a-date-into-a-quarter-using-vba-code\" class=\"wp-block-heading\"> 3. VBA kodunu kullanarak bir tarihi \u00e7eyre\u011fe d\u00f6n\u00fc\u015ft\u00fcr\u00fcn<\/h2><p> Burada bir tarihi basit\u00e7e \u00e7eyrek numaras\u0131na d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in VBA kodunu kullan\u0131yoruz. \u0130\u015fte kod:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub convert2Quarter() Dim Rng As Range For Each Rng In Selection If IsDate(Rng.Value) = True Then Rng.Value = DatePart(\"q\", Rng.Value) Rng.NumberFormat = \u201cGeneral\u201d End If Next Rng End Sub<\/code><\/pre><p> Bu kodu kullanmak i\u00e7in VB d\u00fczenleyicinize eklemeniz yeterlidir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/code-vba-pour-obtenir-le-numero-de-trimestre-excel-vbe.png\" sizes=\"\" srcset=\"\" alt=\"\u00c7eyrek say\u0131y\u0131 alma kodu excel vbe\"><\/figure><\/div><p> Ve sonra tarihi \u00e7eyrek say\u0131ya d\u00f6n\u00fc\u015ft\u00fcrmeniz gereken h\u00fccreleri se\u00e7in ve son olarak bu kodu \u00e7al\u0131\u015ft\u0131r\u0131n.<\/p><h3 id=\"here-s-how-this-code-works\" class=\"wp-block-heading\"> \u0130\u015fte bu kod nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/h3><p> Bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda \u00f6ncelikle h\u00fccrenin tarih i\u00e7erip i\u00e7ermedi\u011fini kontrol eder, tarih ise \u00e7eyrek say\u0131ya \u00e7evirir.<\/p><p> Burada iki farkl\u0131 VBA i\u015flevi kulland\u0131k:<\/p><ol><li> ISDATE: H\u00fccrenin tarihi olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in.<\/li><li> DATEPART: bir tarihi \u00e7eyre\u011fe d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in.<\/li><\/ol><p> <strong>\u015eunu kontrol edin: VBA&#8217;ya Yeni Ba\u015flayanlar i\u00e7in En Faydal\u0131 100 Makro Kodu | <a href=\"https:\/\/exceladvisor.org\/tr\/vba\/\">Excel&#8217;de VBA nedir<\/a><\/strong><\/p><h2 id=\"4-4-get-quarter-start-date-from-a-date\" class=\"wp-block-heading\"> 4. Bir tarihten \u00fc\u00e7 ayl\u0131k ba\u015flang\u0131\u00e7 \u200b\u200btarihini al\u0131n<\/h2><p> \u00c7eyrek say\u0131s\u0131n\u0131 unutal\u0131m ve \u00e7eyre\u011fin ba\u015flang\u0131\u00e7 \u200b\u200btarihini kullanal\u0131m.<\/p><p> Bu, 26 May\u0131s 2018 tarihine sahipsek, 2 numaral\u0131 \u00e7eyre\u011fe sahip olmak yerine, \u00e7eyre\u011fin ilk ay\u0131n\u0131n ba\u015flang\u0131\u00e7 \u200b\u200btarihi olan 01 Nisan 2018&#8217;e sahip olabilece\u011fimiz anlam\u0131na gelir. Kullanmam\u0131z gereken form\u00fcl \u015fu \u015fekilde: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATE(YEAR(A1),FLOOR.MATH(\u200bMONTH (A1)-1,3)+1,1)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22429\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-de-date-de-debut-de-trimestre-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00e7eyrek ba\u015flang\u0131\u00e7 \u200b\u200btarihi form\u00fcl\u00fc excel\" width=\"619\" height=\"143\"><\/figure><\/div><p> Bu form\u00fcl\u00fc girdi\u011finizde yaln\u0131zca \u00fc\u00e7 ayl\u0131k d\u00f6nemin ba\u015flang\u0131\u00e7 \u200b\u200btarihini d\u00f6nd\u00fcr\u00fcr.<\/p><h3 id=\"how-this-formula-works\" class=\"wp-block-heading\"> <strong>Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/strong><\/h3><p> Bu form\u00fcl size bir d\u00f6nemin ba\u015flang\u0131\u00e7 \u200b\u200btarihini veren d\u00f6rt farkl\u0131 b\u00f6l\u00fcmden olu\u015fur. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-de-date-de-debut-de-trimestre-excel.png\" sizes=\"\" srcset=\"\" alt=\"\u00e7eyrek ba\u015flang\u0131\u00e7 \u200b\u200btarihi form\u00fcl\u00fc excel \u00e7al\u0131\u015f\u0131yor\"><\/figure><\/div><p> <strong>\u0130lk<\/strong> b\u00f6l\u00fcmde tarihin ay say\u0131s\u0131n\u0131 d\u00f6nd\u00fcren MONTH fonksiyonunu kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-de-date-de-debut-de-trimestre-excel.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> Yani MONTH, ay say\u0131s\u0131 olarak 5&#8217;i d\u00f6nd\u00fcrd\u00fc\u011f\u00fcnde (sonra bundan bir eksi), <strong>ikinci<\/strong> b\u00f6l\u00fcmde FLOOR bunu 3&#8217;e yuvarlar ve ard\u0131ndan bir ekler, b\u00f6ylece 4&#8217;\u00fc elde edebiliriz ki bu da ayn\u0131 \u00e7eyre\u011fin ilk ay\u0131 (Nisan) olur mu? <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-trimestre-date-de-debut-formule-etage-maths.png\" sizes=\"\" srcset=\"\" alt=\"excel \u00e7eyrek ba\u015flang\u0131\u00e7 \u200b\u200btarihi form\u00fcl kat matematik\"><\/figure><\/div><p> Daha sonra <strong>\u00fc\u00e7\u00fcnc\u00fc<\/strong> b\u00f6l\u00fcmde y\u0131l\u0131 ger\u00e7ek tarihten almak i\u00e7in YEAR fonksiyonunu kulland\u0131k.<\/p><p> <strong>D\u00f6rd\u00fcnc\u00fc<\/strong> b\u00f6l\u00fcmde ise ilk iki b\u00f6l\u00fcmdeki de\u011ferleri birle\u015ftiren bir tarih olu\u015fturmak i\u00e7in DATE i\u015flevini basit\u00e7e birle\u015ftirdik.<\/p><h2 id=\"5-5-get-quarter-end-date-from-a-date\" class=\"wp-block-heading\"> 5. Bir tarihten \u00e7eyrek biti\u015f tarihini al\u0131n<\/h2><p> Tamam, ba\u015flang\u0131\u00e7 \u200b\u200btarihi veya numaras\u0131 yerine \u00e7eyre\u011fin biti\u015f tarihine ihtiyac\u0131n\u0131z var ve bunun i\u00e7in kullanabilece\u011fimiz form\u00fcl \u015fu: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATE(YEAR(A2),((INT((MONTH(A2)-1)\/3)+1)*3)+1,1)-1<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22300\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-trimestrielle-excel-obtenir-la-date-de-fin.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00fc\u00e7 ayl\u0131k form\u00fcl excel biti\u015f tarihini al\" width=\"618\" height=\"134\"><\/figure><\/div><p> 26-May\u0131s-18 i\u00e7in, \u00e7eyre\u011fin son tarihi olan 30-Haz-18&#8217;de geri geliyor.<\/p><h3 id=\"how-this-formula-works\" class=\"wp-block-heading\"> <strong>Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/strong><\/h3><p> Bu form\u00fclde d\u00f6rt farkl\u0131 par\u00e7am\u0131z var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-trimestrielle-excel-obtenir-la-date-de-fin.png\" sizes=\"\" srcset=\"\" alt=\"\u00fc\u00e7 ayl\u0131k form\u00fcl excel biti\u015f tarihi alma \u00e7al\u0131\u015fmalar\u0131\"><\/figure><\/div><p> <strong>\u0130lk<\/strong> b\u00f6l\u00fcmde INT ve MONTH fonksiyonlar\u0131n\u0131 birle\u015ftirdik. MONTH, tarihin ay numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr, sonra bunu 3&#8217;e b\u00f6leriz. Daha sonra INT bunu en yak\u0131n tam say\u0131ya yuvarlar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-trimestrielle-excel-obtenir-la-date-de-fin-premiere-partie.png\" sizes=\"\" srcset=\"\" alt=\"\u00fc\u00e7 ayl\u0131k form\u00fcl excel biti\u015f tarihini al ilk b\u00f6l\u00fcm\"><\/figure><\/div><p> Son olarak \u00e7eyre\u011fin son ay\u0131 olan 6&#8217;y\u0131 (Haziran) elde etmek i\u00e7in bunu 3 ile \u00e7arp\u0131yoruz ve buna 1 ekliyoruz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-trimestrielle-excel-obtenir-la-date-de-fin-premiere-partie.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> Basit bir ifadeyle, form\u00fcl\u00fcn bu k\u0131sm\u0131, fiili tarihin ay\u0131n\u0131 bir sonraki \u00e7eyre\u011fin ilk ay\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-trimestrielle-excel-obtenir-la-date-de-fin-premiere-partie-plus-un.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> <strong>\u0130kinci<\/strong> b\u00f6l\u00fcmde ise y\u0131l\u0131 ger\u00e7ek tarihten almak i\u00e7in YEAR fonksiyonunu kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-trimestrielle-excel-obtenir-la-date-de-fin-deuxieme-partie.png\" sizes=\"\" srcset=\"\" alt=\"\u00fc\u00e7 ayl\u0131k form\u00fcl excel biti\u015f tarihini al b\u00f6l\u00fcm iki\"><\/figure><\/div><p> Bundan sonra, <strong>\u00fc\u00e7\u00fcnc\u00fc<\/strong> b\u00f6l\u00fcmde, tarihi DATE i\u015fleviyle tamamlamak i\u00e7in sadece 1&#8217;i kullan\u0131n.<\/p><p> \u00dczg\u00fcn\u00fcm! Bir \u015fey daha.<\/p><p> <strong>D\u00f6rd\u00fcnc\u00fcde<\/strong> , t\u00fcm form\u00fclden eksi 1, b\u00f6ylece bir sonraki \u00e7eyre\u011fin ilk tarihi yerine \u00e7eyre\u011fin son tarihini alabiliriz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-trimestrielle-excel-obtenir-la-date-de-fin-troisieme-partie.png\" sizes=\"\" srcset=\"\" alt=\"\u00fc\u00e7 ayl\u0131k form\u00fcl excel biti\u015f tarihini al \u00fc\u00e7\u00fcnc\u00fc b\u00f6l\u00fcm\"><\/figure><\/div><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\/quart-formule-2.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/p><\/div><h2 id=\"7-conclusion\" class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> \u0130\u015flevleri basit\u00e7e birle\u015ftirerek, bir tarihten itibaren \u00e7eyre\u011fi hesaplamak i\u00e7in basit bir form\u00fcl olu\u015fturabilirsiniz. Ve bu yaz\u0131m\u0131zda bunun i\u00e7in d\u00f6rt form\u00fcl + VBA kodunu inceledik.<\/p><p> A\u00e7\u0131k\u00e7as\u0131 #1, \u00e7eyrek randevu bulman\u0131n en \u00e7ok kullan\u0131lan ve en kolay yoludur ancak isterseniz geri kalan\u0131n\u0131 da kullanabilirsiniz. Umar\u0131m bu makaleyi faydal\u0131 bulmu\u015fsunuzdur, ama \u015fimdi bana \u015funu s\u00f6yleyin.<\/p><p> <em>Bir tarihten itibaren \u00e7eyrek say\u0131s\u0131n\u0131 hesaplamak i\u00e7in ba\u015fka bir y\u00f6ntem biliyor musunuz?<\/em><\/p><p> Yorumlar b\u00f6l\u00fcm\u00fcnde benimle payla\u015f\u0131n, sizden haber almak isterim ve bu ipucunu arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n. Eminim takdir edeceklerdir.<\/p><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\/ayin-adi\/\">Excel&#8217;de bir tarihten ay al\u0131n (al\u0131nt\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-1602","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>Excel&#039;deki bir tarihten \u00e7eyreklik nas\u0131l al\u0131n\u0131r?<\/title>\n<meta name=\"description\" content=\"Burada bir tarihten \u00e7eyreklik almak i\u00e7in kullanabilece\u011finiz en iyi 5 yolu listeledim. Bu y\u00f6ntemlerin her biri\" \/>\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\/ceyrek\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;deki bir tarihten \u00e7eyreklik nas\u0131l al\u0131n\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Burada bir tarihten \u00e7eyreklik almak i\u00e7in kullanabilece\u011finiz en iyi 5 yolu listeledim. Bu y\u00f6ntemlerin her biri\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/ceyrek\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:58:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-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=\"7 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/ceyrek\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/ceyrek\/\",\"name\":\"Excel&#39;deki bir tarihten \u00e7eyreklik nas\u0131l al\u0131n\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/ceyrek\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/ceyrek\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png\",\"datePublished\":\"2023-11-15T13:41:10+00:00\",\"dateModified\":\"2023-12-10T05:58:59+00:00\",\"description\":\"Burada bir tarihten \u00e7eyreklik almak i\u00e7in kullanabilece\u011finiz en iyi 5 yolu listeledim. Bu y\u00f6ntemlerin her biri\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/ceyrek\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/ceyrek\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/ceyrek\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/ceyrek\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bir randevunun \u00e7eyre\u011fi 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":"Excel&#39;deki bir tarihten \u00e7eyreklik nas\u0131l al\u0131n\u0131r?","description":"Burada bir tarihten \u00e7eyreklik almak i\u00e7in kullanabilece\u011finiz en iyi 5 yolu listeledim. Bu y\u00f6ntemlerin her biri","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\/ceyrek\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;deki bir tarihten \u00e7eyreklik nas\u0131l al\u0131n\u0131r?","og_description":"Burada bir tarihten \u00e7eyreklik almak i\u00e7in kullanabilece\u011finiz en iyi 5 yolu listeledim. Bu y\u00f6ntemlerin her biri","og_url":"https:\/\/exceladvisor.org\/tr\/ceyrek\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:58:59+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"7 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/ceyrek\/","url":"https:\/\/exceladvisor.org\/tr\/ceyrek\/","name":"Excel&#39;deki bir tarihten \u00e7eyreklik nas\u0131l al\u0131n\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/ceyrek\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/ceyrek\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png","datePublished":"2023-11-15T13:41:10+00:00","dateModified":"2023-12-10T05:58:59+00:00","description":"Burada bir tarihten \u00e7eyreklik almak i\u00e7in kullanabilece\u011finiz en iyi 5 yolu listeledim. Bu y\u00f6ntemlerin her biri","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/ceyrek\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/ceyrek\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/ceyrek\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/ceyrek\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Bir randevunun \u00e7eyre\u011fi 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\/1602","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=1602"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1602\/revisions"}],"predecessor-version":[{"id":2286,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1602\/revisions\/2286"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1602"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}