{"id":4630,"date":"2023-07-09T11:39:57","date_gmt":"2023-07-09T11:39:57","guid":{"rendered":"https:\/\/statorials.org\/id\/tanggal-gabungan-google-sheet\/"},"modified":"2023-07-09T11:39:57","modified_gmt":"2023-07-09T11:39:57","slug":"tanggal-gabungan-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tanggal-gabungan-google-sheet\/","title":{"rendered":"Cara menggabungkan tanggal di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Saat Anda menggunakan fungsi <strong>CONCATENATE<\/strong> , Google Spreadsheet akan otomatis mengonversi tanggal menjadi nilai numerik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, Anda menggunakan fungsi <strong>TEXT<\/strong> untuk menentukan bahwa tanggal harus tetap diformat sebagai tanggal:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">CONCATENATE<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">TEXT<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #800080;\">B2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\"M\/DD\/YYYY\"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini akan menggabungkan string di sel <strong>A2<\/strong> dan <strong>B2<\/strong> dan menyimpan tanggal di sel <strong>B2<\/strong> dalam format <strong>M\/DD\/YYYY<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menggabungkan Tanggal di Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang berisi informasi tanggal mulai untuk berbagai karyawan di sebuah perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36132 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/concatdate1.png\" alt=\"\" width=\"496\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika kita menggunakan fungsi <strong>CONCATENATE<\/strong> berikut untuk membuat string yang menjelaskan kapan setiap karyawan mulai bekerja, setiap tanggal di kolom B akan dikonversi ke nilai numerik secara default:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">CONCATENATE<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">, \"started working on\",<\/span> <span dir=\"auto\" style=\"color: #800080;\">B2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36133 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/concatdate2.png\" alt=\"\" width=\"523\" height=\"461\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap tanggal telah dikonversi ke nilai numerik secara default.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menggabungkan sel dan menyimpan tanggal di kolom B dalam format tanggal, kita bisa menggunakan rumus berikut:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">CONCATENATE<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">, \"started working on\", TEXT(<\/span> <span dir=\"auto\" style=\"color: #800080;\">B2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">, \"M\/DD\/YYYY\"))<\/span><\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36134\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/concatdate3.png\" alt=\"Tanggal gabungan Google Spreadsheet\" width=\"636\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dengan menggunakan fungsi <strong>TEXT<\/strong> dalam fungsi <strong>CONCATENATE<\/strong> , kita dapat menggabungkan nama dan tanggal karyawan sekaligus menjaga tanggal dalam format yang benar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa <strong>M\/DD\/YYYY<\/strong> hanyalah salah satu opsi format tanggal yang dapat kami gunakan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat menggunakan <strong>MMM YYYY<\/strong> untuk menampilkan bulan dan tahun saja:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">CONCATENATE<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">, \"started working on\", TEXT(<\/span> <span dir=\"auto\" style=\"color: #800080;\">B2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">, \"MMM YYYY\"))<\/span><\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36135 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/concatdate4.png\" alt=\"\" width=\"614\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Lihat <a href=\"https:\/\/developers.google.com\/sheets\/api\/guides\/formats\" target=\"_blank\" rel=\"noopener\">dokumentasi Google Sheets<\/a> untuk daftar lengkap format tanggal yang tersedia yang dapat Anda gunakan.<\/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 Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/hapus-lembar-google-di-bawah-string\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus substring di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengekstrak-nomor-saluran\/\" target=\"_blank\" rel=\"noopener\">Cara mengekstrak angka dari string di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengonversi-tanggal-menjadi-string\/\" target=\"_blank\" rel=\"noopener\">Cara mengonversi tanggal menjadi string di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Saat Anda menggunakan fungsi CONCATENATE , Google Spreadsheet akan otomatis mengonversi tanggal menjadi nilai numerik. Namun, Anda menggunakan fungsi TEXT untuk menentukan bahwa tanggal harus tetap diformat sebagai tanggal: = CONCATENATE ( A2 , TEXT ( B2 , &#8220;M\/DD\/YYYY&#8221; ) ) Rumus khusus ini akan menggabungkan string di sel A2 dan B2 dan menyimpan tanggal [&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 menggabungkan tanggal di Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggabungkan tanggal di Google Sheets, dengan sebuah 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-gabungan-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggabungkan tanggal di Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggabungkan tanggal di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tanggal-gabungan-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T11:39:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/concatdate1.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\/tanggal-gabungan-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/tanggal-gabungan-google-sheet\/\",\"name\":\"Cara menggabungkan tanggal di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T11:39:57+00:00\",\"dateModified\":\"2023-07-09T11:39:57+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggabungkan tanggal di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tanggal-gabungan-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tanggal-gabungan-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tanggal-gabungan-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggabungkan tanggal di google sheets\"}]},{\"@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 menggabungkan tanggal di Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara menggabungkan tanggal di Google Sheets, dengan sebuah 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-gabungan-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggabungkan tanggal di Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menggabungkan tanggal di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tanggal-gabungan-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-09T11:39:57+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/concatdate1.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\/tanggal-gabungan-google-sheet\/","url":"https:\/\/statorials.org\/id\/tanggal-gabungan-google-sheet\/","name":"Cara menggabungkan tanggal di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T11:39:57+00:00","dateModified":"2023-07-09T11:39:57+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggabungkan tanggal di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tanggal-gabungan-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tanggal-gabungan-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tanggal-gabungan-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggabungkan tanggal di google sheets"}]},{"@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\/4630"}],"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=4630"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4630\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}