{"id":1578,"date":"2023-11-16T09:57:07","date_gmt":"2023-11-16T09:57:07","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/"},"modified":"2023-12-10T06:02:38","modified_gmt":"2023-12-10T06:02:38","slug":"tarih-araligi","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/","title":{"rendered":"Excel&#39;de tarih aral\u0131\u011f\u0131 nas\u0131l olu\u015fturulur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-4209999273\"><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>Tarih i\u00e7eren veriler \u00fczerinde \u00e7al\u0131\u015f\u0131rken tarih aral\u0131\u011f\u0131 olu\u015fturman\u0131z gerekebilir. Aral\u0131k, ba\u015flang\u0131\u00e7 tarihi ve biti\u015f tarihi olan bir \u015feydir. Bu e\u011fitimde tarih aral\u0131\u011f\u0131n\u0131n nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.<\/p><h2 class=\"wp-block-heading\"> Bug\u00fcnden itibaren bir tarih aral\u0131\u011f\u0131 olu\u015fturun<\/h2><p> \u015eimdi, bug\u00fcnden yedi g\u00fcn sonras\u0131na ait bir tarih aral\u0131\u011f\u0131 olu\u015fturmak istedi\u011finizi varsayal\u0131m. A\u015fa\u011f\u0131daki \u00f6rnekte A1 h\u00fccresinde bug\u00fcn fonksiyonunu kullanarak elde etti\u011fimiz bug\u00fcn\u00fcn tarihi bulunmaktad\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64220\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png\" sizes=\"auto, \" srcset=\"\" alt=\"bug\u00fcnden-tarih aral\u0131\u011f\u0131\" width=\"387\" height=\"284\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1+7<\/code><\/pre><p> Tarih aral\u0131\u011f\u0131 olu\u015fturmak i\u00e7in \u015fu basit ad\u0131mlar\u0131 izleyin:<\/p><ol type=\"1\"><li> B1 h\u00fccresine veya ba\u015fka bir h\u00fccreye \u201c=\u201d girin.<\/li><li> Aral\u0131\u011f\u0131n ba\u015flang\u0131\u00e7 tarihinin bulundu\u011fu A1 h\u00fccresine bak\u0131n.<\/li><li> Bug\u00fcn\u00fcn tarihine g\u00fcn eklemek i\u00e7in &#8220;+&#8221; i\u015faretini kullan\u0131n.<\/li><li> Bug\u00fcn\u00fcn tarihine eklemek istedi\u011finiz g\u00fcn say\u0131s\u0131n\u0131 belirtin. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64221\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-creer-une-plage-de-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir tarih aral\u0131\u011f\u0131 olu\u015ftur\" width=\"395\" height=\"239\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Tek h\u00fccrede tarih aral\u0131\u011f\u0131 olu\u015fturma<\/h2><p> Bir ad\u0131m daha ileri giderek tek h\u00fccrede tarih aral\u0131\u011f\u0131 olu\u015ftural\u0131m. Bunun i\u00e7in hem ba\u015flang\u0131\u00e7 tarihini hem de biti\u015f tarihini tek bir h\u00fccrede birle\u015ftirmemiz gerekiyor. Ancak sorun \u015fu ki, iki tarihi tek bir h\u00fccrede birle\u015ftirmeye \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda a\u015fa\u011f\u0131daki gibi bir \u015fey d\u00f6nd\u00fcr\u00fcyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64222\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-creer-une-plage-de-dates-dans-une-seule-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"tek-h\u00fccrede-bir-tarih aral\u0131\u011f\u0131 olu\u015ftur\" width=\"452\" height=\"242\"><\/figure><\/div><p> \u015eimdi bu sorunun \u00fcstesinden gelmek i\u00e7in tarihleri metne d\u00f6n\u00fc\u015ft\u00fcrmek ve ard\u0131ndan bunlar\u0131 bir tarih aral\u0131\u011f\u0131nda birle\u015ftirmek i\u00e7in TEXT i\u015flevini kullanmam\u0131z gerekiyor. Form\u00fcl a\u015fa\u011f\u0131daki gibi bir \u015fey olacakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64224\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-fonction-de-texte-pour-la-plage-de-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"tarih aral\u0131\u011f\u0131 i\u00e7in metin i\u015flevi\" width=\"626\" height=\"268\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(A1,\"dd\/mmm\/yy\")&amp;\" --- \"&amp;TEXT(B1,\"dd\/mmm\/yy\")<\/code><\/pre><p> \u015eimdi g\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi C1 h\u00fccresinde 8 \u015eubat 22\u2019den 15 \u015eubat 22\u2019ye kadar bir tarih aral\u0131\u011f\u0131m\u0131z var. E\u011fer tek h\u00fccrede tarih aral\u0131\u011f\u0131 olu\u015fturmak istiyorsan\u0131z a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(TODAY(),\"dd\/mmm\/yy\")&amp;\" --- \"&amp;TEXT(A1+7,\"dd\/mmm\/yy\")<\/code><\/pre><p> TEXT fonksiyonunun kullan\u0131m\u0131 ile ilgili k\u0131s\u0131mda tarih format\u0131n\u0131 diledi\u011finiz gibi de\u011fi\u015ftirebilirsiniz. <\/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> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-une-plage-de-dates.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/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\/iki-tarihi-karsilastir\/\">Excel&#8217;de iki tarihi kar\u015f\u0131la\u015ft\u0131r\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tarihi-sayiya-donustur\/\">Excel&#8217;de tarihi say\u0131ya d\u00f6n\u00fc\u015ft\u00fcr\u00fcn<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bugune-kadarki-metin\/\">Excel&#8217;de metni tarihe d\u00f6n\u00fc\u015ft\u00fcrme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ozel-tarih-formatlari\/\">Excel&#8217;de \u00f6zel tarih bi\u00e7imleri<\/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-arasini-vurgulama\/\">Excel&#8217;de iki tarih aras\u0131ndaki tarihleri vurgulay\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/iki-tarihi-birlestir\/\">Excel&#8217;de iki tarihi h\u0131zla birle\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/rastgele-tarih-olusturucu\/\">Excel&#8217;de Rastgele Tarih Olu\u015fturucu (Excel Form\u00fcl\u00fc)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-ve-saati-birlestir\/\">Excel&#8217;de tarih ve saati birle\u015ftirme<\/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-1578","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;de tarih aral\u0131\u011f\u0131 nas\u0131l olu\u015fturulur? - Excel Dan\u0131\u015fman\u0131<\/title>\n<meta name=\"description\" content=\"Bu form\u00fcller e\u011fitiminde, metin i\u015flevini ve\" \/>\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\/tarih-araligi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de tarih aral\u0131\u011f\u0131 nas\u0131l olu\u015fturulur? - Excel Dan\u0131\u015fman\u0131\" \/>\n<meta property=\"og:description\" content=\"Bu form\u00fcller e\u011fitiminde, metin i\u015flevini ve\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:02:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.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=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/\",\"name\":\"Excel&#39;de tarih aral\u0131\u011f\u0131 nas\u0131l olu\u015fturulur? - Excel Dan\u0131\u015fman\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png\",\"datePublished\":\"2023-11-16T09:57:07+00:00\",\"dateModified\":\"2023-12-10T06:02:38+00:00\",\"description\":\"Bu form\u00fcller e\u011fitiminde, metin i\u015flevini ve\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de tarih aral\u0131\u011f\u0131 nas\u0131l olu\u015fturulur?\"}]},{\"@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;de tarih aral\u0131\u011f\u0131 nas\u0131l olu\u015fturulur? - Excel Dan\u0131\u015fman\u0131","description":"Bu form\u00fcller e\u011fitiminde, metin i\u015flevini ve","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\/tarih-araligi\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de tarih aral\u0131\u011f\u0131 nas\u0131l olu\u015fturulur? - Excel Dan\u0131\u015fman\u0131","og_description":"Bu form\u00fcller e\u011fitiminde, metin i\u015flevini ve","og_url":"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:02:38+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/","url":"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/","name":"Excel&#39;de tarih aral\u0131\u011f\u0131 nas\u0131l olu\u015fturulur? - Excel Dan\u0131\u015fman\u0131","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png","datePublished":"2023-11-16T09:57:07+00:00","dateModified":"2023-12-10T06:02:38+00:00","description":"Bu form\u00fcller e\u011fitiminde, metin i\u015flevini ve","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/tarih-araligi\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de tarih aral\u0131\u011f\u0131 nas\u0131l olu\u015fturulur?"}]},{"@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\/1578","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=1578"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1578\/revisions"}],"predecessor-version":[{"id":2608,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1578\/revisions\/2608"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1578"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}