{"id":2877,"date":"2023-07-20T07:15:24","date_gmt":"2023-07-20T07:15:24","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-hari-kerja-antar-tanggal\/"},"modified":"2023-07-20T07:15:24","modified_gmt":"2023-07-20T07:15:24","slug":"google-sheet-hari-kerja-antar-tanggal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-hari-kerja-antar-tanggal\/","title":{"rendered":"Google spreadsheet: hitung jumlah hari kerja antar tanggal"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <strong>NETWORKDAYS<\/strong> di Google Spreadsheet untuk menghitung jumlah hari kerja antara dua tanggal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">NETWORKDAYS(start_date, end_date, [holidays])\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>start_date<\/strong> : Tanggal mulai<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>end_date:<\/strong> tanggal akhir<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>hari libur<\/strong> : Daftar tanggal hari libur yang harus diabaikan saat menghitung (opsional)<\/span><\/li>\n<\/ul>\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: Hitung hari kerja antara dua tanggal<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung jumlah hari kerja antara 01\/01\/2022 hingga 01\/10\/2022.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita dapat menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=NETWORKDAYS( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> , <span dir=\"auto\" style=\"color: #800080;\">B2<\/span> )\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-25138 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jours-ouvrables1-1.jpg\" alt=\"hari kerja antara dua tanggal di Google Spreadsheet\" width=\"546\" height=\"414\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ada <b>6<\/b> hari kerja antara 1\/1\/2022 dan 01\/10\/2022.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hal ini dapat dipastikan dengan menghitung jumlah hari kerja antara dua tanggal pada kalender:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25139 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jours-ouvrables2.jpg\" alt=\"\" width=\"270\" height=\"213\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Faktanya ada <strong>6<\/strong> hari kerja antara kedua tanggal tersebut.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: menghitung hari kerja antara dua tanggal (sebutkan hari libur)<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung jumlah hari kerja antara 01\/03\/2022 dan 27\/12\/2022 tanpa menghitung hari libur berikut jika jatuh pada hari kerja:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Paskah (17\/04\/2022)<\/span><\/li>\n<li> <span style=\"color: #000000;\">Halloween (31\/10\/2022)<\/span><\/li>\n<li> <span style=\"color: #000000;\">Syukuran (24\/11\/2022)<\/span><\/li>\n<li> <span style=\"color: #000000;\">Natal (25\/12\/2022)<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita dapat menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=NETWORKDAYS( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> , <span dir=\"auto\" style=\"color: #800080;\">B2<\/span> , <span style=\"color: #008080;\">A8:A11<\/span> )\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25140 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jours-ouvrables3.jpg\" alt=\"\" width=\"531\" height=\"431\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terdapat <b>214<\/b> hari kerja antara 1\/3\/2022 hingga 27\/12\/2022, tidak termasuk daftar hari libur yang telah kami tentukan.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi <strong>NETWORKDAYS<\/strong> di Google Spreadsheet <a href=\"https:\/\/support.google.com\/docs\/answer\/3092979?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 tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\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\/rentang-tanggal-filter-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara memfilter berdasarkan rentang tanggal di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Mengisi Tanggal Secara Otomatis di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi NETWORKDAYS di Google Spreadsheet untuk menghitung jumlah hari kerja antara dua tanggal. Fungsi ini menggunakan sintaks dasar berikut: NETWORKDAYS(start_date, end_date, [holidays]) Emas: start_date : Tanggal mulai end_date: tanggal akhir hari libur : Daftar tanggal hari libur yang harus diabaikan saat menghitung (opsional) Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. [&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 hari kerja antar tanggal - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah hari kerja antar 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-hari-kerja-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 hari kerja antar tanggal - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah hari kerja antar tanggal di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-hari-kerja-antar-tanggal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T07:15:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jours-ouvrables1-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-hari-kerja-antar-tanggal\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-hari-kerja-antar-tanggal\/\",\"name\":\"Google Spreadsheet: Hitung jumlah hari kerja antar tanggal - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T07:15:24+00:00\",\"dateModified\":\"2023-07-20T07:15:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jumlah hari kerja antar tanggal di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-hari-kerja-antar-tanggal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-hari-kerja-antar-tanggal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-hari-kerja-antar-tanggal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: hitung jumlah hari kerja 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 hari kerja antar tanggal - Statologi","description":"Tutorial ini menjelaskan cara menghitung jumlah hari kerja antar 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-hari-kerja-antar-tanggal\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Hitung jumlah hari kerja antar tanggal - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung jumlah hari kerja antar tanggal di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-hari-kerja-antar-tanggal\/","og_site_name":"Statorials","article_published_time":"2023-07-20T07:15:24+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jours-ouvrables1-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-hari-kerja-antar-tanggal\/","url":"https:\/\/statorials.org\/id\/google-sheet-hari-kerja-antar-tanggal\/","name":"Google Spreadsheet: Hitung jumlah hari kerja antar tanggal - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T07:15:24+00:00","dateModified":"2023-07-20T07:15:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jumlah hari kerja antar tanggal di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-hari-kerja-antar-tanggal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-hari-kerja-antar-tanggal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-hari-kerja-antar-tanggal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: hitung jumlah hari kerja 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\/2877"}],"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=2877"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2877\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2877"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2877"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}