{"id":1580,"date":"2023-11-16T09:57:07","date_gmt":"2023-11-16T09:57:07","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/"},"modified":"2023-12-06T06:13:50","modified_gmt":"2023-12-06T06:13:50","slug":"rentang-tanggal","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/","title":{"rendered":"Bagaimana cara membuat rentang tanggal di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1293145516\"><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>Saat mengerjakan data yang berisi tanggal, Anda mungkin perlu membuat rentang tanggal. Rentang adalah sesuatu yang memiliki tanggal mulai dan tanggal berakhir. Dalam tutorial ini, Anda akan mempelajari cara membuat rentang tanggal.<\/p><h2 class=\"wp-block-heading\"> Buat rentang tanggal dari hari ini<\/h2><p> Sekarang katakanlah Anda ingin membuat rentang tanggal tujuh hari dari hari ini. Pada contoh berikut, kita mempunyai tanggal hari ini di sel A1 yang kita peroleh dengan menggunakan fungsi hari ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64220\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png\" sizes=\"auto, \" srcset=\"\" alt=\"rentang tanggal-dari-hari ini\" width=\"387\" height=\"284\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1+7<\/code><\/pre><p> Untuk membuat rentang tanggal, ikuti langkah-langkah sederhana berikut:<\/p><ol type=\"1\"><li> Masukkan \u201c=\u201d di sel B1, atau sel lainnya.<\/li><li> Lihat sel A1, tempat Anda mengetahui tanggal mulai rentang tersebut.<\/li><li> Gunakan tanda &#8220;+&#8221; untuk menambahkan hari ke tanggal hari ini.<\/li><li> Tentukan jumlah hari yang ingin Anda tambahkan ke tanggal hari ini. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64221\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-creer-une-plage-de-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"buat rentang tanggal\" width=\"395\" height=\"239\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Buat rentang tanggal dalam satu sel<\/h2><p> Mari melangkah lebih jauh dan membuat rentang tanggal dalam satu sel. Dan untuk ini kita perlu menggabungkan tanggal mulai dan tanggal akhir dalam satu sel. Namun masalahnya adalah ketika Anda mencoba menggabungkan dua tanggal dalam satu sel, hasilnya akan seperti di bawah ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64222\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-creer-une-plage-de-dates-dans-une-seule-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"buat-rentang-tanggal-dalam-sel-tunggal\" width=\"452\" height=\"242\"><\/figure><\/div><p> Sekarang untuk mengatasi masalah ini kita perlu menggunakan fungsi TEXT untuk mengubah tanggal menjadi teks dan kemudian menggabungkannya ke dalam rentang tanggal. Rumusnya akan seperti di bawah ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64224\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-fonction-de-texte-pour-la-plage-de-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi teks untuk rentang tanggal\" width=\"626\" height=\"268\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(A1,\"dd\/mmm\/yy\")&amp;\" --- \"&amp;TEXT(B1,\"dd\/mmm\/yy\")<\/code><\/pre><p> Sekarang, seperti yang Anda lihat, kami memiliki rentang tanggal di sel C1 dari 8 Februari 22 hingga 15 Februari 22. Dan jika Anda ingin membuat rentang tanggal dalam satu sel, Anda dapat menggunakan rumus berikut.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(TODAY(),\"dd\/mmm\/yy\")&amp;\" --- \"&amp;TEXT(A1+7,\"dd\/mmm\/yy\")<\/code><\/pre><p> Pada bagian tentang penggunaan fungsi TEXT, Anda dapat mengubah format tanggal sesuai keinginan. <\/p><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> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-une-plage-de-dates.xlsx\" rel=\"nofollow\">Unduh<\/a><\/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\/membandingkan-dua-tanggal\/\">Bandingkan dua tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/\">Ubah tanggal menjadi angka di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/teks-sampai-saat-ini\/\">Ubah teks menjadi tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/\">Format tanggal khusus di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menyorot-antara-dua-tanggal\/\">Sorot tanggal antara dua tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-dua-tanggal\/\">Gabungkan dua tanggal dengan cepat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/generator-tanggal-acak\/\">Generator Tanggal Acak (Rumus Excel) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-tanggal-dan-waktu\/\">Gabungkan tanggal dan waktu di Excel<\/a><\/li><\/ul><\/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-1580","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>Bagaimana cara membuat rentang tanggal di Excel? - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Dalam tutorial rumus ini, Anda akan mempelajari cara membuat rentang tanggal menggunakan fungsi teks dan\" \/>\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\/rentang-tanggal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara membuat rentang tanggal di Excel? - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial rumus ini, Anda akan mempelajari cara membuat rentang tanggal menggunakan fungsi teks dan\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/\",\"name\":\"Bagaimana cara membuat rentang tanggal di Excel? - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png\",\"datePublished\":\"2023-11-16T09:57:07+00:00\",\"dateModified\":\"2023-12-06T06:13:50+00:00\",\"description\":\"Dalam tutorial rumus ini, Anda akan mempelajari cara membuat rentang tanggal menggunakan fungsi teks dan\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membuat rentang tanggal 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":"Bagaimana cara membuat rentang tanggal di Excel? - Penasihat Excel","description":"Dalam tutorial rumus ini, Anda akan mempelajari cara membuat rentang tanggal menggunakan fungsi teks dan","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\/rentang-tanggal\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara membuat rentang tanggal di Excel? - Penasihat Excel","og_description":"Dalam tutorial rumus ini, Anda akan mempelajari cara membuat rentang tanggal menggunakan fungsi teks dan","og_url":"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:50+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/","url":"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/","name":"Bagaimana cara membuat rentang tanggal di Excel? - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png","datePublished":"2023-11-16T09:57:07+00:00","dateModified":"2023-12-06T06:13:50+00:00","description":"Dalam tutorial rumus ini, Anda akan mempelajari cara membuat rentang tanggal menggunakan fungsi teks dan","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/rentang-tanggal\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-dates-a-partir-daujourdhui.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membuat rentang tanggal 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\/1580","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=1580"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1580\/revisions"}],"predecessor-version":[{"id":2314,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1580\/revisions\/2314"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}