{"id":1800,"date":"2023-11-04T01:51:44","date_gmt":"2023-11-04T01:51:44","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/"},"modified":"2023-12-10T06:01:10","modified_gmt":"2023-12-10T06:01:10","slug":"iki-tarih-arasindaki-ay","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/","title":{"rendered":"Excel&#39;de iki tarih aras\u0131ndaki aylar nas\u0131l say\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-334049367\"><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 iki tarih aras\u0131ndaki ay say\u0131s\u0131n\u0131 alman\u0131n en iyi yolu ETAR\u0130HL\u0130 i\u015flevini kullanmakt\u0131r. Bu fonksiyonda ba\u015flang\u0131\u00e7 tarihini ve biti\u015f tarihini belirtmeniz gerekir. Bundan sonra sonucu almak istedi\u011finiz birimi de belirtmeniz gerekir.<\/p><p> A\u015fa\u011f\u0131daki \u00f6rnekte A2 ve B2 h\u00fccrelerinde iki tarihimiz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69850\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-dates-dans-les-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"h\u00fccre i\u00e7i iki randevu\" width=\"419\" height=\"319\"><\/figure><\/div><h2 class=\"wp-block-heading\"> \u0130ki tarih aras\u0131ndaki aylar\u0131 alma form\u00fcl\u00fc (DATEDIF)<\/h2><ol type=\"1\"><li> \u0130lk olarak C2 h\u00fccresine TAR\u0130HL\u0130 E\u011eER i\u015flevini girin.<\/li><li> Bundan sonra, ilk ba\u011f\u0131ms\u0131z de\u011fi\u015fkende ba\u015flang\u0131\u00e7 tarihinin bulundu\u011fu A2 h\u00fccresine bak\u0131n.<\/li><li> Daha sonra ikinci arg\u00fcmanda biti\u015f tarihinin bulundu\u011fu B2&#8217;ye bak\u0131n.<\/li><li> \u015eimdi \u00fc\u00e7\u00fcnc\u00fc arg\u00fcmana \u201cm\u201d girin.<\/li><li> Sonunda sonucu almak i\u00e7in Enter tu\u015funa bas\u0131n. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69851\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-dates-si-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"tarihliif-form\u00fcl\u00fc\" width=\"463\" height=\"302\"><\/figure><\/div><p> Burada sonu\u00e7ta 11 oldu\u011funu g\u00f6r\u00fcyorsunuz, bu do\u011fru \u00e7\u00fcnk\u00fc Mart 2021 ile \u015eubat 2022 aras\u0131nda 11 ay\u0131m\u0131z var.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATEDIF(A2,B2,\"m\")<\/code><\/pre><p> TAR\u0130HL\u0130 E\u011eER fonksiyonuna girdi\u011finizde g\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi Excel fonksiyonu g\u00f6r\u00fcnt\u00fclemiyor ve bu fonksiyonu listedeki fonksiyonlar listesinde bulamazs\u0131n\u0131z. DATEDIF hakk\u0131nda daha fazla bilgiyi buradan edinebilirsiniz. Aylar\u0131 ve g\u00fcnleri ayr\u0131 ayr\u0131, ancak tek bir h\u00fccrede g\u00f6r\u00fcnt\u00fclemek i\u00e7in DATEDIF&#8217;i de kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69852\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-dates-pour-afficher-les-mois-jours-separement.png\" sizes=\"auto, \" srcset=\"\" alt=\"ay-g\u00fcnleri-ayr\u0131 ayr\u0131-g\u00f6r\u00fcnt\u00fclenecekse tarihli\" width=\"720\" height=\"355\"><\/figure><\/div><p> Yukar\u0131daki form\u00fclde, aylar\u0131, ard\u0131ndan g\u00fcnleri elde etmek i\u00e7in DATEDIF&#8217;i iki kez kulland\u0131k, ard\u0131ndan tam bir sonu\u00e7 elde etmek i\u00e7in iki form\u00fcl\u00fc birle\u015ftirdik.<\/p><h2 class=\"wp-block-heading\"> YEARFRAC kullan\u0131larak iki tarih aras\u0131ndaki ay<\/h2><p> 2 tarih aras\u0131ndaki aylar\u0131 saymam\u0131z gereken bir durum olabilir ama aylar bittikten sonra kalan g\u00fcnleri de hesaba katmam\u0131z gerekiyor. Bu durumda en iyi yol YEARFRAC fonksiyonunu kullanmakt\u0131r.<\/p><p> YILFRAC&#8217;ta, ilk ba\u011f\u0131ms\u0131z de\u011fi\u015fkende ba\u015flang\u0131\u00e7 tarihini belirtmeniz ve ard\u0131ndan ikinci ba\u011f\u0131ms\u0131z de\u011fi\u015fkende biti\u015f tarihini belirtmeniz gerekir. Daha sonra y\u0131ld\u0131z i\u015faretini kullanarak 12 ile \u00e7arp\u0131n.<\/p><p> \u015eimdi enter tu\u015funa bast\u0131\u011f\u0131n\u0131zda, bu iki tarih aras\u0131ndaki toplam ay say\u0131s\u0131n\u0131 tamsay\u0131 olarak ve g\u00fcnleri ondal\u0131k say\u0131 olarak alacaks\u0131n\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69853\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-frac-de-4-ans.png\" sizes=\"auto, \" srcset=\"\" alt=\"y\u0131ll\u0131k frac i\u015flevi\" width=\"495\" height=\"266\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte ba\u015flang\u0131\u00e7 tarihi olarak 1 Mart 2021, biti\u015f tarihi olarak ise 23 \u015eubat 2022&#8217;yi g\u00f6r\u00fcyoruz. \u015eimdi YEARFRAC kulland\u0131\u011f\u0131mda 11,73 de\u011ferini d\u00f6nd\u00fcr\u00fcyor; burada 11, ay say\u0131s\u0131d\u0131r ve 0,73, \u015eubat ay\u0131nda sahip oldu\u011fumuz 23 g\u00fcn\u00fc temsil eden ondal\u0131k de\u011ferdir.<\/p><p> Sonucu yuvarlamak istiyorsan\u0131z bu form\u00fcl\u00fc yuvarlama fonksiyonuyla sarabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69854\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-tours-avec-fonction-yearfrac.png\" sizes=\"auto, \" srcset=\"\" alt=\"y\u0131ll\u0131k frac ile yuvarlak i\u015flev\" width=\"608\" height=\"287\"><\/figure><\/div><h2 class=\"wp-block-heading\"> \u0130ki tarih aras\u0131ndaki ay\u0131 bulmak i\u00e7in YIL + AY i\u015flevini kullanma<\/h2><p> \u0130ki tarih aras\u0131ndaki ay say\u0131s\u0131n\u0131 almak i\u00e7in kullanabilece\u011finiz ba\u015fka bir y\u00f6ntem daha var. YIL ve AY i\u015flevlerini birle\u015ftirerek aylar\u0131 d\u00f6nd\u00fcren a\u015fa\u011f\u0131daki form\u00fcl\u00fc olu\u015fturabilirsiniz. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=(YEAR(B2)-YEAR(A2))*12+MONTH(B2)-MONTH(A2)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69855\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-6-ans-plus-mois.png\" sizes=\"auto, \" srcset=\"\" alt=\"y\u0131l art\u0131 ay i\u015flevi\" width=\"672\" height=\"292\"><\/figure><\/div><p> Bu i\u015flevi anlamak i\u00e7in onu iki b\u00f6l\u00fcme ay\u0131rman\u0131z gerekir:<\/p><p> Y\u0131l fonksiyonumuzun oldu\u011fu ilk k\u0131s\u0131mda \u00f6nce biti\u015f tarihinin y\u0131l\u0131n\u0131, ard\u0131ndan ba\u015flang\u0131\u00e7 tarihinin y\u0131l\u0131n\u0131 al\u0131p on ikiyle \u00e7arp\u0131yor. Bu b\u00f6l\u00fcm, tarihler aras\u0131nda kalan ay say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69856\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-premiere-partie-de-la-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"fonksiyonun ilk k\u0131sm\u0131\" width=\"583\" height=\"308\"><\/figure><\/div><p> Form\u00fcl\u00fcn bu k\u0131sm\u0131 sadece tarihlerin farkl\u0131 y\u0131llara sahip olmas\u0131 durumunda fark yarat\u0131r, her iki tarih de ayn\u0131 y\u0131llara sahiptir, bu durumda bu k\u0131s\u0131m hesaplamada herhangi bir fark yaratmayacakt\u0131r. G\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi elimizde 2021 ve 2022 var ve form\u00fcl\u00fcn bu k\u0131sm\u0131n\u0131n verdi\u011fi sonu\u00e7 12.<\/p><p> \u0130kinci k\u0131s\u0131mda ise ba\u015flang\u0131\u00e7 tarihinden itibaren ay\u0131, biti\u015f tarihinden itibaren ay\u0131 \u00e7\u0131kar\u0131yoruz. Ve bu k\u0131s\u0131m ayn\u0131 zamanda eri\u015fime sahip oldu\u011fumuz g\u00fcnleri de g\u00f6z ard\u0131 ediyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69857\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-deuxieme-partie-de-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"fonksiyonun ikinci k\u0131sm\u0131\" width=\"560\" height=\"318\"><\/figure><\/div><p> Yani (3 Mart)&#8217;\u0131 \u015eubat (2)&#8217;den \u00e7\u0131kard\u0131\u011f\u0131m\u0131zda sonu\u00e7ta -1 elde ederiz.<\/p><p> Bundan sonra, 12&#8217;den -1&#8217;i \u00e7\u0131kararak iki tarih aras\u0131ndaki toplam ay say\u0131s\u0131 olan 11&#8217;i elde ederiz. Bana en \u00e7ok hangi y\u00f6ntemi be\u011fendi\u011fimi sorarsan\u0131z kullan\u0131m\u0131 basit ve kullan\u0131c\u0131 taraf\u0131ndan anla\u015f\u0131lmas\u0131 kolay olan DATEDIF derdim. <\/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\/mois-entre-les-dates.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\/ayin-adi\/\">Excel&#8217;deki 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\"><\/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-1800","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 iki tarih aras\u0131ndaki aylar nas\u0131l say\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Bu dersimizde iki tarih aras\u0131nda kalan ay say\u0131s\u0131n\u0131 bulmak i\u00e7in nas\u0131l form\u00fcl yazaca\u011f\u0131m\u0131z\u0131 \u00f6\u011frenece\u011fiz.\" \/>\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\/iki-tarih-arasindaki-ay\/\" \/>\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 iki tarih aras\u0131ndaki aylar nas\u0131l say\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Bu dersimizde iki tarih aras\u0131nda kalan ay say\u0131s\u0131n\u0131 bulmak i\u00e7in nas\u0131l form\u00fcl yazaca\u011f\u0131m\u0131z\u0131 \u00f6\u011frenece\u011fiz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-dates-dans-les-cellules.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=\"4 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/\",\"name\":\"\u25b7 Excel&#39;de iki tarih aras\u0131ndaki aylar nas\u0131l say\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-dates-dans-les-cellules.png\",\"datePublished\":\"2023-11-04T01:51:44+00:00\",\"dateModified\":\"2023-12-10T06:01:10+00:00\",\"description\":\"Bu dersimizde iki tarih aras\u0131nda kalan ay say\u0131s\u0131n\u0131 bulmak i\u00e7in nas\u0131l form\u00fcl yazaca\u011f\u0131m\u0131z\u0131 \u00f6\u011frenece\u011fiz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-dates-dans-les-cellules.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-dates-dans-les-cellules.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de iki tarih aras\u0131ndaki aylar nas\u0131l say\u0131l\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 iki tarih aras\u0131ndaki aylar nas\u0131l say\u0131l\u0131r?","description":"Bu dersimizde iki tarih aras\u0131nda kalan ay say\u0131s\u0131n\u0131 bulmak i\u00e7in nas\u0131l form\u00fcl yazaca\u011f\u0131m\u0131z\u0131 \u00f6\u011frenece\u011fiz.","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\/iki-tarih-arasindaki-ay\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Excel&#39;de iki tarih aras\u0131ndaki aylar nas\u0131l say\u0131l\u0131r?","og_description":"Bu dersimizde iki tarih aras\u0131nda kalan ay say\u0131s\u0131n\u0131 bulmak i\u00e7in nas\u0131l form\u00fcl yazaca\u011f\u0131m\u0131z\u0131 \u00f6\u011frenece\u011fiz.","og_url":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:10+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-dates-dans-les-cellules.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"4 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/","url":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/","name":"\u25b7 Excel&#39;de iki tarih aras\u0131ndaki aylar nas\u0131l say\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-dates-dans-les-cellules.png","datePublished":"2023-11-04T01:51:44+00:00","dateModified":"2023-12-10T06:01:10+00:00","description":"Bu dersimizde iki tarih aras\u0131nda kalan ay say\u0131s\u0131n\u0131 bulmak i\u00e7in nas\u0131l form\u00fcl yazaca\u011f\u0131m\u0131z\u0131 \u00f6\u011frenece\u011fiz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-dates-dans-les-cellules.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-dates-dans-les-cellules.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-ay\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de iki tarih aras\u0131ndaki aylar nas\u0131l say\u0131l\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\/1800","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=1800"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1800\/revisions"}],"predecessor-version":[{"id":2483,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1800\/revisions\/2483"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}