{"id":6195,"date":"2024-12-21T14:10:18","date_gmt":"2024-12-21T14:10:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel\/"},"modified":"2024-12-21T14:10:18","modified_gmt":"2024-12-21T14:10:18","slug":"cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel\/","title":{"rendered":"C\u00e1ch thay \u0111\u1ed5i v\u00e0 t\u1ea1o \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng m\u1eb7c \u0111\u1ecbnh tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y,<strong> <a href=\"http:\/\/blog.ezworkapp.com\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a> <\/strong>s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n <strong>c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong Excel<\/strong>, c\u0169ng nh\u01b0 gi\u1ea3i th\u00edch c\u00e1ch \u0111\u1eb7t \u0111\u1ecbnh d\u1ea1ng m\u1eb7c \u0111\u1ecbnh cho c\u00e1c th\u00f4ng tin ng\u00e0y th\u00e1ng v\u00e0 c\u00e1ch chuy\u1ec3n \u0111\u1ed5i ng\u00e0y th\u00e1ng theo s\u1ef1 thay \u0111\u1ed5i c\u1ee7a \u0111\u1ecba \u0111i\u1ec3m.<\/p>\n<p style=\"text-align: justify\">C\u00f9ng v\u1edbi s\u1ed1, ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian l\u00e0 nh\u1eefng d\u1eef li\u1ec7u ph\u1ed5 bi\u1ebfn nh\u1ea5t m\u00e0 m\u1ecdi ng\u01b0\u1eddi th\u01b0\u1eddng x\u1eed l\u00fd v\u1edbi Excel. Tuy nhi\u00ean, nh\u1eefng th\u00f4ng tin n\u00e0y c\u00f3 th\u1ec3 h\u01a1i ph\u1ee9c t\u1ea1p v\u00ec c\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch hi\u1ec3n th\u1ecb c\u00f9ng 1 th\u00f4ng tin n\u00e0y tr\u00ean Excel v\u00e0 v\u00ec Excel lu\u00f4n t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i c\u00e1c th\u00f4ng tin ng\u00e0y th\u00e1ng theo m\u1ed9t \u0111\u1ecbnh d\u1ea1ng nh\u1ea5t \u0111\u1ecbnh d\u00f9 c\u00f3 nh\u1eefng th\u00f4ng tin b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb n\u00f3 m\u1ed9t c\u00e1ch kh\u00e1c bi\u1ec7t.<\/p>\n<p style=\"text-align: justify\">Vi\u1ec7c n\u1eafm \u0111\u01b0\u1ee3c nh\u1eefng \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng c\u1ee7a Excel m\u1ed9t c\u00e1ch k\u1ef9 c\u00e0ng s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m nhi\u1ec1u th\u1eddi gian v\u00e0 \u0111\u00f3 c\u0169ng ch\u00ednh l\u00e0 m\u1ee5c ti\u00eau c\u1ee7a b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y.<\/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-6766cc49bae82\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#Dinh_dang_ngay_thang_cua_Excel\" title=\"\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng c\u1ee7a Excel\">\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng c\u1ee7a Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#Ngay_thang_trong_Excel\" title=\"Ng\u00e0y th\u00e1ng trong Excel\">Ng\u00e0y th\u00e1ng trong Excel<\/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\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#Thoi_gian_trong_Excel\" title=\"Th\u1eddi gian trong Excel\">Th\u1eddi gian trong Excel<\/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\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#Thoi_gian_va_ngay_thang_trong_Excel\" title=\"Th\u1eddi gian v\u00e0 ng\u00e0y th\u00e1ng trong Excel\">Th\u1eddi gian v\u00e0 ng\u00e0y th\u00e1ng trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#Cach_chuyen_doi_ngay_thang_thanh_so_trong_Excel\" title=\"C\u00e1ch chuy\u1ec3n \u0111\u1ed5i ng\u00e0y th\u00e1ng th\u00e0nh s\u1ed1 trong Excel\">C\u00e1ch chuy\u1ec3n \u0111\u1ed5i ng\u00e0y th\u00e1ng th\u00e0nh s\u1ed1 trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#1_Cua_so_Dinh_dang_o_Format_Cells\" title=\"1. C\u1eeda s\u1ed5 \u0110\u1ecbnh d\u1ea1ng \u00f4 (Format Cells)\">1. C\u1eeda s\u1ed5 \u0110\u1ecbnh d\u1ea1ng \u00f4 (Format Cells)<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#2_Chuc_nang_DATEVALUE_va_TIMEVALUE_cua_Excel\" title=\"2. Ch\u1ee9c n\u0103ng DATEVALUE v\u00e0 TIMEVALUE c\u1ee7a Excel\">2. Ch\u1ee9c n\u0103ng DATEVALUE v\u00e0 TIMEVALUE c\u1ee7a Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#Dinh_dang_ngay_thang_mac_dinh_trong_Excel\" title=\"\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng m\u1eb7c \u0111\u1ecbnh trong Excel\">\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng m\u1eb7c \u0111\u1ecbnh trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#Cach_thay_doi_dinh_dang_ngay_thang_va_thoi_gian_trong_Excel\" title=\"C\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian trong Excel\">C\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#Cach_ap_dung_nhanh_dinh_dang_ngay_thang_va_thoi_gian_mac_dinh_tren_Excel\" title=\"C\u00e1ch \u00e1p d\u1ee5ng nhanh \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian m\u1eb7c \u0111\u1ecbnh tr\u00ean Excel\">C\u00e1ch \u00e1p d\u1ee5ng nhanh \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian m\u1eb7c \u0111\u1ecbnh tr\u00ean Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#Cach_thay_doi_dinh_dang_ngay_thang_tren_Excel\" title=\"C\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng tr\u00ean Excel\">C\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng tr\u00ean Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#Cach_chuyen_doi_dinh_dang_ngay_thang_theo_vi_tri_khu_vuc\" title=\"C\u00e1ch chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng theo v\u1ecb tr\u00ed khu v\u1ef1c\">C\u00e1ch chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng theo v\u1ecb tr\u00ed khu v\u1ef1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#Cach_tao_dinh_dang_ngay_thang_dac_biet_trong_Excel\" title=\"C\u00e1ch t\u1ea1o \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng \u0111\u1eb7c bi\u1ec7t trong Excel\">C\u00e1ch t\u1ea1o \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng \u0111\u1eb7c bi\u1ec7t trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#Lam_the_nao_de_tao_dinh_dang_ngay_thang_tren_Excel_doi_voi_nhung_dia_diem_khac_nhau\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng tr\u00ean Excel \u0111\u1ed1i v\u1edbi nh\u1eefng \u0111\u1ecba \u0111i\u1ec3m kh\u00e1c nhau?\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng tr\u00ean Excel \u0111\u1ed1i v\u1edbi nh\u1eefng \u0111\u1ecba \u0111i\u1ec3m kh\u00e1c nhau?<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#Chen_ngay_thang_trong_Excel_de_dang_voi_Calendar_Control\" title=\"Ch\u00e8n ng\u00e0y th\u00e1ng trong Excel d\u1ec5 d\u00e0ng v\u1edbi Calendar Control\">Ch\u00e8n ng\u00e0y th\u00e1ng trong Excel d\u1ec5 d\u00e0ng v\u1edbi Calendar Control<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#Dinh_dang_cua_Excel_khong_hoat_dong_%E2%80%93_giai_phap\" title=\"\u0110\u1ecbnh d\u1ea1ng c\u1ee7a Excel kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng \u2013 gi\u1ea3i ph\u00e1p\">\u0110\u1ecbnh d\u1ea1ng c\u1ee7a Excel kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng \u2013 gi\u1ea3i ph\u00e1p<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#O_khong_du_rong_de_chua_toan_bo_thong_tin\" title=\"\u00d4 kh\u00f4ng \u0111\u1ee7 r\u1ed9ng \u0111\u1ec3 ch\u1ee9a to\u00e0n b\u1ed9 th\u00f4ng tin\">\u00d4 kh\u00f4ng \u0111\u1ee7 r\u1ed9ng \u0111\u1ec3 ch\u1ee9a to\u00e0n b\u1ed9 th\u00f4ng tin<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html#Thoi_gian_duoc_nhap_vao_EXCEL_nhu_la_gia_tri_chu\" title=\"Th\u1eddi gian \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o EXCEL nh\u01b0 l\u00e0 gi\u00e1 tr\u1ecb ch\u1eef\">Th\u1eddi gian \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o EXCEL nh\u01b0 l\u00e0 gi\u00e1 tr\u1ecb ch\u1eef<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dinh_dang_ngay_thang_cua_Excel\"><\/span>\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng c\u1ee7a Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Tr\u01b0\u1edbc khi b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c nh\u1eefng t\u00ednh n\u0103ng c\u1ee7a Excel khi x\u1eed l\u00fd th\u00f4ng tin ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian, b\u1ea1n s\u1ebd c\u1ea7n hi\u1ec3u \u0111\u01b0\u1ee3c c\u00e1ch th\u1ee9c Excel l\u01b0u tr\u1eef nh\u1eefng d\u1eef li\u1ec7u n\u00e0y b\u1edfi l\u1ebd \u0111\u00e2y th\u01b0\u1eddng l\u00e0 nguy\u00ean nh\u00e2n ch\u00ednh g\u00e2y kh\u00f3 kh\u0103n cho b\u1ea1n khi x\u1eed l\u00fd d\u1eef li\u1ec7u. Th\u1ef1c t\u1ebf, khi b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u, Excel s\u1ebd kh\u00f4ng ghi nh\u1edb n\u00f3 l\u00e0 ng\u00e0y, th\u00e1ng, n\u0103m m\u00e0 s\u1ebd l\u01b0u tr\u1eef n\u00f3 nh\u01b0 l\u00e0 1 d\u00e3y s\u1ed1, v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 ch\u1ee9a th\u00f4ng tin s\u1ebd chuy\u1ec3n d\u00e3y s\u1ed1 \u0111\u00f3 th\u00e0nh nh\u1eefng th\u00f4ng tin ng\u00e0y th\u00e1ng ho\u1eb7c gi\u1edd ph\u00fat.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ngay_thang_trong_Excel\"><\/span>Ng\u00e0y th\u00e1ng trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef l\u00e0 s\u1ed1 nguy\u00ean trong Excel, hi\u1ec3n th\u1ecb s\u1ed1 ng\u00e0y \u0111\u01b0\u1ee3c t\u00ednh t\u1eeb ng\u00e0y 1\/1\/1990. B\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u nh\u01b0 sau:<br \/>\nS\u1ed1 1 t\u01b0\u1ee3ng tr\u01b0ng cho ng\u00e0y 1\/1\/1990<br \/>\nS\u1ed1 2 t\u01b0\u1ee3ng tr\u01b0ng cho ng\u00e0y 2\/1\/1990<br \/>\nS\u1ed1 3 t\u01b0\u1ee3ng tr\u01b0ng cho ng\u00e0y 3\/1\/1990<br \/>\nS\u1ed1 42005 t\u01b0\u1ee3ng tr\u01b0ng cho ng\u00e0y 1\/1\/2015 (v\u00ec ng\u00e0y 1\/1\/2015 c\u00e1ch ng\u00e0y 1\/1\/1990 \u0111\u00fang 42,005 ng\u00e0y)<br \/>\nS\u1ed1 2958465 t\u01b0\u1ee3ng tr\u01b0ng cho ng\u00e0y 31\/12\/9999<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Thoi_gian_trong_Excel\"><\/span>Th\u1eddi gian trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Th\u1eddi gian (gi\u1edd ph\u00fat gi\u00e2y) \u0111\u01b0\u1ee3c ghi nh\u1eadn l\u00e0 s\u1ed1 th\u1eadp ph\u00e2n trong Excel, gi\u1eefa .0 v\u00e0 .99999, t\u01b0\u1ee3ng tr\u01b0ng cho s\u1ed1 th\u1eddi gian \u0111\u01b0\u1ee3c ph\u00e2n chia trong ng\u00e0y, trong \u0111\u00f3:<br \/>\nS\u1ed1 0 t\u01b0\u1ee3ng tr\u01b0ng cho 00:00:00<br \/>\nS\u1ed1 0.25 t\u01b0\u1ee3ng tr\u01b0ng cho 06:00 s\u00e1ng<br \/>\nS\u1ed1 0.5 t\u01b0\u1ee3ng tr\u01b0ng cho 12:00 tr\u01b0a<br \/>\nS\u1ed1 0.541655093 t\u01b0\u1ee3ng tr\u01b0ng cho 12:59:59 t\u1ed1i<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Thoi_gian_va_ngay_thang_trong_Excel\"><\/span>Th\u1eddi gian v\u00e0 ng\u00e0y th\u00e1ng trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Excel l\u01b0u tr\u1eef th\u1eddi gian v\u00e0 ng\u00e0y th\u00e1ng trong Excel \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef l\u00e0 s\u1ed1 nguy\u00ean + s\u1ed1 th\u1eadp ph\u00e2n t\u01b0\u1ee3ng tr\u01b0ng cho ng\u00e0y th\u00e1ng v\u00e0 s\u1ed1 gi\u1edd t\u01b0\u01a1ng \u1ee9ng. Ta c\u00f3 th\u1ec3 xem v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<br \/>\nS\u1ed1 1.25 l\u00e0 1\/1\/1900 v\u00e0o l\u00fac 6:00 s\u00e1ng<br \/>\nS\u1ed1 42005.5 l\u00e0 ng\u00e0y 1\/1\/2015 v\u00e0o l\u00fac 12:00 tr\u01b0a.<\/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-235.gif\" title=\"vba101_92019-nho-235\"><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-557.gif\" title=\"ex101_92019-nho-557\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_chuyen_doi_ngay_thang_thanh_so_trong_Excel\"><\/span>C\u00e1ch chuy\u1ec3n \u0111\u1ed5i ng\u00e0y th\u00e1ng th\u00e0nh s\u1ed1 trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft d\u00e3y s\u1ed1 bi\u1ec3u th\u1ecb cho ng\u00e0y th\u00e1ng hay th\u1eddi gian n\u00e0o, b\u1ea1n s\u1ebd c\u00f3 2 c\u00e1ch \u0111\u1ec3 th\u1ef1c hi\u1ec7n.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"1_Cua_so_Dinh_dang_o_Format_Cells\"><\/span>1. C\u1eeda s\u1ed5 \u0110\u1ecbnh d\u1ea1ng \u00f4 (Format Cells)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Ch\u1ecdn \u00f4 ch\u1ee9a th\u00f4ng tin ng\u00e0y th\u00e1ng trong Excel, nh\u1ea5n <code class=\"excel-formula-inline\"><strong><em>Ctrl + 1<\/em><\/strong><\/code> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <code class=\"excel-formula-inline\"><em>Format Cells<\/em><\/code> v\u00e0 ch\u1ecdn tab <em>General<\/em>.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft d\u00e3y s\u1ed1 t\u01b0\u1ee3ng tr\u01b0ng cho ng\u00e0y th\u00e1ng m\u00e0 kh\u00f4ng c\u00f3 nhu c\u1ea7u \u0111\u1ed5i ng\u00e0y th\u00e1ng th\u00e0nh s\u1ed1, h\u00e3y vi\u1ebft ra \u00e3y s\u1ed1 m\u00e0 b\u1ea1n nh\u00ecn th\u1ea5y \u1edf \u00f4 <em>Sample<\/em> v\u00e0 nh\u1ea5n<em> Cancel<\/em> \u0111\u1ec3 \u0111\u00f3ng h\u1ed9p tho\u1ea1i. N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ed5i ng\u00e0y th\u00e1ng th\u00e0nh s\u1ed1, nh\u1ea5n OK.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6240 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-date-300x249-1.png\" width=\"300\" height=\"249\" title=\"excel-date-300x249-1\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"2_Chuc_nang_DATEVALUE_va_TIMEVALUE_cua_Excel\"><\/span>2. Ch\u1ee9c n\u0103ng DATEVALUE v\u00e0 TIMEVALUE c\u1ee7a Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng <strong>DATEVALUE()<\/strong> \u0111\u1ec3 chuy\u1ec3n 1 th\u00f4ng tin ng\u00e0y th\u00e1ng tr\u00ean Excel th\u00e0nh d\u00e3y s\u1ed1, v\u00ed d\u1ee5 nh\u01b0 =DATEVALUE(\u201c1\/1\/2015\u201d).<\/p>\n<p style=\"text-align: justify\">S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng <strong>TIMEVALUE()<\/strong> \u0111\u1ec3 chuy\u1ec3n th\u1eddi gian th\u00e0nh s\u1ed1 th\u1eadp ph\u00e2n, v\u00ed d\u1ee5 nh\u01b0 =TIMEVALUE(\u201c6:30 AM\u201d).<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c d\u00e3y s\u1ed1 hi\u1ec3n th\u1ecb c\u1ea3 th\u00f4ng tin ng\u00e0y v\u00e0 th\u00e1ng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u1ea3 2 ch\u1ee9c n\u0103ng nh\u01b0 sau:<br \/>\n<strong>=DATEVALUE(\u201c1\/1\/2015\u201d) &amp; TIMEVALUE(\u201c6:00 AM\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6239 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/datevalue-timevalue-functions-1-300x93-1.png\" width=\"300\" height=\"93\" title=\"datevalue-timevalue-functions-1-300x93-1\"><\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd.<\/strong> V\u00ec d\u00e3y s\u1ed1 c\u1ee7a Excel b\u1eaft \u0111\u1ea7u t\u1eeb ng\u00e0y 1 th\u00e1ng 1 n\u0103m 1900 v\u00e0 s\u1ed1 \u00e2m s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c ghi nh\u1eadn, nh\u1eefng ng\u00e0y th\u00e1ng tr\u01b0\u1edbc n\u0103m 1900 s\u1ebd kh\u00f4ng th\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u00e0nh s\u1ed1 tr\u00ean Excel.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111i\u1ec1n th\u00f4ng tin \u0111\u00f3 v\u00e0o trang t\u00ednh, v\u00ed d\u1ee5 nh\u01b0 ng\u00e0y 12\/31\/1899 (t\u1ee9c ng\u00e0y 31 th\u00e1ng 12 n\u0103m 1899, trong Excel th\u00e1ng s\u1ebd hi\u1ec3n th\u1ecb tr\u01b0\u1edbc), n\u00f3 s\u1ebd hi\u1ec3n th\u1ecb l\u00e0 gi\u00e1 tr\u1ecb ch\u1eef thay v\u00ec l\u00e0 ng\u00e0y th\u00e1ng, ngh\u0129a l\u00e0 b\u1ea1n kh\u00f4ng th\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u00e0nh s\u1ed1 theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng. \u0110\u1ec3 ch\u1eafc ch\u1eafn, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c =DATEVALUE(\u201c12\/31\/1899\u201d), k\u1ebft qu\u1ea3 nh\u1eadn l\u1ea1i s\u1ebd l\u00e0<a href=\"http:\/\/blog.ezworkapp.com\/xu-ly-loi-cong-thuc-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\"> l\u1ed7i #VALUE!<\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dinh_dang_ngay_thang_mac_dinh_trong_Excel\"><\/span>\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng m\u1eb7c \u0111\u1ecbnh trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi th\u00f4ng tin ng\u00e0y th\u00e1ng tr\u00ean Excel, nh\u1eefng \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng d\u00e0i ho\u1eb7c ng\u1eafn s\u1ebd \u0111\u01b0\u1ee3c quy \u0111\u1ecbnh d\u1ef1a tr\u00ean c\u00e0i \u0111\u1eb7t khu v\u1ef1c c\u1ee7a Windows. Nh\u1eefng \u0111\u1ecbnh d\u1ea1ng m\u1eb7c \u0111\u1ecbnh n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng d\u1ea5u hoa th\u1ecb (*) trong h\u1ed9p tho\u1ea1i <strong>Format Cells.<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6242 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-default-date-formats-300x261-1.png\" width=\"300\" height=\"261\" title=\"excel-default-date-formats-300x261-1\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong h\u1ed9p tho\u1ea1i <em>Format Cells<\/em> s\u1ebd thay \u0111\u1ed5i n\u1ebfu b\u1ea1n thay \u0111\u1ed5i c\u00e0i \u0111\u1eb7t ng\u00e0y th\u00e1ng m\u1eb7c \u0111\u1ecbnh c\u1ee7a Windows trong Control Panel.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_thay_doi_dinh_dang_ngay_thang_va_thoi_gian_trong_Excel\"><\/span>C\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i nh\u1eefng \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian m\u1eb7c \u0111\u1ecbnh trong m\u00e1y t\u00ednh, v\u00ed d\u1ee5 nh\u01b0 ng\u00e0y th\u00e1ng theo ki\u1ec3u M\u1ef9 th\u00e0nh ki\u1ec3u Anh, h\u00e3y v\u00e0o Control Panel v\u00e0 v\u00e0o ph\u1ea7n <strong>Region and Language<\/strong>. N\u1ebfu h\u1ed9p Control Panel c\u1ee7a b\u1ea1n m\u1edf trong ph\u1ea7n Category, b\u1ea1n h\u00e3y v\u00e0o ph\u1ea7n <em>Clock, Language and Region &gt; Region and Language &gt; Change the date, time, or number format.<\/em><\/p>\n<p style=\"text-align: justify\">Trong tab <em>Formats<\/em>, ch\u1ecdn khu v\u1ef1c ph\u00f9 h\u1ee3p trong danh s\u00e1ch c\u1ee7a Windows theo \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6234 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-default-date-format-300x269-1.png\" width=\"300\" height=\"269\" title=\"change-default-date-format-300x269-1\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:<strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-chinh-dung-dinh-dang-ngay-thang-nam-trong-excel.html\">\u00a0\u0110\u1ecbnh d\u1ea1ng Ng\u00e0y Th\u00e1ng N\u0103m trong Excel<\/a><\/strong> \u0111\u00fang c\u00e1ch<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>M\u1eb9o.<\/strong> N\u1ebfu b\u1ea1n kh\u00f4ng ch\u1eafc ch\u1eafn nh\u1eefng k\u00fd hi\u1ec7u mmm, ddd, yyy c\u00f3 \u00fd ngh\u0129a th\u1ebf n\u00e0o, b\u1ea1n h\u00e3y click v\u00e0o \u0111\u01b0\u1eddng link <em>\u201cWhat does the notation mean\u201d<\/em> d\u01b0\u1edbi ph\u1ea7n <em>Date and time formats.<\/em><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n kh\u00f4ng v\u1eeba \u00fd v\u1edbi b\u1ea5t c\u1ee9 \u0111\u1ecbnh d\u1ea1ng n\u00e0o c\u00f3 trong ph\u1ea7n <em>Formats<\/em>, v\u00e0o ph\u1ea7n <strong>Additional settings<\/strong> \u1edf ph\u00eda b\u00ean ph\u1ea3i d\u01b0\u1edbi c\u00f9ng c\u1ee7a h\u1ed9p tho\u1ea1i <em>Region and Language<\/em>. H\u1ed9p tho\u1ea1i <em>Customize<\/em> s\u1ebd hi\u1ec7n ra, sau \u0111\u00f3 b\u1ea1n chuy\u1ec3n sang tab <strong>Date<\/strong> v\u00e0 nh\u1eadp \u0111\u1ecbnh d\u1ea1ng mong mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6238 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-default-date-excel-245x300-1.png\" width=\"245\" height=\"300\" title=\"custom-default-date-excel-245x300-1\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_ap_dung_nhanh_dinh_dang_ngay_thang_va_thoi_gian_mac_dinh_tren_Excel\"><\/span>C\u00e1ch \u00e1p d\u1ee5ng nhanh \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian m\u1eb7c \u0111\u1ecbnh tr\u00ean Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Excel c\u00f3 hai \u0111\u1ecbnh d\u1ea1ng cho ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian \u2013 d\u00e0i v\u00e0 ng\u1eafn.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong Excel theo c\u00e0i \u0111\u1eb7t m\u1eb7c \u0111\u1ecbnh, b\u1ea1n h\u00e3y l\u00e0m nh\u01b0 sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn ng\u00e0y th\u00e1ng b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng.<\/li>\n<li>\u1ede tab <em>Home<\/em>, trong ph\u1ea7n <em>Number<\/em>, click v\u00e0o d\u1ea5u m\u0169i t\u00ean ngay c\u1ea1nh \u00f4 <strong>Number Format<\/strong>, ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng b\u1ea1n mu\u1ed1n \u2013 short date, long date ho\u1eb7c time.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-6243 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-default-date-time-formats-1-153x300-1.png\" width=\"153\" height=\"300\" title=\"excel-default-date-time-formats-1-153x300-1\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n nhi\u1ec1u s\u1ef1 l\u1ef1a ch\u1ecdn h\u01a1n, ch\u1ecdn <em>More Number Formats<\/em> t\u1eeb danh s\u00e1ch ho\u1eb7c ch\u1ecdn <em>Dialog Box Launcher<\/em> ngay c\u1ea1nh ph\u1ea7n <em>Number<\/em>. C\u00e1ch n\u00e0y s\u1ebd m\u1edf m\u1ed9t h\u1ed9p tho\u1ea1i <em>Format Cells<\/em> t\u01b0\u01a1ng t\u1ef1 nh\u01b0 tr\u00ean v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i m\u1eb7c \u0111\u1ecbnh trong \u0111\u00f3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6244 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/format-cells-launcher.png\" width=\"148\" height=\"171\" title=\"format-cells-launcher\"><\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o.<\/strong> N\u1ebfu b\u1ea1n mu\u1ed1n nhanh ch\u00f3ng thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng tr\u00ean Excel th\u00e0nh <em>dd-mmm-yy<\/em>, h\u00e3y nh\u1ea5n <code class=\"excel-formula-inline\"><em><strong>Ctrl + Shift + #<\/strong><\/em><\/code>. H\u00e3y l\u01b0u \u00fd r\u1eb1ng c\u00e1ch l\u00e0m t\u1eaft n\u00e0y s\u1ebd \u00e1p d\u1ee5ng \u00e1p d\u1ee5ng cho \u0111\u1ecbnh d\u1ea1ng <strong>dd-mmm-yy,<\/strong> nh\u01b0 01-Jan-15, kh\u00f4ng quan tr\u1ecdng \u0111\u1ecbnh d\u1ea1ng m\u1eb7c \u0111\u1ecbnh c\u1ee7a Windows l\u00e0 g\u00ec.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_thay_doi_dinh_dang_ngay_thang_tren_Excel\"><\/span>C\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng tr\u00ean Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong Excel, ng\u00e0y th\u00e1ng s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb theo nhi\u1ec1u c\u00e1ch. Khi thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong 1 \u00f4 hay nhi\u1ec1u \u00f4, c\u00e1ch d\u1ec5 d\u00e0ng nh\u1ea5t l\u00e0 m\u1edf h\u1ed9p tho\u1ea1i <strong>Format Cells<\/strong> v\u00e0 ch\u1ecdn m\u1ed9t trong nh\u1eefng \u0111\u1ecbnh d\u1ea1ng d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\">1. Ch\u1ecdn ng\u00e0y th\u00e1ng m\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng, ho\u1eb7c \u00f4 tr\u1ed1ng m\u00e0 b\u1ea1n mu\u1ed1n \u0111i\u1ec1n ng\u00e0y th\u00e1ng.<br \/>\n2. Nh\u1ea5n <code class=\"excel-formula-inline\"><em><strong>Ctrl + 1<\/strong><\/em><\/code> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <em>Format Cells<\/em>. Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 click chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 \u0111\u00f3 v\u00e0 ch\u1ecdn <em>Format Cells<\/em>.<br \/>\n3. Trong c\u1eeda s\u1ed1 <em>Format Cells<\/em>, ch\u1ecdn tab <em>Number<\/em> v\u00e0 <strong>Date<\/strong> \u1edf b\u1ea3ng <em>Category<\/em>.<br \/>\n4. Trong ph\u1ea7n <em>Type<\/em>, ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng m\u00e0 b\u1ea1n mong mu\u1ed1n, khi \u0111\u00f3 trong \u00f4 <em>Sample<\/em> s\u1ebd hi\u1ec3n th\u1ecb v\u00ed d\u1ee5 t\u01b0\u01a1ng \u1ee9ng v\u1edbi ng\u00e0y th\u00e1ng b\u1ea1n \u0111\u00e3 nh\u1eadp v\u00e0o \u00f4.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6235 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-excel-date-format-300x261-1.png\" width=\"300\" height=\"261\" title=\"change-excel-date-format-300x261-1\"><\/p>\n<p style=\"text-align: justify\">5. Khi b\u1ea1n \u0111\u00e3 v\u1eeba \u00fd, click <em>OK<\/em> \u0111\u1ec3 l\u01b0u thay \u0111\u1ed5i v\u00e0 \u0111\u00f3ng c\u1eeda s\u1ed5.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu \u0111\u1ecbnh d\u1ea1ng kh\u00f4ng thay \u0111\u1ed5i, c\u00f3 th\u1ec3 l\u00e0 do ng\u00e0y th\u00e1ng b\u1ea1n \u0111i\u1ec1n v\u00e0o \u0111\u00e3 b\u1ecb coi l\u00e0 v\u0103n b\u1ea3n (text) v\u00e0 b\u1ea1n s\u1ebd c\u1ea7n chuy\u1ec3n n\u00f3 th\u00e0nh d\u1ea1ng ng\u00e0y th\u00e1ng tr\u01b0\u1edbc.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_chuyen_doi_dinh_dang_ngay_thang_theo_vi_tri_khu_vuc\"><\/span>C\u00e1ch chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng theo v\u1ecb tr\u00ed khu v\u1ef1c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong Excel, b\u1ea1n c\u00f3 1 lo\u1ea1t nh\u1eefng ng\u00e0y th\u00e1ng v\u1edbi \u0111\u1ecbnh d\u1ea1ng l\u1ed9n x\u1ed9n v\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i ch\u00fang cho \u0111\u1ed3ng b\u1ed9. V\u00ed d\u1ee5 nh\u01b0 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng theo ki\u1ec3u M\u1ef9 (th\u00e1ng\/ng\u00e0y\/n\u0103m) th\u00e0nh ki\u1ec3u Ch\u00e2u \u00c2u (ng\u00e0y\/th\u00e1ng n\u0103m), b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1ch th\u1ee9c sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn \u00f4 c\u00f3 ng\u00e0y th\u00e1ng b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng<\/li>\n<li>Ch\u1ecdn <code class=\"excel-formula-inline\"><strong>Ctrl+1<\/strong><\/code> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <em>Format Cells<\/em>.<\/li>\n<li>Ch\u1ecdn v\u1ecb tr\u00ed \u1edf ph\u1ea7n Locale (location) trong h\u1ed9p tho\u1ea1i v\u00e0 click OK \u0111\u1ec3 l\u01b0u thay \u0111\u1ed5i. B\u1ea1n c\u00f3 th\u1ec3 xem tr\u01b0\u1edbc \u0111\u1ecbnh d\u1ea1ng trong ph\u1ea7n sample tr\u01b0\u1edbc khi nh\u1ea5n OK nh\u00e9.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6233 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-date-format-other-language-300x261-1.png\" width=\"300\" height=\"261\" title=\"change-date-format-other-language-300x261-1\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n ng\u00e0y th\u00e1ng hi\u1ec3n th\u1ecb theo ng\u00f4n ng\u1eef kh\u00e1c nhau, b\u1ea1n s\u1ebd ph\u1ea3i t\u1ea1o \u0111\u1ecbnh d\u1ea1ng \u0111\u1eb7c bi\u1ec7t v\u1edbi m\u00e3 khu v\u1ef1c.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tao_dinh_dang_ngay_thang_dac_biet_trong_Excel\"><\/span>C\u00e1ch t\u1ea1o \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng \u0111\u1eb7c bi\u1ec7t trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n th\u1ea5y r\u1eb1ng kh\u00f4ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 s\u1eb5n n\u00e0o trong Excel ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u1ef1 t\u1ea1o \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ri\u00eang m\u00ecnh.<\/p>\n<p style=\"text-align: justify\">1. Trong file Excel, ch\u1ecdn \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng<br \/>\n2. Nh\u1ea5n <code class=\"excel-formula-inline\"><em><strong>Ctrl + 1<\/strong><\/em><\/code> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Format Cells.<br \/>\n3. \u1ede tab <em>Number<\/em>, b\u1ea1n ch\u1ecdn <strong>Custom<\/strong> \u1edf b\u1ea3ng <em>Category<\/em> v\u00e0 \u0111i\u1ec1n \u0111\u1ecbnh d\u1ea1ng b\u1ea1n mu\u1ed1n trong \u00f4 <strong>Type<\/strong> b\u00ean c\u1ea1nh.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-6236 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-date-format-excel-300x233-1.png\" width=\"300\" height=\"233\" title=\"custom-date-format-excel-300x233-1\"><\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o<\/strong>. C\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 t\u1ea1o \u0111\u1ecbnh d\u1ea1ng m\u1edbi l\u00e0 b\u1eaft \u0111\u1ea7u t\u1eeb \u0111\u1ecbnh d\u1ea1ng c\u00f3 s\u1eb5n v\u00e0 g\u1ea7n gi\u1ed1ng nh\u1ea5t v\u1edbi \u0111\u1ecbnh d\u1ea1ng m\u00e0 b\u1ea1n mu\u1ed1n. \u0110\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y, h\u00e3y v\u00e0o \u00f4 <strong>Date<\/strong> trong b\u1ea3ng <em>Category<\/em> tr\u01b0\u1edbc, ch\u1ecdn m\u1ed9t trong nh\u1eefng \u0111\u1ecbnh d\u1ea1ng c\u00f3 s\u1eb5n trong \u00f4 <em>Type<\/em>. Sau \u0111\u00f3 b\u1ea1n h\u00e3y v\u00e0o <em>Custom<\/em> v\u00e0 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng m\u00e0 b\u1ea1n mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\">Khi t\u1ea1o \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong Excel, b\u1ea1n h\u00e3y d\u00f9ng nh\u1eefng k\u00fd hi\u1ec7u sau:<\/p>\n<table style=\"height: 37px\" width=\"805\">\n<tbody>\n<tr style=\"height: 24px\">\n<td style=\"width: 261px;height: 24px\">m<\/td>\n<td style=\"width: 261px;height: 24px\">S\u1ed1 th\u00e1ng kh\u00f4ng c\u00f3 s\u1ed1 0 \u0111\u1ee9ng tr\u01b0\u1edbc<\/td>\n<td style=\"width: 261px;height: 24px\">1<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 261px;height: 24px\">mm<\/td>\n<td style=\"width: 261px;height: 24px\">S\u1ed1 th\u00e1ng c\u00f3 s\u1ed1 0 \u0111\u1ee9ng tr\u01b0\u1edbc<\/td>\n<td style=\"width: 261px;height: 24px\">01<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 261px;height: 24px\">mmm<\/td>\n<td style=\"width: 261px;height: 24px\">T\u00ean th\u00e1ng \u1edf d\u1ea1ng ng\u1eafn<\/td>\n<td style=\"width: 261px;height: 24px\">Jan<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 261px;height: 24px\">mmmm<\/td>\n<td style=\"width: 261px;height: 24px\">T\u00ean th\u00e1ng \u1edf d\u1ea1ng \u0111\u1ea7y \u0111\u1ee7<\/td>\n<td style=\"width: 261px;height: 24px\">January<\/td>\n<\/tr>\n<tr style=\"height: 48px\">\n<td style=\"width: 261px;height: 48px\">mmmmm<\/td>\n<td style=\"width: 261px;height: 48px\">T\u00ean th\u00e1ng k\u00fd hi\u1ec7u b\u1eb1ng ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean<\/td>\n<td style=\"width: 261px;height: 48px\">J (k\u00fd hi\u1ec7u cho January, June and July)<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 261px;height: 24px\">d<\/td>\n<td style=\"width: 261px;height: 24px\">Ng\u00e0y kh\u00f4ng c\u00f3 s\u1ed1 0 \u0111\u1ee9ng tr\u01b0\u1edbc<\/td>\n<td style=\"width: 261px;height: 24px\">1<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 261px;height: 24px\">dd<\/td>\n<td style=\"width: 261px;height: 24px\">Ng\u00e0y c\u00f3 s\u1ed1 0 \u0111\u1ee9ng tr\u01b0\u1edbc<\/td>\n<td style=\"width: 261px;height: 24px\">01<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 261px;height: 24px\">ddd<\/td>\n<td style=\"width: 261px;height: 24px\">T\u00ean th\u1ee9 \u1edf d\u1ea1ng ng\u1eafn<\/td>\n<td style=\"width: 261px;height: 24px\">Mon<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 261px;height: 24px\">dddd<\/td>\n<td style=\"width: 261px;height: 24px\">T\u00ean th\u1ee9 \u1edf d\u1ea1ng d\u00e0i<\/td>\n<td style=\"width: 261px;height: 24px\">Monday<\/td>\n<\/tr>\n<tr style=\"height: 24.9688px\">\n<td style=\"width: 261px;height: 24.9688px\">yy<\/td>\n<td style=\"width: 261px;height: 24.9688px\">N\u0103m v\u1edbi 2 con s\u1ed1<\/td>\n<td style=\"width: 261px;height: 24.9688px\">05<\/td>\n<\/tr>\n<tr style=\"height: 24.9688px\">\n<td style=\"width: 261px;height: 24.9688px\">yyyy<\/td>\n<td style=\"width: 261px;height: 24.9688px\">N\u0103m v\u1edbi 4 con s\u1ed1<\/td>\n<td style=\"width: 261px;height: 24.9688px\">2005<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">Khi t\u1ea1o \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian trong Excel, b\u1ea1n h\u00e3y d\u00f9ng nh\u1eefng k\u00fd hi\u1ec7u sau:<\/p>\n<table style=\"height: 21px\" width=\"803\">\n<tbody>\n<tr style=\"height: 24px\">\n<td style=\"width: 260px;height: 24px\">h<\/td>\n<td style=\"width: 260px;height: 24px\">Gi\u1edd kh\u00f4ng c\u00f3 s\u1ed1 kh\u00f4ng \u0111\u1eb1ng tr\u01b0\u1edbc<\/td>\n<td style=\"width: 261px;height: 24px\">0-23<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 260px;height: 24px\">hh<\/td>\n<td style=\"width: 260px;height: 24px\">Gi\u1edd kh\u00f4ng c\u00f3 s\u1ed1 kh\u00f4ng \u0111\u1eb1ng tr\u01b0\u1edbc<\/td>\n<td style=\"width: 261px;height: 24px\">00-23<\/td>\n<\/tr>\n<tr style=\"height: 48px\">\n<td style=\"width: 260px;height: 48px\">m<\/td>\n<td style=\"width: 260px;height: 48px\">Ph\u00fat kh\u00f4ng c\u00f3 s\u1ed1 kh\u00f4ng \u0111\u1eb1ng tr\u01b0\u1edbc<\/td>\n<td style=\"width: 261px;height: 48px\">0-59<\/td>\n<\/tr>\n<tr style=\"height: 24.9688px\">\n<td style=\"width: 260px;height: 24.9688px\">mm<\/td>\n<td style=\"width: 260px;height: 24.9688px\">Ph\u00fat c\u00f3 s\u1ed1 kh\u00f4ng \u0111\u1eb1ng tr\u01b0\u1edbc<\/td>\n<td style=\"width: 261px;height: 24.9688px\">00-59<\/td>\n<\/tr>\n<tr style=\"height: 24.9688px\">\n<td style=\"width: 260px;height: 24.9688px\">s<\/td>\n<td style=\"width: 260px;height: 24.9688px\">Gi\u00e2y c\u00f3 s\u1ed1 kh\u00f4ng \u0111\u1eb1ng tr\u01b0\u1edbc<\/td>\n<td style=\"width: 261px;height: 24.9688px\">0-59<\/td>\n<\/tr>\n<tr style=\"height: 24.9688px\">\n<td style=\"width: 260px;height: 24.9688px\">ss<\/td>\n<td style=\"width: 260px;height: 24.9688px\">Gi\u00e2y kh\u00f4ng c\u00f3 s\u1ed1 kh\u00f4ng \u0111\u1eb1ng tr\u01b0\u1edbc<\/td>\n<td style=\"width: 261px;height: 24.9688px\">00-59<\/td>\n<\/tr>\n<tr style=\"height: 24.9688px\">\n<td style=\"width: 260px;height: 24.9688px\">AM\/PM<\/td>\n<td style=\"width: 260px;height: 24.9688px\">Th\u1eddi \u0111i\u1ec3m s\u00e1ng\/ chi\u1ec1u trong ng\u00e0y<\/td>\n<td style=\"width: 261px;height: 24.9688px\">6AM or 6PM<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\"><strong>M\u1eb9o<\/strong>. N\u1ebfu b\u1ea1n \u0111\u1ecbnh t\u1ea1o m\u1ed9t \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 b\u1ea1n d\u00f9ng k\u00fd hi\u1ec7u \u201cm\u201d ngay sau \u201chh\u201d ho\u1eb7c \u201ch\u201d ho\u1eb7c ngay tr\u01b0\u1edbc \u201css\u201d ho\u1eb7c \u201cs\u201d, Excel s\u1ebd hi\u1ec3n th\u1ecb k\u00fd hi\u1ec7u n\u00e0y l\u00e0 ph\u00fat ch\u1ee9 kh\u00f4ng ph\u1ea3i l\u00e0 th\u00e1ng.<\/p>\n<p style=\"text-align: justify\">Khi t\u1ea1o \u0111\u1ecbnh d\u1ea1ng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng d\u1ea5u ph\u1ea9y, d\u1ea5u g\u1ea1ch ngang, d\u1ea5u g\u1ea1ch ch\u00e9o v\u00e0 d\u1ea5u hai ch\u1ea5m nh\u00e9.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, c\u00f9ng l\u00e0 January 13, 2015 13:03 nh\u01b0ng c\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch hi\u1ec3n th\u1ecb th\u00f4ng tin n\u00e0y:<\/p>\n<table style=\"height: 5px\" width=\"804\">\n<tbody>\n<tr style=\"height: 24px\">\n<td style=\"width: 394px;height: 24px\">dd-mmm-yy<\/td>\n<td style=\"width: 394px;height: 24px\">13-Jan-15<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 394px;height: 24px\">mm\/dd\/yyyy<\/td>\n<td style=\"width: 394px;height: 24px\">01\/13\/2015<\/td>\n<\/tr>\n<tr style=\"height: 24.9688px\">\n<td style=\"width: 394px;height: 24.9688px\">m\/dd\/yy<\/td>\n<td style=\"width: 394px;height: 24.9688px\">1\/13\/15<\/td>\n<\/tr>\n<tr style=\"height: 24.9688px\">\n<td style=\"width: 394px;height: 24.9688px\">dddd, m\/d\/yy h:mm AM\/PM<\/td>\n<td style=\"width: 394px;height: 24.9688px\">Tuesday, 1\/13\/15 1:03 PM<\/td>\n<\/tr>\n<tr style=\"height: 24.9688px\">\n<td style=\"width: 394px;height: 24.9688px\">ddd, mmmm dd, yyyy hh:mm:ss<\/td>\n<td style=\"width: 394px;height: 24.9688px\">Tue, January 13, 2015 13:03:00<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_tao_dinh_dang_ngay_thang_tren_Excel_doi_voi_nhung_dia_diem_khac_nhau\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng tr\u00ean Excel \u0111\u1ed1i v\u1edbi nh\u1eefng \u0111\u1ecba \u0111i\u1ec3m kh\u00e1c nhau?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n ng\u00e0y th\u00e1ng c\u1ee7a m\u00ecnh hi\u1ec3n th\u1ecb theo ng\u00f4n ng\u1eef kh\u00e1c, b\u1ea1n s\u1ebd ph\u1ea3i t\u1ea1o ra \u0111\u1ecbnh d\u1ea1ng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c k\u00fd hi\u1ec7u khu v\u1ef1c t\u01b0\u01a1ng \u1ee9ng. K\u00fd hi\u1ec7u khu v\u1ef1c n\u00ean \u0111\u01b0\u1ee3c \u0111\u1ec3 trong d\u1ea5u ngo\u1eb7c vu\u00f4ng, \u0111i k\u00e8m v\u1edbi k\u00fd hi\u1ec7u $ v\u00e0 d\u1ea5u g\u1ea1ch ngang, v\u00ed d\u1ee5 nh\u01b0:<\/p>\n<p style=\"text-align: justify\">[$-409] \u2013 Ti\u1ebfng Anh ki\u1ec3u M\u1ef9<br \/>\n[$-1009] \u2013 Ti\u1ebfng Anh ki\u1ec3u Canada<br \/>\n[$-407] \u2013 Ti\u1ebfng \u0110\u1ee9c ki\u1ec3u \u0110\u1ee9c<br \/>\n[$-807] \u2013 Ti\u1ebfng \u0110\u1ee9c ki\u1ec3u Th\u1ee5y S\u0129<br \/>\n[$-804] \u2013 Ti\u1ebfng Bengali \u1ea4n \u0110\u1ed9<br \/>\n[$-804] \u2013 Ti\u1ebfng Trung t\u1ea1i Trung Qu\u1ed1c<br \/>\n[$-404] \u2013 Ti\u1ebfng Trung t\u1ea1i \u0110\u00e0i Loan<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 c\u00f3 m\u1ed9t danh s\u00e1ch \u0111\u1ea7y \u0111\u1ee7 \u0111\u1ecba \u0111i\u1ec3m t\u1ea1i <a href=\"http:\/\/blog.csdn.net\/2066\/article\/details\/45555\">b\u00e0i vi\u1ebft<\/a> n\u00e0y nh\u00e9.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, b\u1ea1n mu\u1ed1n t\u1ea1o m\u1ed9t \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng theo ki\u1ec3u Trung Qu\u1ed1c v\u1edbi th\u1ee9 t\u1ef1 n\u0103m-th\u00e1ng-ng\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1n th\u00f4ng tin nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6237 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-date-locale-code-300x261-1.png\" width=\"300\" height=\"261\" title=\"custom-date-locale-code-300x261-1\"><\/p>\n<p style=\"text-align: justify\">Trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y s\u1ebd l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5 v\u1ec1 ng\u00e0y th\u00e1ng v\u1edbi nh\u1eefng m\u00e3 \u0111\u1ecba \u0111i\u1ec3m kh\u00e1c nhau t\u01b0\u01a1ng \u1ee9ng v\u1edbi nh\u1eefng ng\u00f4n ng\u1eef kh\u00e1c nhau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6241 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dates-different-locales-300x61-1.png\" width=\"300\" height=\"61\" title=\"excel-dates-different-locales-300x61-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Chen_ngay_thang_trong_Excel_de_dang_voi_Calendar_Control\"><\/span>Ch\u00e8n ng\u00e0y th\u00e1ng trong Excel d\u1ec5 d\u00e0ng v\u1edbi Calendar Control<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1eafc m\u1eafc c\u00e1ch n\u00e0o \u0111\u1ec3<strong> ch\u00e8n ng\u00e0y th\u00e1ng trong excel<\/strong> d\u1ec5 d\u00e0ng nh\u1ea5t ch\u01b0a? Ch\u1ec9 v\u1edbi c\u00f4ng c\u1ee5 Calendar Control c\u00f3 s\u1eb5n trong Excel\u00a0b\u1ea1n s\u1ebd ch\u00e8n \u0111\u01b0\u1ee3c ng\u00e0y th\u00e1ng trong ch\u01b0a t\u1edbi 30 gi\u00e2y.<\/p>\n<p>Xem video \u0111\u1ec3 bi\u1ebft c\u00e1ch download<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/2sMWMHQ1Rjs\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dinh_dang_cua_Excel_khong_hoat_dong_%E2%80%93_giai_phap\"><\/span>\u0110\u1ecbnh d\u1ea1ng c\u1ee7a Excel kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng \u2013 gi\u1ea3i ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Th\u00f4ng th\u01b0\u1eddng, Excel s\u1ebd x\u1eed l\u00fd th\u00f4ng tin d\u1eef li\u1ec7u r\u1ea5t t\u1ed1t v\u00e0 kh\u00f4ng c\u00f3 b\u1ea5t c\u1ee9 m\u1ed9t v\u1ea5n \u0111\u1ec1 n\u00e0o x\u1ea3y ra. Tuy nhi\u00ean, n\u1ebfu b\u1ea1n kh\u00f4ng thi\u1ebft l\u1eadp \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng, h\u00e3y th\u1eed xem x\u00e9t nh\u1eefng m\u1eb9o sau.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"O_khong_du_rong_de_chua_toan_bo_thong_tin\"><\/span>\u00d4 kh\u00f4ng \u0111\u1ee7 r\u1ed9ng \u0111\u1ec3 ch\u1ee9a to\u00e0n b\u1ed9 th\u00f4ng tin<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n th\u1ea5y \u00f4 hi\u1ec3n th\u1ecb m\u1ed9t lo\u1ea1t d\u1ea5u ##### thay v\u00ec ng\u00e0y th\u00e1ng, c\u00f3 kh\u1ea3 n\u0103ng \u00f4 kh\u00f4ng \u0111\u1ee7 r\u1ed9ng \u0111\u1ec3 ch\u1ee9a th\u00f4ng tin.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3i ph\u00e1p. Click chu\u1ed9t \u0111\u00f4i v\u00e0o c\u1ea1nh b\u00ean ph\u1ea3i c\u1ee7a \u00f4 \u0111\u1ec3 thay \u0111\u1ed5i k\u00edch c\u1ee1 v\u1eeba v\u1eb7n v\u1edbi th\u00f4ng tin, ho\u1eb7c d\u00f9ng chu\u1ed9t k\u00e9o c\u1ea1nh b\u00ean ph\u1ea3i c\u1ee7a \u00f4 sang b\u00ean ph\u1ea3i cho \u0111\u1ebfn khi \u00f4 \u0111\u1ee7 r\u1ed9ng.<\/p>\n<p style=\"text-align: justify\">S\u1ed1 \u00e2m tr\u1edf th\u00e0nh ng\u00e0y th\u00e1ng<\/p>\n<p style=\"text-align: justify\">Trong c\u00e1ch phi\u00ean b\u1ea3n Excel 2010, 2013 v\u00e0 2017, d\u00e3y ##### c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n n\u1ebfu m\u1ed9t \u00f4 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng nh\u01b0ng l\u1ea1i c\u00f3 ch\u1ee9a m\u1ed9t gi\u00e1 tr\u1ecb \u00e2m. Th\u00f4ng th\u01b0\u1eddng \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c nh\u01b0ng c\u0169ng c\u00f3 th\u1ec3 x\u1ea3y ra khi b\u1ea1n \u0111i\u1ec1n m\u1ed9t gi\u00e1 tr\u1ecb \u00e2m v\u00e0o \u00f4 v\u00e0 sau \u0111\u00f3 \u0111\u1ecbnh d\u1ea1ng \u00f4 th\u00e0nh ng\u00e0y th\u00e1ng. N\u1ebfu b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb s\u1ed1 \u00e2m th\u00e0nh ng\u00e0y \u00e2m, c\u00f3 hai l\u1ef1a ch\u1ecdn cho b\u1ea1n.<\/p>\n<p style=\"text-align: justify\"><strong>Gi\u1ea3i ph\u00e1p 1. \u0110\u1ed5i sang h\u1ec7 th\u1ed1ng ng\u00e0y th\u00e1ng 1904.<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00e0o <em>File &gt; Options &gt; Advanced<\/em>, k\u00e9o xu\u1ed1ng \u0111\u1ebfn ph\u1ea7n <em>When calculating this workbook<\/em>, \u0111\u00e1nh d\u1ea5u v\u00e0o \u00f4 <strong>Use 1904 date system<\/strong> v\u00e0 click <em>OK<\/em>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-6232 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1904-date-system-300x226-1.png\" width=\"300\" height=\"226\" title=\"1904-date-system-300x226-1\"><\/p>\n<p style=\"text-align: justify\">V\u1edbi h\u1ec7 th\u1ed1ng n\u00e0y, 0 is 1-Jan-1904; 1 l\u00e0 2-Jan-1904; v\u00e0 -1 s\u1ebd hi\u1ec3n th\u1ecb cho ng\u00e0y \u00e2m -2-Jan-1904.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6245 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/negative-dates-excel.png\" width=\"81\" height=\"122\" title=\"negative-dates-excel\"><\/p>\n<p style=\"text-align: justify\">\u0110\u01b0\u01a1ng nhi\u00ean, c\u00e1ch hi\u1ec3n th\u1ecb n\u00e0y r\u1ea5t b\u1ea5t th\u01b0\u1eddng v\u00e0 s\u1ebd c\u1ea7n th\u1eddi gian l\u00e0m quen, nh\u01b0ng s\u1ebd l\u00e0 c\u00e1ch ch\u00ednh x\u00e1c n\u1ebfu b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb ph\u00e9p t\u00ednh cho nh\u1eefng ng\u00e0y tr\u01b0\u1edbc \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\"><strong>Gi\u1ea3i ph\u00e1p 2. D\u00f9ng ch\u1ee9c n\u0103ng TEXT c\u1ee7a Excel<\/strong><\/p>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 hi\u1ec3n th\u1ecb s\u1ed1 \u00e2m l\u00e0 ng\u00e0y \u00e2m tr\u00ean Excel l\u00e0 d\u00f9ng ch\u1ee9c n\u0103ng TEXT. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n tr\u1eeb C1 cho B1 v\u00e0 gi\u00e1 tr\u1ecb t\u1ea1i C1 l\u1edbn h\u01a1n B1, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 c\u00f3 ra k\u1ebft qu\u1ea3 d\u01b0\u1edbi d\u1ea1ng ng\u00e0y th\u00e1ng:<br \/>\n<strong>=TEXT(ABS(B1-C1),\u201d-d-mmm-yyyy\u201d)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-6246 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/text-function-negative-dates-300x135-1.png\" width=\"300\" height=\"135\" title=\"text-function-negative-dates-300x135-1\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i th\u00e0nh c\u0103n l\u1ec1 ph\u1ea3i, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng b\u1ea5t c\u1ee9 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u00e0o do b\u1ea1n t\u1ef1 t\u1ea1o ra trong c\u00f4ng th\u1ee9c TEXT.<\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd.<\/strong> Kh\u00f4ng nh\u01b0 nh\u1eefng gi\u1ea3i ph\u00e1p tr\u01b0\u1edbc \u0111\u00f3, ch\u1ee9c n\u0103ng TEXT s\u1ebd ra k\u1ebft qu\u1ea3 l\u00e0 gi\u00e1 tr\u1ecb ch\u1eef, ch\u00ednh v\u00ec v\u1eady b\u1ea1n kh\u00f4ng th\u1ec3 d\u00f9ng k\u1ebft qu\u1ea3 \u0111\u00f3 trong nh\u1eefng ph\u00e9p t\u00ednh to\u00e1n kh\u00e1c.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Thoi_gian_duoc_nhap_vao_EXCEL_nhu_la_gia_tri_chu\"><\/span>Th\u1eddi gian \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o EXCEL nh\u01b0 l\u00e0 gi\u00e1 tr\u1ecb ch\u1eef<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Khi b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u t\u1eeb m\u1ed9t file .csv hay m\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u b\u00ean ngo\u00e0i n\u00e0o kh\u00e1c v\u00e0o Excel, th\u1eddi gian s\u1ebd th\u01b0\u1eddng c\u00f3 \u0111\u1ecbnh d\u1ea1ng ch\u1eef. Ch\u00fang tr\u00f4ng nh\u01b0 ng\u00e0y th\u00e1ng th\u00f4ng th\u01b0\u1eddng, nh\u01b0ng Excel coi ch\u00fang c\u00f3 d\u1ea1ng ch\u1eef (Text).<\/p>\n<p style=\"text-align: justify\"><strong>Gi\u1ea3i ph\u00e1p.<\/strong> B\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n \u201cng\u00e0y th\u00e1ng d\u1ea1ng ch\u1eef\u201d th\u00e0nh \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng chu\u1ea9n b\u1eb1ng c\u00e1ch d\u00f9ng ch\u1ee9c n\u0103ng DATEVALUE ho\u1eb7c Text to Columns.<\/p>\n<p style=\"text-align: justify\">Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u1ec3 thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong Excel. Trong nh\u1eefng ph\u1ea7n ti\u1ebfp theo, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n nh\u1eefng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dien-ngay-thang-vao-excel-thong-tin-ngay-thang-hien-tai-tu-dong-dien-ngay-thang-vao-cot.html\" target=\"_blank\" rel=\"noopener noreferrer\">c\u00e1ch \u0111\u1ec3 nh\u1eadp th\u00f4ng tin ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian v\u00e0o Excel<\/a>. Xin c\u1ea3m \u01a1n v\u00e0 h\u1eb9n g\u1eb7p l\u1ea1i c\u00e1c b\u1ea1n.<\/p>\n<p>\u0110\u1ec3 n\u00e2ng cao ki\u1ebfn th\u1ee9c Excel, b\u1ea1n h\u00e3y tham gia ngay kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a> c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong>. Trong kh\u00f3a h\u1ecdc n\u00e0y b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5: conditional formatting, data validation, pivot table\u2026 \u0111\u1ec3 \u1ee9ng d\u1ee5ng v\u00e0o trong c\u00f4ng vi\u1ec7c. Ngo\u00e0i ra b\u1ea1n c\u00f2n bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong excel, t\u1eeb c\u00e1c h\u00e0m c\u01a1 b\u1ea3n cho t\u1edbi c\u00e1c h\u00e0m n\u00e2ng cao, ph\u1ee9c t\u1ea1p. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"http:\/\/blog.ezworkapp.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">BlogHocExcel.Online<\/a><\/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-235.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6196,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6195","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\/6195","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=6195"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6195\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6196"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}