{"id":4375,"date":"2023-07-11T14:39:32","date_gmt":"2023-07-11T14:39:32","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-membandingkan-tanggal\/"},"modified":"2023-07-11T14:39:32","modified_gmt":"2023-07-11T14:39:32","slug":"vba-membandingkan-tanggal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-membandingkan-tanggal\/","title":{"rendered":"Bagaimana membandingkan tanggal di vba (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut di VBA untuk membandingkan dua tanggal:<\/span><\/p>\n

 SubCompareDates<\/span> ()\n    Dim<\/span> i As<\/span> Integer\n\n    For<\/span> i = 2 To<\/span> 5\n        If<\/span> CDate(Range(\" A<\/span> \" & i)) < CDate(Range(\" B<\/span> \" & i)) Then<\/span>\n            Result = \" First Date is Earlier<\/span> \"\n    Else<\/span>\n        If<\/span> CDate(Range(\" A<\/span> \" & i)) > CDate(Range(\" B<\/span> \" & i)) Then<\/span>\n                Result = \u201c First Date is Later<\/span> \u201d\n            Else<\/span>\n                Result = \" Dates Are Equal<\/span> \"\n            End If<\/span>\n        End If<\/span>\n        \n    Range(\" C<\/span> \" & i) = Result\n    \n    Next<\/span> i\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Contoh khusus ini akan membandingkan tanggal di sel terkait dalam rentang A2:A5<\/strong> dan B2:B5<\/strong> dan mengembalikan hasil perbandingan tanggal dalam rentang C2:C5<\/strong> .<\/span><\/p>\n
 Catatan<\/strong> : Fungsi CDate<\/strong> mengonversi nilai sel tertentu menjadi tanggal.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Bandingkan tanggal di VBA<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki dua kolom berikut dengan tanggal di Excel:<\/span> <\/p>\n
\"\"<\/p>\n
 Misalkan kita ingin membandingkan tanggal pada setiap baris yang cocok dan menampilkan hasil perbandingan tanggal pada kolom C.<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 SubCompareDates<\/span> ()\n    Dim<\/span> i As<\/span> Integer\n\n    For<\/span> i = 2 To<\/span> 5\n        If<\/span> CDate(Range(\" A<\/span> \" & i)) < CDate(Range(\" B<\/span> \" & i)) Then<\/span>\n            Result = \" First Date is Earlier<\/span> \"\n    Else<\/span>\n        If<\/span> CDate(Range(\" A<\/span> \" & i)) > CDate(Range(\" B<\/span> \" & i)) Then<\/span>\n                Result = \u201c First Date is Later<\/span> \u201d\n            Else<\/span>\n                Result = \" Dates Are Equal<\/span> \"\n            End If<\/span>\n        End If<\/span>\n        \n    Range(\" C<\/span> \" & i) = Result\n    \n    Next<\/span> i\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Hasil perbandingan tanggal kini ditampilkan di kolom C.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 VBA: Cara mengurutkan lembar berdasarkan beberapa kolom<\/a>
 VBA: Cara menghitung jumlah baris dalam jangkauan<\/a>
 VBA: cara memfilter kolom<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut di VBA untuk membandingkan dua tanggal: SubCompareDates () Dim i As Integer For i = 2 To 5 If CDate(Range(” A ” & i)) < CDate(Range(” B ” & i)) Then Result = ” First Date is Earlier ” Else If CDate(Range(” A ” & i)) > CDate(Range(” B […]<\/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":"\nCara Membandingkan Tanggal di VBA (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membandingkan tanggal di VBA, beserta contohnya.\" \/>\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\/vba-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 VBA (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membandingkan tanggal di VBA, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-membandingkan-tanggal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T14:39:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/datevba1.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\/vba-membandingkan-tanggal\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-membandingkan-tanggal\/\",\"name\":\"Cara Membandingkan Tanggal di VBA (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T14:39:32+00:00\",\"dateModified\":\"2023-07-11T14:39:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membandingkan tanggal di VBA, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-membandingkan-tanggal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-membandingkan-tanggal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-membandingkan-tanggal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana membandingkan tanggal di vba (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 VBA (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara membandingkan tanggal di VBA, beserta contohnya.","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\/vba-membandingkan-tanggal\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membandingkan Tanggal di VBA (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara membandingkan tanggal di VBA, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/vba-membandingkan-tanggal\/","og_site_name":"Statorials","article_published_time":"2023-07-11T14:39:32+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/datevba1.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\/vba-membandingkan-tanggal\/","url":"https:\/\/statorials.org\/id\/vba-membandingkan-tanggal\/","name":"Cara Membandingkan Tanggal di VBA (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T14:39:32+00:00","dateModified":"2023-07-11T14:39:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membandingkan tanggal di VBA, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-membandingkan-tanggal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-membandingkan-tanggal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-membandingkan-tanggal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana membandingkan tanggal di vba (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\/4375"}],"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=4375"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4375\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}