{"id":1709,"date":"2023-11-10T10:05:13","date_gmt":"2023-11-10T10:05:13","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/"},"modified":"2023-12-06T06:18:25","modified_gmt":"2023-12-06T06:18:25","slug":"tanggal-ke-teks-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/","title":{"rendered":"Bagaimana cara mengubah tanggal menjadi teks di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1564373590\"><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>Seperti yang Anda ketahui, Excel menyimpan tanggal sebagai angka dan Anda memiliki format tanggal pada sel untuk menampilkannya sebagai tanggal. Dengan mengonversi tanggal menjadi teks, Anda bisa mendapatkan nama hari, nomor hari, nama bulan, dan nomor tahun. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79828\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-la-date-en-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"konversi-tanggal-ke-teks\" width=\"799\" height=\"218\"><\/figure><\/div><p> Untuk melakukan ini, yang terbaik adalah menggunakan fungsi TEXT. Fungsi ini memungkinkan Anda mengekstrak bagian (hari, bulan, dan tahun) suatu tanggal dalam bentuk teks. Dalam tutorial ini, kita akan melihat beberapa contoh untuk memahami cara menggunakan metode ini.<\/p><h2 class=\"wp-block-heading\"> Ubah tanggal menjadi teks menggunakan fungsi TEXT<\/h2><p> Anda dapat menggunakan langkah-langkah di bawah ini:<\/p><ol type=\"1\"><li> Pertama masukkan fungsi TEXT dalam sel.<\/li><li> Setelah itu, pada argumen pertama, lihat tanggal aslinya.<\/li><li> Kemudian pada argumen ketiga, masukkan format tanggal yang ingin Anda dapatkan hasilnya.<\/li><li> Terakhir, masukkan tanda kurung tutup dan 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-79829\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-convertir-la-date-en-utilisant-la-fonction-de-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"konversi-tanggal-menggunakan-fungsi teks\" width=\"482\" height=\"269\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(A1,\"dd-mmm-yy\")<\/code><\/pre><h2 class=\"wp-block-heading\"> Dapatkan nama bulan sebagai teks dari tanggal<\/h2><p> Dalam fungsi TEXT Anda perlu merujuk ke tanggal sebenarnya di argumen pertama, lalu di argumen kedua Anda perlu menentukan format tanggal yang ingin Anda dapatkan di hasilnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79830\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-obtenir-le-nom-du-mois-sous-forme-de-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"dapatkan-nama-bulan-sebagai-teks\" width=\"487\" height=\"228\"><\/figure><\/div><p> Dalam rumus ini, kami menggunakan format \u201cMMMM\u201d. Format ini memberitahu fungsi TEXT untuk hanya mendapatkan nama bulan penuh dari tanggal sebagai teks.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(A1,\"MMMM\")<\/code><\/pre><p> Dan jika Anda ingin mendapatkan nama pendek bulan tersebut, Anda hanya perlu mengubah formatnya dari \u201cMMMM\u201d menjadi \u201cMMM\u201d. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79831\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-obtenir-le-nom-court-du-mois-sous-forme-de-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"dapatkan-nama-bulan-pendek-sebagai-teks\" width=\"494\" height=\"259\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(A1,\"MMM\")<\/code><\/pre><h2 class=\"wp-block-heading\"> Dapatkan nama hari sebagai teks dari tanggal<\/h2><p> Dan jika Anda ingin mendapatkan nama hari sebagai teks dari tanggal maka Anda perlu menggunakan fungsi yang sama yaitu TEXT. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79832\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-obtenir-le-nom-du-jour-sous-forme-de-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"dapatkan-nama-hari-sebagai-teks\" width=\"509\" height=\"276\"><\/figure><\/div><p> Di sini Anda telah menggunakan fungsi yang sama dengan format untuk mendapatkan nama hari penuh.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(A1,\"DDDD\")<\/code><\/pre><p> Untuk mendapatkan nama hari yang pendek, Anda bisa menggunakan rumus berikut. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(A1,\"DDD\")<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79833\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-obtenir-le-nom-du-jour-court-sous-forme-de-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"dapatkan-nama-hari-pendek-sebagai-teks\" width=\"513\" height=\"279\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Dapatkan tanggal dalam kalimat teks lengkap<\/h2><p> Pada rumus di bawah ini, kami telah menggunakan fungsi TEXT untuk membuat kalimat teks untuk menentukan nama tanggal dan hari sebagai kalimat panjang. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=\"The date is \"&amp;TEXT(A1,\"DD, MMMM'YY\")&amp;\" and day is \"&amp;TEXT(A1,\"DDDD\")&amp;\".\"<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79834\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-obtenir-la-date-en-texte-complet.png\" sizes=\"auto, \" srcset=\"\" alt=\"dapatkan-tanggal-dalam-teks lengkap\" width=\"793\" height=\"216\"><\/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\/08\/date-au-texte.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\/bulan-hari-kerja\/\">Hari kerja dalam sebulan<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hari-hitung-mundur\/\">Hari hitung mundur<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hari-antara-dua-tanggal\/\">Hitung hari antara dua tanggal<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/julienne-tanggal-2\/\">Konversikan ke tanggal Julian<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/minggu-sebelumnya-2\/\">Dapatkan hari Minggu sebelumnya<\/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-1709","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 mengubah tanggal menjadi teks di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah tanggal menjadi teks. Mari kita periksa ini\u2026\" \/>\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\/tanggal-ke-teks-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara mengubah tanggal menjadi teks di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah tanggal menjadi teks. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-la-date-en-texte.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\/tanggal-ke-teks-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/\",\"name\":\"Bagaimana cara mengubah tanggal menjadi teks di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-la-date-en-texte.png\",\"datePublished\":\"2023-11-10T10:05:13+00:00\",\"dateModified\":\"2023-12-06T06:18:25+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah tanggal menjadi teks. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-la-date-en-texte.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-la-date-en-texte.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengubah tanggal menjadi teks 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 mengubah tanggal menjadi teks di Excel? (Tutorial 2023)","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah tanggal menjadi teks. Mari kita periksa ini\u2026","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\/tanggal-ke-teks-2\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mengubah tanggal menjadi teks di Excel? (Tutorial 2023)","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah tanggal menjadi teks. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:25+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-la-date-en-texte.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\/tanggal-ke-teks-2\/","url":"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/","name":"Bagaimana cara mengubah tanggal menjadi teks di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-la-date-en-texte.png","datePublished":"2023-11-10T10:05:13+00:00","dateModified":"2023-12-06T06:18:25+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah tanggal menjadi teks. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-la-date-en-texte.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-la-date-en-texte.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tanggal-ke-teks-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengubah tanggal menjadi teks 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\/1709","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=1709"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1709\/revisions"}],"predecessor-version":[{"id":2722,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1709\/revisions\/2722"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}