{"id":2694,"date":"2023-07-21T03:34:27","date_gmt":"2023-07-21T03:34:27","guid":{"rendered":"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-excel\/"},"modified":"2023-07-21T03:34:27","modified_gmt":"2023-07-21T03:34:27","slug":"tanggal-pengisian-otomatis-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-excel\/","title":{"rendered":"Cara mengisi otomatis tanggal di excel (3 contoh)"},"content":{"rendered":"

<\/p>\n

\n

Seringkali Anda mungkin ingin mengisi tanggal secara otomatis di Excel. Untungnya, ini mudah dilakukan berkat fungsi drag-and-fill sederhana yang ada di Excel.<\/span><\/p>\n

Contoh berikut menunjukkan cara mengisi tanggal secara otomatis di Excel dalam praktiknya.<\/span><\/p>\n

Contoh 1: IsiOtomatis hari di Excel<\/strong><\/span><\/h3>\n

Untuk secara otomatis mengisi daftar hari di Excel, cukup masukkan tanggal untuk memulai:<\/span> <\/p>\n

\"\"<\/p>\n

Kemudian arahkan kursor ke pojok kanan bawah sel hingga muncul tanda \u201c +<\/strong> \u201d kecil.<\/span><\/p>\n

Kemudian klik dan seret ke jumlah sel yang Anda inginkan di kolom yang sama:<\/span> <\/p>\n

\"\"<\/p>\n

Hasilnya adalah daftar hari berturut-turut.<\/span><\/p>\n

Contoh 2: IsiOtomatis minggu di Excel<\/strong><\/span><\/h3>\n

Untuk secara otomatis mengisi daftar minggu di Excel, cukup masukkan dua tanggal dengan jarak tepat satu minggu:<\/span> <\/p>\n

\"\"<\/p>\n

Sorot sel A2<\/strong> dan A3<\/strong> . Lalu arahkan kursor ke pojok kanan bawah sel A3<\/strong> hingga muncul tanda \u201c +<\/strong> \u201d kecil.<\/span><\/p>\n

Kemudian klik dan seret ke jumlah sel yang Anda inginkan di kolom yang sama:<\/span> <\/p>\n

\"\"<\/p>\n

Hasilnya adalah daftar minggu berturut-turut.<\/span><\/p>\n

Contoh 3: IsiOtomatis bulan di Excel<\/strong><\/span><\/h3>\n

Untuk secara otomatis mengisi daftar bulan di Excel, cukup masukkan dua tanggal yang berjarak tepat satu bulan:<\/span> <\/p>\n

\"\"<\/p>\n

Sorot sel A2<\/strong> dan A3<\/strong> . Lalu arahkan kursor ke pojok kanan bawah sel A3<\/strong> hingga muncul tanda \u201c +<\/strong> \u201d kecil.<\/span><\/p>\n

Kemudian klik dan seret ke jumlah sel yang Anda inginkan di kolom yang sama:<\/span> <\/p>\n

\"\"<\/p>\n

Hasilnya adalah daftar bulan berturut-turut.<\/span><\/p>\n

Sumber daya tambahan<\/strong><\/span><\/h3>\n

Tutorial berikut menjelaskan cara melakukan operasi umum lainnya dengan tanggal di Excel:<\/span><\/p>\n

Cara menggunakan COUNTIFS dengan rentang tanggal di Excel<\/a>
Cara menghitung rata-rata antara dua tanggal di Excel<\/a>
Cara menghitung selisih dua tanggal di excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Seringkali Anda mungkin ingin mengisi tanggal secara otomatis di Excel. Untungnya, ini mudah dilakukan berkat fungsi drag-and-fill sederhana yang ada di Excel. Contoh berikut menunjukkan cara mengisi tanggal secara otomatis di Excel dalam praktiknya. Contoh 1: IsiOtomatis hari di Excel Untuk secara otomatis mengisi daftar hari di Excel, cukup masukkan tanggal untuk memulai: Kemudian arahkan […]<\/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":"\nCara Mengisi Otomatis Tanggal di Excel (3 Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengisi otomatis tanggal di Excel, 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\/tanggal-pengisian-otomatis-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengisi Otomatis Tanggal di Excel (3 Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengisi otomatis tanggal di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T03:34:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplissage-automatique1.jpg\" \/>\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\/tanggal-pengisian-otomatis-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-excel\/\",\"name\":\"Cara Mengisi Otomatis Tanggal di Excel (3 Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T03:34:27+00:00\",\"dateModified\":\"2023-07-21T03:34:27+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengisi otomatis tanggal di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengisi otomatis tanggal di excel (3 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 Mengisi Otomatis Tanggal di Excel (3 Contoh) - Statorials","description":"Tutorial ini menjelaskan cara mengisi otomatis tanggal di Excel, 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\/tanggal-pengisian-otomatis-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengisi Otomatis Tanggal di Excel (3 Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara mengisi otomatis tanggal di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-21T03:34:27+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplissage-automatique1.jpg"}],"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\/tanggal-pengisian-otomatis-excel\/","url":"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-excel\/","name":"Cara Mengisi Otomatis Tanggal di Excel (3 Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T03:34:27+00:00","dateModified":"2023-07-21T03:34:27+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengisi otomatis tanggal di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengisi otomatis tanggal di excel (3 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\/2694"}],"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=2694"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2694\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}