{"id":2786,"date":"2024-12-02T08:45:18","date_gmt":"2024-12-02T08:45:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-tao-bang-cham-cong-tren-excel-chi-tiet-nhat\/"},"modified":"2024-12-02T08:45:18","modified_gmt":"2024-12-02T08:45:18","slug":"huong-dan-cach-tao-bang-cham-cong-tren-excel-chi-tiet-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-tao-bang-cham-cong-tren-excel-chi-tiet-nhat\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean Excel chi ti\u1ebft nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p class=\"post-title entry-title\"><em>T\u1ea1o b\u1ea3ng ch\u1ea5m c\u00f4ng b\u1eb1ng Excel gi\u00fap ch\u00fang ta chuy\u00ean nghi\u1ec7p h\u00f3a \u0111\u01b0\u1ee3c c\u00f4ng vi\u1ec7c qu\u1ea3n tr\u1ecb nh\u00e2n l\u1ef1c. \u0110\u1ed3ng th\u1eddi h\u1ec7 th\u1ed1ng n\u00e0y c\u0169ng gi\u00fap l\u01b0u tr\u1eef t\u00f4t v\u00e0 ho\u1ea1t \u0111\u1ed9ng tr\u01a1n tru h\u01a1n so v\u1edbi truy\u1ec1n th\u1ed1ng. <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n<strong> t\u1ea1o b\u1ea3ng ch\u1ea5m c\u00f4ng b\u1eb1ng Excel<\/strong> v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n<\/em><\/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-674d739dba50d\" 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\/huong-dan-cach-tao-bang-cham-cong-tren-excel-chi-tiet-nhat.html#Xac_dinh_mo_hinh_bang_cham_cong\" title=\"X\u00e1c \u0111\u1ecbnh m\u00f4 h\u00ecnh b\u1ea3ng ch\u1ea5m c\u00f4ng:\">X\u00e1c \u0111\u1ecbnh m\u00f4 h\u00ecnh b\u1ea3ng ch\u1ea5m c\u00f4ng:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-bang-cham-cong-tren-excel-chi-tiet-nhat.html#Cac_buoc_thuc_hien_chi_tiet\" title=\"C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n chi ti\u1ebft\">C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n chi ti\u1ebft<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-bang-cham-cong-tren-excel-chi-tiet-nhat.html#Bo_cuc_cac_Sheet\" title=\"B\u1ed1 c\u1ee5c c\u00e1c Sheet\">B\u1ed1 c\u1ee5c c\u00e1c Sheet<\/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\/huong-dan-cach-tao-bang-cham-cong-tren-excel-chi-tiet-nhat.html#Sheet_Danh_sach_nhan_vien\" title=\"Sheet Danh s\u00e1ch nh\u00e2n vi\u00ean:\">Sheet Danh s\u00e1ch nh\u00e2n vi\u00ean:<\/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\/huong-dan-cach-tao-bang-cham-cong-tren-excel-chi-tiet-nhat.html#Sheet_Thang_1\" title=\"Sheet Th\u00e1ng 1\">Sheet Th\u00e1ng 1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-bang-cham-cong-tren-excel-chi-tiet-nhat.html#Tao_ngay_thang_trong_bang_cham_cong\" title=\"T\u1ea1o ng\u00e0y th\u00e1ng trong b\u1ea3ng ch\u1ea5m c\u00f4ng\">T\u1ea1o ng\u00e0y th\u00e1ng trong 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-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-bang-cham-cong-tren-excel-chi-tiet-nhat.html#Dat_ky_hieu_cham_cong\" title=\"\u0110\u1eb7t k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng\">\u0110\u1eb7t k\u00fd hi\u1ec7u 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-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-bang-cham-cong-tren-excel-chi-tiet-nhat.html#Ham_cong_thuc_tinh_cong\" title=\"H\u00e0m, c\u00f4ng th\u1ee9c t\u00ednh c\u00f4ng\">H\u00e0m, c\u00f4ng th\u1ee9c t\u00ednh c\u00f4ng<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 id=\"post-body-2189301398856601471\" class=\"post-body entry-content\"><span class=\"ez-toc-section\" id=\"Xac_dinh_mo_hinh_bang_cham_cong\"><\/span><b>X\u00e1c \u0111\u1ecbnh m\u00f4 h\u00ecnh b\u1ea3ng ch\u1ea5m c\u00f4ng:<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div class=\"post-body entry-content\">Tr\u01b0\u1edbc khi l\u1eadp 1 file excel, b\u1ea1n n\u00ean t\u01b0\u1edfng t\u01b0\u1ee3ng, h\u00ecnh dung ra tr\u01b0\u1edbc xem file b\u1ea3ng ch\u1ea5m c\u00f4ng g\u1ed3m nh\u1eefng g\u00ec, bao nhi\u00eau sheet, n\u1ed9i dung nh\u01b0 th\u1ebf n\u00e0o, c\u00e1ch ho\u1ea1t \u0111\u1ed9ng ra sao\u2026? Khi tr\u1ea3 l\u1eddi \u0111\u01b0\u1ee3c c\u00e1c c\u00e2u h\u1ecfi th\u00ec b\u1ea1n c\u00e0ng bi\u1ebft r\u00f5 c\u00e1ch l\u00e0m tr\u00ean excel \u0111\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 \u00fd mu\u1ed1n.<br \/>\nT\u00f4i s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp 1 m\u00f4 h\u00ecnh b\u1ea3ng ch\u1ea5m c\u00f4ng v\u00ed d\u1ee5 nh\u01b0 sau:<\/div>\n<div class=\"post-body entry-content\">\n<ul>\n<li class=\"post-body entry-content\">G\u1ed3m 13 sheet, m\u1ed7i sheet l\u00e0 1 th\u00e1ng v\u00e0 1 sheet l\u00e0m danh s\u00e1ch nh\u00e2n vi\u00ean<\/li>\n<li class=\"post-body entry-content\">Trung b\u00ecnh m\u1ed7i th\u00e1ng l\u00e0 20 nh\u00e2n vi\u00ean<\/li>\n<li class=\"post-body entry-content\">K\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng c\u00f3 th\u1ec3 thay \u0111\u1ed5i \u0111\u01b0\u1ee3c t\u00f9y ng\u01b0\u1eddi s\u1eed d\u1ee5ng (m\u1ed7i ng\u01b0\u1eddi c\u00f3 th\u1ec3 ch\u1ea5m 1 ki\u1ec3u k\u00fd hi\u1ec7u, nh\u01b0ng s\u1ebd \u0111\u1ed3ng nh\u1ea5t trong 12 th\u00e1ng)<\/li>\n<li class=\"post-body entry-content\">Trong m\u1ed7i b\u1ea3ng ch\u1ea5m c\u00f4ng c\u00f3 ghi r\u00f5 ng\u00e0y, th\u1ee9 trong th\u00e1ng. V\u00e0o th\u1ee9 7 v\u00e0 ch\u1ee7 nh\u1eadt th\u00ec t\u1ef1 \u0111\u1ed5i m\u00e0u kh\u00e1c so v\u1edbi ng\u00e0y th\u01b0\u1eddng.<\/li>\n<li class=\"post-body entry-content\">H\u00e0ng ng\u00e0y s\u1ebd ch\u1ea5m c\u00f4ng v\u00e0o c\u00e1c ng\u00e0y trong th\u00e1ng. Cu\u1ed1i th\u00e1ng s\u1ebd t\u1ef1 t\u00ednh s\u1ed1 t\u1ed5ng s\u1ed1 c\u00f4ng trong th\u00e1ng.<\/li>\n<li class=\"post-body entry-content\">T\u00ean nh\u00e2n vi\u00ean trong b\u1ea3ng ch\u1ea5m c\u00f4ng s\u1ebd l\u1ea5y t\u1eeb danh s\u00e1ch nh\u00e2n vi\u00ean<\/li>\n<li class=\"post-body entry-content\">C\u00f3 th\u1ec3 li\u00ean k\u1ebft gi\u1eefa c\u00e1c th\u00e1ng v\u1edbi nhau \u0111\u1ec3 d\u1ec5 thao t\u00e1c.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cac_buoc_thuc_hien_chi_tiet\"><\/span><b>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n chi ti\u1ebft<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Bo_cuc_cac_Sheet\"><\/span>B\u1ed1 c\u1ee5c c\u00e1c Sheet<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/div>\n<div class=\"post-body entry-content\">\n<p>V\u1ec1 m\u00f4 h\u00ecnh l\u00e0 13 sheet, nh\u01b0ng khi b\u1eaft \u0111\u1ea7u l\u00e0m ta ch\u1ec9 c\u1ea7n 2 sheet:<\/p>\n<p style=\"padding-left: 30px\">+ 1 sheet l\u00e0 Danh s\u00e1ch nh\u00e2n vi\u00ean (DSNV)<\/p>\n<p style=\"padding-left: 30px\">+ 1 sheet l\u00e0 Th\u00e1ng 1 (l\u00e0m ho\u00e0n ch\u1ec9nh cho 1 th\u00e1ng, c\u00e1c th\u00e1ng sau c\u00f3 th\u1ec3 copy sheet n\u00e0y r\u1ed3i \u0111\u1ed5i t\u00ean)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Sheet_Danh_sach_nhan_vien\"><\/span>Sheet Danh s\u00e1ch nh\u00e2n vi\u00ean:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ed9i dung ch\u1ee7 y\u1ebfu trong sheet n\u00e0y l\u00e0 T\u00ean v\u00e0 M\u00e3 nh\u00e2n vi\u00ean. C\u1ea7n t\u1ea1o m\u00e3 nh\u00e2n vi\u00ean v\u00ec c\u00f3 th\u1ec3 c\u00f3 tr\u01b0\u1eddng h\u1ee3p tr\u00f9ng t\u00ean. Khi qu\u1ea3n l\u00fd theo m\u00e3 s\u1ebd tr\u00e1nh tr\u01b0\u1eddng h\u1ee3p b\u1ecb tr\u00f9ng.<\/p>\n<p>Ngo\u00e0i ra c\u00f2n c\u00f3 c\u00e1c n\u1ed9i dung kh\u00e1c li\u00ean quan t\u1edbi nh\u00e2n vi\u00ean, nh\u01b0: ng\u00e0y sinh, qu\u00ea qu\u00e1n, s\u1ed1 CMT, ng\u00e0y v\u00e0o l\u00e0m\u2026<br \/>\nB\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o nh\u01b0 sau:<\/p>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-01.jpg\" width=\"640\" height=\"512\" border=\"0\" title=\"bcc-01\"><\/div>\n<div class=\"separator\"><\/div>\n<p>+ C\u1ed9t E (ng\u00e0y sinh), b\u1ea1n b\u00f4i \u0111en c\u1ea3 c\u1ed9t (\u0111\u01b0a con tr\u1ecf chu\u1ed9t v\u00e0o v\u1ecb tr\u00ed tr\u00ean c\u00f9ng c\u1ee7a c\u1ed9t \u2013 ch\u1eef E, b\u1ea5m ch\u1ecdn c\u1ea3 c\u1ed9t), b\u1ea1n \u0111\u1ecbnh d\u1ea1ng Format cell\/Number\/Custome\/ ch\u1ecdn dd-mm-yyyy . T\u00e1c d\u1ee5ng: khi b\u1ea1n nh\u1eadp b\u1ea5t k\u1ef3 d\u1eef li\u1ec7u ki\u1ec3u ng\u00e0y th\u00e1ng v\u00e0o c\u1ed9t n\u00e0y s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u01b0a v\u1ec1 d\u1ea1ng dd-mm-yyyy (01-01-2014)<\/p>\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-215.gif\" title=\"ex101_92019-nho-215\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"separator\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-02.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-02.jpg\" width=\"640\" height=\"564\" border=\"0\" title=\"bcc-02\"><\/a><\/div>\n<p>Sheet danh s\u00e1ch nh\u00e2n vi\u00ean h\u1ea7u h\u1ebft l\u00e0 nh\u1eadp b\u1eb1ng tay n\u00ean kh\u00f4ng c\u00f3 g\u00ec ph\u1ee9c t\u1ea1p.<br \/>\nL\u01b0u \u00fd: b\u1ea1n ch\u1eeba ra kho\u1ea3ng 2-3 d\u00f2ng tr\u00ean c\u00f9ng \u0111\u1ec3 t\u1ea1o li\u00ean k\u1ebft t\u1edbi c\u00e1c sheet kh\u00e1c. B\u00ean tr\u00e1i c\u00e1ch ra 1 c\u1ed9t \u0111\u1ec3 d\u1ef1 ph\u00f2ng n\u1ebfu c\u1ea7n b\u1ed5 sung g\u00ec th\u00eam.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Sheet_Thang_1\"><\/span>Sheet Th\u00e1ng 1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ea7u ti\u00ean b\u1ea1n t\u1ea1o khung cho b\u1ea3ng ch\u1ea5m c\u00f4ng, g\u1ed3m c\u00e1c n\u1ed9i dung: ti\u00eau \u0111\u1ec1 \u2013 b\u1ea3ng ch\u1ea5m c\u00f4ng, th\u00e1ng, b\u1ed9 ph\u1eadn ch\u1ea5m c\u00f4ng, \u0111\u1ecbnh m\u1ee9c ng\u00e0y c\u00f4ng trong th\u00e1ng, c\u00e1c c\u1ed9t g\u1ed3m: m\u00e3 nh\u00e2n vi\u00ean, t\u00ean nh\u00e2n vi\u00ean, ng\u00e0y trong th\u00e1ng (31 c\u1ed9t t\u01b0\u01a1ng \u1ee9ng v\u1edbi 31 ng\u00e0y \u2013 s\u1ed1 ng\u00e0y l\u1edbn nh\u1ea5t c\u1ee7a 1 th\u00e1ng), 4-5 c\u1ed9t t\u00ednh quy ra c\u00f4ng, 1 c\u1ed9t \u0111\u1ec3 ghi ch\u00fa<\/p>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-03.jpg\" width=\"640\" height=\"512\" border=\"0\" title=\"bcc-03\"><\/div>\n<div class=\"separator\"><\/div>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-04.jpg\" width=\"640\" height=\"512\" border=\"0\" title=\"bcc-04\"><\/div>\n<div class=\"separator\"><\/div>\n<p>Ti\u1ebfp sau \u0111\u00f3 b\u1ea1n co \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u00e1c c\u1ed9t sao cho g\u1ecdn v\u00e0 d\u1ec5 nh\u00ecn. C\u00e1c c\u1ed9t ng\u00e0y trong th\u00e1ng c\u00f3 th\u1ec3 co l\u1ea1i nh\u1ecf v\u1eeba \u0111\u1ee7 \u0111\u1ec3 ch\u1ea5m c\u00f4ng th\u00f4i. C\u1ed9t quy ra c\u00f4ng c\u0169ng kh\u00f4ng c\u1ea7n r\u1ed9ng l\u1eafm. Ch\u1ee7 y\u1ebfu c\u1ed9t t\u00ean v\u00e0 m\u00e3 nh\u00e2n vi\u00ean hi\u1ec3n th\u1ecb \u0111\u1ee7 l\u00e0 \u0111\u01b0\u1ee3c.<\/p>\n<p>C\u00e1ch co \u0111\u1ed9 r\u1ed9ng: b\u1ea1n b\u00f4i \u0111en c\u00e1c c\u1ed9t ng\u00e0y trong th\u00e1ng, quy ra c\u00f4ng (trong v\u00ed d\u1ee5 l\u00e0 b\u00f4i \u0111en t\u1eeb c\u1ed9t E \u0111\u1ebfn c\u1ed9t AM), sau \u0111\u00f3 co \u0111\u1ed9 r\u1ed9ng \u1edf c\u1ed9t E kho\u1ea3ng 30 pixels (ho\u1eb7c b\u00f4i \u0111en t\u1eeb c\u1ed9t E \u0111\u1ebfn c\u1ed9t AM, sau \u0111\u00f3 b\u1ea5m ch\u1ecdn command Column Width, ch\u1ecdn 3,13 t\u01b0\u01a1ng \u1ee9ng 30 pixels)<\/p>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-05.jpg\" width=\"640\" height=\"512\" border=\"0\" title=\"bcc-05\"><\/div>\n<div class=\"separator\"><\/div>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-06.jpg\" width=\"640\" height=\"512\" border=\"0\" title=\"bcc-06\"><\/div>\n<p>V\u1eady l\u00e0 b\u1ea1n \u0111\u00e3 l\u00e0m xong ph\u1ea7n khung c\u1ee7a B\u1ea3ng ch\u1ea5m c\u00f4ng. Ti\u1ebfp theo ta s\u1ebd th\u1ef1c hi\u1ec7n thao t\u00e1c ch\u1ecdn ng\u00e0y th\u00e1ng c\u1ee7a b\u1ea3ng ch\u1ea5m c\u00f4ng.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tao_ngay_thang_trong_bang_cham_cong\"><\/span><b>T\u1ea1o ng\u00e0y th\u00e1ng trong b\u1ea3ng ch\u1ea5m c\u00f4ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u2013 \u0110\u1ea7u ti\u00ean ta x\u00e1c \u0111\u1ecbnh n\u0103m s\u1eed d\u1ee5ng. T\u1ea1i \u00f4 D1 nh\u1eadp gi\u00e1 tr\u1ecb c\u1ee7a n\u0103m. V\u00ed d\u1ee5 n\u0103m 2014<\/p>\n<p>\u2013 T\u1ea1i \u00f4 B4 (x\u00e1c \u0111\u1ecbnh th\u00e1ng ch\u1ea5m c\u00f4ng), ta nh\u1eadp h\u00e0m x\u00e1c \u0111\u1ecbnh ng\u00e0y: =date($D$1;1;1)<br \/>\nL\u01b0u \u00fd d\u1ea5u ng\u0103n c\u00e1ch c\u00e1c th\u00e0nh ph\u1ea7n trong h\u00e0m c\u00f3 th\u1ec3 l\u00e0 d\u1ea5u ; ho\u1eb7c d\u1ea5u , t\u00f9y thi\u1ebft l\u1eadp c\u1ee7a m\u00e1y t\u00ednh. \u1ede m\u00e1y t\u00ednh c\u1ee7a t\u00f4i s\u1eed d\u1ee5ng d\u1ea5u ;<br \/>\nN\u1ed9i dung h\u00e0m date: x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb c\u1ee7a ng\u00e0y th\u00e1ng theo gi\u00e1 tr\u1ecb x\u00e1c \u0111\u1ecbnh trong h\u00e0m. gi\u00e1 tr\u1ecb theo th\u1ee9 t\u1ef1 l\u00e0 N\u0103m, th\u00e1ng, ng\u00e0y. \u1ede h\u00e0m tr\u00ean l\u00e0 N\u0103m = gi\u00e1 tr\u1ecb t\u1ea1i \u00f4 D1, Th\u00e1ng = 1, Ng\u00e0y = 1<\/p>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-07.jpg\" width=\"640\" height=\"504\" border=\"0\" title=\"bcc-07\"><\/div>\n<p>\u2013 Sau khi nh\u1eadp h\u00e0m xong, t\u1ea1i \u00f4 B4, ch\u1ecdn format cell \/ custom \/ nh\u1eadp gi\u00e1 tr\u1ecb [\u201cth\u00e1ng \u201cmm\u201d n\u0103m \u201cyyyy] v\u00e0o \u00f4 Type b\u00ean ph\u1ea3i, xong r\u1ed3i \u1ea5n ok (d\u1ea5u nh\u00e1y k\u00e9p\u00a0+ th\u00e1ng\u00a0+ d\u1ea5u c\u00e1ch\u00a0+ d\u1ea5u nh\u00e1y k\u00e9p\u00a0+ mm\u00a0+ d\u1ea5u nh\u00e1y k\u00e9p\u00a0+ n\u0103m\u00a0+ d\u1ea5u c\u00e1ch\u00a0+ d\u1ea5u nh\u00e1y k\u00e9p\u00a0+ yyyy)<\/p>\n<p><strong>Xem th\u00eam<\/strong>: <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 trong Excel<\/a><\/p>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-08.jpg\" width=\"640\" height=\"558\" border=\"0\" title=\"bcc-08\"><\/div>\n<p>\u2013 B\u1ea1n c\u00f3 th\u1ec3 marge cell t\u1eeb \u00f4 B4 \u0111\u1ebfn D4 \u0111\u1ec3 cho hi\u1ec3n th\u1ecb \u0111\u1ee7 n\u1ed9i dung cho d\u1ec5 nh\u00ecn.<\/p>\n<p>\u2013 T\u1ea1i \u00f4 ng\u00e0y 1 ( \u00f4 E9), b\u1ea1n nh\u1eadp =b4 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ng\u00e0y \u0111\u1ea7u ti\u00ean trong th\u00e1ng.<\/p>\n<p>\u2013 T\u1ea1i \u00f4 F9, b\u1ea1n nh\u1eadp =e9+1 (ng\u00e0y ti\u1ebfp theo trong th\u00e1ng)<\/p>\n<p>\u2013 Copy c\u00f4ng th\u1ee9c t\u1ea1i \u00f4 F9 sang c\u00e1c \u00f4 b\u00ean c\u1ea1nh, cho \u0111\u1ebfn \u00f4 ng\u00e0y th\u1ee9 31 (\u00f4 AI9) b\u1eb1ng c\u00e1ch sau:<\/p>\n<ul>\n<li>C\u00e1ch 1: B\u00f4i \u0111en t\u1eeb \u00f4 F9 \u0111\u1ebfn \u00f4 AI9, b\u1ea5m Ctrl\u00a0+ R<\/li>\n<li>C\u00e1ch 2: B\u1ea5m chu\u1ed9t v\u00e0o \u00f4 F9, gi\u1eef chu\u1ed9t t\u1ea1i v\u1ecb tr\u00ed d\u1ea5u ch\u1ea5m \u0111en trong \u00f4 \u0111\u1ec3 con tr\u1ecf chu\u1ed9t tr\u1edf th\u00e0nh d\u1ea5u +, k\u00e9o chu\u1ed9t t\u1edbi \u00f4 AI9 r\u1ed3i th\u1ea3 ra<\/li>\n<\/ul>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-09.jpg\" width=\"640\" height=\"308\" border=\"0\" title=\"bcc-09\"><\/div>\n<p>\u2013 B\u00f4i \u0111en t\u1eeb \u00f4 E9 \u0111\u1ebfn \u00f4 AI9, ch\u1ecdn Format cells \/ custom \/ m\u1ee5c Type b\u1ea1n g\u00f5 ch\u1eef dd r\u1ed3i b\u1ea5m ok (ch\u1ec9 hi\u1ec7n th\u1ecb s\u1ed1 ng\u00e0y)<br \/>\nN\u1ed9i dung trong \u00f4 E9 \u0111\u1ebfn \u00f4 AI9 s\u1ebd hi\u1ec3n th\u1ecb ra ng\u00e0y nh\u01b0 trong b\u1ea3ng tr\u00ean.<\/p>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-10.jpg\" width=\"400\" height=\"346\" border=\"0\" title=\"bcc-10\"><\/div>\n<p>\u2013 T\u1ea1i \u00f4 E10 nh\u1eadp h\u00e0m =CHOOSE(WEEKDAY(E9);\u201dCh\u1ee7 nh\u1eadt\u201d;\u201dT. hai\u201d;\u201dT. ba\u201d;\u201dT. t\u01b0\u201d;\u201dT. n\u0103m\u201d;\u201dT. s\u00e1u\u201d;\u201dT. b\u1ea3y\u201d)<\/p>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-11.jpg\" width=\"640\" height=\"330\" border=\"0\" title=\"bcc-11\"><\/div>\n<p>N\u1ed9i dung h\u00e0m:<\/p>\n<ul>\n<li><strong>Weekday(e9)<\/strong> : l\u00e0 l\u1ea5y gi\u00e1 tr\u1ecb ng\u00e0y trong tu\u1ea7n c\u1ee7a \u00f4 E9. N\u1ebfu n\u1ed9i dung trong h\u00e0m weekday kh\u00f4ng c\u00f3 \u0111\u1eb7t quy \u0111\u1ecbnh v\u1ec1 th\u1ee9 t\u1ef1 ng\u00e0y trong tu\u1ea7n th\u00ec s\u1ebd t\u1ef1 tr\u1ea3 v\u1ec1 theo th\u1ee9 t\u1ef1 Ch\u1ee7 nh\u1eadt, th\u1ee9 hai, th\u1ee9 3\u2026 th\u1ee9 7 (B\u1eaft \u0111\u1ea7u l\u00e0 ch\u1ee7 nh\u1eadt, k\u1ebft th\u00fac l\u00e0 th\u1ee9 7), v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 8<\/li>\n<li><strong>Choose<\/strong>: l\u00e0 h\u00e0m ch\u1ecdn gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1. Gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean trong h\u00e0m l\u00e0 gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c ch\u1ecdn \u0111\u1ec3 l\u00e0m c\u0103n c\u1ee9 x\u00e1c \u0111\u1ecbnh. C\u00e1c gi\u00e1 tr\u1ecb ti\u1ebfp theo l\u00e0 n\u1ed9i dung \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 t\u01b0\u01a1ng \u1ee9ng theo gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean.<\/li>\n<\/ul>\n<p>Trong h\u00e0m tr\u00ean, ng\u00e0y 01\/01\/2014 khi d\u00f9ng h\u00e0m weekday s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 4, khi d\u00f9ng h\u00e0m choose v\u1edbi th\u1ee9 t\u1ef1 t\u01b0\u01a1ng \u1ee9ng l\u00e0 Ch\u1ee7 nh\u1eadt, th\u1ee9 hai, th\u1ee9 ba\u2026 th\u1ee9 b\u1ea3y th\u00ec gi\u00e1 tr\u1ecb 4 s\u1ebd t\u01b0\u01a1ng \u1ee9ng v\u1edbi th\u1ee9 t\u01b0. B\u1edfi v\u00ec h\u00e0m weekday kh\u00f4ng t\u1ef1 tr\u1ea3 v\u1ec1 th\u1ee9 theo ti\u1ebfng vi\u1ec7t, n\u00ean ta ph\u1ea3i k\u1ebft h\u1ee3p v\u1edbi h\u00e0m choose \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c n\u1ed9i dung l\u00e0 th\u1ee9 m\u1ea5y trong tu\u1ea7n<\/p>\n<p>\u2013 Copy c\u00f4ng th\u1ee9c t\u1ea1i \u00f4 E10 sang c\u00e1c \u00f4 k\u1ebf ti\u1ebfp b\u00ean ph\u1ea3i, cho t\u1edbi \u00f4 AI10 (ng\u00e0y th\u1ee9 31)<\/p>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-12.jpg\" width=\"640\" height=\"292\" border=\"0\" title=\"bcc-12\"><\/div>\n<blockquote>\n<div class=\"separator\">Xem th\u00eam:\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Excel c\u01a1 ba\u0309n<\/a><\/div>\n<\/blockquote>\n<p>Tuy nhi\u00ean kh\u00f4ng ph\u1ea3i th\u00e1ng n\u00e0o c\u0169ng c\u00f3 31 ng\u00e0y, n\u00ean \u0111\u1ec3 tr\u00e1nh vi\u1ec7c hi\u1ec3n th\u1ecb c\u00e1c ng\u00e0y c\u1ee7a th\u00e1ng kh\u00e1c v\u00e0o th\u00e1ng n\u00e0y, ta th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c sau:<br \/>\n+ B\u1eaft \u0111\u1ea7u t\u1eeb ng\u00e0y th\u1ee9 29 (\u00f4 AG9), ta \u0111i\u1ec1u ch\u1ec9nh v\u1ec1 h\u00e0m nh\u01b0 sau: =IF(DAY(AF9+1)=DAY(E9);\u201d\u201d;AF9+1)<br \/>\nN\u1ed9i dung h\u00e0m: N\u1ebfu gi\u00e1 tr\u1ecb ng\u00e0y c\u1ee7a \u00f4 AF9\u00a0+1 b\u1eb1ng gi\u00e1 tr\u1ecb ng\u00e0y c\u1ee7a \u00f4 E9 s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 r\u1ed7ng, n\u1ebfu kh\u00f4ng b\u1eb1ng th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u00f4 AF9\u00a0+ 1 (Ngh\u0129a l\u00e0 n\u1ebfu th\u00e1ng 2 c\u00f3 28 ng\u00e0y, th\u00ec ng\u00e0y th\u1ee9 29 s\u1ebd l\u00e0 ng\u00e0y 01\/03, v\u1eady gi\u00e1 tr\u1ecb ng\u00e0y l\u00e0 1, b\u1eb1ng v\u1edbi gi\u00e1 tr\u1ecb ng\u00e0y c\u1ee7a \u00f4 E9, n\u1ebfu \u0111\u00fang nh\u01b0 th\u1ebf th\u00ec s\u1ebd l\u00e0 r\u1ed7ng, kh\u00f4ng hi\u1ec3n th\u1ecb ng\u00e0y 01\/03. C\u00f2n n\u1ebfu th\u00e1ng 2 \u0111\u00f3 c\u00f3 29 ng\u00e0y th\u00ec s\u1ebd hi\u1ec7n ng\u00e0y 29)<\/p>\n<p>+ T\u1ea1i \u00f4 AH9, ta d\u00f9ng h\u00e0m sau: =IF(AG9=\u201d\u201d;\u201d\u201d;if(DAY(AG9+1)=DAY(E9);\u201d\u201d;AG9+1))<br \/>\nN\u1ed9i dung h\u00e0m:<\/p>\n<ul>\n<li>IF th\u1ee9 1: N\u1ebfu t\u1ea1i \u00f4 AG9 l\u00e0 gi\u00e1 tr\u1ecb r\u1ed7ng, th\u00ec \u00f4 AH9 c\u0169ng s\u1ebd c\u00f3 gi\u00e1 tr\u1ecb r\u1ed7ng (t\u1ee9c l\u00e0 v\u00e0o tr\u01b0\u1eddng h\u1ee3p th\u00e1ng 2 c\u00f3 28 ng\u00e0y th\u00ec s\u1ebd kh\u00f4ng c\u00f3 ng\u00e0y th\u1ee9 30)<\/li>\n<li>IF th\u1ee9 2: t\u01b0\u01a1ng t\u1ef1 v\u1edbi h\u00e0m if t\u1ea1i \u00f4 AG9, t\u1ee9c l\u00e0 tr\u01b0\u1eddng h\u1ee3p th\u00e1ng 2 c\u00f3 29 ng\u00e0y, th\u00ec s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb ng\u00e0y 30.<\/li>\n<\/ul>\n<p>+ T\u1ea1i \u00f4 AI9, ta d\u00f9ng h\u00e0m sau: =IF(AH9=\u201d\u201d;\u201d\u201d;if(DAY(AH9+1)=DAY(E9);\u201d\u201d;AH9+1))<\/p>\n<p>N\u1ed9i dung h\u00e0m:<\/p>\n<ul>\n<li>IF th\u1ee9 1: N\u1ebfu AH9 l\u00e0 gi\u00e1 tr\u1ecb r\u1ed7ng, th\u00ec AI9 c\u0169ng s\u1ebd c\u00f3 gi\u00e1 tr\u1ecb r\u1ed7ng (t\u1ee9c l\u00e0 tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng c\u00f3 ng\u00e0y th\u1ee9 30 th\u00ec c\u0169ng kh\u00f4ng c\u00f3 ng\u00e0y th\u1ee9 31)<\/li>\n<li>IF th\u1ee9 2: tr\u01b0\u1eddng h\u1ee3p th\u00e1ng ch\u1ec9 c\u00f3 30 ng\u00e0y th\u00ec s\u1ebd kh\u00f4ng c\u00f3 ng\u00e0y th\u1ee9 31<\/li>\n<\/ul>\n<p>+ Khi c\u00e1c \u00f4 AG9, AH9, AI9 l\u00e0 r\u1ed7ng th\u00ec h\u00e0m choose \u1edf c\u00e1c \u00f4 AG10, AH10, AI10 s\u1ebd ph\u00e1t sinh l\u1ed7i. Nh\u01b0ng kh\u00f4ng \u1ea3nh h\u01b0\u1edfng g\u00ec \u0111\u1ebfn b\u1ea3ng t\u00ednh n\u00ean kh\u00f4ng c\u1ea7n lo l\u1eafng v\u1ec1 vi\u1ec7c n\u00e0y.<\/p>\n<p>Nh\u01b0 v\u1eady ta \u0111\u00e3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c ph\u1ea7n c\u00e1c ng\u00e0y trong th\u00e1ng, v\u00e0 c\u00e1c th\u1ee9 trong tu\u1ea7n.<\/p>\n<p>Ti\u1ebfp theo l\u00e0 vi\u1ec7c t\u1ef1 \u0111\u1ed9ng \u0111\u1ed5i m\u00e0u cho c\u00e1c ng\u00e0y th\u1ee9 7, ch\u1ee7 nh\u1eadt cho kh\u00e1c v\u1edbi ng\u00e0y th\u01b0\u1eddng<\/p>\n<p>+ B\u00f4i \u0111en n\u1ed9i dung trong b\u1ea3ng (T\u1eeb E9 \u0111\u1ebfn AI30 \u2013 t\u1ee9c l\u00e0 t\u1ea5t c\u1ea3 c\u00e1c n\u1ed9i dung v\u1ec1 ng\u00e0y trong th\u00e1ng l\u1eabn ph\u1ea7n ch\u1ea5m c\u00f4ng c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean), ch\u1ecdn ch\u1ee9c n\u0103ng Conditional Formatting (\u0111\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n), trong m\u1ee5c Condittional Formatting, ch\u1ecdn New Rule.<\/p>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-13.jpg\" width=\"640\" height=\"484\" border=\"0\" title=\"bcc-13\"><\/div>\n<div class=\"separator\"><\/div>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-14.jpg\" width=\"400\" height=\"318\" border=\"0\" title=\"bcc-14\"><\/div>\n<div class=\"separator\">Trong b\u1ea3ng New Formatting Rule, b\u1ea1n ch\u1ecdn d\u00f2ng cu\u1ed1i c\u00f9ng trong m\u1ee5c Select a Rule Type l\u00e0 Use a formula to determine which cells to format (D\u00f9ng c\u00f4ng th\u1ee9c \u0111\u1ec3 m\u00f4 t\u1ea3 c\u00e1ch \u0111\u1ecbnh d\u1ea1ng cells)<\/div>\n<div class=\"separator\"><\/div>\n<div class=\"separator\">+\u00a0T\u1ea1i m\u1ee5c Format values where this formula is true, ta nh\u1eadp h\u00e0m<\/div>\n<div class=\"separator\" style=\"padding-left: 30px\">=if(weekday(e$9)=1;true;false)<\/div>\n<div class=\"separator\"><strong>N\u1ed9i dung h\u00e0m<\/strong>: N\u1ebfu ng\u00e0y trong tu\u1ea7n t\u1ea1i \u00f4 e9 l\u00e0 1 (t\u1ee9c l\u00e0 ch\u1ee7 nh\u1eadt) th\u00ec l\u00e0 \u0111\u00fang, kh\u00f4ng th\u00ec s\u1ebd sai. N\u1ebfu d\u00fang th\u00ec s\u1ebd \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u1ee7a Conditional formatting. \u0110\u1eb7t d\u1ea5u c\u1ed1 \u0111\u1ecbnh e$9 l\u00e0 c\u1ed1 \u0111\u1ecbnh h\u00e0ng 9, t\u00ednh t\u1eeb c\u1ed9t e.<\/div>\n<div class=\"separator\"><\/div>\n<div class=\"separator\">+\u00a0Sau khi \u0111\u1eb7t h\u00e0m, ta thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng cho CF. Trong b\u1ea3ng \u0111\u1ecbnh d\u1ea1ng, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn font ch\u1eef, m\u00e0u ch\u1eef t\u1ea1i Font, m\u00e0u n\u1ec1n t\u1ea1i Fill, k\u1ebb \u0111\u01b0\u1eddng vi\u1ec1n \u00f4 t\u1ea1i Border\u2026 (gi\u1ed1ng \u0111\u1ecbnh d\u1ea1ng \u00f4 c\u1ee7a Format cells th\u00f4ng th\u01b0\u1eddng). Ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng xong b\u1ea5m ok.<\/div>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-15.jpg\" width=\"640\" height=\"374\" border=\"0\" title=\"bcc-15\"><\/div>\n<div class=\"separator\"><\/div>\n<div class=\"separator\"><\/div>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-16.jpg\" width=\"640\" height=\"512\" border=\"0\" title=\"bcc-16\"><\/div>\n<div class=\"separator\" style=\"text-align: center\">K\u1ebft qu\u1ea3 khi th\u1ef1c hi\u1ec7n Conditional formatting v\u1edbi \u0111i\u1ec1u ki\u1ec7n ng\u00e0y ch\u1ee7 nh\u1eadt.<\/div>\n<div class=\"separator\">+ L\u00e0m t\u01b0\u01a1ng t\u1ef1 v\u1edbi \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u1ee9 7:<\/div>\n<div class=\"separator\">B\u00f4i \u0111en v\u00f9ng trong b\u1ea3ng, ch\u1ecdn ch\u1ee9c n\u0103ng Conditional Formatting\/ New rule\/ Use a formulas\u2026, nh\u1eadp h\u00e0m =if(weekday(e$9)=7;true;false) , ch\u1ecdn ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng cho ng\u00e0y th\u1ee9 7<\/div>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-18.jpg\" width=\"640\" height=\"512\" border=\"0\" title=\"bcc-18\"><\/div>\n<div class=\"separator\" style=\"text-align: center\">K\u1ebft qu\u1ea3 khi th\u1ef1c hi\u1ec7n \u0111\u1ecbnh d\u1ea1ng th\u1ee9 7 v\u00e0 ch\u1ee7 nh\u1eadt<\/div>\n<p>+ Thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng cho c\u00e1c c\u1ed9t kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb ng\u00e0y (v\u00ed d\u1ee5 th\u00e1ng 2 c\u00f3 28 ng\u00e0y, t\u1ef1 \u0111\u1ed9ng b\u00f4i \u0111en c\u00e1c ng\u00e0y tr\u1ed1ng \u0111\u1ec3 ph\u00e2n bi\u1ec7t)<\/p>\n<p>B\u01b0\u1edbc 1: T\u1ea1i \u00f4 B4, s\u1eeda t\u1ea1m gi\u00e1 tr\u1ecb th\u00e1ng l\u00e0 2 \u0111\u1ec3 l\u00e0m th\u1eed<\/p>\n<p>B\u01b0\u1edbc 2: B\u00f4i \u0111en v\u00f9ng trong b\u1ea3ng, ch\u1ecdn ch\u1ee9c n\u0103ng Conditional formatting \/ new rule \/ use a formulas\u2026, nh\u1eadp h\u00e0m\u00a0=if(e$9=\u201d\u201d;true;false), ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng l\u00e0 t\u00f4 m\u00e0u x\u00e1m cho ch\u1eef v\u00e0 n\u1ec1n, ta c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<div class=\"separator\"><\/div>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-19.jpg\" width=\"640\" height=\"512\" border=\"0\" title=\"bcc-19\"><\/div>\n<div class=\"separator\"><\/div>\n<p>Khi l\u00e0m xong nh\u1edb tr\u1ea3 l\u1ea1i gi\u00e1 tr\u1ecb th\u00e1ng 1 \u1edf \u00f4 B4 nh\u00e9.<\/p>\n<p>Ph\u00f9, v\u1eady l\u00e0 xong ph\u1ea7n thi\u1ebft l\u1eadp ng\u00e0y th\u00e1ng cho b\u1ea3ng ch\u1ea5m c\u00f4ng. Gi\u1edd c\u00f2n kh\u00e2u cu\u1ed1i c\u00f9ng l\u00e0 \u0111\u1eb7t k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng n\u1eefa l\u00e0 xong.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dat_ky_hieu_cham_cong\"><\/span>\u0110\u1eb7t k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>+ B\u1ea1n ch\u1ecdn 1 v\u00e0i k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng cho 1 s\u1ed1 lo\u1ea1i c\u00f4ng nh\u01b0 sau:<\/p>\n<ul>\n<li>Ng\u00e0y c\u00f4ng th\u1ef1c t\u1ebf (\u0111i l\u00e0m \u0111\u1ee7 s\u1ed1 c\u00f4ng):<\/li>\n<li>N\u1eeda ng\u00e0y c\u00f4ng (l\u00e0m n\u1eeda ca, n\u1eeda ng\u00e0y\u2026)<\/li>\n<li>Ng\u00e0y ngh\u1ec9 h\u01b0\u1edfng nguy\u00ean l\u01b0\u01a1ng (\u0111i h\u1ecdc, h\u1ecdp, ph\u00e9p\u2026 ngh\u1ec9 m\u00e0 c\u00f3 l\u01b0\u01a1ng)<\/li>\n<li>Ngh\u1ec9 kh\u00f4ng l\u01b0\u01a1ng<\/li>\n<\/ul>\n<p>\u2026. (t\u00f9y \u0111\u01a1n v\u1ecb m\u00e0 ch\u1ecdn c\u00e1c h\u00ecnh th\u1ee9c ch\u1ea5m c\u00f4ng kh\u00e1c nhau)<\/p>\n<p>L\u01b0u \u00fd m\u1ed7i k\u00ed hi\u1ec7u ch\u1ea5m c\u00f4ng s\u1ebd t\u01b0\u01a1ng \u1ee9ng v\u1edbi 1 c\u1ed9t quy ra c\u00f4ng (ho\u1eb7c c\u00f3 th\u1ec3 g\u1ed9p), ngo\u00e0i ra th\u00eam 1 c\u1ed9t t\u00ednh t\u1ed5ng s\u1ed1 c\u00f4ng<\/p>\n<p>T\u1ea1i v\u00ed d\u1ee5 t\u00f4i \u0111\u1eb7t nh\u01b0 sau:<\/p>\n<ul>\n<li>Ng\u00e0y c\u00f4ng th\u1ef1c t\u1ebf: x<\/li>\n<li>N\u1eeda ng\u00e0y c\u00f4ng : v<\/li>\n<li>Ng\u00e0y ngh\u1ec9 h\u01b0\u1edfng nguy\u00ean l\u01b0\u01a1ng: P<\/li>\n<li>Ngh\u1ec9 kh\u00f4ng l\u01b0\u01a1ng: K<\/li>\n<li>\u1ed0m \u0111au, thai s\u1ea3n: O<\/li>\n<\/ul>\n<div class=\"separator\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bcc-20.jpg\" width=\"640\" height=\"512\" border=\"0\" title=\"bcc-20\"><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_cong_thuc_tinh_cong\"><\/span>H\u00e0m, c\u00f4ng th\u1ee9c t\u00ednh c\u00f4ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1i c\u1ed9t Ng\u00e0y c\u00f4ng th\u1ef1c t\u1ebf (c\u1ed9t AJ), t\u1ea1i \u00f4 AJ11, \u0111\u1eb7t h\u00e0m sau:<\/p>\n<p style=\"padding-left: 30px\">=COUNTIF($E11:$AI11;$G$34)<\/p>\n<p>N\u1ed9i dung h\u00e0m: \u0110\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a gi\u00e1 tr\u1ecb t\u1ea1i \u00f4 G34, trong v\u00f9ng E11 \u0111\u1ebfn AI11. Gi\u00e1 tr\u1ecb t\u1ea1i \u00f4 G34 l\u00e0 k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng c\u1ee7a ng\u00e0y c\u00f4ng \u0111\u1ee7, v\u00f9ng E11 \u0111\u1ebfn AI11 l\u00e0 s\u1ed1 ng\u00e0y c\u00f4ng trong th\u00e1ng c\u1ee7a ng\u01b0\u1eddi \u0111\u1ea7u ti\u00ean (h\u00e0ng 11), c\u1ed1 \u0111\u1ecbnh c\u1ed9t E v\u00e0 AI \u0111\u1ec3 khi copy c\u00f4ng th\u1ee9c kh\u00f4ng b\u1ecb \u1ea3nh h\u01b0\u1edfng t\u1edbi v\u00f9ng ch\u1ea5m c\u00f4ng<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c c\u1ed9t kh\u00e1c, ta \u0111\u1eb7t c\u00f4ng th\u1ee9c:<\/p>\n<ul>\n<li>\u00d4 AK11 (N\u1eeda c\u00f4ng) = countif($E11:$AI11;$G$35)<\/li>\n<li>\u00d4 AL11 (Ngh\u1ec9 h\u01b0\u1edfng l\u01b0\u01a1ng) = countif($E11:$AI11;$G$36)<\/li>\n<li>\u00d4 AM11 (ngh\u1ec9 kh\u00f4ng l\u01b0\u01a1ng) = countif($E11:$AI11;$G$37)<\/li>\n<li>\u00d4 AN11 (\u1ed1m \u0111au, thai s\u1ea3n) = countif($E11:$AI11;$G$38)<\/li>\n<\/ul>\n<p>T\u1ed5ng s\u1ed1 c\u00f4ng s\u1ebd t\u00ednh t\u00f9y theo y\u00eau c\u1ea7u t\u00ednh c\u00f4ng c\u1ee7a \u0111\u01a1n v\u1ecb. V\u00ed d\u1ee5: t\u1ed5ng ng\u00e0y c\u00f4ng = Ng\u00e0y c\u00f4ng th\u1ef1c t\u1ebf\u00a0+ N\u1eeda c\u00f4ng x 0,5\u00a0+ Ngh\u1ec9 h\u01b0\u1edfng l\u01b0\u01a1ng\u00a0+ \u1ed0m \u0111au, thai s\u1ea3n<\/p>\n<p style=\"padding-left: 30px\">\u00d4 AO11 = AJ11+AK11*0,5+AL11+AN11<\/p>\n<p>Sau khi \u0111\u1eb7t c\u00f4ng th\u1ee9c xong, ta copy c\u00f4ng th\u1ee9c xu\u1ed1ng cho c\u00e1c nh\u00e2n vi\u00ean kh\u00e1c<\/p>\n<p>Khi ho\u00e0n thi\u1ec7n s\u1ebd c\u00f3 nh\u01b0 sau:<\/p>\n<div class=\"separator\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tao_bcc-01.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tao_bcc-01.jpg\" width=\"640\" height=\"512\" border=\"0\" title=\"tao_bcc-01\"><\/a><\/div>\n<p>Nh\u01b0 v\u1eady l\u00e0 \u0111\u00e3 ho\u00e0n thi\u1ec7n xong vi\u1ec7c ch\u1ea5m c\u00f4ng, t\u1ea1o k\u00fd hi\u1ec7u v\u00e0 t\u00ednh s\u1ed1 c\u00f4ng. Gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch ch\u1ea5m th\u1eed v\u00e0i k\u00fd hi\u1ec7u v\u00e0o b\u1ea3ng \u0111\u1ec3 ki\u1ec3m tra.<\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 ta \u0111\u00e3 ho\u00e0n ch\u1ec9nh xong b\u1ea3ng ch\u1ea5m c\u00f4ng c\u1ee7a th\u00e1ng 1. Gi\u1edd ch\u1ec9 c\u00f2n vi\u1ec7c copy ra c\u00e1c th\u00e1ng c\u00f2n l\u1ea1i.<\/p>\n<p>Ngo\u00e0i vi\u1ec7c ch\u1ea5m c\u00f4ng, ch\u00fang ta c\u00f2n c\u1ea7n ph\u1ea3i l\u00e0m nh\u1eefng c\u00f4ng vi\u1ec7c kh\u00e1c li\u00ean quan t\u1edbi ti\u1ec1n l\u01b0\u01a1ng, b\u1ea3o hi\u1ec3m, thu\u1ebf TNCN\u2026 \u0110\u1ec3 n\u1eafm \u0111\u01b0\u1ee3c nh\u1eefng ki\u1ebfn th\u1ee9c v\u00e0 c\u00e1ch \u1ee9ng d\u1ee5ng Excel trong c\u00f4ng vi\u1ec7c h\u00e0nh ch\u00ednh-nh\u00e2n s\u1ef1, m\u1eddi b\u1ea1n tham gia kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\">H\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1 t\u1eeb A-Z c\u1ee7a H\u1ecdc Excel Online<\/a>. B\u1eadt m\u00ed l\u00e0 b\u1ea1n c\u00f2n \u0111\u01b0\u1ee3c t\u1eb7ng k\u00e8m ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 khi tham gia kh\u00f3a h\u1ecdc n\u00e0y nh\u00e9. \u00c0 qu\u00ean, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 file excel theo d\u00f5i ngh\u1ec9 ph\u00e9p khi tham gia kh\u00f3a h\u1ecdc n\u1eefa. Chi ti\u1ebft xem t\u1ea1i: H\u1ecdc Excel Online\n<\/p>\n<\/div>\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\/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-215.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2787,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2786","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2786","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=2786"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2786\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2787"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2786"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2786"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}