{"id":2312,"date":"2023-07-22T19:58:19","date_gmt":"2023-07-22T19:58:19","guid":{"rendered":"https:\/\/statorials.org\/id\/perbedaan-google-sheet-antar-tanggal\/"},"modified":"2023-07-22T19:58:19","modified_gmt":"2023-07-22T19:58:19","slug":"perbedaan-google-sheet-antar-tanggal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/perbedaan-google-sheet-antar-tanggal\/","title":{"rendered":"Hitung perbedaan antara dua tanggal di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Kita dapat menggunakan fungsi <strong>DATEDIF()<\/strong> untuk menghitung selisih antara dua tanggal di Google Spreadsheet.<\/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, satuan)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>start_date:<\/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>unit:<\/strong> Satuan waktu penggunaan (\u201cY\u201d, \u201cM\u201d, \u201cD\u201d untuk tahun, bulan, tanggal)<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini untuk menghitung perbedaan antara dua tanggal di Google Spreadsheet.<\/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=\" wp-image-21021 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date1-1.png\" alt=\"\" width=\"498\" height=\"430\" 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=\" wp-image-21022 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date2-2.png\" alt=\"\" width=\"502\" height=\"426\" 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=\" wp-image-21023 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date3-1.png\" alt=\"\" width=\"501\" height=\"393\" 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=\" wp-image-21024 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date4.png\" alt=\"\" width=\"670\" height=\"336\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selisih antara tanggal mulai dan tanggal berakhir adalah 3 tahun 1 bulan.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-membandingkan-dua-kolom\/\" target=\"_blank\" rel=\"noopener\">Bagaimana membandingkan dua kolom di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlahkan-di-beberapa-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara menambahkan beberapa lembar<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sumif-lembar-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: Cara menggunakan SUMIF dengan banyak kolom<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kita dapat menggunakan fungsi DATEDIF() untuk menghitung selisih antara dua tanggal di Google Spreadsheet. Fungsi ini menggunakan sintaks berikut: =DATEDIF(tanggal_mulai,tanggal_akhir, satuan) Emas: start_date: tanggal mulai end_date: tanggal akhir unit: Satuan waktu penggunaan (\u201cY\u201d, \u201cM\u201d, \u201cD\u201d untuk tahun, bulan, tanggal) Contoh berikut menunjukkan cara menggunakan fungsi ini untuk menghitung perbedaan antara dua tanggal di Google Spreadsheet. [&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>Hitung perbedaan antara dua tanggal di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung selisih dua tanggal di Google Sheets, 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-google-sheet-antar-tanggal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hitung perbedaan antara dua tanggal di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung selisih dua tanggal di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/perbedaan-google-sheet-antar-tanggal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T19:58:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date1-1.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-google-sheet-antar-tanggal\/\",\"url\":\"https:\/\/statorials.org\/id\/perbedaan-google-sheet-antar-tanggal\/\",\"name\":\"Hitung perbedaan antara dua tanggal di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T19:58:19+00:00\",\"dateModified\":\"2023-07-22T19:58:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung selisih dua tanggal di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/perbedaan-google-sheet-antar-tanggal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/perbedaan-google-sheet-antar-tanggal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/perbedaan-google-sheet-antar-tanggal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hitung perbedaan antara dua tanggal di google spreadsheet\"}]},{\"@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":"Hitung perbedaan antara dua tanggal di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung selisih dua tanggal di Google Sheets, 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-google-sheet-antar-tanggal\/","og_locale":"id_ID","og_type":"article","og_title":"Hitung perbedaan antara dua tanggal di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung selisih dua tanggal di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/perbedaan-google-sheet-antar-tanggal\/","og_site_name":"Statorials","article_published_time":"2023-07-22T19:58:19+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date1-1.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-google-sheet-antar-tanggal\/","url":"https:\/\/statorials.org\/id\/perbedaan-google-sheet-antar-tanggal\/","name":"Hitung perbedaan antara dua tanggal di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T19:58:19+00:00","dateModified":"2023-07-22T19:58:19+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung selisih dua tanggal di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/perbedaan-google-sheet-antar-tanggal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/perbedaan-google-sheet-antar-tanggal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/perbedaan-google-sheet-antar-tanggal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Hitung perbedaan antara dua tanggal di google spreadsheet"}]},{"@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\/2312"}],"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=2312"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2312\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}