{"id":1673,"date":"2023-11-12T13:33:22","date_gmt":"2023-11-12T13:33:22","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/"},"modified":"2023-12-06T06:16:00","modified_gmt":"2023-12-06T06:16:00","slug":"bulan-hari-kerja","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/","title":{"rendered":"Bagaimana cara mengekstrak hari kerja dalam sebulan?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1244581202\"><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 mendapatkan jumlah hari kerja (working day) di Excel menggunakan rumus, Anda perlu menggabungkan dua fungsi (EOMONTH dan NETWORKDAYS). Dalam rumus ini, EOMONTH membantu Anda mendapatkan <a href=\"https:\/\/exceladvisor.org\/id\/akhir-bulan\/\">tanggal terakhir pada bulan tersebut<\/a> , dan menggunakan tanggal terakhir dan tanggal pertama yang Anda tentukan, NETWORKDAYS mengembalikan jumlah total hari kerja dalam sebulan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79816\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-ouvres-par-mois.png\" sizes=\"auto, \" srcset=\"\" alt=\"hari kerja dalam sebulan\" width=\"592\" height=\"471\"><\/figure><\/div><p> Dalam tutorial ini, kita akan mempelajari cara menulis rumus ini. Dan kami juga akan memperhitungkan hari libur nasional yang perlu Anda tentukan saat menghitung jumlah hari.<\/p><h2 class=\"wp-block-heading\"> Rumus Excel untuk mendapatkan jumlah hari kerja dalam sebulan<\/h2><p> Anda dapat menggunakan langkah-langkah di bawah ini:<\/p><ol type=\"1\"><li> Pertama, di dalam sel, masukkan fungsi COUNT OF WORKDAYS.<\/li><li> Setelah itu, di argumen pertama (tanggal_mulai) rujuk ke sel tempat Anda memiliki tanggal mulai bulan tersebut.<\/li><li> Kemudian, di argumen kedua, (tanggal_akhir) masukkan fungsi EOMONTH.<\/li><li> Dari sana, di EOMONTH, tentukan tanggal mulai bulan yang Anda referensikan dalam argumen start_date NETWORKDAYS.<\/li><li> Sekarang masukkan angka nol (0) dalam argumen (bulan) EOMONTH dan ketik tanda kurung tutup untuk menutup fungsi.<\/li><li> Pada akhirnya, lihat daftar hari libur (harus berupa daftar tanggal yang valid) di argumen [hari libur] di NETWORKDAYS, ketikkan tanda kurung penutup 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-79817\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-2-jours-de-reseau.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi hari jaringan\" width=\"580\" height=\"357\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula line-numbers\" lang=\"excel-formula\">=NETWORKDAYS(A1,EOMONTH(A1,0),A4:A14) =NETWORKDAYS(start_date,EOMONTH(start_date,0),list_of_holidays)<\/code><\/pre><h2 class=\"wp-block-heading\"> Bagaimana cara kerja rumus ini?<\/h2><p> Seperti yang saya sebutkan sebelumnya, fungsi EOMONTH mengembalikan tanggal terakhir setiap bulan. Saat Anda menentukan tanggal dalam fungsi, fungsi tersebut akan mengembalikan tanggal terakhir bulan itu. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79818\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-3-mois.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi eobulan\" width=\"546\" height=\"213\"><\/figure><\/div><p> COUNT.WORKDAYS menggunakan tanggal ini sebagai tanggal akhir untuk mendapatkan jumlah hari antara dua tanggal tersebut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79819\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-fonction-reseau-pour-obtenir-des-jours.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi-jaringan-untuk-mendapatkan-hari\" width=\"558\" height=\"279\"><\/figure><\/div><p> Dan pada akhirnya, ketika Anda menentukan daftar tanggal yang merupakan hari libur. COUNT.WORKDAYS juga memperhitungkan hal ini saat menghitung jumlah hari.<\/p><p> Pada contoh di atas, kita menggunakan hari pertama bulan Januari 2023. Pada bulan Januari, kita memiliki total 31 hari. Dan jika Anda memeriksanya secara manual, Anda memiliki 10 akhir pekan dan hari libur dalam sebulan. Ini berarti 21 hari kerja untuk sebuah bisnis. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79820\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-exemples-pour-obtenir-des-jours-ouvres.png\" sizes=\"auto, \" srcset=\"\" alt=\"contoh-untuk-mendapatkan-hari-kerja\" width=\"616\" height=\"394\"><\/figure><\/div><p> Dan itulah jumlah pasti hari kerja yang kami dapatkan sebagai hasilnya. <\/p><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\/jours-ouvrables.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\/tambahkan-tanggal-dalam-seminggu\/\">Tambahkan-kurangi minggu dari tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mendapatkan-nama-hari-itu\/\">Dapatkan nama hari dari tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hari-dalam-sebulan\/\">Dapatkan jumlah total hari dalam sebulan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/\">Ubah tanggal menjadi teks<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/\">Hari hitung mundur<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hari-antara-dua-tanggal\/\">Hitung hari antara dua tanggal<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/julienne-tanggal-2\/\">Konversikan ke tanggal Julian<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/minggu-sebelumnya-2\/\">Dapatkan hari Minggu sebelumnya<\/a><\/li><\/ul><\/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-1673","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 mengekstrak hari kerja dalam sebulan? - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan jumlah hari kerja dalam sebulan. 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\/bulan-hari-kerja\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara mengekstrak hari kerja dalam sebulan? - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan jumlah hari kerja dalam sebulan. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-ouvres-par-mois.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/\",\"name\":\"Bagaimana cara mengekstrak hari kerja dalam sebulan? - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-ouvres-par-mois.png\",\"datePublished\":\"2023-11-12T13:33:22+00:00\",\"dateModified\":\"2023-12-06T06:16:00+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan jumlah hari kerja dalam sebulan. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-ouvres-par-mois.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-ouvres-par-mois.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengekstrak hari kerja dalam sebulan?\"}]},{\"@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 mengekstrak hari kerja dalam sebulan? - Penasihat Excel","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan jumlah hari kerja dalam sebulan. 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\/bulan-hari-kerja\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mengekstrak hari kerja dalam sebulan? - Penasihat Excel","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan jumlah hari kerja dalam sebulan. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:00+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-ouvres-par-mois.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/","url":"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/","name":"Bagaimana cara mengekstrak hari kerja dalam sebulan? - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-ouvres-par-mois.png","datePublished":"2023-11-12T13:33:22+00:00","dateModified":"2023-12-06T06:16:00+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan jumlah hari kerja dalam sebulan. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-ouvres-par-mois.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-ouvres-par-mois.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengekstrak hari kerja dalam sebulan?"}]},{"@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\/1673","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=1673"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1673\/revisions"}],"predecessor-version":[{"id":2479,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1673\/revisions\/2479"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}