{"id":1844,"date":"2023-10-31T17:10:51","date_gmt":"2023-10-31T17:10:51","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/"},"modified":"2023-12-10T06:00:14","modified_gmt":"2023-12-10T06:00:14","slug":"ayin-sonu","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/","title":{"rendered":"Excel&#39;de ay\u0131n biti\u015f tarihi nas\u0131l al\u0131n\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3705858167\"><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>Bazen tamamlanma tarihi, biti\u015f tarihi, hedef tarih olarak kullanmak i\u00e7in bir ay biti\u015f tarihi almam\u0131z gerekir, bazen de iki tarih aras\u0131ndaki g\u00fcnleri hesaplamak i\u00e7in buna ihtiya\u00e7 duyar\u0131z.<\/p><p> Hi\u00e7 \u00e7aba harcamadan kolayca manuel olarak ekleyebiliriz, ancak baz\u0131 form\u00fcller <span style=\"font-size: revert;\">bunu hesaplamam\u0131za yard\u0131mc\u0131 olabilir.<\/span><\/p><p> Ay\u0131n son tarihini hesaplaman\u0131n en iyi yolu EOMONTH fonksiyonunu kullanmakt\u0131r. Ancak bunun d\u0131\u015f\u0131nda ba\u015fka y\u00f6ntemleri de (VBA) kullanabilirsiniz.<\/p><p> Bir form\u00fcl veya ba\u015fka bir dinamik y\u00f6ntem kullanman\u0131n avantaj\u0131, onu tekrar tekrar hesaplaman\u0131za gerek olmamas\u0131d\u0131r. Bug\u00fcn bu yaz\u0131mda Excel&#8217;de ay sonu tarihini alman\u0131n 3 basit ve dinamik yolunu sizlerle payla\u015fmak istiyorum.<\/p><p> \u00d6yleyse ba\u015flayal\u0131m ve takip etmek i\u00e7in l\u00fctfen ayn\u0131 dosyay\u0131 buradan indirin.<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> EOMONTH i\u015flevini kullanarak ay\u0131n son g\u00fcn\u00fcn\u00fc al\u0131n<\/h2><p> EOMONTH, bir ay\u0131n son g\u00fcn\u00fcn\u00fc hesaplamak i\u00e7in en sevdi\u011fim fonksiyondur. Bu i\u015flev \u00f6zellikle bu t\u00fcr hesaplamalar i\u00e7in tasarlanm\u0131\u015ft\u0131r.<\/p><p> Tek yapman\u0131z gereken, ge\u00e7erli bir tarihi ve ba\u015flang\u0131\u00e7 tarihinden \u00f6nceki ve sonraki son tarihi hesaplamak istedi\u011finiz ay say\u0131s\u0131n\u0131 belirtmenizdir. \u0130\u015fte s\u00f6zdizimi:<\/p><p class=\"formula\"> EOMONTH(ba\u015flang\u0131\u00e7_tarihi; ay)<\/p><p> Bu s\u00f6zdiziminde, ba\u015flang\u0131\u00e7 tarihi ge\u00e7erli tarih olacak ve aylar, ileri veya geri kalan aylar\u0131n say\u0131s\u0131n\u0131 temsil eden bir say\u0131 olacakt\u0131r.<\/p><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> Ayn\u0131 ay\u0131n biti\u015f tarihi<\/h2><p> Diyelim ki &#8220;06-\u015eubat-2017&#8221; tarihiniz var ve &#8220;\u015eubat&#8221; ay\u0131n\u0131n son g\u00fcn\u00fcn\u00fc almak istiyorsunuz. Bu durumda kullanman\u0131z gereken form\u00fcller \u015funlard\u0131r: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=EOMONTH(\"22-Feb-2017\",0)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-dernier-jour-dun-mois-en-cours-en-utilisant-eomonth-min-1.png\" sizes=\"\" srcset=\"\" alt=\"eomonth kullanarak mevcut ay\u0131n g\u00fcn sonunu al\u0131n\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte EOMONTH kullan\u0131ld\u0131\u011f\u0131nda \u015eubat ay\u0131n\u0131n son tarihi olan 28-Feb-2017 de\u011feri d\u00f6nd\u00fcr\u00fclm\u00fc\u015ft\u00fcr.<\/p><p> <strong>Nas\u0131l \u00e7al\u0131\u015f\u0131r<\/strong> : Burada say\u0131sal arg\u00fcman i\u00e7in &#8220;0&#8221; kulland\u0131n\u0131z \u00e7\u00fcnk\u00fc kulland\u0131\u011f\u0131n\u0131z ba\u015flang\u0131\u00e7 tarihi \u015eubat ay\u0131d\u0131r ve ayn\u0131 ay\u0131n son g\u00fcn\u00fcne sahip olmayacaks\u0131n\u0131z. &#8220;0&#8221; kulland\u0131\u011f\u0131n\u0131zda, yaln\u0131zca ba\u015flang\u0131\u00e7 tarihinizin oldu\u011fu ay i\u00e7in son tarihi d\u00f6nd\u00fcr\u00fcr.<\/p><p> Dinamik bir form\u00fcl olu\u015fturmak i\u00e7in <code>start_date<\/code> ba\u011f\u0131ms\u0131z de\u011fi\u015fkeninde BUG\u00dcN i\u015flevini kullanabilirsiniz.<\/p><h2 id=\"tab-con-3\" class=\"wp-block-heading\"> Gelecek ay\u0131n biti\u015f tarihi<\/h2><p> \u015eimdi ayn\u0131 tarihten itibaren &#8220;Nisan&#8221; ay\u0131n\u0131n son g\u00fcn\u00fcn\u00fc almak istedi\u011finizi varsayal\u0131m. Bu durumda kullanman\u0131z gereken form\u00fcller \u015funlard\u0131r: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=EOMONTH(\"22-Feb-2017\",2)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-dernier-jour-du-mois-futur-en-utilisant-eomonth-min-1.png\" sizes=\"\" srcset=\"\" alt=\"eomonth kullanarak gelecek ay i\u00e7in ay biti\u015f tarihini al\u0131n\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte form\u00fcl, Nisan ay\u0131n\u0131n son tarihi olan 30 Nisan 2017&#8217;yi d\u00f6nd\u00fcr\u00fcyordu.<\/p><h3 class=\"wp-block-heading\"> Nas\u0131l \u00e7al\u0131\u015f\u0131r<\/h3><p> Burada say\u0131sal arg\u00fcman olarak &#8216;2&#8217;yi kulland\u0131n\u0131z ve kulland\u0131\u011f\u0131n\u0131z ba\u015flang\u0131\u00e7 tarihi \u015eubat&#8217;t\u0131r. \u015eimdi bakarsan\u0131z Nisan, \u015eubat ay\u0131ndan tam 2 ay sonra, bu y\u00fczden 30 Nisan 2017&#8217;de geri geldi.<\/p><h2 id=\"tab-con-4\" class=\"wp-block-heading\"> \u00d6nceki ay\u0131n biti\u015f tarihi<\/h2><p> Ve e\u011fer \u00f6nceki ay\u0131n son tarihini almak istiyorsan\u0131z bunun i\u00e7in negatif bir say\u0131 kullanabilirsiniz. Diyelim ki Ocak ay\u0131n\u0131n son g\u00fcn\u00fcn\u00fc istiyorsunuz. Yani kullanman\u0131z gereken form\u00fcl: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=EOMONTH(\"22-Feb-2017\",-1)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11929\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-dernier-jour-du-mois-precedent-en-utilisant-eomonth-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"eomonth kullanarak \u00f6nceki aya ait ay biti\u015f tarihini al\u0131n\" width=\"524\" height=\"143\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte form\u00fcl, Ocak ay\u0131n\u0131n son tarihi olan 31 Ocak 2017&#8217;yi d\u00f6nd\u00fcr\u00fcyordu.<\/p><p> <strong>Nas\u0131l \u00e7al\u0131\u015f\u0131r:<\/strong> Burada say\u0131sal arg\u00fcman i\u00e7in &#8220;-1&#8221; kulland\u0131n\u0131z ve Ocak, \u015eubat&#8217;tan tam olarak 1 ay \u00f6ncedir.<\/p><h2 id=\"tab-con-5\" class=\"wp-block-heading\"> Ay\u0131n son tarihini almak i\u00e7in DATE i\u015flevi<\/h2><p> DATE i\u015flevi, Excel&#8217;de son g\u00fcn\u00fc almak i\u00e7in ba\u015fka bir yakla\u015f\u0131md\u0131r. Tarih i\u015flevi, y\u0131l\u0131, ay\u0131 ve g\u00fcn\u00fc belirterek ge\u00e7erli bir Excel tarihi olu\u015fturman\u0131za yard\u0131mc\u0131 olur. \u0130\u015fte s\u00f6zdizimi:<\/p><p> TAR\u0130H(y\u0131l, ay, g\u00fcn)<\/p><p> Bahsetti\u011fim gibi tarih fonksiyonunda y\u0131l, ay ve g\u00fcn\u00fc girmeniz gerekiyor ve buna g\u00f6re ge\u00e7erli bir tarih d\u00f6nd\u00fcr\u00fcyor. \u015eimdi, bug\u00fcnk\u00fc tart\u0131\u015fmayla yapabilece\u011finiz k\u00fc\u00e7\u00fck bir numara var. <\/p><div class=\"su-note\" style=\"border-color: #bdc7a7; border-radius: 3px; -moz-border-radius: 3px; -webkit-border-radius: 3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color: #d7e1c1; border-color: #ffffff; color: #3a3a3a; border-radius: 3px; -moz-border-radius: 3px; -webkit-border-radius: 3px;\"> <strong>K\u00fc\u00e7\u00fck ipucu:<\/strong> G\u00fcn olarak 0&#8217;\u0131 kullan\u0131rsan\u0131z \u00f6nceki ay\u0131n son tarihi d\u00f6nd\u00fcr\u00fcl\u00fcr. \u00d6rne\u011fin Y\u0131l: 2017, Ay: 4 (yani May\u0131s) ve G\u00fcn: 0 belirtirseniz sonu\u00e7 30-Nisan-2017 de\u011ferini verecektir.<\/div><\/div><p> \u0130\u00e7inde bulunulan ay\u0131n son g\u00fcn\u00fcn\u00fc hesaplamak istiyorsan\u0131z form\u00fcl \u015f\u00f6yle olacakt\u0131r: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-dernier-jour-du-mois-en-utilisant-la-date-min-1.png\" sizes=\"\" srcset=\"\" alt=\"tarih i\u015flevini kullanarak ay\u0131n biti\u015f tarihini al\u0131n\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATE(CurrentYear,CurrentMonth + 1,0)<\/code><\/pre><p> Veya yaln\u0131zca ba\u015fvurulacak bir tarihiniz varsa form\u00fcl \u015f\u00f6yle olacakt\u0131r:<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATE(YEAR(date),MONTH(date)+1,0)<\/code><\/pre><h2 id=\"tab-con-6\" class=\"wp-block-heading\"> UDF ile son g\u00fcn\u00fc al\u0131n<\/h2><p> Harika bir VBA \u00f6rne\u011fi. Bu, ay\u0131n son g\u00fcn\u00fcn\u00fc almak i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/\">VBA UDF&#8217;yi<\/a> kullanmaya y\u00f6nelik bir makro koddur. VBA d\u00fczenleyicinize kopyalaman\u0131z yeterli. <\/p><pre class=\"wp-block-code\"> <code class=\"language-Visual Basic\" lang=\"Visual Basic\">Function LastD(Optional sd As Date = 0) As Date If sd = 0 Then sd = VBA.DateLastD = VBA.DateSerial(VBA.Year(sd), VBA.Month(sd) + 1, 0) End Function<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-dernier-jour-dun-mois-en-utilisant-vba-min-1.png\" sizes=\"\" srcset=\"\" alt=\"vba kullanarak ay\u0131n biti\u015f tarihini almak\"><\/figure><\/div><p> E-tablonuzda \u201c=SonD(\u201d yaz\u0131n ve ay\u0131n tarihini veya bir h\u00fccreye referans\u0131 girin. Ayr\u0131ca, ge\u00e7erli ay\u0131n son g\u00fcn\u00fcn\u00fc istiyorsan\u0131z parantez kullanarak bo\u015f b\u0131rakman\u0131z yeterlidir.<\/p><h2 class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> Dedi\u011fim gibi ay\u0131n son g\u00fcn\u00fc hedef tarihleri, biti\u015f tarihlerini veya tamamlanma tarihlerini hesaplarken size yard\u0131mc\u0131 olabilir. Ve \u015fimdi bunu elde etmenin \u00fc\u00e7 farkl\u0131 yolu var.<\/p><p> EOMONTH kullan\u0131yorsan\u0131z ge\u00e7mi\u015f veya gelecek aylar\u0131 tarihlemenize yard\u0131mc\u0131 olabilecek dinamik bir form\u00fcl olu\u015fturmak \u00e7ok kolayd\u0131r ve bence bunu yapman\u0131n en iyi yolu budur.<\/p><p> Umar\u0131m faydal\u0131 bulmu\u015fsunuzdur ve becerilerinizi bir sonraki seviyeye ta\u015f\u0131man\u0131za yard\u0131mc\u0131 olacakt\u0131r.<\/p><p> \u015eimdi bana bir \u015fey s\u00f6yle. Her \u015feyden \u00f6nce en sevdi\u011finiz y\u00f6ntem nedir? Yoksa farkl\u0131 bir y\u00f6nteminiz mi var? L\u00fctfen yorum kutusunda 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-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\/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><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ceyrek\/\">Excel&#8217;de bir tarihten [Mali + Takvim] d\u00f6rtte birini al\u0131n<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/\">Excel&#8217;de iki tarih aras\u0131ndaki ay say\u0131s\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/2-numaradaki-ayin-adi\/\">Ay ad\u0131n\u0131 say\u0131ya d\u00f6n\u00fc\u015ft\u00fcr<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ay-yil-icindeki-tarih\/\">Tarihi ay ve y\u0131la d\u00f6n\u00fc\u015ft\u00fcrme<\/a><\/li><\/ul><\/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-1844","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>\u25b7 Excel&#039;de ay\u0131n biti\u015f tarihi nas\u0131l al\u0131n\u0131r?<\/title>\n<meta name=\"description\" content=\"Bazen tamamlanma tarihi, vade tarihi, hedef tarih olarak kullanmak i\u00e7in ay sonu tarihi almam\u0131z gerekir, bazen de...\" \/>\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-sonu\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Excel&#039;de ay\u0131n biti\u015f tarihi nas\u0131l al\u0131n\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Bazen tamamlanma tarihi, vade tarihi, hedef tarih olarak kullanmak i\u00e7in ay sonu tarihi almam\u0131z gerekir, bazen de...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:00:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-dernier-jour-dun-mois-en-cours-en-utilisant-eomonth-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-sonu\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/\",\"name\":\"\u25b7 Excel&#39;de ay\u0131n biti\u015f tarihi nas\u0131l al\u0131n\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-dernier-jour-dun-mois-en-cours-en-utilisant-eomonth-min-1.png\",\"datePublished\":\"2023-10-31T17:10:51+00:00\",\"dateModified\":\"2023-12-10T06:00:14+00:00\",\"description\":\"Bazen tamamlanma tarihi, vade tarihi, hedef tarih olarak kullanmak i\u00e7in ay sonu tarihi almam\u0131z gerekir, bazen de...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-dernier-jour-dun-mois-en-cours-en-utilisant-eomonth-min-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-dernier-jour-dun-mois-en-cours-en-utilisant-eomonth-min-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de ay\u0131n biti\u015f tarihi 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":"\u25b7 Excel&#39;de ay\u0131n biti\u015f tarihi nas\u0131l al\u0131n\u0131r?","description":"Bazen tamamlanma tarihi, vade tarihi, hedef tarih olarak kullanmak i\u00e7in ay sonu tarihi almam\u0131z gerekir, bazen de...","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-sonu\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Excel&#39;de ay\u0131n biti\u015f tarihi nas\u0131l al\u0131n\u0131r?","og_description":"Bazen tamamlanma tarihi, vade tarihi, hedef tarih olarak kullanmak i\u00e7in ay sonu tarihi almam\u0131z gerekir, bazen de...","og_url":"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:00:14+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-dernier-jour-dun-mois-en-cours-en-utilisant-eomonth-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-sonu\/","url":"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/","name":"\u25b7 Excel&#39;de ay\u0131n biti\u015f tarihi nas\u0131l al\u0131n\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-dernier-jour-dun-mois-en-cours-en-utilisant-eomonth-min-1.png","datePublished":"2023-10-31T17:10:51+00:00","dateModified":"2023-12-10T06:00:14+00:00","description":"Bazen tamamlanma tarihi, vade tarihi, hedef tarih olarak kullanmak i\u00e7in ay sonu tarihi almam\u0131z gerekir, bazen de...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/ayin-sonu\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-dernier-jour-dun-mois-en-cours-en-utilisant-eomonth-min-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-le-dernier-jour-dun-mois-en-cours-en-utilisant-eomonth-min-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de ay\u0131n biti\u015f tarihi 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\/1844","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=1844"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1844\/revisions"}],"predecessor-version":[{"id":2389,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1844\/revisions\/2389"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}