{"id":4671,"date":"2023-07-09T03:10:34","date_gmt":"2023-07-09T03:10:34","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-rastgele-tarihler-olustur\/"},"modified":"2023-07-09T03:10:34","modified_gmt":"2023-07-09T03:10:34","slug":"excel-rastgele-tarihler-olustur","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-rastgele-tarihler-olustur\/","title":{"rendered":"Excel'de rastgele tarihler nas\u0131l olu\u015fturulur (\u00f6rneklerle)"},"content":{"rendered":"

<\/p>\n

\n

Excel’de belirli bir tarih aral\u0131\u011f\u0131 aras\u0131nda rastgele bir tarih olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n

 =RANDBETWEEN( $A$2<\/span> , $B$2<\/span> )\n<\/strong><\/pre>\n
 Bu form\u00fcl, ba\u015flang\u0131\u00e7 tarihinin A2<\/strong> h\u00fccresinde, biti\u015f tarihinin ise B2<\/strong> h\u00fccresinde oldu\u011funu varsayar.<\/span><\/p>\n
 Varsay\u0131lan olarak, Excel bu rastgele tarihi say\u0131sal bir de\u011fer olarak g\u00f6r\u00fcnt\u00fcler, ancak bunun yerine bunu bir tarih de\u011feri olarak g\u00f6r\u00fcnt\u00fclemek i\u00e7in Excel’deki Say\u0131 Bi\u00e7imi<\/strong> \u00f6zelli\u011fini kullanabilirsiniz.<\/span><\/p>\n
 A\u015fa\u011f\u0131daki \u00f6rnek, pratikte Excel’de rastgele tarihlerin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n
 \u00d6rnek: Excel’de rastgele tarihler olu\u015fturma<\/strong><\/span><\/h2>\n
 Diyelim ki Excel’de 1\/1\/2000 ile 31\/12\/2023 tarihleri aras\u0131nda rastgele bir tarih olu\u015fturmak istiyoruz.<\/span><\/p>\n
 Bu ba\u015flang\u0131\u00e7 ve biti\u015f tarihlerini s\u0131ras\u0131yla A2<\/strong> ve B2<\/strong> h\u00fccrelerine girebilir ve ard\u0131ndan C2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc girerek bu iki tarih aras\u0131nda rastgele bir tarih olu\u015fturabiliriz:<\/span><\/p>\n
 =RANDBETWEEN( $A$2<\/span> , $B$2<\/span> )<\/strong><\/pre>\n
 A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir:<\/span> <\/p>\n
\"\"<\/p>\n
 RANDBETWEEN<\/strong> i\u015flevi bu tarih aral\u0131\u011f\u0131 aras\u0131nda rastgele bir tarih olu\u015fturur ancak tarih, varsay\u0131lan olarak say\u0131sal bir de\u011fer olarak g\u00f6r\u00fcnt\u00fclenir.<\/span><\/p>\n
 Not<\/strong> : Say\u0131sal de\u011fer 1\/1\/1900’den bu yana ge\u00e7en g\u00fcn say\u0131s\u0131n\u0131 temsil eder.<\/span><\/p>\n
 Bu say\u0131sal de\u011feri tarihe d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in C2<\/strong> h\u00fccresini vurgulayabilir, ard\u0131ndan Giri\u015f<\/strong> sekmesindeki Say\u0131 Bi\u00e7imi<\/strong> a\u00e7\u0131l\u0131r men\u00fcs\u00fcn\u00fc t\u0131klay\u0131p ard\u0131ndan K\u0131sa Tarih’i<\/strong> t\u0131klayabiliriz:<\/span> <\/p>\n
\"\"<\/p>\n
 Say\u0131sal de\u011fer otomatik olarak tarihe d\u00f6n\u00fc\u015ft\u00fcr\u00fclecektir:<\/span> <\/p>\n
\"Excel,<\/p>\n
 RANDBETWEEN<\/strong> fonksiyonunun belirtti\u011fimiz ba\u015flang\u0131\u00e7 ve biti\u015f tarihleri aras\u0131ndaki 4\/3\/2006<\/strong> tarihini \u00fcretti\u011fini g\u00f6r\u00fcyoruz.<\/span><\/p>\n
 Bu tarih aral\u0131\u011f\u0131 aras\u0131nda birden fazla rastgele tarih olu\u015fturmak i\u00e7in bu form\u00fcl\u00fc t\u0131klay\u0131p C s\u00fctunundaki daha fazla h\u00fccreye de s\u00fcr\u00fckleyebilece\u011fimizi unutmay\u0131n:<\/span> <\/p>\n
\"\"<\/p>\n
 T\u00fcm rastgele tarihlerin belirtti\u011fimiz tarih aral\u0131\u011f\u0131na girdi\u011fini unutmay\u0131n.<\/span><\/p>\n
 Ek kaynaklar<\/strong><\/span><\/h2>\n
 A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n
 Excel’de saat olmadan tarihler nas\u0131l kar\u015f\u0131la\u015ft\u0131r\u0131l\u0131r<\/a>
 Excel’de bir tarih aral\u0131\u011f\u0131yla SUMIFS nas\u0131l kullan\u0131l\u0131r?<\/a>
 Excel’de tarihleri aya g\u00f6re filtreleme<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Excel’de belirli bir tarih aral\u0131\u011f\u0131 aras\u0131nda rastgele bir tarih olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz: =RANDBETWEEN( $A$2 , $B$2 ) Bu form\u00fcl, ba\u015flang\u0131\u00e7 tarihinin A2 h\u00fccresinde, biti\u015f tarihinin ise B2 h\u00fccresinde oldu\u011funu varsayar. Varsay\u0131lan olarak, Excel bu rastgele tarihi say\u0131sal bir de\u011fer olarak g\u00f6r\u00fcnt\u00fcler, ancak bunun yerine bunu bir tarih de\u011feri olarak g\u00f6r\u00fcnt\u00fclemek i\u00e7in Excel’deki Say\u0131 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4671","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\nExcel'de Rastgele Tarihler Nas\u0131l Olu\u015fturulur (\u00d6rneklerle) - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, Excel'de iki belirli tarih aras\u0131nda rastgele tarihlerin nas\u0131l olu\u015fturulaca\u011f\u0131 \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/excel-rastgele-tarihler-olustur\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de Rastgele Tarihler Nas\u0131l Olu\u015fturulur (\u00d6rneklerle) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, Excel'de iki belirli tarih aras\u0131nda rastgele tarihlerin nas\u0131l olu\u015fturulaca\u011f\u0131 \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excel-rastgele-tarihler-olustur\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T03:10:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/randate1.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-rastgele-tarihler-olustur\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-rastgele-tarihler-olustur\/\",\"name\":\"Excel'de Rastgele Tarihler Nas\u0131l Olu\u015fturulur (\u00d6rneklerle) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-09T03:10:34+00:00\",\"dateModified\":\"2023-07-09T03:10:34+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, Excel'de iki belirli tarih aras\u0131nda rastgele tarihlerin nas\u0131l olu\u015fturulaca\u011f\u0131 \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-rastgele-tarihler-olustur\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-rastgele-tarihler-olustur\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-rastgele-tarihler-olustur\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel'de rastgele tarihler nas\u0131l olu\u015fturulur (\u00f6rneklerle)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de Rastgele Tarihler Nas\u0131l Olu\u015fturulur (\u00d6rneklerle) - Statorials","description":"Bu e\u011fitimde, Excel'de iki belirli tarih aras\u0131nda rastgele tarihlerin nas\u0131l olu\u015fturulaca\u011f\u0131 \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.","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:\/\/statorials.org\/tr\/excel-rastgele-tarihler-olustur\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de Rastgele Tarihler Nas\u0131l Olu\u015fturulur (\u00d6rneklerle) - Statorials","og_description":"Bu e\u011fitimde, Excel'de iki belirli tarih aras\u0131nda rastgele tarihlerin nas\u0131l olu\u015fturulaca\u011f\u0131 \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excel-rastgele-tarihler-olustur\/","og_site_name":"Statorials","article_published_time":"2023-07-09T03:10:34+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/randate1.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/excel-rastgele-tarihler-olustur\/","url":"https:\/\/statorials.org\/tr\/excel-rastgele-tarihler-olustur\/","name":"Excel'de Rastgele Tarihler Nas\u0131l Olu\u015fturulur (\u00d6rneklerle) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-09T03:10:34+00:00","dateModified":"2023-07-09T03:10:34+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, Excel'de iki belirli tarih aras\u0131nda rastgele tarihlerin nas\u0131l olu\u015fturulaca\u011f\u0131 \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-rastgele-tarihler-olustur\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-rastgele-tarihler-olustur\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-rastgele-tarihler-olustur\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel'de rastgele tarihler nas\u0131l olu\u015fturulur (\u00f6rneklerle)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4671","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=4671"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4671\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=4671"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=4671"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=4671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}