{"id":1693,"date":"2023-11-11T11:20:49","date_gmt":"2023-11-11T11:20:49","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/"},"modified":"2023-12-06T06:20:16","modified_gmt":"2023-12-06T06:20:16","slug":"hari-hitung-mundur","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/","title":{"rendered":"Hitung mundur hari di excel"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3063826993\"><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 menulis rumus hitung mundur di Excel, Anda perlu menentukan tanggal yang ingin Anda buat hitungan mundurnya. Bersamaan dengan ini, Anda perlu menggunakan fitur HARI INI. Saat Anda mengurangi tanggal yang akan datang dari tanggal hari ini, ini akan mengembalikan sisa hari. Karena Anda menggunakan HARI INI yang mudah berubah dan memperbarui tanggal setiap hari. Ini menciptakan hitungan mundur untuk hari-hari yang tersisa. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80160\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png\" sizes=\"auto, \" srcset=\"\" alt=\"hitung mundur\" width=\"596\" height=\"217\"><\/figure><\/div><p> Dalam tutorial ini, kita akan mempelajari cara menulis rumus ini.<\/p><h2 class=\"wp-block-heading\"> Rumus Excel untuk mendapatkan hitungan mundur hari yang tersisa<\/h2><p> Anda dapat menggunakan langkah-langkah di bawah ini:<\/p><ol type=\"1\"><li> Pertama, masukkan (=) sama dengan di sel untuk memulai rumus.<\/li><li> Setelah itu, lihat sel di mana Anda memiliki tanggalnya.<\/li><li> Selanjutnya masukkan tanda (-) untuk pengurangan.<\/li><li> Sekarang masukkan fungsi TODAY tanpa argumen apa pun.<\/li><li> Pada akhirnya, 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-80161\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-obtenir-le-compte-a-rebours-des-jours-restants.png\" sizes=\"auto, \" srcset=\"\" alt=\"dapatkan hitungan mundur hari yang tersisa\" width=\"535\" height=\"234\"><\/figure><\/div><p> Setelah Anda menekan Enter, ini akan mengembalikan jumlah hari yang tersisa dari tanggal mendatang yang Anda tentukan. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1-TODAY()<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80162\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-a-renvoye-le-nombre-de-jours.png\" sizes=\"auto, \" srcset=\"\" alt=\"mengembalikan hitungan hari\" width=\"580\" height=\"258\"><\/figure><\/div><p> Dalam contoh ini, tanggalnya adalah 10 Februari 2023 dan tanggal yang dikembalikan oleh TODAY adalah 18 Januari 2023. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80163\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-date-de-retour.png\" sizes=\"auto, \" srcset=\"\" alt=\"tanggal pengembalian\" width=\"469\" height=\"224\"><\/figure><\/div><p> Dan bila Anda menguranginya dari tanggal yang akan datang, Anda mendapatkan sisa hari.<\/p><p> Seperti yang saya sebutkan sebelumnya, TODAY adalah fungsi yang mudah menguap, dan ketika tanggal berubah di sistem Anda, tanggal yang dikembalikan juga berubah, menjadikannya hitungan mundur.<\/p><p> Agar hasil rumusnya lebih bermakna, Anda bisa menggabungkannya dengan nilai tes. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80164\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-combiner-la-formule-avec-la-valeur-du-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"menggabungkan-rumus-dengan-nilai-teks\" width=\"612\" height=\"232\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1-TODAY()&amp;\" day(s) remaning.\"<\/code><\/pre><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\/08\/compte-a-rebours.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\/tambahkan-tanggal-dalam-seminggu\/\">Tambahkan-kurangi minggu dari tanggal di Excel<\/a><\/li><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-1693","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>Hitung mundur hari di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membuat hitungan mundur dinamis sisa hari dari suatu tanggal.\" \/>\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\/hari-hitung-mundur\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hitung mundur hari di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membuat hitungan mundur dinamis sisa hari dari suatu tanggal.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.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\/hari-hitung-mundur\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/\",\"name\":\"Hitung mundur hari di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png\",\"datePublished\":\"2023-11-11T11:20:49+00:00\",\"dateModified\":\"2023-12-06T06:20:16+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membuat hitungan mundur dinamis sisa hari dari suatu tanggal.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hitung mundur hari di excel\"}]},{\"@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":"Hitung mundur hari di Excel","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membuat hitungan mundur dinamis sisa hari dari suatu tanggal.","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\/hari-hitung-mundur\/","og_locale":"id_ID","og_type":"article","og_title":"Hitung mundur hari di Excel","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membuat hitungan mundur dinamis sisa hari dari suatu tanggal.","og_url":"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:16+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.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\/hari-hitung-mundur\/","url":"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/","name":"Hitung mundur hari di Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png","datePublished":"2023-11-11T11:20:49+00:00","dateModified":"2023-12-06T06:20:16+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk membuat hitungan mundur dinamis sisa hari dari suatu tanggal.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-jours-de-compte-a-rebours.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Hitung mundur hari di excel"}]},{"@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\/1693","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=1693"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1693\/revisions"}],"predecessor-version":[{"id":2908,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1693\/revisions\/2908"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}