{"id":1609,"date":"2023-11-15T12:06:15","date_gmt":"2023-11-15T12:06:15","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/"},"modified":"2023-12-06T06:15:08","modified_gmt":"2023-12-06T06:15:08","slug":"tambahkan-tanggal-dalam-seminggu","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/","title":{"rendered":"Bagaimana cara menambah\/mengurangi satu minggu dari suatu tanggal?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2837183746\"><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>Untuk menambah atau mengurangi tanggal dari Excel, ada metode aritmatika sederhana yang bisa Anda gunakan. Namun selain itu, ada beberapa cara lain yang bisa Anda gunakan. Dalam tutorial ini, kita akan melihat semua metode ini satu per satu.<\/p><h2 id=\"add-a-week-in-a-date\" class=\"wp-block-heading\"> Tambahkan satu minggu ke suatu tanggal<\/h2><p> Dalam contoh berikut, Anda memiliki tanggal di sel A1 dan sekarang Anda perlu menambahkan satu minggu ke tanggal tersebut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64159\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"menambahkan satu minggu ke suatu tanggal\" width=\"414\" height=\"271\"><\/figure><\/div><ol type=\"1\"><li> Pertama, masukkan \u201c=\u201d di sel B1.<\/li><li> Selanjutnya, rujuk ke sel tempat Anda memiliki tanggalnya.<\/li><li> Sekarang masukkan \u201c+\u201d untuk menambahkan.<\/li><li> Pada akhirnya, masukkan 7 untuk menambahkan satu minggu ke tanggal tersebut. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64160\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-semaine-et-date-dans-une-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"akhir pekan-dan-tanggal-dalam-kolom\" width=\"507\" height=\"286\"><\/figure><\/div><p> Seperti yang Anda lihat, setelah menambahkan tujuh hari ke data, Anda mendapatkan tanggal 8 <sup>Desember<\/sup> , tepat satu minggu setelah tanggal <sup>1<\/sup> Desember. Sekarang, jika Anda ingin menambahkan lebih dari satu minggu ke suatu tanggal, Anda dapat mengalikan angka 7 dengan angka ini. . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64161\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-ajouter-des-nombres-dans-la-date-de-la-semaine.png\" sizes=\"auto, \" srcset=\"\" alt=\"tambahkan angka pada tanggal minggu\" width=\"520\" height=\"249\"><\/figure><\/div><p> Pada contoh di atas, kalikan (7*3) untuk menjumlahkan 21 hari sehingga menghasilkan 3 minggu.<\/p><h2 id=\"subtract-week-from-a-data\" class=\"wp-block-heading\"> Kurangi satu minggu dari data<\/h2><p> Dengan menggunakan metode yang sama persis, Anda juga dapat mengurangi satu minggu atau beberapa minggu dari sebuah tanggal. Anda harus menggunakan pengurangan daripada penambahan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64162\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-soustraire-une-semaine-a-une-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"kurangi-minggu-dari-tanggal\" width=\"517\" height=\"286\"><\/figure><\/div><p> Dan jika Anda ingin mengurangkan lebih dari seminggu dari suatu tanggal, Anda dapat mengalikan 7 dengan angka tersebut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64163\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-soustraire-une-semaine-de-la-date-de-la-semaine.png\" sizes=\"auto, \" srcset=\"\" alt=\"kurangi satu minggu dari tanggal dalam seminggu\" width=\"536\" height=\"276\"><\/figure><\/div><h2 id=\"other-methods-sum-function\" class=\"wp-block-heading\"> Metode lain (fungsi SUM)<\/h2><p> Ada metode lain yang dapat Anda gunakan untuk menambah atau mengurangi minggu dari suatu tanggal. Daripada menggunakan operator penjumlahan atau pengurangan, Anda dapat menggunakan fungsi penjumlahan.<\/p><p> Dalam contoh berikut, Anda memiliki fungsi penjumlahan di mana argumen pertama adalah tanggal dan dalam argumen kedua kita memiliki 7 untuk menambahkan minggu ke tanggal tersebut. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUM(A1,7)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64164\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-fonction-de-somme-ajouter-supprimer-la-date-de-la-semaine.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-fungsi-tambah-hapus-tanggal-minggu\" width=\"531\" height=\"293\"><\/figure><\/div><p> Dan ini selama beberapa minggu. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUM(A1,7*3)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64165\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-ajouter-plusieurs-semaines-dans-la-date-de-la-semaine.png\" sizes=\"auto, \" srcset=\"\" alt=\"tambahkan-beberapa-minggu-dalam-minggu-tanggal\" width=\"549\" height=\"261\"><\/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><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/ajouter-une-semaine-a-une-date-2.xlsx\" rel=\"nofollow\">Unduh<\/a><\/p><\/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\/mendapatkan-nama-hari-itu\/\">Dapatkan nama hari dari tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hari-dalam-sebulan\/\">Dapatkan jumlah total hari dalam sebulan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/bulan-hari-kerja\/\">Hari kerja dalam sebulan<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/\">Ubah tanggal menjadi teks<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/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-1609","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>\u25b7 Bagaimana cara menambah\/mengurangi satu minggu dari suatu tanggal?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial rumus ini, Anda akan mempelajari cara menambahkan satu minggu atau lebih ke suatu tanggal. Dan Anda juga akan belajar mengurangi\" \/>\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\/tambahkan-tanggal-dalam-seminggu\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menambah\/mengurangi satu minggu dari suatu tanggal?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial rumus ini, Anda akan mempelajari cara menambahkan satu minggu atau lebih ke suatu tanggal. Dan Anda juga akan belajar mengurangi\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.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\/tambahkan-tanggal-dalam-seminggu\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/\",\"name\":\"\u25b7 Bagaimana cara menambah\/mengurangi satu minggu dari suatu tanggal?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.png\",\"datePublished\":\"2023-11-15T12:06:15+00:00\",\"dateModified\":\"2023-12-06T06:15:08+00:00\",\"description\":\"Dalam tutorial rumus ini, Anda akan mempelajari cara menambahkan satu minggu atau lebih ke suatu tanggal. Dan Anda juga akan belajar mengurangi\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambah\/mengurangi satu minggu dari suatu tanggal?\"}]},{\"@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":"\u25b7 Bagaimana cara menambah\/mengurangi satu minggu dari suatu tanggal?","description":"Dalam tutorial rumus ini, Anda akan mempelajari cara menambahkan satu minggu atau lebih ke suatu tanggal. Dan Anda juga akan belajar mengurangi","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\/tambahkan-tanggal-dalam-seminggu\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menambah\/mengurangi satu minggu dari suatu tanggal?","og_description":"Dalam tutorial rumus ini, Anda akan mempelajari cara menambahkan satu minggu atau lebih ke suatu tanggal. Dan Anda juga akan belajar mengurangi","og_url":"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:08+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.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\/tambahkan-tanggal-dalam-seminggu\/","url":"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/","name":"\u25b7 Bagaimana cara menambah\/mengurangi satu minggu dari suatu tanggal?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.png","datePublished":"2023-11-15T12:06:15+00:00","dateModified":"2023-12-06T06:15:08+00:00","description":"Dalam tutorial rumus ini, Anda akan mempelajari cara menambahkan satu minggu atau lebih ke suatu tanggal. Dan Anda juga akan belajar mengurangi","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-semaine-dans-une-date.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tambahkan-tanggal-dalam-seminggu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambah\/mengurangi satu minggu dari suatu tanggal?"}]},{"@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\/1609","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=1609"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1609\/revisions"}],"predecessor-version":[{"id":2393,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1609\/revisions\/2393"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}