{"id":2860,"date":"2023-07-20T09:03:42","date_gmt":"2023-07-20T09:03:42","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-bulan-antar-tanggal\/"},"modified":"2023-07-20T09:03:42","modified_gmt":"2023-07-20T09:03:42","slug":"google-sheet-bulan-antar-tanggal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-bulan-antar-tanggal\/","title":{"rendered":"Google spreadsheet: hitung jumlah bulan antar tanggal"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk menghitung jumlah bulan antara dua tanggal di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rumus 1: Hitung bulan lengkap antara dua tanggal<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=DATEDIF( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> , <span dir=\"auto\" style=\"color: #800080;\">B2<\/span> , <span class=\" string \" dir=\"auto\">\u201c <span style=\"color: #008000;\">m<\/span> \u201d<\/span> )\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Rumus 2: Hitung pecahan bulan antara dua tanggal<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=DATEDIF( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> , <span dir=\"auto\" style=\"color: #800080;\">B2<\/span> , <span class=\" string \" dir=\"auto\">\u201c <span style=\"color: #008000;\">m<\/span> \u201d<\/span> ) <span class=\"  default-formula-text-color\" dir=\"auto\">+<\/span> DATEDIF( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> , <span dir=\"auto\" style=\"color: #800080;\">B2<\/span> , <span class=\" string \" dir=\"auto\">\u201c <span style=\"color: #008000;\">md<\/span> \u201d<\/span> ) <span class=\"  default-formula-text-color\" dir=\"auto\">\/<\/span> ( <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">365<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">\/<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">12<\/span> )\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kedua rumus tersebut mengasumsikan bahwa sel <strong>A2<\/strong> berisi tanggal mulai dan sel <strong>B2<\/strong> berisi tanggal akhir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung bulan penuh antara dua tanggal<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menghitung jumlah bulan lengkap antara daftar tanggal mulai dan akhir di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-25035\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mois-entre-1-1.jpg\" alt=\"hitung bulan antara dua tanggal di Google Sheets\" width=\"537\" height=\"410\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan hasilnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Ada <strong>1<\/strong> bulan penuh antara 01\/01\/2022 dan 04\/02\/2022.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada <strong>4<\/strong> bulan penuh antara 01\/07\/2022 dan 29\/05\/2022.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada <strong>0<\/strong> bulan penuh antara 20\/01\/2022 dan 02\/05\/2022.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung pecahan bulan antara dua tanggal<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menghitung jumlah pecahan bulan antara daftar tanggal mulai dan akhir di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-25036\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mois-entre-2-1.jpg\" alt=\"hitung pecahan bulan antara tanggal di Google Spreadsheet\" width=\"551\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan hasilnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Ada sekitar <strong>1.099<\/strong> bulan antara 01\/01\/2022 dan 04\/02\/2022.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada sekitar <strong>4.723<\/strong> bulan antara 01\/07\/2022 dan 29\/05\/2022.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada sekitar <strong>0,526<\/strong> bulan antara 20\/01\/2022 dan 02\/05\/2022.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan #1<\/strong> : Rumus ini menggunakan <strong>365\/12<\/strong> untuk memperkirakan jumlah hari dalam sebulan. Anda dapat mengubah nilai ini menjadi <strong>30<\/strong> jika Anda ingin menyederhanakan rumus dan berasumsi bahwa satu bulan pada umumnya memiliki 30 hari.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan #2<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <strong>DATEDIF<\/strong> di Google Spreadsheet <a href=\"https:\/\/support.google.com\/docs\/answer\/6055612?hl=en\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/\" target=\"_blank\" rel=\"noopener\">Cara mengonversi stempel waktu ke tanggal di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/urutkan-berdasarkan-tanggal-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara mengurutkan berdasarkan tanggal di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-membandingkan-tanggal\/\" target=\"_blank\" rel=\"noopener\">Cara Membandingkan Tanggal di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk menghitung jumlah bulan antara dua tanggal di Google Spreadsheet: Rumus 1: Hitung bulan lengkap antara dua tanggal =DATEDIF( A2 , B2 , \u201c m \u201d ) Rumus 2: Hitung pecahan bulan antara dua tanggal =DATEDIF( A2 , B2 , \u201c m \u201d ) + DATEDIF( A2 , B2 , [&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>Google Spreadsheet: Hitung jumlah bulan antar tanggal - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah bulan antara dua tanggal 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\/google-sheet-bulan-antar-tanggal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Hitung jumlah bulan antar tanggal - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah bulan antara dua tanggal di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-bulan-antar-tanggal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T09:03:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mois-entre-1-1.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\/google-sheet-bulan-antar-tanggal\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-bulan-antar-tanggal\/\",\"name\":\"Google Spreadsheet: Hitung jumlah bulan antar tanggal - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T09:03:42+00:00\",\"dateModified\":\"2023-07-20T09:03:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jumlah bulan antara dua tanggal di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-bulan-antar-tanggal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-bulan-antar-tanggal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-bulan-antar-tanggal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: hitung jumlah bulan antar tanggal\"}]},{\"@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":"Google Spreadsheet: Hitung jumlah bulan antar tanggal - Statologi","description":"Tutorial ini menjelaskan cara menghitung jumlah bulan antara dua tanggal 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\/google-sheet-bulan-antar-tanggal\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Hitung jumlah bulan antar tanggal - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung jumlah bulan antara dua tanggal di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-bulan-antar-tanggal\/","og_site_name":"Statorials","article_published_time":"2023-07-20T09:03:42+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mois-entre-1-1.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\/google-sheet-bulan-antar-tanggal\/","url":"https:\/\/statorials.org\/id\/google-sheet-bulan-antar-tanggal\/","name":"Google Spreadsheet: Hitung jumlah bulan antar tanggal - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T09:03:42+00:00","dateModified":"2023-07-20T09:03:42+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jumlah bulan antara dua tanggal di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-bulan-antar-tanggal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-bulan-antar-tanggal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-bulan-antar-tanggal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: hitung jumlah bulan antar tanggal"}]},{"@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\/2860"}],"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=2860"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2860\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2860"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}