{"id":4448,"date":"2024-12-05T23:31:37","date_gmt":"2024-12-05T23:31:37","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/cac-cach-dinh-dang-ngay-thang-trong-excel\/"},"modified":"2024-12-05T23:31:37","modified_gmt":"2024-12-05T23:31:37","slug":"cac-cach-dinh-dang-ngay-thang-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/cac-cach-dinh-dang-ngay-thang-trong-excel\/","title":{"rendered":"C\u00e1c c\u00e1ch \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>\u1ede b\u00e0i h\u1ecdc tr\u01b0\u1edbc, ch\u00fang ta\u00a0\u0111\u00e3 t\u00ecm hi\u1ec3u v\u1ec1 vi\u1ec7c \u201c<a href=\"http:\/\/blog.ezworkapp.com\/cach-chinh-dung-dinh-dang-ngay-thang-nam-trong-excel.html\">\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m\u00a0trong\u00a0Excel\u00a0\u0111\u00fang c\u00e1ch<\/a>\u201c.<\/p>\n<p>Trong b\u00e0i n\u00e0y,\u00a0<a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n chi ti\u1ebft h\u01a1n v\u1ec1 c\u00e1c c\u00e1ch\u00a0\u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng\u00a0\u1edf trong\u00a0Excel.<\/p>\n<p>Ch\u00fang ta c\u00f3 v\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12125 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic-01-3.png\" width=\"596\" height=\"288\" title=\"pic-01-3\"><\/p>\n<p>Nh\u00ecn v\u00e0o c\u00e1c v\u00ed d\u1ee5 tr\u00ean ch\u00fang ta c\u00f3 th\u1ec3 hi\u1ec3u kh\u00e1i qu\u00e1t v\u1ec1 c\u00e1c k\u00fd t\u1ef1 bi\u1ec3u di\u1ec5n ng\u00e0y, th\u00e1ng, n\u0103m nh\u01b0 sau:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-675237d82c9e3\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cac-cach-dinh-dang-ngay-thang-trong-excel.html#Bieu_dien_gia_tri_ngay\" title=\"Bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb ng\u00e0y\">Bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb ng\u00e0y<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cac-cach-dinh-dang-ngay-thang-trong-excel.html#Bieu_dien_gia_tri_thang\" title=\"Bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb th\u00e1ng\">Bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb th\u00e1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cac-cach-dinh-dang-ngay-thang-trong-excel.html#Bieu_dien_gia_tri_nam\" title=\"Bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb n\u0103m\">Bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb n\u0103m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cac-cach-dinh-dang-ngay-thang-trong-excel.html#Bieu_dien_dau_ngan_cach_cac_thanh_phan_ngay_thang_nam\" title=\"Bi\u1ec3u di\u1ec5n d\u1ea5u ng\u0103n c\u00e1ch c\u00e1c th\u00e0nh ph\u1ea7n ng\u00e0y th\u00e1ng n\u0103m\">Bi\u1ec3u di\u1ec5n d\u1ea5u ng\u0103n c\u00e1ch c\u00e1c th\u00e0nh ph\u1ea7n ng\u00e0y th\u00e1ng n\u0103m<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Bieu_dien_gia_tri_ngay\"><\/span><strong>Bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb ng\u00e0y<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>d (m\u1ed9t ch\u1eef d) l\u00e0 bi\u1ec3u di\u1ec5n ng\u00e0y d\u01b0\u1edbi d\u1ea1ng 1 ch\u1eef s\u1ed1, n\u1ebfu ng\u00e0y &lt; 10 th\u00ec ng\u00e0y\u00a0\u0111\u00f3 s\u1ebd kh\u00f4ng c\u00f3 s\u1ed1 0\u00a0\u0111\u1ee9ng tr\u01b0\u1edbc (v\u00ed d\u1ee5 ng\u00e0y 9 s\u1ebd ch\u1ec9 l\u00e0 s\u1ed1 9)<\/li>\n<li>dd (hai ch\u1eef d) l\u00e0 bi\u1ec3u di\u1ec5n ng\u00e0y d\u01b0\u1edbi d\u1ea1ng 2 ch\u1eef s\u1ed1, n\u1ebfu ng\u00e0y &lt; 10 th\u00ec ng\u00e0y\u00a0\u0111\u00f3 s\u1ebd c\u00f3 s\u1ed1 0\u00a0\u0111\u1ee9ng tr\u01b0\u1edbc (v\u00ed d\u1ee5 ng\u00e0y 9 s\u1ebd c\u00f3 d\u1ea1ng 09)<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Bieu_dien_gia_tri_thang\"><\/span><strong>Bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb th\u00e1ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>mm (hai ch\u1eef m) l\u00e0 bi\u1ec3u di\u1ec5n th\u00e1ng d\u01b0\u1edbi d\u1ea1ng 2 ch\u1eef s\u1ed1 (L\u01b0u \u00fd: kh\u00f4ng c\u00f3 d\u1ea1ng 1 ch\u1eef m)<\/li>\n<li>mmm (ba ch\u1eef m) l\u00e0 bi\u1ec3u di\u1ec5n th\u00e1ng d\u01b0\u1edbi d\u1ea1ng vi\u1ebft t\u1eaft 3 ch\u1eef c\u00e1i \u0111\u1ea7u c\u1ee7a th\u00e1ng \u0111\u00f3\u00a0trong ti\u1ebfng anh (v\u00ed d\u1ee5 th\u00e1ng 11 trong ti\u1ebfng anh l\u00e0 November th\u00ec vi\u1ebft t\u1eaft l\u00e0 Nov)<\/li>\n<li>mmmm (b\u1ed1n ch\u1eef m) l\u00e0 bi\u1ec3u di\u1ec5n th\u00e1ng d\u01b0\u1edbi d\u1ea1ng vi\u1ebft\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 t\u00ean ti\u1ebfng anh c\u1ee7a th\u00e1ng\u00a0\u0111\u00f3<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Bieu_dien_gia_tri_nam\"><\/span><strong>Bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb n\u0103m<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>yy (hai ch\u1eef y) l\u00e0 bi\u1ec3u di\u1ec5n n\u0103m d\u01b0\u1edbi d\u1ea1ng 2 ch\u1eef s\u1ed1 cu\u1ed1i c\u1ee7a n\u0103m \u0111\u00f3\u00a0(L\u01b0u\u00a0\u00fd: kh\u00f4ng c\u00f3 d\u1ea1ng 1 ch\u1eef y)<\/li>\n<li>yyyy (b\u1ed1n ch\u1eef y) l\u00e0 bi\u1ec3u di\u1ec5n n\u0103m d\u01b0\u1edbi d\u1ea1ng\u00a0\u0111\u1ee7 4 ch\u1eef s\u1ed1 c\u1ee7a n\u0103m\u00a0\u0111\u00f3<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Bieu_dien_dau_ngan_cach_cac_thanh_phan_ngay_thang_nam\"><\/span><strong>Bi\u1ec3u di\u1ec5n d\u1ea5u ng\u0103n c\u00e1ch c\u00e1c th\u00e0nh ph\u1ea7n ng\u00e0y th\u00e1ng n\u0103m<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>C\u00f3 th\u1ec3 d\u00f9ng c\u00e1c d\u1ea5u\u00a0 \u00a0\/ (d\u1ea5u g\u1ea1ch ch\u00e9o, d\u1ea5u ph\u00e9p chia)\u00a0 \u00a0hay d\u1ea5u .\u00a0 (d\u1ea5u ch\u1ea5m), ho\u1eb7c d\u1ea5u\u00a0 \u2013\u00a0 (d\u1ea5u g\u1ea1ch ngang, d\u1ea5u tr\u1eeb) tuy nhi\u00ean ph\u1ea3i s\u1eed d\u1ee5ng th\u1ed1ng nh\u1ea5t trong 1\u00a0\u0111\u1ecbnh d\u1ea1ng.<\/li>\n<\/ul>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp\u00a0\u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng, ch\u00fang ta ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n\u00a0\u0111\u1ecbnh d\u1ea1ng, sau\u00a0\u0111\u00f3 ch\u1ecdn Format cells, r\u1ed3i ch\u1ecdn Custome<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12126 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-02-13-at-11-57-21-972x1024-1-1.png\" width=\"972\" height=\"1024\" title=\"screen-shot-2017-02-13-at-11-57-21-972x1024-1-1\"><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-155.gif\" title=\"vba101_92019-nho-155\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-361.gif\" title=\"ex101_92019-nho-361\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>Xem th\u00eam<\/strong>:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tong-hop-nhung-bai-viet-ve-chu-de-ngay-thang-thoi-gian-trong-excel.html\">T\u1ed5ng h\u1ee3p nh\u1eefng b\u00e0i vi\u1ebft v\u1ec1 ch\u1ee7 \u0111\u1ec1 Ng\u00e0y \u2013 Th\u00e1ng \u2013 Th\u1eddi gian trong Excel<\/a><\/p>\n<p>* <strong>C\u00e1ch\u00a0\u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng c\u00f3 k\u00e8m theo k\u00fd t\u1ef1\u00a0\u0111\u1eb7c bi\u1ec7t<\/strong> (\u00f4 A8 trong h\u00ecnh v\u00ed d\u1ee5)<\/p>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 gh\u00e9p c\u00e1c k\u00fd t\u1ef1 text chung v\u1edbi k\u00fd t\u1ef1 ng\u00e0y th\u00e1ng trong ph\u1ea7n t\u00f9y ch\u1ecdn\u00a0\u0111\u1ecbnh d\u1ea1ng (format cells \/ custome) b\u1eb1ng c\u00e1ch:<\/p>\n<ul>\n<li>K\u00fd t\u1ef1 text\u00a0\u0111\u1eb7c bi\u1ec7t (v\u00ed d\u1ee5 nh\u01b0 k\u00fd t\u1ef1 Ng\u00e0y) th\u00ec ph\u1ea3i\u00a0\u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p<\/li>\n<li>K\u00fd t\u1ef1 quy\u00a0\u01b0\u1edbc ng\u00e0y, th\u00e1ng, n\u0103m v\u1eabn gi\u1eef nguy\u00ean v\u00e0 kh\u00f4ng\u00a0\u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p<\/li>\n<li>D\u1ea5u ng\u0103n c\u00e1ch gi\u1eefa k\u1ef9 t\u1ef1 text v\u1edbi k\u00fd t\u1ef1 ng\u00e0y th\u00e1ng (d\u1ea5u c\u00e1ch) c\u00f3 th\u1ec3\u00a0\u0111\u1ec3 trong d\u1ea5u nh\u00e1y k\u00e9p ho\u1eb7c\u00a0\u1edf ngo\u00e0i d\u1ea5u nh\u00e1y k\u00e9p\u00a0\u0111\u1ec1u\u00a0\u0111\u01b0\u1ee3c<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5:<\/strong><\/p>\n<p><em>\u201cNg\u00e0y \u201c<\/em><strong>dd<\/strong><em>\u201d th\u00e1ng \u201c<\/em><strong>mm<\/strong><em>\u201d n\u0103m \u201c<\/em><strong>yyyy<\/strong>\u00a0 s\u1ebd cho k\u1ebft qu\u1ea3 gi\u1ed1ng v\u1edbi<\/p>\n<p><em>\u201cNg\u00e0y\u201d<\/em> <strong>dd<\/strong> <em>\u201cth\u00e1ng\u201d<\/em> <strong>mm<\/strong> <em>\u201cn\u0103m\u201d<\/em> <strong>yyyy<\/strong><\/p>\n<p>(ch\u00fa\u00a0\u00fd d\u1ea5u c\u00e1ch\u00a0\u1edf 2 tr\u01b0\u1eddng h\u1ee3p c\u00f3 v\u1ecb tr\u00ed kh\u00e1c nhau so v\u1edbi v\u1ecb tr\u00ed d\u1ea5u nh\u00e1y k\u00e9p<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12127 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic-02-3.png\" width=\"876\" height=\"596\" title=\"pic-02-3\"><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3\u00a0\u00e1p d\u1ee5ng nguy\u00ean t\u1eafc n\u00e0y\u00a0\u0111\u1ec3\u00a0\u00e1p d\u1ee5ng cho c\u00e1c t\u00f9y ch\u1ecdn ng\u00e0y th\u00e1ng theo\u00a0\u00fd mu\u1ed1n nh\u00e9.<\/p>\n<p>Hi\u00ea\u0323n nay, blog.excel.online \u0111ang co\u0301 r\u00e2\u0301t nhi\u00ea\u0300u kho\u0301a ho\u0323c v\u00ea\u0300 Excel nh\u01b0: <a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">Excel c\u01a1 ba\u0309n<\/a>, Excel n\u00e2ng cao, kho\u0301a ho\u0323c l\u00e2\u0323p tri\u0300nh VBA, <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">kho\u0301a ho\u0323c Excel k\u00ea\u0301 toa\u0301n<\/a>\u2026. v\u01a1\u0301i ca\u0301c chuy\u00ean gia\u00a0v\u00ea\u0300 Excel ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam se\u0303 h\u01b0\u01a1\u0301ng d\u00e2\u0303n t\u01b0\u0300ng chi ti\u00ea\u0301t v\u00ea\u0300 t\u01b0\u0300ng kho\u0301a ho\u0323c cho ca\u0301c ba\u0323n m\u00f4\u0323t ca\u0301ch t\u00e2\u0323n ti\u0300nh nh\u00e2\u0301t. Th\u00f4ng tin chi ti\u1ebft v\u1ec1 kh\u00f3a h\u1ecdc, b\u1ea1n tham kh\u1ea3o t\u1ea1i link d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-155.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4449,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4448","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4448","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=4448"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4448\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4449"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}