{"id":2037,"date":"2023-10-23T19:33:13","date_gmt":"2023-10-23T19:33:13","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tahun\/"},"modified":"2023-12-06T06:18:18","modified_gmt":"2023-12-06T06:18:18","slug":"tahun","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tahun\/","title":{"rendered":"Bagaimana cara menggunakan fungsi vba year?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-440919617\"><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 YEAR tercantum dalam kategori tanggal dan waktu fungsi VBA. Saat Anda menggunakannya dalam kode VBA, <span style=\"color: #f16334;\">ia mengembalikan tahun dari tanggal<\/span> yang Anda berikan. Seperti yang Anda ketahui, tanggal VBA yang valid terdiri dari hari, bulan, dan tahun, sehingga membutuhkan waktu satu tahun dan mengabaikan bagian lainnya. Ini seperti fungsi YEAR di spreadsheet.<\/p><h2 class=\"wp-block-heading\"> Sintaksis<\/h2><p> <strong>Tahun (tanggal)<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumen<\/h2><ul><li> <strong>Tanggal:<\/strong> Tanggal VBA valid yang ingin Anda dapatkan nilai tahunnya.<\/li><\/ul><h2 class=\"wp-block-heading\"> Contoh<\/h2><p> Untuk memahami secara praktis cara menggunakan fungsi VBA YEAR, Anda perlu melihat contoh di bawah ini di mana kami telah menulis kode vba menggunakan fungsi tersebut: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"contoh-vba-tahun-fungsi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-annee-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-year-function\" width=\"836\" height=\"460\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_YEAR() Range(\"B1\").Value = Year(Range(\"A1\")) End Sub<\/code><\/pre><p> Pada contoh di atas, kita menggunakan YEAR untuk mendapatkan tahun dari tanggal yang kita miliki di sel A1 dan hasilnya menghasilkan 2019 karena tanggalnya adalah 1 Januari 2019.<\/p><h2 class=\"wp-block-heading\"> Komentar<\/h2><ul><li> Jika tanggal yang ditentukan adalah nilai selain tanggal atau tanggal yang tidak dapat dikenali sebagai tanggal, VBA akan mengembalikan kesalahan runtime 13.<\/li><li> Dan jika tanggal yang diberikan adalah NULL, maka akan menghasilkan NULL. <\/li><\/ul><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-12\"><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-2037","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 YEAR? (sintaks + contoh)<\/title>\n<meta name=\"description\" content=\"Pelajari cara menggunakan fungsi VBA YEAR dengan sintaks, 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\/tahun\/\" \/>\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 YEAR? (sintaks + contoh)\" \/>\n<meta property=\"og:description\" content=\"Pelajari cara menggunakan fungsi VBA YEAR dengan sintaks, argumen, dan contoh dengan kode contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tahun\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-annee-vba.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\/tahun\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tahun\/\",\"name\":\"Bagaimana cara menggunakan fungsi VBA YEAR? (sintaks + contoh)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tahun\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tahun\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-annee-vba.png\",\"datePublished\":\"2023-10-23T19:33:13+00:00\",\"dateModified\":\"2023-12-06T06:18:18+00:00\",\"description\":\"Pelajari cara menggunakan fungsi VBA YEAR dengan sintaks, argumen, dan contoh dengan kode contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tahun\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tahun\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tahun\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-annee-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-annee-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tahun\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan fungsi vba year?\"}]},{\"@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 YEAR? (sintaks + contoh)","description":"Pelajari cara menggunakan fungsi VBA YEAR dengan sintaks, 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\/tahun\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan fungsi VBA YEAR? (sintaks + contoh)","og_description":"Pelajari cara menggunakan fungsi VBA YEAR dengan sintaks, argumen, dan contoh dengan kode contoh.","og_url":"https:\/\/exceladvisor.org\/id\/tahun\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:18+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-annee-vba.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\/tahun\/","url":"https:\/\/exceladvisor.org\/id\/tahun\/","name":"Bagaimana cara menggunakan fungsi VBA YEAR? (sintaks + contoh)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tahun\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tahun\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-annee-vba.png","datePublished":"2023-10-23T19:33:13+00:00","dateModified":"2023-12-06T06:18:18+00:00","description":"Pelajari cara menggunakan fungsi VBA YEAR dengan sintaks, argumen, dan contoh dengan kode contoh.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tahun\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tahun\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tahun\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-annee-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-annee-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tahun\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan fungsi vba year?"}]},{"@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\/2037","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=2037"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2037\/revisions"}],"predecessor-version":[{"id":2707,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2037\/revisions\/2707"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}