{"id":4977,"date":"2023-07-05T16:05:45","date_gmt":"2023-07-05T16:05:45","guid":{"rendered":"https:\/\/statorials.org\/id\/serial-tanggal-vba\/"},"modified":"2023-07-05T16:05:45","modified_gmt":"2023-07-05T16:05:45","slug":"serial-tanggal-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/serial-tanggal-vba\/","title":{"rendered":"Cara menggunakan fungsi dateserial di vba (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan fungsi DateSerial<\/b> di VBA untuk mengembalikan tanggal pada hari, bulan, dan tahun tertentu.<\/span><\/p>\n

Berikut cara umum untuk menggunakan fungsi ini dalam praktik:<\/span><\/p>\n

 SubUseDateSerial<\/span> ()\n    \nDim<\/span> i As<\/span> Integer\n\nFor<\/span> i = 2 To<\/span> 13\n    Range(\" D<\/span> \" & i) = DateSerial(Range(\" C<\/span> \" & i), Range(\" B<\/span> \" & i), Range(\" A<\/span> \" & i))\nNext<\/span> i\n    \nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Makro khusus ini akan mengembalikan nilai tanggal pada rentang D2:D13<\/strong> menggunakan nilai tahun di kolom C, nilai bulan di kolom B, dan nilai hari di kolom A.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan fungsi DateSerial<\/b> dalam praktiknya.<\/span><\/p>\n
 Contoh: Cara menggunakan fungsi DateSerial di VBA<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki kolom berikut di Excel yang menampilkan hari, bulan dan tahun untuk tanggal berbeda:<\/span> <\/p>\n
\"\"<\/p>\n
 Misalkan kita ingin menampilkan nilai tanggal pada kolom D, menggunakan nilai hari, bulan, dan tahun pada setiap barisnya.<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 SubUseDateSerial<\/span> ()\n    \nDim<\/span> i As<\/span> Integer\n\nFor<\/span> i = 2 To<\/span> 13\n    Range(\" D<\/span> \" & i) = DateSerial(Range(\" C<\/span> \" & i), Range(\" B<\/span> \" & i), Range(\" A<\/span> \" & i))\nNext<\/span> i\n    \nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Kolom D menampilkan nilai tanggal yang dihasilkan dari penggunaan nilai hari, bulan, dan tahun masing-masing dari kolom A, B, dan C.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi VBA DateSerial<\/b> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 Bagaimana membandingkan tanggal di VBA<\/a>
 Bagaimana mengkonversi nomor tanggal ke minggu di VBA<\/a>
 Cara menghitung hari antara dua tanggal di VBA<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan fungsi DateSerial di VBA untuk mengembalikan tanggal pada hari, bulan, dan tahun tertentu. Berikut cara umum untuk menggunakan fungsi ini dalam praktik: SubUseDateSerial () Dim i As Integer For i = 2 To 13 Range(” D ” & i) = DateSerial(Range(” C ” & i), Range(” B ” & i), Range(” A […]<\/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 Menggunakan Fungsi DateSerial di VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi DateSerial di VBA, dengan contoh lengkap.\" \/>\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\/serial-tanggal-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan Fungsi DateSerial di VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi DateSerial di VBA, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/serial-tanggal-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-05T16:05:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/serie1.png\" \/>\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\/serial-tanggal-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/serial-tanggal-vba\/\",\"name\":\"Cara Menggunakan Fungsi DateSerial di VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-05T16:05:45+00:00\",\"dateModified\":\"2023-07-05T16:05:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi DateSerial di VBA, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/serial-tanggal-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/serial-tanggal-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/serial-tanggal-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan fungsi dateserial 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 Menggunakan Fungsi DateSerial di VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi DateSerial di VBA, dengan contoh lengkap.","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\/serial-tanggal-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan Fungsi DateSerial di VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi DateSerial di VBA, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/serial-tanggal-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-05T16:05:45+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/serie1.png"}],"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\/serial-tanggal-vba\/","url":"https:\/\/statorials.org\/id\/serial-tanggal-vba\/","name":"Cara Menggunakan Fungsi DateSerial di VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-05T16:05:45+00:00","dateModified":"2023-07-05T16:05:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi DateSerial di VBA, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/serial-tanggal-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/serial-tanggal-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/serial-tanggal-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan fungsi dateserial 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\/4977"}],"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=4977"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4977\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4977"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4977"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4977"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}