{"id":1585,"date":"2023-11-16T09:01:55","date_gmt":"2023-11-16T09:01:55","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/"},"modified":"2023-12-06T06:13:09","modified_gmt":"2023-12-06T06:13:09","slug":"membandingkan-dua-tanggal","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/","title":{"rendered":"Bagaimana cara membandingkan dua tanggal di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3705974751\"><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>Di Excel, Anda bisa membandingkan dua tanggal menggunakan rumus cepat dan mudah yang bisa menghasilkan hasil TRUE atau FALSE. Atau Anda juga dapat menggunakan fungsi IF untuk mendapatkan pesan khusus pada hasil sambil membandingkan dua tanggal.<\/p><p> Dalam contoh berikut, kita memiliki dua tanggal berbeda di sel A1 dan B1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64884\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"bandingkan-dua-tanggal\" width=\"388\" height=\"274\"><\/figure><\/div><p> Anda dapat menggunakan langkah-langkah berikut:<\/p><ol type=\"1\"><li> Pertama, masukkan tanda sama dengan \u201c=\u201d di sel C1.<\/li><li> Sekarang lihat sel A1 tempat Anda berkencan pertama.<\/li><li> Kemudian masukkan lagi tanda sama dengan \u201c=\u201d.<\/li><li> Setelah itu, lihat sel B1 tempat Anda memiliki kencan kedua.<\/li><li> Pada akhirnya, tekan Enter. <\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1=B1<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64885\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formules-pour-comparer-les-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus-untuk-membandingkan-tanggal\" width=\"414\" height=\"229\"><\/figure><\/div><p> Nanti di tutorial ini, kita akan melihat beberapa contoh berbeda untuk memahaminya.<\/p><h2 class=\"wp-block-heading\"> Bandingkan JIKA suatu tanggal lebih besar dari tanggal lainnya<\/h2><p> Pada contoh berikut, kita membandingkan tanggal pertama dengan tanggal kedua, jika tanggal pertama lebih besar dari tanggal kedua. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1&gt;B1<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64886\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-comparer-plus-grande-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"bandingkan-tanggal terbesar\" width=\"424\" height=\"234\"><\/figure><\/div><p> Dalam rumusnya, kami menggunakan operator lebih besar dari untuk melakukan ini.<\/p><h2 class=\"wp-block-heading\"> Bandingkan tanggal dengan tanggal hari ini<\/h2><p> Demikian pula jika Anda ingin membandingkan suatu tanggal dengan tanggal hari ini, Anda dapat menggunakan fungsi TODAY. Dalam contoh berikut, kami menggunakan fungsi TODAY dan kemudian membandingkannya dengan tanggal lain. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64887\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-comparer-la-date-avec-aujourdhui.png\" sizes=\"auto, \" srcset=\"\" alt=\"bandingkan-tanggal-dengan-hari ini\" width=\"421\" height=\"263\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A5=TODAY()<\/code><\/pre><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\/comparer-les-dates.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\/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><\/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\/id\/menyorot-antara-dua-tanggal\/\">Sorot tanggal antara dua tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-dua-tanggal\/\">Gabungkan dua tanggal dengan cepat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/\">Generator Tanggal Acak (Rumus Excel) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-tanggal-dan-waktu\/\">Gabungkan tanggal dan waktu 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-1585","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>\u25b7 Bagaimana cara membandingkan dua tanggal di Excel? (Panduan 2023)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari rumus sederhana untuk menggabungkan dua tanggal dalam sel yang sama di semua situasi...\" \/>\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\/membandingkan-dua-tanggal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara membandingkan dua tanggal di Excel? (Panduan 2023)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari rumus sederhana untuk menggabungkan dua tanggal dalam sel yang sama di semua situasi...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.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\/membandingkan-dua-tanggal\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/\",\"name\":\"\u25b7 Bagaimana cara membandingkan dua tanggal di Excel? (Panduan 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.png\",\"datePublished\":\"2023-11-16T09:01:55+00:00\",\"dateModified\":\"2023-12-06T06:13:09+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari rumus sederhana untuk menggabungkan dua tanggal dalam sel yang sama di semua situasi...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membandingkan dua tanggal 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":"\u25b7 Bagaimana cara membandingkan dua tanggal di Excel? (Panduan 2023)","description":"Dalam tutorial ini, Anda akan mempelajari rumus sederhana untuk menggabungkan dua tanggal dalam sel yang sama di semua situasi...","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\/membandingkan-dua-tanggal\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara membandingkan dua tanggal di Excel? (Panduan 2023)","og_description":"Dalam tutorial ini, Anda akan mempelajari rumus sederhana untuk menggabungkan dua tanggal dalam sel yang sama di semua situasi...","og_url":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:09+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.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\/membandingkan-dua-tanggal\/","url":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/","name":"\u25b7 Bagaimana cara membandingkan dua tanggal di Excel? (Panduan 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.png","datePublished":"2023-11-16T09:01:55+00:00","dateModified":"2023-12-06T06:13:09+00:00","description":"Dalam tutorial ini, Anda akan mempelajari rumus sederhana untuk menggabungkan dua tanggal dalam sel yang sama di semua situasi...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-dates.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membandingkan dua tanggal 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\/1585","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=1585"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1585\/revisions"}],"predecessor-version":[{"id":2269,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1585\/revisions\/2269"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}