{"id":4873,"date":"2024-12-08T11:35:18","date_gmt":"2024-12-08T11:35:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/cach-tao-mau-bcc-lam-them-gio-theo-tt133-tren-excel-nam-2021\/"},"modified":"2024-12-08T11:35:18","modified_gmt":"2024-12-08T11:35:18","slug":"cach-tao-mau-bcc-lam-them-gio-theo-tt133-tren-excel-nam-2021","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/cach-tao-mau-bcc-lam-them-gio-theo-tt133-tren-excel-nam-2021\/","title":{"rendered":"C\u00e1ch t\u1ea1o m\u1eabu BCC l\u00e0m th\u00eam gi\u1edd theo TT133 tr\u00ean Excel n\u0103m 2021"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ngo\u00e0i vi\u1ec7c theo d\u00f5i, ch\u1ea5m c\u00f4ng l\u00e0m vi\u1ec7c trong th\u1eddi gian quy\u00a0\u0111\u1ecbnh, b\u1ed9 ph\u1eadn qu\u1ea3n l\u00fd lao\u00a0\u0111\u1ed9ng, ti\u1ec1n l\u01b0\u01a1ng, k\u1ebf to\u00e1n l\u01b0\u01a1ng c\u00f2n ph\u1ea3i theo d\u00f5i c\u1ea3 vi\u1ec7c ch\u1ea5m c\u00f4ng l\u00e0m th\u00eam gi\u1edd, l\u00e0m vi\u1ec7c ng\u00e0y ngh\u1ec9 tu\u1ea7n, l\u00e0m vi\u1ec7c ng\u00e0y l\u1ec5, l\u00e0m vi\u1ec7c ban\u00a0\u0111\u00eam. V\u1eady l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 x\u00e2y d\u1ef1ng m\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0m th\u00eam gi\u1edd tr\u00ean\u00a0Excel? C\u1ee5 th\u1ec3 h\u01a1n l\u00e0 <strong>c\u00e1ch t\u1ea1o <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tao-bang-cham-cong-tren-excel-chi-tiet-nhat.html\">m\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng<\/a> l\u00e0m th\u00eam gi\u1edd theo quy\u00a0\u0111\u1ecbnh c\u1ee7a th\u00f4ng t\u01b0 133\/2016\/TT-BTC\u00a0\u00e1p d\u1ee5ng cho n\u0103m 2018<\/strong> nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u nh\u00e9.<\/p>\n<p>K\u1ebft qu\u1ea3 ch\u00fang ta mong mu\u1ed1n\u00a0\u0111\u1ea1t\u00a0\u0111\u01b0\u1ee3c l\u00e0 1 m\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16618\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-bcc-them-gio-tt133-01.png\" width=\"1520\" height=\"568\" title=\"heo-bcc-them-gio-tt133-01\"><\/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-67558475e5856\" 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\/cach-tao-mau-bcc-lam-gio-theo-tt133-tren-excel-nam-2018.html#Buoc_1_Xac_dinh_bo_cuc_chung_cua_bang_cham_cong\" title=\"B\u01b0\u1edbc 1: X\u00e1c \u0111\u1ecbnh b\u1ed1 c\u1ee5c chung c\u1ee7a b\u1ea3ng ch\u1ea5m c\u00f4ng\">B\u01b0\u1edbc 1: X\u00e1c \u0111\u1ecbnh b\u1ed1 c\u1ee5c chung c\u1ee7a b\u1ea3ng ch\u1ea5m c\u00f4ng<\/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\/cach-tao-mau-bcc-lam-gio-theo-tt133-tren-excel-nam-2018.html#Buoc_2_Ham_Excel_xac_dinh_ngay_trong_thang\" title=\"B\u01b0\u1edbc 2: H\u00e0m\u00a0Excel x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y trong th\u00e1ng\">B\u01b0\u1edbc 2: H\u00e0m\u00a0Excel x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y trong 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\/cach-tao-mau-bcc-lam-gio-theo-tt133-tren-excel-nam-2018.html#Buoc_3_Xac_dinh_thu_theo_ngay\" title=\"B\u01b0\u1edbc 3: X\u00e1c\u00a0\u0111\u1ecbnh th\u1ee9 theo ng\u00e0y\">B\u01b0\u1edbc 3: X\u00e1c\u00a0\u0111\u1ecbnh th\u1ee9 theo ng\u00e0y<\/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-tao-mau-bcc-lam-gio-theo-tt133-tren-excel-nam-2018.html#Buoc_4_Phan_biet_ngay_chu_nhat_trong_thang\" title=\"B\u01b0\u1edbc 4: Ph\u00e2n bi\u1ec7t ng\u00e0y ch\u1ee7 nh\u1eadt trong th\u00e1ng\">B\u01b0\u1edbc 4: Ph\u00e2n bi\u1ec7t ng\u00e0y ch\u1ee7 nh\u1eadt trong th\u00e1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-mau-bcc-lam-gio-theo-tt133-tren-excel-nam-2018.html#Buoc_5_Cong_thuc_quy_ra_cong\" title=\"B\u01b0\u1edbc 5: C\u00f4ng th\u1ee9c quy ra c\u00f4ng\">B\u01b0\u1edbc 5: C\u00f4ng th\u1ee9c quy ra c\u00f4ng<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1_Xac_dinh_bo_cuc_chung_cua_bang_cham_cong\"><\/span>B\u01b0\u1edbc 1: X\u00e1c \u0111\u1ecbnh b\u1ed1 c\u1ee5c chung c\u1ee7a b\u1ea3ng ch\u1ea5m c\u00f4ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea3ng ch\u1ea5m c\u00f4ng theo th\u00f4ng t\u01b0 133\/2016\/TT-BTC\u00a0\u0111\u01b0\u1ee3c quy\u00a0\u0111\u1ecbnh theo m\u1eabu s\u1ed1 01a-L\u0110TL g\u1ed3m c\u00e1c ph\u1ea7n c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>Th\u00f4ng tin\u00a0\u0111\u01a1n v\u1ecb<\/strong>: g\u1ed3m t\u00ean,\u00a0\u0111\u1ecba ch\u1ec9 c\u1ee7a\u00a0\u0111\u01a1n v\u1ecb. M\u1ee5c n\u00e0y\u00a0\u0111\u1eb7t\u00a0\u1edf g\u00f3c tr\u00ean c\u00f9ng b\u00ean tr\u00e1i (2 d\u00f2ng)<\/li>\n<li><strong>T\u00ean ti\u00eau\u00a0\u0111\u1ec1<\/strong>: \u201cb\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0m th\u00eam gi\u1edd\u201d\u00a0\u0111\u1eb7t\u00a0\u1edf ch\u00ednh gi\u1eefa, d\u00f2ng ph\u00eda d\u01b0\u1edbi th\u00f4ng tin\u00a0\u0111\u01a1n v\u1ecb. Vi\u1ebft hoa to\u00e0n b\u1ed9\u00a0\u0111\u1ec3 l\u00e0m r\u00f5 n\u1ed9i dung n\u00e0y.<\/li>\n<li><strong>M\u1eabu b\u1ea3ng<\/strong>: Ph\u1ea7n n\u00e0y\u00a0\u0111\u1eb7t trong 1 Textbox (Insert\/Textbox). Khi\u00a0\u0111\u1eb7t trong Textbox th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 di chuy\u1ec3n to\u00e0n b\u1ed9\u00a0\u0111o\u1ea1n Text n\u00e0y v\u00e0\u00a0\u0111\u1eb7t v\u00e0o v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 m\u00e0 kh\u00f4ng ph\u1ea3i lo vi\u1ec7c\u00a0\u1ea3nh h\u01b0\u1edfng t\u1edbi c\u00e1c\u00a0\u00f4 trong Sheet<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16592\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-bcc-tt133-02.png\" width=\"721\" height=\"261\" title=\"heo-bcc-tt133-02\"><\/p>\n<ul>\n<li><strong>Th\u1eddi gian ch\u1ea5m c\u00f4ng<\/strong>: l\u00e0 th\u00e1ng n\u00e0o, n\u0103m n\u00e0o.\u00a0\u0110\u00e2y l\u00e0 c\u0103n c\u1ee9 ph\u00e2n bi\u1ec7t c\u00e1c b\u1ea3ng ch\u1ea5m c\u00f4ng c\u1ee7a c\u00e1c th\u00e1ng, c\u00e1c n\u0103m kh\u00e1c nhau.\u00a0\u0110\u1ed3ng th\u1eddi\u00a0\u0111\u00e2y c\u0169ng l\u00e0 c\u0103n c\u1ee9 ph\u00e2n bi\u1ec7t c\u00e1c ng\u00e0y trong th\u00e1ng. M\u1ed7i\u00a0\u00f4 ch\u1ee9a s\u1ed1\u00a0Th\u00e1ng, N\u0103m c\u1ea7n\u00a0\u0111\u1eb7t\u00a0\u1edf nh\u1eefng\u00a0\u00f4 ri\u00eang\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng l\u00e0m tham chi\u1ebfu\u00a0trong h\u00e0m\u00a0x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y trong th\u00e1ng.<\/li>\n<li><strong>N\u1ed9i dung b\u1ea3ng ch\u1ea5m c\u00f4ng<\/strong>: G\u1ed3m\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng ch\u1ea5m c\u00f4ng (h\u1ecd t\u00ean), ng\u00e0y c\u00f4ng trong th\u00e1ng (ng\u00e0y trong th\u00e1ng\u00a0\u0111\u1ec3 ghi nh\u1eadn ch\u1ea5m c\u00f4ng theo t\u1eebng ng\u00e0y) v\u00e0 k\u1ebft qu\u1ea3 ch\u1ea5m c\u00f4ng (quy ra c\u00f4ng). C\u0103n c\u1ee9 theo\u00a0\u0111\u1eb7c\u00a0\u0111i\u1ec3m\u00a0\u0111\u01a1n v\u1ecb\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh b\u1ea3ng ch\u1ea5m c\u00f4ng c\u00f3 bao nhi\u00eau d\u00f2ng, t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi vi\u1ec7c ch\u1ea5m c\u00f4ng cho bao nhi\u00eau ng\u01b0\u1eddi.<\/li>\n<li><strong>Th\u1eddi gian k\u00fd v\u00e0 ng\u01b0\u1eddi c\u00f3 tr\u00e1ch nhi\u1ec7m k\u00fd t\u00ean<\/strong>: B\u1ea3ng ch\u1ea5m c\u00f4ng\u00a0\u0111\u01b0\u1ee3c l\u1eadp ra b\u1edfi b\u1ed9 ph\u1eadn n\u00e0o, nh\u1eefng ai ch\u1ecbu tr\u00e1ch nhi\u1ec7m v\u1ec1 t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a k\u1ebft qu\u1ea3 ch\u1ea5m c\u00f4ng\u2026\u00a0\u0111\u1ec1u ph\u1ea3i k\u00fd t\u00ean tr\u00ean b\u1ea3ng ch\u1ea5m c\u00f4ng\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o c\u00e1c c\u01a1 s\u1edf ph\u00e1p l\u00fd cho vi\u1ec7c t\u00ednh l\u01b0\u01a1ng,\u00a0\u0111\u00e1nh gi\u00e1 lao\u00a0\u0111\u1ed9ng\u2026<\/li>\n<li><strong>K\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng<\/strong>: Trong th\u00f4ng t\u01b0 133 c\u00f3 quy\u00a0\u0111\u1ecbnh s\u1eb5n m\u1ed9t v\u00e0i k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng\u00a0\u0111\u1ec3 ch\u00fang ta c\u00f3 th\u1ec3 tham kh\u1ea3o v\u00e0 t\u00f9y theo\u00a0\u0111\u1eb7c th\u00f9\u00a0\u0111\u01a1n v\u1ecb, y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c v\u00e0 t\u00ednh ch\u1ea5t c\u00e1c lo\u1ea1i c\u00f4ng th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn c\u00e1c k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng ph\u00f9 h\u1ee3p.\u00a0\u0110\u00e2y l\u00e0 c\u0103n c\u1ee9\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh c\u00e1c lo\u1ea1i c\u00f4ng v\u00e0 t\u00ednh ra k\u1ebft qu\u1ea3 ch\u1ea5m c\u00f4ng.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2_Ham_Excel_xac_dinh_ngay_trong_thang\"><\/span><strong>B\u01b0\u1edbc 2<\/strong>: H\u00e0m\u00a0Excel x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y trong th\u00e1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1i d\u00f2ng 7 ch\u00fang ta c\u00f3 c\u00e1c ng\u00e0y trong th\u00e1ng, g\u1ed3m 31 c\u1ed9t b\u1eaft\u00a0\u0111\u1ea7u t\u1eeb c\u1ed9t\u00a0C t\u1edbi c\u1ed9t AG<\/p>\n<p>\u0110\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh c\u00e1c ng\u00e0y trong th\u00e1ng ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m DATE nh\u01b0 sau:<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-401.gif\" title=\"ex101_92019-nho-401\"><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-401.gif\" title=\"ex101_92019-nho-401\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>a. C\u1ea5u tr\u00fac h\u00e0m Date<\/strong><\/p>\n<p style=\"padding-left: 30px\">DATE(Year, Month, Day)<\/p>\n<ul>\n<li><strong>Year=N\u0103m<\/strong>: x\u00e1c\u00a0\u0111\u1ecbnh t\u1ea1i\u00a0\u00f4 F5<\/li>\n<li><strong>Month=Th\u00e1ng<\/strong>: x\u00e1c\u00a0\u0111\u1ecbnh t\u1ea1i\u00a0\u00f4 C5<\/li>\n<li><strong>Day=Ng\u00e0y<\/strong>: t\u1ea1i\u00a0\u00f4 C7 ch\u00fang ta c\u00f3 ng\u00e0y\u00a0\u0111\u1ea7u ti\u00ean l\u00e0 ng\u00e0y 1<\/li>\n<\/ul>\n<p><strong>b. X\u00e1c\u00a0\u0111\u1ecbnh c\u00e1c ng\u00e0y trong th\u00e1ng<\/strong><\/p>\n<p>C7 l\u00e0 ng\u00e0y 01 trong th\u00e1ng<\/p>\n<p style=\"padding-left: 30px\">C7=Date(F5,C5,1)<\/p>\n<p>D7\u00a0l\u00e0 ng\u00e0y 02 trong th\u00e1ng, l\u1edbn h\u01a1n C7 m\u1ed9t ng\u00e0y do\u00a0\u0111\u00f3:<\/p>\n<p style=\"padding-left: 30px\">D7=C7+1<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 c\u00e1c ng\u00e0y ti\u1ebfp theo s\u1ebd b\u1eb1ng ng\u00e0y tr\u01b0\u1edbc\u00a0\u0111\u00f3 + 1<\/p>\n<p>Tuy nhi\u00ean h\u00e0m Date cho ch\u00fang ta\u00a0\u0111\u1ecbnh d\u1ea1ng ng\u00e0y\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 g\u1ed3m:\u00a0dd\/mm\/yyyy (ng\u00e0y\/th\u00e1ng\/n\u0103m) trong khi t\u1ea1i d\u00f2ng 7 ch\u00fang ta ch\u1ec9 mu\u1ed1n n\u1ed9i dung hi\u1ec3n th\u1ecb l\u00e0 s\u1ed1 ng\u00e0y. Do\u00a0\u0111\u00f3 ch\u00fang ta s\u1ebd th\u1ef1c hi\u1ec7n Format Cells cho v\u00f9ng C7:AG7 nh\u01b0 sau<\/p>\n<p>Ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng C7:AG7, ch\u1ecdn Format Cells.<\/p>\n<p>Trong tab Number ch\u1ecdn m\u1ee5c Custom<\/p>\n<p>Trong th\u1ebb Type nh\u1eadp 2 ch\u1eef\u00a0d l\u00e0\u00a0dd (ch\u1ec9 hi\u1ec3n th\u1ecb cho ng\u00e0y)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16593\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-bcc-tt133-03.png\" width=\"672\" height=\"598\" title=\"heo-bcc-tt133-03\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_3_Xac_dinh_thu_theo_ngay\"><\/span>B\u01b0\u1edbc 3: X\u00e1c\u00a0\u0111\u1ecbnh th\u1ee9 theo ng\u00e0y<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Mu\u1ed1n bi\u1ebft 1 ng\u00e0y c\u1ee5 th\u1ec3 l\u00e0 th\u1ee9 m\u1ea5y th\u00ec ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m\u00a0Weekday<\/p>\n<p>(Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-weekday-trong-excel.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0Weekday trong\u00a0Excel<\/a>)<\/p>\n<p>Th\u1ee9 c\u1ee7a ng\u00e0y trong\u00a0\u00f4 C7=Weekday(C7,1)<\/p>\n<p>Tuy nhi\u00ean h\u00e0m\u00a0Weekday ch\u1ec9 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u1eeb 1\u00a0\u0111\u1ebfn 7, t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi th\u1ee9 t\u1ef1 l\u00e0 (khi ch\u1ecdn tham s\u1ed1 trong h\u00e0m\u00a0weekday l\u00e0 1):<\/p>\n<ul>\n<li>S\u1ed1 1 t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi ng\u00e0y Ch\u1ee7 nh\u1eadt (CN)<\/li>\n<li>S\u1ed1\u00a02 t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi ng\u00e0y Th\u1ee9 hai (T2)<\/li>\n<li>S\u1ed1\u00a03 t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi ng\u00e0y Th\u1ee9 ba (T3)<\/li>\n<li>S\u1ed1\u00a04 t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi ng\u00e0y Th\u1ee9 t\u01b0 (T4)<\/li>\n<li>S\u1ed1\u00a05 t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi ng\u00e0y Th\u1ee9 n\u0103m (T5)<\/li>\n<li>S\u1ed1\u00a06 t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi ng\u00e0y Th\u1ee9 s\u00e1u (T6)<\/li>\n<li>S\u1ed1\u00a07 t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi ng\u00e0y Th\u1ee9 b\u1ea3y (T7)<\/li>\n<\/ul>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh Th\u1ee9 v\u1ec1\u00a0\u0111\u00fang d\u1ea1ng ti\u1ebfng vi\u1ec7t, ch\u00fang ta s\u1ebd c\u1ea7n k\u1ebft h\u1ee3p h\u00e0m Choose v\u1edbi h\u00e0m\u00a0Weekday.<\/p>\n<p>(Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-choose-trong-excel.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Choose trong\u00a0Excel<\/a>)<\/p>\n<p>H\u00e0m Choose cho ph\u00e9p ch\u00fang ta\u00a0tr\u1ea3 v\u1ec1 n\u1ed9i dung t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi th\u1ee9 t\u1ef1 k\u1ebft qu\u1ea3<\/p>\n<p>C\u00e1ch vi\u1ebft nh\u01b0 sau:<\/p>\n<p>C8=CHOOSE(WEEKDAY(C7,1),\u201dCN\u201d,\u201dT2\u2033,\u201dT3\u2033,\u201dT4\u2033,\u201dT5\u2033,\u201dT6\u2033,\u201dT7\u2033)<\/p>\n<p>\u00c1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 cho c\u00e1c ng\u00e0y kh\u00e1c b\u1eb1ng c\u00e1ch sao ch\u00e9p c\u00f4ng th\u1ee9c\u00a0\u1edf C8 t\u1edbi AG8<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_4_Phan_biet_ngay_chu_nhat_trong_thang\"><\/span><strong>B\u01b0\u1edbc 4: Ph\u00e2n bi\u1ec7t ng\u00e0y ch\u1ee7 nh\u1eadt trong th\u00e1ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Conditional formatting\u00a0\u0111\u1ec3 t\u1ef1\u00a0\u0111\u1ed9ng ph\u00e2n bi\u1ec7t c\u00e1c ng\u00e0y ch\u1ee7 nh\u1eadt trong th\u00e1ng nh\u01b0 sau:<\/p>\n<p>C\u0103n c\u1ee9 v\u00e0o d\u00f2ng 8 ta c\u00f3 ng\u00e0y ch\u1ee7 nh\u1eadt l\u00e0 ng\u00e0y c\u00f3 k\u00fd hi\u1ec7u CN<\/p>\n<ul>\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng C7:AG14 (v\u00f9ng ng\u00e0y trong th\u00e1ng,\u00a0\u00e1p d\u1ee5ng t\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng ch\u1ea5m c\u00f4ng)<\/li>\n<li>Ch\u1ecdn ch\u1ee9c n\u0103ng Conditional formatting (Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-dinh-dang-co-dieu-kien-trong-excel-2010-2013-va-2016.html\">C\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Conditional formatting<\/a>)<\/li>\n<li>Thi\u1ebft l\u1eadp conditional formatting theo\u00a0\u0111i\u1ec1u ki\u1ec7n nh\u01b0 sau:<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16623\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-bcc-them-gio-tt133-03.png\" width=\"1121\" height=\"508\" title=\"heo-bcc-them-gio-tt133-03\"><\/p>\n<p>Vi\u1ec7c thi\u1ebft l\u1eadp\u00a0\u0111\u1ecbnh d\u1ea1ng\u00a0\u0111\u1ec3 c\u1ea3nh b\u00e1o c\u00e1c c\u1ed9t ng\u00e0y Ch\u1ee7 nh\u1eadt s\u1ebd\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1ecbnh d\u1ea1ng t\u1ea1i m\u1ee5c Format (b\u00ean c\u1ea1nh m\u1ee5c Preview)<\/p>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16620\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-bcc-them-gio-tt133-02.png\" width=\"1235\" height=\"364\" title=\"heo-bcc-them-gio-tt133-02\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_5_Cong_thuc_quy_ra_cong\"><\/span>B\u01b0\u1edbc 5: C\u00f4ng th\u1ee9c quy ra c\u00f4ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Sau khi ti\u1ebfn h\u00e0nh ch\u1ea5m c\u00f4ng trong b\u1ea3ng ch\u1ea5m c\u00f4ng th\u00ec ch\u00fang ta s\u1ebd th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n s\u1ed1\u00a0c\u00f4ng trong th\u00e1ng\u00a0\u0111\u00e3 ch\u1ea5m c\u1ee7a t\u1eebng ng\u01b0\u1eddi.<\/p>\n<p>C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p>S\u1eed d\u1ee5ng h\u00e0m COUNTIF\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a t\u1eebng\u00a0k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi lo\u1ea1i h\u00ecnh c\u00f4ng c\u1ea7n t\u00ednh<\/p>\n<p style=\"padding-left: 30px\">(xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-countifs-dem-theo-nhieu-dieu-kien.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF<\/a>)<\/p>\n<p style=\"padding-left: 30px\">V\u00ed d\u1ee5:\u00a0\u0110\u1ebfm s\u1ed1 bu\u1ed5i l\u00e0m vi\u1ec7c ban\u00a0\u0111\u00eam =&gt;\u00a0\u0110\u1ebfm s\u1ed1 k\u00fd hi\u1ec7u\u00a0\u0110 (gi\u00e1 tr\u1ecb\u00a0\u1edf\u00a0\u00f4 B20)<\/p>\n<p style=\"padding-left: 30px\">AK10=COUNTIF(C10:AG10,$B$20)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16633\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-bcc-them-gio-tt133-04.png\" width=\"1568\" height=\"262\" title=\"heo-bcc-them-gio-tt133-04\"><\/p>\n<p>S\u1eed d\u1ee5ng h\u00e0m SUMIF\u00a0\u0111\u1ec3\u00a0t\u00ednh t\u1ed5ng\u00a0s\u1ed1 gi\u1edd c\u00f4ng (n\u1ebfu ch\u1ea5m c\u00f4ng theo s\u1ed1 gi\u1edd)<\/p>\n<p style=\"padding-left: 30px\">(xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIF<\/a>)<\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh xong m\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng theo th\u00f4ng t\u01b0 133 r\u1ed3i.<\/p>\n<p>\u0110\u1ec3 t\u00ecm hi\u1ec3u k\u1ef9 h\u01a1n c\u00e1ch ch\u1ea5m c\u00f4ng nh\u01b0 th\u1ebf n\u00e0o trong b\u1ea3ng ch\u1ea5m c\u00f4ng, m\u1eddi b\u1ea1n tham kh\u1ea3o b\u00e0i vi\u1ebft<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-cham-cong-tren-bang-cham-cong-lam-gio-tren-excel-2018.html\">C\u00e1ch ch\u1ea5m c\u00f4ng tr\u00ean b\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0m th\u00eam gi\u1edd\u00a0theo th\u00f4ng t\u01b0 133 tr\u00ean Excel m\u1edbi nh\u1ea5t 2018<\/a><\/p>\n<p>\u2014<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc\u00a0Excel Online!<\/p>\n<p>T\u1ea3i v\u1ec1 m\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2jKfJ6O\">http:\/\/bit.ly\/2jKfJ6O<\/a><\/p>\n<p>B\u1ea1n c\u00f3 ngh\u0129 r\u1eb1ng l\u00e0m k\u1ebf to\u00e1n t\u1ed5ng h\u1ee3p tr\u00ean Excel quan tr\u1ecdng kh\u00f4ng, b\u1edfi tr\u00ean\u00a0Excel b\u1ea1n c\u00f3 th\u1ec3 n\u1eafm\u00a0\u0111\u01b0\u1ee3c c\u00e1ch t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u k\u1ebf to\u00e1n,\u00a0\u0111\u1ed3ng th\u1eddi t\u1ef1 tay x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c l\u00ean c\u00e1c b\u00e1o c\u00e1o t\u00e0i ch\u00ednh. Khi\u00a0\u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3\u00a0d\u1ec5 d\u00e0ng ki\u1ec3m tra k\u1ebft qu\u1ea3, bi\u1ebft\u00a0\u0111\u01b0\u1ee3c nh\u1eefng thay\u00a0\u0111\u1ed5i d\u1eef li\u1ec7u trong s\u1ed5 NKC s\u1ebd\u00a0\u1ea3nh h\u01b0\u1edfng nh\u01b0 th\u1ebf n\u00e0o t\u1edbi k\u1ebft qu\u1ea3 trong c\u00e1c b\u00e1o c\u00e1o.<\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-401.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4874,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4873","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\/4873","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=4873"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4873\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4874"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4873"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4873"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4873"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}