{"id":4679,"date":"2023-07-09T00:55:58","date_gmt":"2023-07-09T00:55:58","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-hari-kerja-pertama-setiap-bulan\/"},"modified":"2023-07-09T00:55:58","modified_gmt":"2023-07-09T00:55:58","slug":"excel-hari-kerja-pertama-setiap-bulan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-hari-kerja-pertama-setiap-bulan\/","title":{"rendered":"Cara menemukan hari kerja pertama setiap bulan di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk menemukan hari kerja pertama setiap bulan untuk tanggal tertentu di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=WORKDAY(EOMONTH( <span style=\"color: #3366ff;\">A2<\/span> ,-1), 1)<\/span><\/strong><\/span>\n<\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Rumus ini akan mengembalikan hari kerja pertama setiap bulan untuk tanggal di sel <strong>A2<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus ini bekerja dengan menggunakan fungsi <strong>EOMONTH<\/strong> untuk mencari hari terakhir suatu bulan sebelum tanggal di sel <strong>A2<\/strong> , kemudian menggunakan fungsi <strong>WORKDAY<\/strong> untuk mencari hari pertama dalam minggu di bulan berikutnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan Kumpulan Data<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari masukkan kumpulan data berikut ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36536 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fbday1.png\" alt=\"\" width=\"464\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung hari kerja pertama setiap bulan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan mengetikkan rumus berikut di sel <strong>C2<\/strong> untuk mencari hari kerja pertama pada bulan tersebut untuk tanggal di sel <strong>A2<\/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\">=WORKDAY(EOMONTH( <span style=\"color: #3366ff;\">A2<\/span> ,-1), 1)<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36537\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fbday2.png\" alt=\"Excel menemukan hari kerja pertama setiap bulan\" width=\"531\" height=\"428\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Ubah nilai numerik menjadi format tanggal<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Secara default, nilai tanggal ditampilkan sebagai nilai numerik.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Nilai numerik mewakili jumlah hari sejak 1\/1\/1900.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengubah nilai numerik tersebut menjadi tanggal, kita dapat menyorot cell range <strong>C2:C11<\/strong> , lalu klik menu drop-down <strong>Number Format<\/strong> pada tab <strong>Home<\/strong> , lalu klik <strong>Short Date<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36540 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fbday3.png\" alt=\"\" width=\"651\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap nilai numerik di kolom C akan diubah ke format tanggal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36541 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fbday4.png\" alt=\"\" width=\"507\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom C menunjukkan hari kerja pertama pada bulan dimana tanggal pada kolom A berada.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat melihat kalender dan melihat bahwa <strong>01\/04\/2022<\/strong> adalah hari Selasa:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36470 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/premiere-semaine4.png\" alt=\"\" width=\"329\" height=\"357\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Hari kerja pertama bulan Januari adalah Senin tanggal 3.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Jadi rumus kami mengembalikan <strong>3\/1\/2022<\/strong> .<\/span><\/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 tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/excel-menambahkan-bulan-ke-tanggal\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan bulan hingga saat ini di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-mengurutkan-bulan-secara-kronologis\/\" target=\"_blank\" rel=\"noopener\">Cara mengurutkan bulan secara kronologis di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-bulan-antar-tanggal\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung jumlah bulan antar tanggal di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk menemukan hari kerja pertama setiap bulan untuk tanggal tertentu di Excel: =WORKDAY(EOMONTH( A2 ,-1), 1) Rumus ini akan mengembalikan hari kerja pertama setiap bulan untuk tanggal di sel A2 . Rumus ini bekerja dengan menggunakan fungsi EOMONTH untuk mencari hari terakhir suatu bulan sebelum tanggal di sel A2 , [&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>Cara menemukan hari kerja pertama setiap bulan di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menemukan hari kerja pertama setiap bulan di Excel, beserta contohnya.\" \/>\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-hari-kerja-pertama-setiap-bulan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menemukan hari kerja pertama setiap bulan di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menemukan hari kerja pertama setiap bulan di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-hari-kerja-pertama-setiap-bulan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T00:55:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fbday1.png\" \/>\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-hari-kerja-pertama-setiap-bulan\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-hari-kerja-pertama-setiap-bulan\/\",\"name\":\"Cara menemukan hari kerja pertama setiap bulan di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T00:55:58+00:00\",\"dateModified\":\"2023-07-09T00:55:58+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menemukan hari kerja pertama setiap bulan di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-hari-kerja-pertama-setiap-bulan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-hari-kerja-pertama-setiap-bulan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-hari-kerja-pertama-setiap-bulan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menemukan hari kerja pertama setiap bulan di excel\"}]},{\"@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":"Cara menemukan hari kerja pertama setiap bulan di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menemukan hari kerja pertama setiap bulan di Excel, beserta contohnya.","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-hari-kerja-pertama-setiap-bulan\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menemukan hari kerja pertama setiap bulan di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menemukan hari kerja pertama setiap bulan di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-hari-kerja-pertama-setiap-bulan\/","og_site_name":"Statorials","article_published_time":"2023-07-09T00:55:58+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fbday1.png"}],"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-hari-kerja-pertama-setiap-bulan\/","url":"https:\/\/statorials.org\/id\/excel-hari-kerja-pertama-setiap-bulan\/","name":"Cara menemukan hari kerja pertama setiap bulan di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T00:55:58+00:00","dateModified":"2023-07-09T00:55:58+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menemukan hari kerja pertama setiap bulan di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-hari-kerja-pertama-setiap-bulan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-hari-kerja-pertama-setiap-bulan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-hari-kerja-pertama-setiap-bulan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menemukan hari kerja pertama setiap bulan di excel"}]},{"@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\/4679"}],"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=4679"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4679\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}