{"id":2170,"date":"2023-09-26T08:48:39","date_gmt":"2023-09-26T08:48:39","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/"},"modified":"2023-12-06T06:15:15","modified_gmt":"2023-12-06T06:15:15","slug":"menambahkan-satu-bulan-ke-tanggal-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/","title":{"rendered":"Bagaimana cara menambahkan bulan ke tanggal di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2623857590\"><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>Sama seperti tahun, Anda dapat menambahkan bulan ke suatu tanggal untuk mendapatkan tanggal di masa depan dan menguranginya untuk mendapatkan tanggal di masa lalu. Dalam tutorial ini, kita akan melihat semua metode dengan beberapa contoh untuk melakukannya.<\/p><h2 class=\"wp-block-heading\"> Tambahkan bulan ke tanggal (tanggal bulan berikutnya)<\/h2><p> Pada contoh pertama, kita akan menulis rumus untuk mendapatkan tanggal bulan berikutnya dan kita akan menggunakan rumus EDATE. Seperti yang Anda lihat pada contoh berikut, kita memiliki tanggal di sel A1, yang mana kita perlu mendapatkan tanggal pasti bulan berikutnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-65983\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-date-du-mois-prochain.png\" sizes=\"auto, \" srcset=\"\" alt=\"dapatkan tanggal bulan berikutnya\" width=\"390\" height=\"311\"><\/figure><\/div><p> Ikuti langkah-langkah di bawah ini:<\/p><ol type=\"1\"><li> Pertama, masukkan \u201c=EDATE(\u201d di sel B1.<\/li><li> Setelah itu, lihat sel A1, di mana Anda memiliki tanggalnya.<\/li><li> Sekarang di argumen kedua masukkan 1.<\/li><li> Terakhir, ketikkan tanda kurung tutup dan tekan Enter.<\/li><\/ol><p> Di sini Anda memiliki tanggal 10 Februari 2022 di sel B1 yang tepat 1 bulan sebelum (bulan berikutnya) dari tanggal yang kami tentukan di rumus. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-65984\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Formule-2-jours.png\" sizes=\"auto, \" srcset=\"\" alt=\"formula-edate\" width=\"545\" height=\"254\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=EDATE(A1,1)<\/code><\/pre><h2 class=\"wp-block-heading\"> Tambahkan 6 bulan ke tanggal<\/h2><p> Demikian pula, Anda dapat menambahkan 6 bulan ke suatu tanggal dan mendapatkan tanggal 6 bulan lebih awal dari tanggal saat ini. Dalam contoh berikut, kita memiliki tanggal yang sama di sel A1 dengan yang kita miliki sebelumnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-65985\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-ajouter-six-mois-a-ce-jour.png\" sizes=\"auto, \" srcset=\"\" alt=\"tambahkan-enam bulan-ke-hari\" width=\"533\" height=\"326\"><\/figure><\/div><p> Sekarang untuk menambah 6 bulan Anda hanya perlu menggunakan rumus berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-65986\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-entrez-la-formule-de-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"masukkan rumus tanggal\" width=\"551\" height=\"338\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=EDATE(A1,6)<\/code><\/pre><h2 class=\"wp-block-heading\"> Tambahkan 3 bulan ke tanggal<\/h2><p> Demikian pula, Anda ingin menambahkan tiga hari. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-65987\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-ajouter-trois-mois-a-ce-jour.png\" sizes=\"auto, \" srcset=\"\" alt=\"tambahkan-tiga-bulan-ke-hari\" width=\"534\" height=\"328\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=EDATE(A1,3)<\/code><\/pre><h2 class=\"wp-block-heading\"> Kurangi bulan dari tanggal<\/h2><p> Sekarang misalkan Anda ingin mengurangi bulan dari sebuah tanggal. Dalam hal ini, Anda hanya perlu menggunakan angka negatif pada argumen kedua (bulan). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-65988\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-soustraire-des-mois-a-partir-de-la-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"kurangi-bulan-dari-tanggal\" width=\"530\" height=\"333\"><\/figure><\/div><p> Dalam contoh berikut, kami menggunakan -6 dalam argumen bulan, dan kami memiliki tanggal 10-Jul-21 yang tepat 6 bulan di belakang 10-Jan-22.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=EDATE(A1,-6)<\/code><\/pre><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\/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\/bulan-di-antara-dua-tanggal\/\">Jumlah bulan antara dua tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/nama-bulan-di-nomor-2\/\">Ubah nama bulan menjadi angka<\/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-2170","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>\u25b7 Bagaimana cara menambahkan bulan ke tanggal di Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini Anda akan belajar cara menulis rumus untuk menambahkan bulan ke suatu tanggal untuk mendapatkan tanggal yang akan datang dan menguranginya\" \/>\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\/menambahkan-satu-bulan-ke-tanggal-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menambahkan bulan ke tanggal di Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini Anda akan belajar cara menulis rumus untuk menambahkan bulan ke suatu tanggal untuk mendapatkan tanggal yang akan datang dan menguranginya\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-date-du-mois-prochain.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\/menambahkan-satu-bulan-ke-tanggal-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/\",\"name\":\"\u25b7 Bagaimana cara menambahkan bulan ke tanggal di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-date-du-mois-prochain.png\",\"datePublished\":\"2023-09-26T08:48:39+00:00\",\"dateModified\":\"2023-12-06T06:15:15+00:00\",\"description\":\"Dalam tutorial ini Anda akan belajar cara menulis rumus untuk menambahkan bulan ke suatu tanggal untuk mendapatkan tanggal yang akan datang dan menguranginya\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-date-du-mois-prochain.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-date-du-mois-prochain.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan bulan ke tanggal 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":"\u25b7 Bagaimana cara menambahkan bulan ke tanggal di Excel?","description":"Dalam tutorial ini Anda akan belajar cara menulis rumus untuk menambahkan bulan ke suatu tanggal untuk mendapatkan tanggal yang akan datang dan menguranginya","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\/menambahkan-satu-bulan-ke-tanggal-2\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menambahkan bulan ke tanggal di Excel?","og_description":"Dalam tutorial ini Anda akan belajar cara menulis rumus untuk menambahkan bulan ke suatu tanggal untuk mendapatkan tanggal yang akan datang dan menguranginya","og_url":"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:15+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-date-du-mois-prochain.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\/menambahkan-satu-bulan-ke-tanggal-2\/","url":"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/","name":"\u25b7 Bagaimana cara menambahkan bulan ke tanggal di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-date-du-mois-prochain.png","datePublished":"2023-09-26T08:48:39+00:00","dateModified":"2023-12-06T06:15:15+00:00","description":"Dalam tutorial ini Anda akan belajar cara menulis rumus untuk menambahkan bulan ke suatu tanggal untuk mendapatkan tanggal yang akan datang dan menguranginya","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-date-du-mois-prochain.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-date-du-mois-prochain.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan bulan ke tanggal 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\/2170","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=2170"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2170\/revisions"}],"predecessor-version":[{"id":2400,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2170\/revisions\/2400"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}