{"id":1716,"date":"2023-11-10T08:06:59","date_gmt":"2023-11-10T08:06:59","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/"},"modified":"2023-12-06T06:19:52","modified_gmt":"2023-12-06T06:19:52","slug":"nama-bulan-di-nomor-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/","title":{"rendered":"Cara mengubah nama bulan menjadi angka di excel"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-148095321\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Untuk mengubah nama bulan menjadi nomor bulan, Anda perlu membuat tanggal dengan nama bulan tersebut menggunakan fungsi DATEVALUE, kemudian menggunakan fungsi MONTH untuk mendapatkan nomor bulan. Anda dapat melihat pada contoh berikut rumus yang kami gunakan.<\/p><h2 class=\"wp-block-heading\"> Rumus untuk mendapatkan nomor bulan dari nama bulan<\/h2><p> Anda dapat menggunakan langkah-langkah berikut:<\/p><ol type=\"1\"><li> Pertama masukkan fungsi DATEVALUE dalam sel.<\/li><li> Setelah itu Anda harus memasukkan \u201c01\u201d.<\/li><li> Selanjutnya, gunakan ampersand dan rujuk ke sel tempat Anda mengetahui nama bulannya.<\/li><li> Sekarang gunakan ampersand lagi dan masukkan \u201c1900\u201d.<\/li><li> Pada akhirnya, gabungkan fungsi MONTH dengan DATEVALUE dan tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79425\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-nom-du-mois-en-nombre.png\" sizes=\"auto, \" srcset=\"\" alt=\"konversi-nama-bulan-ke-angka\" width=\"615\" height=\"275\"><\/figure><\/div><p> Untuk memahami rumus ini, Anda dapat membaginya menjadi dua bagian.<\/p><p> <strong>Di bagian pertama<\/strong> , Anda memiliki DATEVALUE, yang membantu Anda membuat tanggal yang valid menggunakan nama bulan. Anda memiliki 01, Jan dan 1900 dan DATEVALUE membuat tanggal 01-Jan-1900. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79426\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-premiere-partie-a-datevalue.png\" sizes=\"auto, \" srcset=\"\" alt=\"2 bagian pertama memiliki nilai tanggal\" width=\"581\" height=\"325\"><\/figure><\/div><p> Di bagian kedua, fungsi MONTH mengembalikan nomor bulan dari tanggal yang dikembalikan oleh DATEVALUE. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79427\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-deuxieme-partie-a-la-fonction-mois.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi bagian kedua bulan\" width=\"520\" height=\"311\"><\/figure><\/div><p> Keuntungan menggunakan rumus ini adalah Anda memiliki bulan dalam bentuk lengkapnya, misalnya &#8220;Januari&#8221; dan bukan &#8220;Jan&#8221;. Rumus ini akan selalu berhasil. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79428\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-avantages-de-la-valeur-du-mois-et-de-la-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"manfaat-nilai-bulan-dan-tanggal\" width=\"394\" height=\"226\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nom-du-mois-au-numero.xlsx\" rel=\"nofollow\">Unduh<\/a><\/p><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/\">Tambahkan bulan ke tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/akhir-bulan\/\">Dapatkan tanggal akhir bulan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/\">Dapatkan hari pertama setiap bulan di Excel (awal bulan)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/nama-bulannya\/\">Dapatkan bulan dari tanggal di Excel (kutipan)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/seperempat\/\">Dapatkan seperempat dari tanggal [Fiskal + Kalender] di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1716","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara mengubah nama bulan menjadi angka di Excel?<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah nama bulan menjadi nomor bulan. Mari kita periksa ini\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara mengubah nama bulan menjadi angka di Excel?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah nama bulan menjadi nomor bulan. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-nom-du-mois-en-nombre.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/\",\"name\":\"Bagaimana cara mengubah nama bulan menjadi angka di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-nom-du-mois-en-nombre.png\",\"datePublished\":\"2023-11-10T08:06:59+00:00\",\"dateModified\":\"2023-12-06T06:19:52+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah nama bulan menjadi nomor bulan. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-nom-du-mois-en-nombre.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-nom-du-mois-en-nombre.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengubah nama bulan menjadi angka di excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara mengubah nama bulan menjadi angka di Excel?","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah nama bulan menjadi nomor bulan. Mari kita periksa ini\u2026","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:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mengubah nama bulan menjadi angka di Excel?","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah nama bulan menjadi nomor bulan. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:52+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-nom-du-mois-en-nombre.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/","url":"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/","name":"Bagaimana cara mengubah nama bulan menjadi angka di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-nom-du-mois-en-nombre.png","datePublished":"2023-11-10T08:06:59+00:00","dateModified":"2023-12-06T06:19:52+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah nama bulan menjadi nomor bulan. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-nom-du-mois-en-nombre.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-nom-du-mois-en-nombre.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengubah nama bulan menjadi angka di excel"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1716","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1716"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1716\/revisions"}],"predecessor-version":[{"id":2883,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1716\/revisions\/2883"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}