{"id":4260,"date":"2023-07-12T11:18:24","date_gmt":"2023-07-12T11:18:24","guid":{"rendered":"https:\/\/statorials.org\/id\/tanggal-konversi-excel-ke-yyyymmdd\/"},"modified":"2023-07-12T11:18:24","modified_gmt":"2023-07-12T11:18:24","slug":"tanggal-konversi-excel-ke-yyyymmdd","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tanggal-konversi-excel-ke-yyyymmdd\/","title":{"rendered":"Excel: cara mengonversi tanggal ke format yyyymmdd"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk mengonversi tanggal ke format YYYYMMDD di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXT( <span style=\"color: #3366ff;\">A1<\/span> , \"YYYYMMDD\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan mengonversi tanggal seperti <strong>1\/4\/2022<\/strong> ke format <strong>20220104<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda juga dapat menyisipkan tanda hubung antara tahun, bulan, dan hari:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXT( <span style=\"color: #3366ff;\">A1<\/span> , \"YYYY-MM-DD\") \n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan mengonversi tanggal seperti <strong>1\/4\/2022<\/strong> ke format <strong>2022-01-04<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap rumus mengasumsikan tanggal ada di sel <strong>A1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Ubah tanggal ke format YYYYMMDD di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk mengonversi tanggal ke format YYYYMMDD di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXT( <span style=\"color: #3366ff;\">A2<\/span> , \"YYYYMMDD\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus ini di sel <strong>B2<\/strong> dan menyeret rumus ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-33636\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/aa1.jpg\" alt=\"Excel mengonversi tanggal ke format YYYYMMDD\" width=\"493\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B menampilkan setiap tanggal di kolom A dalam format <strong>YYYYMMDD<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">01\/04\/2022 diubah menjadi 20220104.<\/span><\/li>\n<li> <span style=\"color: #000000;\">01\/06\/2022 diubah menjadi 20220106.<\/span><\/li>\n<li> <span style=\"color: #000000;\">02\/03\/2022 diubah menjadi 20220203.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda juga dapat menyisipkan tanda hubung antara tahun, bulan, dan hari menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXT( <span style=\"color: #3366ff;\">A2<\/span> , \"YYYY-MM-DD\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus ini di sel <strong>B2<\/strong> dan menyeret rumus ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-33638\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/aa3.jpg\" alt=\"Excel mengonversi tanggal ke format YYYY-MM-DD\" width=\"497\" height=\"452\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B menampilkan setiap tanggal di kolom A dalam format <strong>YYYY-MM-DD<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">01\/04\/2022 telah diubah menjadi 01\/04\/2022.<\/span><\/li>\n<li> <span style=\"color: #000000;\">01\/06\/2022 telah diubah menjadi 01\/06\/2022.<\/span><\/li>\n<li> <span style=\"color: #000000;\">02\/03\/2022 telah diubah menjadi 02\/03\/2022.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi <strong>TEXT<\/strong> Excel <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/tanggal-konversi-excel-kuartal-tahun\/\" target=\"_blank\" rel=\"noopener\">Bagaimana mengkonversi tanggal ke kuartal dan tahun di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-membandingkan-tanggal-tanpa-waktu\/\" target=\"_blank\" rel=\"noopener\">Bagaimana membandingkan tanggal tanpa waktu di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/filter-excel-berdasarkan-bulan\/\" target=\"_blank\" rel=\"noopener\">Cara memfilter tanggal berdasarkan bulan di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk mengonversi tanggal ke format YYYYMMDD di Excel: =TEXT( A1 , &#8220;YYYYMMDD&#8221;) Ini akan mengonversi tanggal seperti 1\/4\/2022 ke format 20220104 . Anda juga dapat menyisipkan tanda hubung antara tahun, bulan, dan hari: =TEXT( A1 , &#8220;YYYY-MM-DD&#8221;) Ini akan mengonversi tanggal seperti 1\/4\/2022 ke format 2022-01-04 . Perhatikan bahwa setiap [&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>Excel: Cara mengonversi tanggal ke format YYYYMMDD - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah tanggal di Excel ke format YYYYMMDD, 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\/tanggal-konversi-excel-ke-yyyymmdd\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara mengonversi tanggal ke format YYYYMMDD - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah tanggal di Excel ke format YYYYMMDD, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tanggal-konversi-excel-ke-yyyymmdd\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T11:18:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/aa1.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\/tanggal-konversi-excel-ke-yyyymmdd\/\",\"url\":\"https:\/\/statorials.org\/id\/tanggal-konversi-excel-ke-yyyymmdd\/\",\"name\":\"Excel: Cara mengonversi tanggal ke format YYYYMMDD - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T11:18:24+00:00\",\"dateModified\":\"2023-07-12T11:18:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah tanggal di Excel ke format YYYYMMDD, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tanggal-konversi-excel-ke-yyyymmdd\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tanggal-konversi-excel-ke-yyyymmdd\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tanggal-konversi-excel-ke-yyyymmdd\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mengonversi tanggal ke format yyyymmdd\"}]},{\"@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":"Excel: Cara mengonversi tanggal ke format YYYYMMDD - Statorials","description":"Tutorial ini menjelaskan cara mengubah tanggal di Excel ke format YYYYMMDD, 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\/tanggal-konversi-excel-ke-yyyymmdd\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara mengonversi tanggal ke format YYYYMMDD - Statorials","og_description":"Tutorial ini menjelaskan cara mengubah tanggal di Excel ke format YYYYMMDD, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/tanggal-konversi-excel-ke-yyyymmdd\/","og_site_name":"Statorials","article_published_time":"2023-07-12T11:18:24+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/aa1.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\/tanggal-konversi-excel-ke-yyyymmdd\/","url":"https:\/\/statorials.org\/id\/tanggal-konversi-excel-ke-yyyymmdd\/","name":"Excel: Cara mengonversi tanggal ke format YYYYMMDD - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T11:18:24+00:00","dateModified":"2023-07-12T11:18:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah tanggal di Excel ke format YYYYMMDD, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tanggal-konversi-excel-ke-yyyymmdd\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tanggal-konversi-excel-ke-yyyymmdd\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tanggal-konversi-excel-ke-yyyymmdd\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mengonversi tanggal ke format yyyymmdd"}]},{"@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\/4260"}],"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=4260"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4260\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}