{"id":1583,"date":"2023-11-16T09:18:33","date_gmt":"2023-11-16T09:18:33","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/"},"modified":"2023-12-06T06:16:04","modified_gmt":"2023-12-06T06:16:04","slug":"mendapat-masa-kerja-2-tahun","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/","title":{"rendered":"Bagaimana cara mengetahui masa kerja?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3356778647\"><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>Tutorial ini akan memandu Anda melalui proses pembuatan rumus di Excel untuk menghitung masa kerja. Alat yang akan Anda gunakan untuk tugas ini adalah fungsi DATEDIF. Jika Anda belum familiar dengan fungsi ini, Anda akan lebih memahaminya jika terus membaca.<\/p><h2 class=\"wp-block-heading\"> Dapatkan jumlah tahun pelayanan<\/h2><p> Dalam contoh berikut, kita memiliki tanggal mulai dan tanggal akhir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64911\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.png\" sizes=\"auto, \" srcset=\"\" alt=\"tahun pelayanan\" width=\"478\" height=\"304\"><\/figure><\/div><p> Dan sekarang mari gunakan langkah-langkah berikut:<\/p><ol type=\"1\"><li> Ketik \u201c= <a href=\"https:\/\/exceladvisor.org\/id\/tanggal-jika\/\">DATEDIF<\/a> (\u201d pada sel C2.<\/li><li> Lihat tanggal mulai, yaitu A2, dan masukkan perintah.<\/li><li> Lihat tanggal akhir, yaitu B2, dan masukkan perintah.<\/li><li> Masukkan &#8220;y&#8221;, masukkan tanda kurung tutup 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-64912\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-obtenir-lannee-de-service.png\" sizes=\"auto, \" srcset=\"\" alt=\"dapatkan tahun layanan\" width=\"490\" height=\"465\"><\/figure><\/div><p> Izinkan saya menjelaskan: Saat Anda menggunakan &#8220;y&#8221; dalam fungsi DATEDIF, fungsi ini mengembalikan satu tahun penuh yang Anda miliki antara tanggal mulai dan tanggal akhir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATEDIF(A2,B2,\"y\")<\/code><\/pre><p> Sekarang katakanlah Anda ingin mendapatkan masa layanan penuh antara dua tanggal, termasuk tahun, bulan, dan tanggal. Anda dapat menggunakan rumus berikut. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATEDIF(A2,B2,\"y\")&amp;\" year(s), \"&amp;DATEDIF(A2,B2,\"ym\")&amp;\" months(s), \"&amp;DATEDIF(A2,B2,\"md\")&amp;\" days(s).\"<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64913\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-ans-mois-date-de-service.png\" sizes=\"auto, \" srcset=\"\" alt=\"dapatkan-tahun-bulan-tanggal-layanan\" width=\"765\" height=\"182\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Dapatkan layanan bertahun-tahun sejak tanggal hari ini<\/h2><p> Sekarang katakanlah Anda ingin menghitung masa kerja menggunakan tanggal hari ini. Inilah rumus yang harus Anda gunakan. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATEDIF(A2,TODAY(),\"y\")&amp;\" year(s)\"<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64914\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-obtenez-une-annee-de-service-a-partir-daujourdhui.png\" sizes=\"auto, \" srcset=\"\" alt=\"dapatkan-tahun-layanan-mulai-hari ini\" width=\"576\" height=\"430\"><\/figure><\/div><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> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-des-annees-de-service.xlsx\" rel=\"nofollow\">Unduh<\/a><\/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-tahun-hingga-saat-ini\/\">Tambahkan tahun hingga saat ini di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-tahun-antara-dua-tanggal\/\">Hitung tahun antara dua tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mendapatkan-nomor-hari-dalam-setahun\/\">Dapatkan jumlah hari dalam setahun di Excel<\/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\/tahun-antar-tanggal\/\">Tahun antar tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/ekstrak-tahun-bulan\/\">Ekstrak (Dapatkan) tahun atau bulan dari tanggal di Excel<\/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-1583","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 mengetahui masa kerja? - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan memandu Anda melalui proses pembuatan rumus di Excel untuk menghitung masa kerja.\" \/>\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\/mendapat-masa-kerja-2-tahun\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara mengetahui masa kerja? - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan memandu Anda melalui proses pembuatan rumus di Excel untuk menghitung masa kerja.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.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\/mendapat-masa-kerja-2-tahun\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/\",\"name\":\"Bagaimana cara mengetahui masa kerja? - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.png\",\"datePublished\":\"2023-11-16T09:18:33+00:00\",\"dateModified\":\"2023-12-06T06:16:04+00:00\",\"description\":\"Tutorial ini akan memandu Anda melalui proses pembuatan rumus di Excel untuk menghitung masa kerja.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengetahui masa kerja?\"}]},{\"@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 mengetahui masa kerja? - Penasihat Excel","description":"Tutorial ini akan memandu Anda melalui proses pembuatan rumus di Excel untuk menghitung masa kerja.","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\/mendapat-masa-kerja-2-tahun\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mengetahui masa kerja? - Penasihat Excel","og_description":"Tutorial ini akan memandu Anda melalui proses pembuatan rumus di Excel untuk menghitung masa kerja.","og_url":"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:04+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.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\/mendapat-masa-kerja-2-tahun\/","url":"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/","name":"Bagaimana cara mengetahui masa kerja? - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.png","datePublished":"2023-11-16T09:18:33+00:00","dateModified":"2023-12-06T06:16:04+00:00","description":"Tutorial ini akan memandu Anda melalui proses pembuatan rumus di Excel untuk menghitung masa kerja.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-an-de-service.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/mendapat-masa-kerja-2-tahun\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengetahui masa kerja?"}]},{"@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\/1583","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=1583"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1583\/revisions"}],"predecessor-version":[{"id":2489,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1583\/revisions\/2489"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}