{"id":5125,"date":"2023-07-03T04:12:23","date_gmt":"2023-07-03T04:12:23","guid":{"rendered":"https:\/\/statorials.org\/id\/isi-otomatis-excel-hari-dalam-seminggu\/"},"modified":"2023-07-03T04:12:23","modified_gmt":"2023-07-03T04:12:23","slug":"isi-otomatis-excel-hari-dalam-seminggu","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/isi-otomatis-excel-hari-dalam-seminggu\/","title":{"rendered":"Cara mengisi otomatis hari dalam seminggu di excel (3 contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Ada tiga cara umum untuk mengisi otomatis hari dalam seminggu di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: IsiOtomatis setiap hari dalam seminggu<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>misalnya<\/strong> Minggu, Senin, Selasa, Rabu,\u2026<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Isi otomatis akhir pekan saja<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>misalnya<\/strong> Senin, Selasa, Rabu, Kamis, Jumat, Senin,\u2026<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: Hanya mengisi otomatis tanggal akhir pekan (melewatkan tanggal akhir pekan)<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">misalnya 02\/01\/2024, 02\/02\/2024, 02\/05\/2024, 02\/06\/2024, \u2026<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: IsiOtomatis setiap hari dalam seminggu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk mengisi otomatis setiap hari dalam seminggu, cukup ketikkan nama hari pertama yang ingin Anda mulai.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita mengetik \u201cMinggu\u201d di sel <strong>A1<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39944 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour-de-remplissage1.png\" alt=\"\" width=\"431\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, arahkan kursor ke sudut kanan bawah sel <strong>A1<\/strong> hingga muncul tanda silang kecil ( <strong>+<\/strong> ), lalu cukup klik dan seret ke bawah ke sel lain di kolom A untuk mengisi hari dalam seminggu secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39945 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour-de-remplissage2.png\" alt=\"\" width=\"428\" height=\"316\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap hari dalam seminggu akan ditampilkan di kolom A:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39946 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour-de-remplissage3.png\" alt=\"\" width=\"435\" height=\"347\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika Anda terus menyeret daftarnya lebih jauh, hari-hari dalam seminggu akan dimulai lagi pada hari Minggu.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: IsiOtomatis hanya pada akhir pekan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk mengisi otomatis hari dalam seminggu saja, masukkan daftar hari dalam seminggu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39947 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour-de-remplissage4.png\" alt=\"\" width=\"479\" height=\"344\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian salin dan tempel lagi daftar ini ke kolom A:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39948 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour-de-remplissage5.png\" alt=\"\" width=\"446\" height=\"358\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian sorot seluruh daftar, lalu klik dan seret ke bawah ke sel yang tersisa di kolom A untuk secara otomatis hanya mengisi hari dalam seminggu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39949 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour-de-remplissage6.png\" alt=\"\" width=\"442\" height=\"525\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini secara otomatis akan mengisi akhir pekan dan mengabaikan akhir pekan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39950 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour-de-remplissage7.png\" alt=\"\" width=\"434\" height=\"492\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Hanya mengisi otomatis tanggal akhir pekan (melewatkan tanggal akhir pekan)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk mengisi otomatis tanggal akhir pekan saja dan mengabaikan akhir pekan, masukkan tanggal pertama yang ingin Anda mulai di sel <strong>A1<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39951 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour-de-remplissage8.png\" alt=\"\" width=\"448\" height=\"363\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian ketikkan rumus berikut pada sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=WORKDAY.INTL( <span style=\"color: #3366ff;\">A1,1<\/span> ,\"0000011\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik dan drag rumus dari sel <strong>A2<\/strong> ke sel sebanyak yang Anda inginkan di kolom A:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39952 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour-de-remplissage9.png\" alt=\"\" width=\"503\" height=\"532\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Daftar tanggal yang dihasilkan hanya mencakup hari dalam seminggu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat memverifikasi ini dengan melihat kalender secara manual dan melihat bahwa setiap tanggal dalam daftar hanya jatuh pada hari kerja:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39953 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour-de-remplissage10.png\" alt=\"\" width=\"368\" height=\"388\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <strong>WORKDAY.INTL<\/strong> di Excel <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/workday-intl-function-a378391c-9ba7-4678-8a39-39611a9bf81d\" target=\"_blank\" rel=\"noopener\">di sini<\/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> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Mengisi Tanggal Secara Otomatis di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/isi-otomatis-excel-dari-daftar\/\" target=\"_blank\" rel=\"noopener\">Cara mengisi otomatis menggunakan daftar kustom di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/isi-otomatis-excel-dari-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">Cara mengisi otomatis nilai dari lembar lain di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ada tiga cara umum untuk mengisi otomatis hari dalam seminggu di Excel: Metode 1: IsiOtomatis setiap hari dalam seminggu misalnya Minggu, Senin, Selasa, Rabu,\u2026 Metode 2: Isi otomatis akhir pekan saja misalnya Senin, Selasa, Rabu, Kamis, Jumat, Senin,\u2026 Metode 3: Hanya mengisi otomatis tanggal akhir pekan (melewatkan tanggal akhir pekan) misalnya 02\/01\/2024, 02\/02\/2024, 02\/05\/2024, 02\/06\/2024, [&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 mengisi hari dalam seminggu secara otomatis di Excel (3 contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengisi otomatis hari dalam seminggu 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\/isi-otomatis-excel-hari-dalam-seminggu\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengisi hari dalam seminggu secara otomatis di Excel (3 contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengisi otomatis hari dalam seminggu di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/isi-otomatis-excel-hari-dalam-seminggu\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T04:12:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour-de-remplissage1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/isi-otomatis-excel-hari-dalam-seminggu\/\",\"url\":\"https:\/\/statorials.org\/id\/isi-otomatis-excel-hari-dalam-seminggu\/\",\"name\":\"Cara mengisi hari dalam seminggu secara otomatis di Excel (3 contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-03T04:12:23+00:00\",\"dateModified\":\"2023-07-03T04:12:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengisi otomatis hari dalam seminggu di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/isi-otomatis-excel-hari-dalam-seminggu\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/isi-otomatis-excel-hari-dalam-seminggu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/isi-otomatis-excel-hari-dalam-seminggu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengisi otomatis hari dalam seminggu di excel (3 contoh)\"}]},{\"@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 mengisi hari dalam seminggu secara otomatis di Excel (3 contoh) - Statologi","description":"Tutorial ini menjelaskan cara mengisi otomatis hari dalam seminggu 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\/isi-otomatis-excel-hari-dalam-seminggu\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengisi hari dalam seminggu secara otomatis di Excel (3 contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mengisi otomatis hari dalam seminggu di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/isi-otomatis-excel-hari-dalam-seminggu\/","og_site_name":"Statorials","article_published_time":"2023-07-03T04:12:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/jour-de-remplissage1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/isi-otomatis-excel-hari-dalam-seminggu\/","url":"https:\/\/statorials.org\/id\/isi-otomatis-excel-hari-dalam-seminggu\/","name":"Cara mengisi hari dalam seminggu secara otomatis di Excel (3 contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-03T04:12:23+00:00","dateModified":"2023-07-03T04:12:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengisi otomatis hari dalam seminggu di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/isi-otomatis-excel-hari-dalam-seminggu\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/isi-otomatis-excel-hari-dalam-seminggu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/isi-otomatis-excel-hari-dalam-seminggu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengisi otomatis hari dalam seminggu di excel (3 contoh)"}]},{"@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\/5125"}],"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=5125"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5125\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}