{"id":2729,"date":"2023-07-20T23:45:33","date_gmt":"2023-07-20T23:45:33","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-membandingkan-tanggal\/"},"modified":"2023-07-20T23:45:33","modified_gmt":"2023-07-20T23:45:33","slug":"google-sheet-membandingkan-tanggal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-membandingkan-tanggal\/","title":{"rendered":"Cara membandingkan tanggal di google sheets (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk membandingkan nilai tanggal di sel <strong>A1<\/strong> dan <strong>B1<\/strong> di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Periksa apakah tanggalnya sama<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">= <span style=\"color: #ff6600;\">A1<\/span> = <span style=\"color: #800080;\">B1<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Periksa apakah tanggalnya tidak sama<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">= <span style=\"color: #ff6600;\">A1<\/span> &lt;&gt; <span style=\"color: #800080;\">B1<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: Periksa apakah tanggal pertama lebih besar dari tanggal kedua<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">= <span style=\"color: #ff6600;\">A1<\/span> &gt; <span style=\"color: #800080;\">B1<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 4: Periksa apakah tanggal pertama kurang dari tanggal kedua<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">= <span style=\"color: #ff6600;\">A1<\/span> &lt; <span style=\"color: #800080;\">B1<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 5: Temukan Tanggal Yang Terbaru<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\"><span style=\"color: #800080;\"><span style=\"color: #000000;\">=IFS( <span dir=\"auto\" style=\"color: #ff6600;\">A1<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">&gt;<\/span> <span dir=\"auto\" style=\"color: #800080;\">B1<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">First Date<\/span> \"<\/span> , <span dir=\"auto\" style=\"color: #ff6600;\">A1<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">&lt;<\/span> <span dir=\"auto\" style=\"color: #800080;\">B1<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">Second Date<\/span> \"<\/span> , <span dir=\"auto\" style=\"color: #ff6600;\">A1<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">=<\/span> <span dir=\"auto\" style=\"color: #800080;\">B1<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">Equal<\/span> \"<\/span> )<\/span>\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Bandingkan tanggal di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki dua kolom di Google Sheets yang masing-masing berisi nilai tanggal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24030 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comparer1.jpg\" alt=\"\" width=\"431\" height=\"420\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut memperlihatkan cara menggunakan rumus yang ditentukan sebelumnya untuk membandingkan nilai di kolom tanggal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24031\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comparer2.jpg\" alt=\"Google Spreadsheet membandingkan tanggal\" width=\"676\" height=\"406\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut cara kerja setiap rumus:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Kolom C: Jika tanggalnya sama, <strong>TRUE<\/strong> dikembalikan. Jika tidak, <strong>FALSE<\/strong> dikembalikan.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kolom D: Jika tanggalnya tidak sama, <strong>TRUE<\/strong> dikembalikan. Jika tidak, <strong>FALSE<\/strong> dikembalikan.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kolom E: Jika tanggal pertama lebih besar (yaitu lebih lambat), nilai <strong>TRUE<\/strong> akan dikembalikan. Jika tidak, <strong>FALSE<\/strong> dikembalikan.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kolom F: Jika tanggal pertama lebih kecil (yaitu lebih awal), nilai <strong>TRUE<\/strong> akan dikembalikan. Jika tidak, <strong>FALSE<\/strong> dikembalikan.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut juga menunjukkan cara menggunakan fungsi <strong>IFS()<\/strong> untuk menentukan tanggal terbaru:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24033 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comparer3.jpg\" alt=\"\" width=\"651\" height=\"379\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa rumus ini hanya akan berfungsi jika nilai di dua kolom pertama diformat sebagai tanggal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengonversi nilai di setiap kolom menjadi tanggal, cukup sorot semua nilai tanggal, lalu klik tab <strong>Format<\/strong> di sepanjang pita atas, lalu klik <strong>Nomor<\/strong> , lalu klik <strong>Tanggal<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut memberikan informasi tambahan tentang cara bekerja dengan tanggal di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Mengisi Tanggal Secara Otomatis di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tambahkan-hari-pengurangan-di-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menambah dan mengurangi hari di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/perbedaan-google-sheet-antar-tanggal\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung selisih dua tanggal di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk membandingkan nilai tanggal di sel A1 dan B1 di Google Spreadsheet: Metode 1: Periksa apakah tanggalnya sama = A1 = B1 Metode 2: Periksa apakah tanggalnya tidak sama = A1 &lt;&gt; B1 Metode 3: Periksa apakah tanggal pertama lebih besar dari tanggal kedua = A1 &gt; B1 Metode 4: [&hellip;]<\/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":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Membandingkan Tanggal di Google Sheets (dengan Contoh) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membandingkan tanggal di Google Sheets, dengan beberapa contoh.\" \/>\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\/id\/google-sheet-membandingkan-tanggal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membandingkan Tanggal di Google Sheets (dengan Contoh) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membandingkan tanggal di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-membandingkan-tanggal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T23:45:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comparer1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-membandingkan-tanggal\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-membandingkan-tanggal\/\",\"name\":\"Cara Membandingkan Tanggal di Google Sheets (dengan Contoh) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T23:45:33+00:00\",\"dateModified\":\"2023-07-20T23:45:33+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membandingkan tanggal di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-membandingkan-tanggal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-membandingkan-tanggal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-membandingkan-tanggal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membandingkan tanggal di google sheets (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Membandingkan Tanggal di Google Sheets (dengan Contoh) \u2013 Statologi","description":"Tutorial ini menjelaskan cara membandingkan tanggal di Google Sheets, dengan beberapa contoh.","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\/id\/google-sheet-membandingkan-tanggal\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membandingkan Tanggal di Google Sheets (dengan Contoh) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara membandingkan tanggal di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-membandingkan-tanggal\/","og_site_name":"Statorials","article_published_time":"2023-07-20T23:45:33+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comparer1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/google-sheet-membandingkan-tanggal\/","url":"https:\/\/statorials.org\/id\/google-sheet-membandingkan-tanggal\/","name":"Cara Membandingkan Tanggal di Google Sheets (dengan Contoh) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T23:45:33+00:00","dateModified":"2023-07-20T23:45:33+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membandingkan tanggal di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-membandingkan-tanggal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-membandingkan-tanggal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-membandingkan-tanggal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membandingkan tanggal di google sheets (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2729"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2729"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2729\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}