{"id":1789,"date":"2023-11-05T01:15:47","date_gmt":"2023-11-05T01:15:47","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/"},"modified":"2023-12-06T06:20:13","modified_gmt":"2023-12-06T06:20:13","slug":"generator-tanggal-acak","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/","title":{"rendered":"Generator tanggal acak di excel"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-330777227\"><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>Dalam tutorial ini, kita akan mempelajari cara sederhana untuk menghasilkan tanggal acak antara dua tanggal (tanggal mulai dan tanggal akhir). Untuk melakukan ini, Anda perlu menggunakan dua fungsi berbeda yang dapat Anda gunakan dalam situasi berbeda.<\/p><ul><li> ALENTENTE<\/li><li> RANDARRAY<\/li><\/ul><h2 class=\"wp-block-heading\"> Hasilkan tanggal acak dengan RANDBETWEEN<\/h2><p> Di Excel, kami memiliki fungsi bernama RANDBETWEEN yang mengambil nilai awal dan nilai akhir untuk menghasilkan nilai acak di antara keduanya, dan Anda bisa menggunakan fungsi ini untuk menghasilkan tanggal acak.<\/p><ol type=\"1\"><li> Pertama, tentukan tanggal mulai dari mana Anda ingin memulai tanggal acak Anda.<\/li><li> Selanjutnya, tentukan tanggal akhir untuk mendapatkan batas atas tanggal acak.<\/li><li> Setelah itu, masukkan fungsi \u201cRANDBETWEEN\u201d ke dalam sel.<\/li><li> Sekarang rujuk ke sel tempat Anda memiliki tanggal mulai dan berakhir dalam argumen.<\/li><li> Dari sana, tekan Enter untuk mendapatkan satu tanggal acak di sel.<\/li><li> Pada akhirnya, jelajahi sel ini ke sel tempat Anda ingin memiliki tanggal acak. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66816\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.png\" sizes=\"auto, \" srcset=\"\" alt=\"randbeetween-untuk-tanggal acak\" width=\"505\" height=\"330\"><\/figure><\/div><p> random_date_generator.xlsx<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=RANDBETWEEN($A$2,$B$2)<\/code><\/pre><p> Pada rumus di atas, kita telah menggunakan fungsi RANDBETWEEN dengan tanggal mulai dan tanggal akhir. Seperti yang Anda lihat, kami telah membekukan referensi sel ke sel A2 dan B2 menggunakan tanda dolar ($). Dan setelah itu kita perlu menelusuri rumusnya ke sel C11 untuk mendapatkan 10 tanggal acak.<\/p><h2 class=\"wp-block-heading\"> Menggunakan RANDARRAY untuk tanggal acak<\/h2><p> Ada fungsi lain yang dapat Anda gunakan untuk menghasilkan angka acak yaitu RANDARRAY. Fungsi ini juga memerlukan tanggal mulai dan tanggal akhir.<\/p><p> Saat menggunakan RANDARRAY, Anda harus menentukan jumlah tanggal yang ingin Anda hasilkan. Dan ini harus Anda tentukan dalam kolom dan baris. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66817\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-aleatoires-pour-des-dates-aleatoires.png\" sizes=\"auto, \" srcset=\"\" alt=\"acak-untuk-tanggal acak\" width=\"542\" height=\"323\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=RANDARRAY(10,2,A2,B2)<\/code><\/pre><p> Dalam rumus di atas, saya menentukan 10 baris dan 2 kolom dan hasilnya menghasilkan 20 tanggal acak (10 x 2).<\/p><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Kedua fungsi yang kami gunakan di atas bersifat fluktuatif, artinya jika Anda menghitung ulang penghitungan sheet, semua tanggal akan dibuat ulang. <\/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\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-generateur-de-dates-aleatoires.xlsx\" rel=\"nofollow\">Unduh<\/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\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/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\/id\/membandingkan-dua-tanggal\/\">Bandingkan dua tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/\">Ubah tanggal menjadi angka di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/teks-sampai-saat-ini\/\">Ubah teks menjadi tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/\">Buat rentang tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/\">Format tanggal khusus di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tanggal-jika\/\">Fungsi DATEDIF di Excel<\/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-1789","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>Penghasil Tanggal Acak di Excel - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari berbagai rumus yang mudah digunakan untuk membuat generator tanggal acak di Excel.\" \/>\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\/id\/generator-tanggal-acak\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Penghasil Tanggal Acak di Excel - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari berbagai rumus yang mudah digunakan untuk membuat generator tanggal acak di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/\",\"name\":\"Penghasil Tanggal Acak di Excel - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.png\",\"datePublished\":\"2023-11-05T01:15:47+00:00\",\"dateModified\":\"2023-12-06T06:20:13+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari berbagai rumus yang mudah digunakan untuk membuat generator tanggal acak di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Generator tanggal acak di excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Penghasil Tanggal Acak di Excel - Penasihat Excel","description":"Dalam tutorial ini, Anda akan mempelajari berbagai rumus yang mudah digunakan untuk membuat generator tanggal acak di Excel.","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\/id\/generator-tanggal-acak\/","og_locale":"id_ID","og_type":"article","og_title":"Penghasil Tanggal Acak di Excel - Penasihat Excel","og_description":"Dalam tutorial ini, Anda akan mempelajari berbagai rumus yang mudah digunakan untuk membuat generator tanggal acak di Excel.","og_url":"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:13+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/","url":"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/","name":"Penghasil Tanggal Acak di Excel - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.png","datePublished":"2023-11-05T01:15:47+00:00","dateModified":"2023-12-06T06:20:13+00:00","description":"Dalam tutorial ini, Anda akan mempelajari berbagai rumus yang mudah digunakan untuk membuat generator tanggal acak di Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-randbeetween-pour-des-dates-aleatoires.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Generator tanggal acak di excel"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1789","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1789"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1789\/revisions"}],"predecessor-version":[{"id":2905,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1789\/revisions\/2905"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}