{"id":4035,"date":"2023-07-14T00:56:38","date_gmt":"2023-07-14T00:56:38","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-minggu-antar-tanggal\/"},"modified":"2023-07-14T00:56:38","modified_gmt":"2023-07-14T00:56:38","slug":"excel-minggu-antar-tanggal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-minggu-antar-tanggal\/","title":{"rendered":"Excel: hitung jumlah minggu antar tanggal"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk menghitung jumlah minggu antara dua tanggal di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rumus 1: Hitung minggu penuh antara dua tanggal<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=INT(( <span style=\"color: #3366ff;\">B2<\/span> - <span style=\"color: #ff0000;\">A2<\/span> )\/7)\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Rumus 2: hitung pecahan minggu antara dua tanggal<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=( <span style=\"color: #3366ff;\">B2<\/span> - <span style=\"color: #ff0000;\">A2<\/span> )\/7 \n<\/span><\/strong><\/span><\/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<h2> <span style=\"color: #000000;\"><strong>Contoh 1: hitung minggu lengkap antara dua tanggal<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut memperlihatkan cara menghitung jumlah minggu lengkap antara daftar tanggal mulai dan berakhir di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32235\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semaines1.jpg\" alt=\"Excel menghitung minggu penuh antar tanggal\" width=\"468\" height=\"473\" 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>4<\/strong> minggu penuh antara 1\/1\/2022 dan 4\/2\/2022.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada <strong>20<\/strong> minggu penuh antara 01\/07\/2022 dan 29\/05\/2022.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada <strong>2<\/strong> minggu penuh antara tanggal 20\/01\/2022 dan 02\/05\/2022.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: hitung pecahan minggu antara dua tanggal<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut memperlihatkan cara menghitung jumlah pecahan minggu antara daftar tanggal mulai dan akhir di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32236\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semaines2.jpg\" alt=\"Excel menghitung pecahan minggu antar tanggal\" width=\"579\" height=\"494\" 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>4.857<\/strong> minggu antara 01\/01\/2022 dan 02\/04\/2022.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada <strong>20.286<\/strong> minggu antara 01\/07\/2022 dan 29\/05\/2022.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada <strong>2.286<\/strong> minggu 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>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/excel-bulan-antar-tanggal\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Jumlah Bulan Antar Tanggal di Excel<\/a><\/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 operasi umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/excel-tambahkan-kurangi-minggu-dari-tanggal\/\" target=\"_blank\" rel=\"noopener\">Cara Menambah dan Mengurangi Minggu ke Tanggal di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/grup-excel-per-minggu\/\" target=\"_blank\" rel=\"noopener\">Cara mengelompokkan data berdasarkan minggu di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlah-excel-per-minggu\/\" target=\"_blank\" rel=\"noopener\">Cara menambah minggu di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk menghitung jumlah minggu antara dua tanggal di Excel: Rumus 1: Hitung minggu penuh antara dua tanggal =INT(( B2 &#8211; A2 )\/7) Rumus 2: hitung pecahan minggu antara dua tanggal =( B2 &#8211; A2 )\/7 Kedua rumus tersebut mengasumsikan bahwa sel A2 berisi tanggal mulai dan sel B2 berisi 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>Excel: Hitung jumlah minggu antar tanggal - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah minggu antara dua tanggal di Excel, 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\/excel-minggu-antar-tanggal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Hitung jumlah minggu antar tanggal - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah minggu antara dua tanggal di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-minggu-antar-tanggal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T00:56:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semaines1.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\/excel-minggu-antar-tanggal\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-minggu-antar-tanggal\/\",\"name\":\"Excel: Hitung jumlah minggu antar tanggal - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T00:56:38+00:00\",\"dateModified\":\"2023-07-14T00:56:38+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jumlah minggu antara dua tanggal di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-minggu-antar-tanggal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-minggu-antar-tanggal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-minggu-antar-tanggal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: hitung jumlah minggu 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":"Excel: Hitung jumlah minggu antar tanggal - Statorial","description":"Tutorial ini menjelaskan cara menghitung jumlah minggu antara dua tanggal di Excel, 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\/excel-minggu-antar-tanggal\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Hitung jumlah minggu antar tanggal - Statorial","og_description":"Tutorial ini menjelaskan cara menghitung jumlah minggu antara dua tanggal di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-minggu-antar-tanggal\/","og_site_name":"Statorials","article_published_time":"2023-07-14T00:56:38+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semaines1.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\/excel-minggu-antar-tanggal\/","url":"https:\/\/statorials.org\/id\/excel-minggu-antar-tanggal\/","name":"Excel: Hitung jumlah minggu antar tanggal - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T00:56:38+00:00","dateModified":"2023-07-14T00:56:38+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jumlah minggu antara dua tanggal di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-minggu-antar-tanggal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-minggu-antar-tanggal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-minggu-antar-tanggal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: hitung jumlah minggu 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\/4035"}],"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=4035"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4035\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}