{"id":2036,"date":"2023-10-23T19:44:04","date_gmt":"2023-10-23T19:44:04","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/"},"modified":"2023-12-06T06:18:17","modified_gmt":"2023-12-06T06:18:17","slug":"nama-hari-kerja","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/","title":{"rendered":"Bagaimana cara menggunakan fungsi vba weekdayname?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1960245773\"><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>Fungsi VBA WEEKDAYNAME tercantum dalam kategori tanggal fungsi VBA. Saat Anda menggunakannya dalam kode VBA, <strong>ia mengembalikan nama hari (hari kerja<\/strong> ) menggunakan bilangan bulat yang disediakan sebagai nomor hari. Secara sederhana, ini mengembalikan nama hari menggunakan nomor hari dalam seminggu (mulai dari 1 hingga 7).<\/p><h2 class=\"wp-block-heading\"> Sintaksis<\/h2><p> <strong>NamaHariPekan(Hari Kerja, [Singkatan], [Hari Minggu Pertama])<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumen<\/h2><ul><li> <strong>Hari dalam seminggu<\/strong> : Bilangan bulat untuk menentukan hari antara 1 dan 7.<\/li><li> <strong>[Singkatan]<\/strong> : Nilai Boolean untuk menentukan apakah Anda memerlukan nama bulan penuh atau nama yang disingkat [Ini adalah argumen opsional dan jika dihilangkan, default VBA adalah FALSE].<ul><li> Gunakan TRUE untuk nama pendek (yaitu \u201cJan\u201d, \u201cFebruari\u201d, \u201cMar\u201d, dll.) atau FALSE untuk nama lengkap (yaitu \u201cJanuari\u201d, \u201cFebruari\u201d, \u201cMaret\u201d, dll.)<\/li><\/ul><\/li><li> <strong>[FirstDayOfWeek]<\/strong> : Sebuah string untuk menyetel hari pertama dalam seminggu [Ini adalah argumen opsional dan jika dihilangkan, VBA menggunakan vbSunday secara default].<ul><li> vbUseSystemDayOfWeek \u2013 Tergantung pada pengaturan sistem.<\/li><li> vbMinggu \u2013 Minggu<\/li><li> vblunday \u2013 senin<\/li><li> vbSelasa \u2013 Selasa<\/li><li> vbRabu \u2013 Rabu<\/li><li> vbKamis \u2013 Kamis<\/li><li> vbJumat \u2013 Jumat<\/li><li> vbSabtu \u2013 Sabtu<\/li><\/ul><\/li><\/ul><h2 class=\"wp-block-heading\"> Contoh<\/h2><p> Untuk memahami secara praktis cara menggunakan fungsi VBA WEEKDAYNAME, Anda perlu melihat contoh di bawah ini di mana kami telah menulis kode vba menggunakannya: <\/p><figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"contoh-vba-nama hari kerja-fungsi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-weekdayname-function\" width=\"838\" height=\"405\"><\/figure><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_WEEKDAYNAME() Range(\"A1\").Value = WeekdayName(1, \"True\", vbMonday) End Sub<\/code><\/pre><p> Pada kode di atas, kita menggunakan WEEKDAYNAME, dan kita menggunakan 1 untuk mendapatkan hari pertama dalam seminggu, TRUE untuk mendapatkan nama pendek hari dalam seminggu, dan vbMonday untuk menetapkan Senin sebagai hari pertama dalam seminggu. Hasilnya, kita memiliki Mon di sel B1. <\/p><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Tutorial lainnya <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-16\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/tanggal-2\/\">TANGGAL VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tanggaltambahan\/\">TANGGAL VBATAMBAH<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/bagian-tanggal\/\">BAGIAN TANGGAL VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/serial-tanggal\/\">SERI TANGGAL VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/nilai-tanggal\/\">NILAI TANGGAL VBA<\/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-2036","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 menggunakan fungsi VBA WEEKDAYNAME?<\/title>\n<meta name=\"description\" content=\"Pelajari cara menggunakan fungsi VBA WEEKDAYNAME dengan sintaksis, argumen, dan contoh dengan kode 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:\/\/exceladvisor.org\/id\/nama-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 menggunakan fungsi VBA WEEKDAYNAME?\" \/>\n<meta property=\"og:description\" content=\"Pelajari cara menggunakan fungsi VBA WEEKDAYNAME dengan sintaksis, argumen, dan contoh dengan kode contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/\",\"name\":\"Bagaimana cara menggunakan fungsi VBA WEEKDAYNAME?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png\",\"datePublished\":\"2023-10-23T19:44:04+00:00\",\"dateModified\":\"2023-12-06T06:18:17+00:00\",\"description\":\"Pelajari cara menggunakan fungsi VBA WEEKDAYNAME dengan sintaksis, argumen, dan contoh dengan kode contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan fungsi vba weekdayname?\"}]},{\"@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 menggunakan fungsi VBA WEEKDAYNAME?","description":"Pelajari cara menggunakan fungsi VBA WEEKDAYNAME dengan sintaksis, argumen, dan contoh dengan kode 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:\/\/exceladvisor.org\/id\/nama-hari-kerja\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan fungsi VBA WEEKDAYNAME?","og_description":"Pelajari cara menggunakan fungsi VBA WEEKDAYNAME dengan sintaksis, argumen, dan contoh dengan kode contoh.","og_url":"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:17+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/","url":"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/","name":"Bagaimana cara menggunakan fungsi VBA WEEKDAYNAME?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png","datePublished":"2023-10-23T19:44:04+00:00","dateModified":"2023-12-06T06:18:17+00:00","description":"Pelajari cara menggunakan fungsi VBA WEEKDAYNAME dengan sintaksis, argumen, dan contoh dengan kode contoh.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-weekdayname.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/nama-hari-kerja\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan fungsi vba weekdayname?"}]},{"@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\/2036","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=2036"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2036\/revisions"}],"predecessor-version":[{"id":2705,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2036\/revisions\/2705"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}