{"id":2175,"date":"2023-09-26T05:54:25","date_gmt":"2023-09-26T05:54:25","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/"},"modified":"2023-12-06T06:12:30","modified_gmt":"2023-12-06T06:12:30","slug":"format-tanggal-khusus","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/","title":{"rendered":"5 format tanggal kustom di excel"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-920649653\"><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>Terkadang kita perlu menggunakan format tanggal khusus yang tidak sesuai dengan format tanggal standar. Seperti yang Anda ketahui, kami beruntung memiliki format khusus sehingga Anda dapat membuat tanggal khusus dengan nomor seri tanggal biasa.<\/p><p> Keuntungan format kustom adalah Anda tidak perlu mengubah nomor seri tanggal sebenarnya, yang berarti Anda dapat menelusuri tanggal tersebut dalam penghitungan.<\/p><p> Jadi hari ini saya ingin berbagi dengan Anda beberapa format tanggal khusus favorit saya yang dapat membantu Anda menyajikan tanggal dengan cara yang unik.<\/p><h2 class=\"wp-block-heading\"> Cara menggunakan format tanggal khusus ini<\/h2><p> Untuk semua format yang saya sebutkan di atas, Anda perlu mengikuti langkah-langkah di bawah ini.<\/p><ol><li> Pilih sel tempat Anda ingin menerapkan format.<\/li><li> Sekarang tekan klik kanan dan pilih &#8220;Format Sel&#8221;. Atau bisa juga menggunakan shortcut keyboard <a href=\"https:\/\/exceladvisor.org\/id\/buka-opsi-format-sel\/\">Ctrl + 1 untuk membuka opsi Format Cells<\/a> .<\/li><li> Setelah itu pilih custom dan masukkan formatnya pada input bar dan klik OK. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-format-personnalise-a-loption-de-format-de-cellule.png\" sizes=\"\" srcset=\"\" alt=\"tambahkan format khusus ke opsi format sel\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Nama hari ini<\/h2><p> Yang ini adalah favoritku. Jika Anda mengerjakan tanggal tertentu di mana Anda hanya ingin mendapatkan nama hari, format tanggal khusus ini dapat membantu Anda. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">\"It's\" dddd<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nom-du-jour-format-de-date-personnalise-dans-excel.gif\" sizes=\"\" srcset=\"\" alt=\"format tanggal khusus nama hari di excel\"><\/figure><\/div><p> Dan jika Anda ingin mendapatkan nama hari dalam bentuk singkat, Anda bisa menggunakan format di bawah ini.<\/p><pre class=\"wp-block-code\"> <code class=\"language-Visual Basic\" lang=\"Visual Basic\">\"It's\" ddd<\/code><\/pre><h2 class=\"wp-block-heading\"> Nomor hari ini<\/h2><p> Sama seperti nama hari, jika ingin mendapatkan nomor hari bisa menggunakan format custom ini. <\/p><pre class=\"wp-block-code\"> <code class=\"language-Visual Basic\" lang=\"Visual Basic\">\"Day\" d<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-numero-de-jour-avec-un-format-de-date-personnalise.gif\" sizes=\"\" srcset=\"\" alt=\"nomor hari dengan format tanggal khusus\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Nama bulan<\/h2><p> Format tanggal khusus ini akan membantu Anda mendapatkan nama bulan untuk nilai tanggal Anda. Dan, Anda juga dapat menambahkan teks khusus sesuai kebutuhan Anda. <\/p><pre class=\"wp-block-code\"> <code class=\"language-Visual Basic\" lang=\"Visual Basic\">\"Current Month is:\" mmmm<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-nom-de-mois-complet-avec-un-format-personnalise.png\" sizes=\"\" srcset=\"\" alt=\"nama bulan penuh dengan format custom\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Tanggal dengan nama hari<\/h2><p> Format ini membantu Anda membuat tanggal dengan nama hari di akhir. <\/p><pre class=\"wp-block-code\"> <code class=\"language-Visual Basic\" lang=\"Visual Basic\">dd-mmm-yyyy (ddd)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-date-simple-avec-le-nom-du-jour-avec-un-format-personnalise.png\" sizes=\"\" srcset=\"\" alt=\"tanggal sederhana dengan nama hari dengan format khusus\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Tanggal teks panjang<\/h2><p> Dan jika Anda menginginkan data teks yang panjang, Anda bisa melakukannya dengan menggunakan format di bawah ini. <\/p><pre class=\"wp-block-code\"> <code class=\"language-Visual Basic\" lang=\"Visual Basic\">\"Today is Day\" d\", Month\" m \"&amp; Year\" yyyy.<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-longue-date-textuelle-avec-un-format-personnalise.png\" sizes=\"\" srcset=\"\" alt=\"tanggal teks panjang dengan format khusus\"><\/figure><\/div><p> Sekarang beritahu aku satu hal. <strong>Apakah Anda memiliki format yang Anda gunakan<\/strong> ? Bagikan dengan saya di bagian komentar.<\/p><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\/rentang-tanggal\/\">Buat rentang tanggal 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-2175","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 5 Format Tanggal Kustom di Excel (Terbaru 2023)<\/title>\n<meta name=\"description\" content=\"Dalam artikel ini, Anda akan mempelajari beberapa format tanggal khusus yang berguna. Anda dapat menggunakan format ini untuk menampilkan tanggal Anda...\" \/>\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\/format-tanggal-khusus\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 5 Format Tanggal Kustom di Excel (Terbaru 2023)\" \/>\n<meta property=\"og:description\" content=\"Dalam artikel ini, Anda akan mempelajari beberapa format tanggal khusus yang berguna. Anda dapat menggunakan format ini untuk menampilkan tanggal Anda...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:12:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-format-personnalise-a-loption-de-format-de-cellule.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\/format-tanggal-khusus\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/\",\"name\":\"\u25b7 5 Format Tanggal Kustom di Excel (Terbaru 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-format-personnalise-a-loption-de-format-de-cellule.png\",\"datePublished\":\"2023-09-26T05:54:25+00:00\",\"dateModified\":\"2023-12-06T06:12:30+00:00\",\"description\":\"Dalam artikel ini, Anda akan mempelajari beberapa format tanggal khusus yang berguna. Anda dapat menggunakan format ini untuk menampilkan tanggal Anda...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-format-personnalise-a-loption-de-format-de-cellule.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-format-personnalise-a-loption-de-format-de-cellule.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"5 format tanggal kustom 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":"\u25b7 5 Format Tanggal Kustom di Excel (Terbaru 2023)","description":"Dalam artikel ini, Anda akan mempelajari beberapa format tanggal khusus yang berguna. Anda dapat menggunakan format ini untuk menampilkan tanggal Anda...","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\/format-tanggal-khusus\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 5 Format Tanggal Kustom di Excel (Terbaru 2023)","og_description":"Dalam artikel ini, Anda akan mempelajari beberapa format tanggal khusus yang berguna. Anda dapat menggunakan format ini untuk menampilkan tanggal Anda...","og_url":"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:12:30+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-format-personnalise-a-loption-de-format-de-cellule.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\/format-tanggal-khusus\/","url":"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/","name":"\u25b7 5 Format Tanggal Kustom di Excel (Terbaru 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-format-personnalise-a-loption-de-format-de-cellule.png","datePublished":"2023-09-26T05:54:25+00:00","dateModified":"2023-12-06T06:12:30+00:00","description":"Dalam artikel ini, Anda akan mempelajari beberapa format tanggal khusus yang berguna. Anda dapat menggunakan format ini untuk menampilkan tanggal Anda...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-format-personnalise-a-loption-de-format-de-cellule.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-format-personnalise-a-loption-de-format-de-cellule.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"5 format tanggal kustom 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\/2175","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=2175"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2175\/revisions"}],"predecessor-version":[{"id":2229,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2175\/revisions\/2229"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}