{"id":1410,"date":"2023-07-26T12:19:19","date_gmt":"2023-07-26T12:19:19","guid":{"rendered":"https:\/\/statorials.org\/id\/perbedaan-antara-tanggal-excel\/"},"modified":"2023-07-26T12:19:19","modified_gmt":"2023-07-26T12:19:19","slug":"perbedaan-antara-tanggal-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/perbedaan-antara-tanggal-excel\/","title":{"rendered":"Cara menghitung selisih dua tanggal di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Kita bisa menggunakan fungsi <strong>DATEDIF()<\/strong> untuk menghitung selisih antara dua tanggal di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>=DATEDIF(Tanggal_Mulai, Tanggal_Akhir, Metrik)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Tanggal_Mulai:<\/strong> tanggal mulai<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>End_Date:<\/strong> tanggal akhir<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Metrik:<\/strong> metrik yang akan dihitung. Pilihannya meliputi:<\/span>\n<ul>\n<li> <span style=\"color: #000000;\">\u201cd\u201d: hari<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u201cm\u201d: bulan<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u201cy\u201d: tahun<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Penting untuk dicatat bahwa fungsi ini tidak akan muncul secara otomatis di Excel sampai Anda mengetik <strong>=DATEDIF(<\/strong> sepenuhnya di salah satu sel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan fungsi ini untuk menghitung perbedaan antara dua tanggal di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: perbedaan hari<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Gambar berikut menunjukkan cara menghitung selisih (dalam hari) antara dua tanggal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13986 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dateif1.png\" alt=\"Perbedaan tanggal dalam hari di Excel\" width=\"452\" height=\"354\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Artinya ada <strong>1.127<\/strong> hari penuh antara 1\/1\/2018 dan 1\/2\/2021.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: perbedaan bulan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Gambar berikut menunjukkan cara menghitung selisih (dalam bulan) antara dua tanggal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13987 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dateif2.png\" alt=\"Perbedaan tanggal dalam bulan di Excel\" width=\"450\" height=\"354\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Perbedaan tahun<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Gambar berikut menunjukkan cara menghitung selisih (dalam tahun) antara dua tanggal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13988 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dateif3.png\" alt=\"Perbedaan tahun antara dua tanggal di Excel\" width=\"451\" height=\"354\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 4: Perbedaan tahun dan bulan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Gambar berikut menunjukkan cara menghitung selisih (dalam tahun dan bulan) antara dua tanggal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13989 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dateif4.png\" alt=\"Perbedaan tahun dan bulan antara dua tanggal di Excel\" width=\"522\" height=\"380\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menemukan tutorial Excel lainnya di halaman ini .<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kita bisa menggunakan fungsi DATEDIF() untuk menghitung selisih antara dua tanggal di Excel. Fungsi ini menggunakan sintaks berikut: =DATEDIF(Tanggal_Mulai, Tanggal_Akhir, Metrik) Emas: Tanggal_Mulai: tanggal mulai End_Date: tanggal akhir Metrik: metrik yang akan dihitung. Pilihannya meliputi: \u201cd\u201d: hari \u201cm\u201d: bulan \u201cy\u201d: tahun Penting untuk dicatat bahwa fungsi ini tidak akan muncul secara otomatis di Excel sampai [&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 menghitung selisih dua tanggal di excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung selisih dua tanggal 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\/perbedaan-antara-tanggal-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung selisih dua tanggal di excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung selisih dua tanggal di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/perbedaan-antara-tanggal-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T12:19:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dateif1.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\/perbedaan-antara-tanggal-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/perbedaan-antara-tanggal-excel\/\",\"name\":\"Cara menghitung selisih dua tanggal di excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T12:19:19+00:00\",\"dateModified\":\"2023-07-26T12:19:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung selisih dua tanggal di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/perbedaan-antara-tanggal-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/perbedaan-antara-tanggal-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/perbedaan-antara-tanggal-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung selisih dua tanggal 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 menghitung selisih dua tanggal di excel","description":"Tutorial ini menjelaskan cara menghitung selisih dua tanggal 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\/perbedaan-antara-tanggal-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung selisih dua tanggal di excel","og_description":"Tutorial ini menjelaskan cara menghitung selisih dua tanggal di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/perbedaan-antara-tanggal-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-26T12:19:19+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dateif1.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\/perbedaan-antara-tanggal-excel\/","url":"https:\/\/statorials.org\/id\/perbedaan-antara-tanggal-excel\/","name":"Cara menghitung selisih dua tanggal di excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T12:19:19+00:00","dateModified":"2023-07-26T12:19:19+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung selisih dua tanggal di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/perbedaan-antara-tanggal-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/perbedaan-antara-tanggal-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/perbedaan-antara-tanggal-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung selisih dua tanggal 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\/1410"}],"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=1410"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1410\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1410"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1410"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}