{"id":1704,"date":"2023-11-10T17:26:12","date_gmt":"2023-11-10T17:26:12","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/"},"modified":"2023-12-06T06:15:33","modified_gmt":"2023-12-06T06:15:33","slug":"tanggal-pencarian-v","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/","title":{"rendered":"Bagaimana cara menemukan tanggal dari data?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3027226190\"><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>Anda juga dapat menggunakan VLOOKUP untuk mencari tanggal dari tanggal dan kemudian mendapatkan nilai dari baris yang sama di kolom terkait. Untuk melakukan ini, Anda perlu menentukan tanggal di VLOOKUP, atau Anda juga dapat menentukannya langsung di dalamnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79555\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"vlookup-untuk-kencan\" width=\"625\" height=\"401\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Menggunakan VLOOKUP dengan tanggal<\/h2><p> Anda dapat menggunakan langkah-langkah di bawah ini:<\/p><ol type=\"1\"><li> Pertama masukkan fungsi VLOOKUP dalam sel.<\/li><li> Setelah itu, di argumen pertama, rujuk ke sel D2 di mana Anda memiliki tanggal yang akan dicari.<\/li><li> Sekarang, di argumen kedua, tentukan rentang A1:B13.<\/li><li> Kemudian pada argumen ketiga masukkan 2 karena ingin mendapatkan nilai dari kolom kedua.<\/li><li> Pada akhirnya, di argumen keempat, masukkan 0 untuk menjalankan argumen yang tepat. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79556\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-vlookup-avec-des-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan-vlookup-dengan-tanggal\" width=\"713\" height=\"384\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=VLOOKUP(VALUE(D2),A1:B13,2,0)<\/code><\/pre><h2 class=\"wp-block-heading\"> Memasukkan tanggal langsung di VLOOKUP<\/h2><p> Anda juga dapat memasukkan tanggal langsung ke dalam fungsinya. Lihat contoh di bawah ini: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=VLOOKUP(DATEVALUE(\"02-Dec-2022\"),A1:B13,2,0)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79557\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-entrer-la-date-dans-la-fonction-vlookup.png\" sizes=\"auto, \" srcset=\"\" alt=\"masukkan-tanggal-dalam-fungsi-vlookup\" width=\"697\" height=\"410\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Hal-hal yang perlu diperhatikan<\/h2><ol type=\"1\"><li> Excel menyimpan tanggal sebagai angka, dan tanggal yang dicari serta tanggal pada datanya harus valid sesuai dengan kode tanggal dan waktu excel.<\/li><li> Jika Anda ingin memasukkan tanggal ke dalam fungsi, Anda perlu menggunakan fungsi DATEVALUE untuk mengubah tanggal yang dimasukkan menjadi tanggal Excel yang valid. <\/li><\/ol><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\/date-de-recherche-v.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\/iferror-vlookup\/\">IFERROR dengan VLOOKUP di Excel untuk menggantikan #N\/A di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pencarian-dua-arah\/\">Lakukan pencarian dua arah di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pencarian-terbalik\/\">Membalikkan VLOOKUP (mundur: kanan ke kiri) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pertandingan-vs-pencarian\/\">Menggabungkan VLOOKUP MATCH di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/vlookup-beberapa-kriteria\/\">VLOOKUP dengan beberapa kriteria di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/wildcard-dengan-vlookup\/\">Wildcard dengan VLOOKUP 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-1704","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>[VLOOKUP] Bagaimana cara mencari tanggal dari data?<\/title>\n<meta name=\"description\" content=\"Pada tutorial kali ini kita akan mempelajari cara menulis rumus di VLOOKUP untuk tanggal dari data di Excel. Mari kita periksa ini\u2026\" \/>\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\/tanggal-pencarian-v\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[VLOOKUP] Bagaimana cara mencari tanggal dari data?\" \/>\n<meta property=\"og:description\" content=\"Pada tutorial kali ini kita akan mempelajari cara menulis rumus di VLOOKUP untuk tanggal dari data di Excel. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/\",\"name\":\"[VLOOKUP] Bagaimana cara mencari tanggal dari data?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png\",\"datePublished\":\"2023-11-10T17:26:12+00:00\",\"dateModified\":\"2023-12-06T06:15:33+00:00\",\"description\":\"Pada tutorial kali ini kita akan mempelajari cara menulis rumus di VLOOKUP untuk tanggal dari data di Excel. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menemukan tanggal dari data?\"}]},{\"@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":"[VLOOKUP] Bagaimana cara mencari tanggal dari data?","description":"Pada tutorial kali ini kita akan mempelajari cara menulis rumus di VLOOKUP untuk tanggal dari data di Excel. Mari kita periksa ini\u2026","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\/tanggal-pencarian-v\/","og_locale":"id_ID","og_type":"article","og_title":"[VLOOKUP] Bagaimana cara mencari tanggal dari data?","og_description":"Pada tutorial kali ini kita akan mempelajari cara menulis rumus di VLOOKUP untuk tanggal dari data di Excel. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:33+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/","url":"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/","name":"[VLOOKUP] Bagaimana cara mencari tanggal dari data?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png","datePublished":"2023-11-10T17:26:12+00:00","dateModified":"2023-12-06T06:15:33+00:00","description":"Pada tutorial kali ini kita akan mempelajari cara menulis rumus di VLOOKUP untuk tanggal dari data di Excel. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vlookup-pour-une-date.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tanggal-pencarian-v\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menemukan tanggal dari data?"}]},{"@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\/1704","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=1704"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1704\/revisions"}],"predecessor-version":[{"id":2426,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1704\/revisions\/2426"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}