{"id":2303,"date":"2023-07-22T20:56:34","date_gmt":"2023-07-22T20:56:34","guid":{"rendered":"https:\/\/statorials.org\/id\/konversi-nomor-nama-bulan-di-google-sheet\/"},"modified":"2023-07-22T20:56:34","modified_gmt":"2023-07-22T20:56:34","slug":"konversi-nomor-nama-bulan-di-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/konversi-nomor-nama-bulan-di-google-sheet\/","title":{"rendered":"Konversi antara nama &amp; nomor bulan di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk mengonversi antara nama bulan dan angka di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Ubah nomor bulan menjadi nama bulan<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #008080;\">#convert month number in cell A1 to full month name<\/span>\n<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: #ff6600;\">A1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">*<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">29<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">mmmm<\/span> \"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)\n<span style=\"color: #008080;\">\n#convert month number in cell A1 to abbreviated month name\n<\/span>=TEXT( <span dir=\"auto\" style=\"color: #ff6600;\">A1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">*<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">29<\/span> , <span class=\" string \" dir=\"auto\">\u201c <span style=\"color: #008000;\">mmm<\/span> \u201d<\/span> )<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Ubah nama bulan menjadi nomor bulan<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #008080;\">#convert month name in cell A1 to month number<\/span>\n<span class=\" default-formula-text-color\" dir=\"auto\">=MONTH( <span dir=\"auto\" style=\"color: #ff6600;\">A1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span> <span class=\"number\" dir=\"auto\">1<\/span> )<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Ubah nomor bulan menjadi nama bulan di Google Sheets<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <strong>TEXT()<\/strong> untuk mengonversi nomor bulan (1 hingga 12) menjadi nama bulan (Januari hingga Desember):<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-20933\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/convertir1.png\" alt=\"ubah nomor bulan menjadi nama bulan di Google Sheets\" width=\"572\" height=\"491\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita juga dapat menggunakan format <strong>&#8220;mmm&#8221;<\/strong> untuk mengonversi nomor bulan menjadi nama bulan yang disingkat:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-20934\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/convertir2.png\" alt=\"ubah nomor bulan menjadi nama bulan pendek di Google Sheets\" width=\"568\" height=\"463\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Ubah nama bulan menjadi nomor bulan di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <strong>MONTH()<\/strong> untuk mengonversi nama bulan (Januari hingga Desember) menjadi nomor bulan (1 hingga 12):<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-20935\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/convertir3.png\" alt=\"ubah nama bulan menjadi nomor bulan di Google Sheets\" width=\"569\" height=\"486\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa fungsi ini juga akan berfungsi pada nama bulan yang disingkat:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20936 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/convertir4.png\" alt=\"\" width=\"560\" height=\"472\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-meninggalkan-rantai\/\" target=\"_blank\" rel=\"noopener\">Cara mengekstrak substring di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara Menggabungkan Kolom di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kemunculan-nomor-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung jumlah kemunculan di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk mengonversi antara nama bulan dan angka di Google Spreadsheet: Metode 1: Ubah nomor bulan menjadi nama bulan #convert month number in cell A1 to full month name = TEXT ( A1 * 29 , &#8221; mmmm &#8221; ) #convert month number in cell A1 to abbreviated month name =TEXT( [&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>Konversi antara nama bulan dan nomor di Google Sheets - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah nama dan angka bulan 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\/konversi-nomor-nama-bulan-di-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Konversi antara nama bulan dan nomor di Google Sheets - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah nama dan angka bulan di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/konversi-nomor-nama-bulan-di-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T20:56:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/convertir1.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\/konversi-nomor-nama-bulan-di-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/konversi-nomor-nama-bulan-di-google-sheet\/\",\"name\":\"Konversi antara nama bulan dan nomor di Google Sheets - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T20:56:34+00:00\",\"dateModified\":\"2023-07-22T20:56:34+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah nama dan angka bulan di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/konversi-nomor-nama-bulan-di-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/konversi-nomor-nama-bulan-di-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/konversi-nomor-nama-bulan-di-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Konversi antara nama &amp; nomor bulan di google spreadsheet\"}]},{\"@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":"Konversi antara nama bulan dan nomor di Google Sheets - Statorials","description":"Tutorial ini menjelaskan cara mengubah nama dan angka bulan 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\/konversi-nomor-nama-bulan-di-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Konversi antara nama bulan dan nomor di Google Sheets - Statorials","og_description":"Tutorial ini menjelaskan cara mengubah nama dan angka bulan di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/konversi-nomor-nama-bulan-di-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-22T20:56:34+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/convertir1.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\/konversi-nomor-nama-bulan-di-google-sheet\/","url":"https:\/\/statorials.org\/id\/konversi-nomor-nama-bulan-di-google-sheet\/","name":"Konversi antara nama bulan dan nomor di Google Sheets - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T20:56:34+00:00","dateModified":"2023-07-22T20:56:34+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah nama dan angka bulan di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/konversi-nomor-nama-bulan-di-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/konversi-nomor-nama-bulan-di-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/konversi-nomor-nama-bulan-di-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Konversi antara nama &amp; nomor bulan di google spreadsheet"}]},{"@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\/2303"}],"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=2303"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2303\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}