{"id":2323,"date":"2023-07-22T18:50:20","date_gmt":"2023-07-22T18:50:20","guid":{"rendered":"https:\/\/statorials.org\/id\/tambahkan-hari-pengurangan-di-lembar-google\/"},"modified":"2023-07-22T18:50:20","modified_gmt":"2023-07-22T18:50:20","slug":"tambahkan-hari-pengurangan-di-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tambahkan-hari-pengurangan-di-lembar-google\/","title":{"rendered":"Cara menambah &amp; mengurangi hari di google sheets (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Kita dapat menggunakan rumus sederhana berikut untuk <strong>menambah atau mengurangi hari<\/strong> dari suatu tanggal di Google Sheets:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #008080;\">#add 10 days to the date in cell A2<\/span>\n<span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">+<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">10<\/span>\n\n<span style=\"color: #008080;\">#subtract 10 days from the date in cell A2\n<\/span><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2 <span style=\"color: #000000;\">-<\/span><\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">10<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dan kita dapat menggunakan rumus berikut untuk <strong>menambah atau mengurangi hari kerja<\/strong> (Senin sampai Jumat) dari suatu tanggal:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #008080;\">#add 10 workdays to the date in cell A2<\/span>\n<span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">workday<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2,10<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">_<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">_<\/span><span class=\" default-formula-text-color\" dir=\"auto\">\n\n<span style=\"color: #008080;\">#subtract 10 workdays from the date in cell A2\n<\/span>=workday( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> , - <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">10<\/span> )<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing rumus ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Menambah dan mengurangi hari di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki daftar tanggal berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21120 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ajouter1.png\" alt=\"\" width=\"472\" height=\"463\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menambahkan 10 hari pada setiap tanggal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21121 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ajouter2.png\" alt=\"\" width=\"484\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dan kita bisa menggunakan rumus berikut untuk mengurangi 10 hari dari setiap tanggal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21122 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ajouter3.png\" alt=\"\" width=\"494\" height=\"464\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Menambah dan mengurangi hari kerja di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Dalam beberapa skenario, kami mungkin hanya ingin menambah atau mengurangi hari kerja dari tanggal di Google Spreadsheet. Untungnya, kita dapat menggunakan fungsi <strong>workday()<\/strong> untuk melakukan hal ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus berikut menunjukkan cara menambahkan 10 hari kerja ke setiap tanggal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21123 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ajouter4.png\" alt=\"\" width=\"504\" height=\"455\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dan rumus berikut menunjukkan cara mengurangi 10 hari kerja dari setiap tanggal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21124 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ajouter5.png\" alt=\"\" width=\"535\" height=\"469\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong><\/span> <a href=\"https:\/\/statorials.org\/id\/perbedaan-google-sheet-antar-tanggal\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung perbedaan antara dua tanggal di Google Sheets<\/a><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/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-menggabungkan-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara Menggabungkan Kolom di Google Sheets<\/a><br \/> <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\/daftar-acak-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Mengacak Daftar di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kita dapat menggunakan rumus sederhana berikut untuk menambah atau mengurangi hari dari suatu tanggal di Google Sheets: #add 10 days to the date in cell A2 = A2 + 10 #subtract 10 days from the date in cell A2 = A2 &#8211; 10 Dan kita dapat menggunakan rumus berikut untuk menambah atau mengurangi hari kerja [&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 Menambah dan Mengurangi Hari di Google Sheets (dengan Contoh) \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambah dan mengurangi hari 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\/tambahkan-hari-pengurangan-di-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menambah dan Mengurangi Hari di Google Sheets (dengan Contoh) \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambah dan mengurangi hari di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tambahkan-hari-pengurangan-di-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T18:50:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ajouter1.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\/tambahkan-hari-pengurangan-di-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/tambahkan-hari-pengurangan-di-lembar-google\/\",\"name\":\"Cara Menambah dan Mengurangi Hari di Google Sheets (dengan Contoh) \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T18:50:20+00:00\",\"dateModified\":\"2023-07-22T18:50:20+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambah dan mengurangi hari di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tambahkan-hari-pengurangan-di-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tambahkan-hari-pengurangan-di-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tambahkan-hari-pengurangan-di-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menambah &amp; mengurangi hari di google sheets (dengan contoh)\"}]},{\"@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 Menambah dan Mengurangi Hari di Google Sheets (dengan Contoh) \u2013 Statorial","description":"Tutorial ini menjelaskan cara menambah dan mengurangi hari 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\/tambahkan-hari-pengurangan-di-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menambah dan Mengurangi Hari di Google Sheets (dengan Contoh) \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menambah dan mengurangi hari di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/tambahkan-hari-pengurangan-di-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-22T18:50:20+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ajouter1.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\/tambahkan-hari-pengurangan-di-lembar-google\/","url":"https:\/\/statorials.org\/id\/tambahkan-hari-pengurangan-di-lembar-google\/","name":"Cara Menambah dan Mengurangi Hari di Google Sheets (dengan Contoh) \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T18:50:20+00:00","dateModified":"2023-07-22T18:50:20+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambah dan mengurangi hari di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tambahkan-hari-pengurangan-di-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tambahkan-hari-pengurangan-di-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tambahkan-hari-pengurangan-di-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menambah &amp; mengurangi hari di google sheets (dengan contoh)"}]},{"@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\/2323"}],"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=2323"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2323\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}