{"id":1881,"date":"2023-10-30T09:47:27","date_gmt":"2023-10-30T09:47:27","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/"},"modified":"2023-12-06T06:14:01","modified_gmt":"2023-12-06T06:14:01","slug":"rentang-tanggal-validasi-data","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/","title":{"rendered":"Bagaimana cara membuat validasi data dengan rentang tanggal?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-427850749\"><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>Katakanlah Anda perlu membuat validasi data untuk tanggal di mana Anda ingin menggunakan rentang tanggal tertentu. Secara sederhana, Anda ingin ketika pengguna memasukkan tanggal ke dalam sel yang harus berada dalam rentang tanggal yang Anda tentukan.<\/p><p> Nah, ini bisa dilakukan dengan menggunakan rumus khusus berdasarkan fungsi AND dan cara mudah untuk mengatur tanggal dalam opsi rentang tanggal dalam validasi data. Kedua metode tersebut akan mencegah pengguna memasukkan tanggal di luar rentang.<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah membuat validasi tanggal dengan rentang tanggal<\/h2><ol><li> Pertama, pilih sel tempat Anda ingin menerapkan aturan validasi data ini.<\/li><li> Sekarang buka tab Data \u21e2 Validasi Data \u21e2 Validasi Data.<\/li><li> Dari sana, dalam dialog validasi data, pilih &#8220;Tanggal&#8221; dari menu tarik-turun &#8220;Izinkan&#8221;.<\/li><li> Setelah itu, pilih entri dari menu tarik-turun \u201cData\u201d.<\/li><li> Selanjutnya, Anda perlu memasukkan dua tanggal di kolom input \u201cTanggal mulai\u201d dan \u201cTanggal akhir\u201d.<\/li><li> Pada akhirnya, klik OK. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-une-plage-de-dates-dans-la-validation-des-donnees.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> Sekarang, di semua sel yang Anda pilih, pengguna hanya dapat memasukkan tanggal dalam rentang tanggal yang Anda tentukan.<\/p><p> Bahkan, alih-alih memasukkan tanggal secara langsung dalam validasi data, Anda bisa merujuk ke sel tempat Anda memiliki tanggal.<\/p><p> Dengan cara ini Anda dapat mengubah tanggal kapan saja tanpa membuka opsi. Anda dapat menggunakan fungsi TODAY untuk membuat rentang tanggal dinamis.<\/p><h2 class=\"wp-block-heading\"> Menggunakan Fungsi AND untuk Membuat Rentang Tanggal dalam Validasi Data<\/h2><p> Hal yang sama juga dapat dilakukan dengan menggunakan rumus khusus berdasarkan fungsi AND.<\/p><ol><li> Pertama, pilih sel A1.<\/li><li> Dalam dialog validasi data, pilih &#8220;Kustom&#8221; dari menu tarik-turun &#8220;Izinkan&#8221;.<\/li><li> Sekarang, di bilah input rumus, masukkan rumus di bawah ini dan klik OK. <\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=AND(A1&gt;=DATE(2016,6,1),A1&lt;=DATE(2016,6,30))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-une-plage-de-dates-dans-la-validation-des-donnees-a-laide-dune-formule-personnalisee.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> Metode ini agak terbatas dan rumit. Namun jika Anda ingin menentukan tanggal untuk satu waktu saja, Anda bisa menggunakan cara ini.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/\">Tutorial Excel Tingkat Lanjut<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/daftar-drop-down-yang-bergantung\/\">Daftar drop-down dependen di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/daftar-dinamis\/\">Daftar drop-down dinamis di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/ya-tidak-ada-daftar-drop-down\/\">Buat Daftar Drop-Down Ya \u2013 Tidak di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hapus-daftar-tarik-turun\/\">Hapus daftar drop-down (validasi data) di Excel<\/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-1881","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>Cara membuat validasi data dengan rentang tanggal<\/title>\n<meta name=\"description\" content=\"Pelajari proses langkah demi langkah sederhana untuk membuat validasi data menggunakan rentang tanggal 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\/rentang-tanggal-validasi-data\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara membuat validasi data dengan rentang tanggal\" \/>\n<meta property=\"og:description\" content=\"Pelajari proses langkah demi langkah sederhana untuk membuat validasi data menggunakan rentang tanggal di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-une-plage-de-dates-dans-la-validation-des-donnees.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\/rentang-tanggal-validasi-data\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/\",\"name\":\"Cara membuat validasi data dengan rentang tanggal\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-une-plage-de-dates-dans-la-validation-des-donnees.png\",\"datePublished\":\"2023-10-30T09:47:27+00:00\",\"dateModified\":\"2023-12-06T06:14:01+00:00\",\"description\":\"Pelajari proses langkah demi langkah sederhana untuk membuat validasi data menggunakan rentang tanggal di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-une-plage-de-dates-dans-la-validation-des-donnees.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-une-plage-de-dates-dans-la-validation-des-donnees.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membuat validasi data dengan rentang tanggal?\"}]},{\"@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":"Cara membuat validasi data dengan rentang tanggal","description":"Pelajari proses langkah demi langkah sederhana untuk membuat validasi data menggunakan rentang tanggal 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\/rentang-tanggal-validasi-data\/","og_locale":"id_ID","og_type":"article","og_title":"Cara membuat validasi data dengan rentang tanggal","og_description":"Pelajari proses langkah demi langkah sederhana untuk membuat validasi data menggunakan rentang tanggal di Excel.","og_url":"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:01+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-une-plage-de-dates-dans-la-validation-des-donnees.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\/rentang-tanggal-validasi-data\/","url":"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/","name":"Cara membuat validasi data dengan rentang tanggal","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-une-plage-de-dates-dans-la-validation-des-donnees.png","datePublished":"2023-10-30T09:47:27+00:00","dateModified":"2023-12-06T06:14:01+00:00","description":"Pelajari proses langkah demi langkah sederhana untuk membuat validasi data menggunakan rentang tanggal di Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-une-plage-de-dates-dans-la-validation-des-donnees.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-une-plage-de-dates-dans-la-validation-des-donnees.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/rentang-tanggal-validasi-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membuat validasi data dengan rentang tanggal?"}]},{"@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\/1881","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=1881"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1881\/revisions"}],"predecessor-version":[{"id":2325,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1881\/revisions\/2325"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1881"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}