{"id":1661,"date":"2024-12-02T05:46:44","date_gmt":"2024-12-02T05:46:44","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dinh-dang-co-dieu-kien-ngay-thang-va-thoi-gian-trong-excel-nhieu-vi-du-hay\/"},"modified":"2024-12-02T05:46:44","modified_gmt":"2024-12-02T05:46:44","slug":"cach-dinh-dang-co-dieu-kien-ngay-thang-va-thoi-gian-trong-excel-nhieu-vi-du-hay","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dinh-dang-co-dieu-kien-ngay-thang-va-thoi-gian-trong-excel-nhieu-vi-du-hay\/","title":{"rendered":"C\u00e1ch \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian trong Excel, nhi\u1ec1u v\u00ed d\u1ee5 hay."},"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\/\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd gi\u1ea3i th\u00edch c\u00e1ch \u00e1p d\u1ee5ng c\u00e1c quy t\u1eafc \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng trong Excel v\u00e0 t\u1ea1o c\u00e1c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a ri\u00eang b\u1ea1n d\u1ef1a tr\u00ean c\u00e1c c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd ch\u00fang ta s\u1ebd t\u1eadn d\u1ee5ng ki\u1ebfn \u200b\u200bth\u1ee9c n\u00e0y v\u00e0 t\u1ea1o ra c\u00e1c b\u1ea3ng t\u00ednh ph\u00e2n bi\u1ec7t gi\u1eefa c\u00e1c ng\u00e0y trong tu\u1ea7n v\u00e0 cu\u1ed1i tu\u1ea7n, l\u00e0m n\u1ed5i b\u1eadt c\u00e1c ng\u00e0y l\u1ec5 ch\u00ednh th\u1ee9c v\u00e0 hi\u1ec3n m\u1ed1c th\u1eddi gian s\u1eafp t\u1edbi. N\u00f3i c\u00e1ch kh\u00e1c, ch\u00fang ta s\u1ebd \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n Excel cho ng\u00e0y. N\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t s\u1ed1 ki\u1ebfn \u200b\u200bth\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 c\u00e1c c\u00f4ng th\u1ee9c Excel, b\u1ea1n c\u00f3 th\u1ec3 quen v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m ng\u00e0y gi\u1edd nh\u01b0 NOW, TODAY, DATE, WEEKDAY, vv Trong h\u01b0\u1edbng d\u1eabn n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u s\u00e2u h\u01a1n c\u00e1c h\u00e0m \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n ng\u00e0y theo c\u00e1ch b\u1ea1n mu\u1ed1n.<\/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-674d49c2e8c6d\" 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<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-dinh-dang-co-dieu-kien-ngay-thang-va-thoi-gian-trong-excel-nhieu-vi-du-hay.html#Dinh_dang_co_dieu_kien_cho_ngay_thang_cac_quy_tac_cai_san\" title=\"\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u00a0cho ng\u00e0y th\u00e1ng (c\u00e1c quy t\u1eafc c\u00e0i s\u1eb5n)\">\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u00a0cho ng\u00e0y th\u00e1ng (c\u00e1c quy t\u1eafc c\u00e0i s\u1eb5n)<\/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-dinh-dang-co-dieu-kien-ngay-thang-va-thoi-gian-trong-excel-nhieu-vi-du-hay.html#Cong_thuc_dinh_dang_co_dieu_kien_cua_Excel_cho_ngay_thang\" title=\"C\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel cho ng\u00e0y th\u00e1ng\">C\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel cho ng\u00e0y 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-dinh-dang-co-dieu-kien-ngay-thang-va-thoi-gian-trong-excel-nhieu-vi-du-hay.html#Cach_lam_noi_bat_ngay_cuoi_tuan_trong_Excel\" title=\"C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt ng\u00e0y cu\u1ed1i tu\u1ea7n trong Excel:\">C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt ng\u00e0y cu\u1ed1i tu\u1ea7n 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-4\" href=\"https:\/\/blog.hocexcel.online\/cach-dinh-dang-co-dieu-kien-ngay-thang-va-thoi-gian-trong-excel-nhieu-vi-du-hay.html#Lam_the_nao_de_lam_noi_bat_ngay_nghi_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt ng\u00e0y ngh\u1ec9 trong Excel:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt ng\u00e0y ngh\u1ec9 trong Excel:<\/a><\/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-dinh-dang-co-dieu-kien-ngay-thang-va-thoi-gian-trong-excel-nhieu-vi-du-hay.html#Dinh_dang_co_dieu_kien_mot_o_khi_gia_tri_o_duoc_thay_doi_thanh_mot_ngay\" title=\"\n\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n m\u1ed9t \u00f4 khi gi\u00e1 tr\u1ecb \u00f4 \u0111\u01b0\u1ee3c thay \u0111\u1ed5i th\u00e0nh m\u1ed9t ng\u00e0y:\"><br \/>\n\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n m\u1ed9t \u00f4 khi gi\u00e1 tr\u1ecb \u00f4 \u0111\u01b0\u1ee3c thay \u0111\u1ed5i th\u00e0nh m\u1ed9t ng\u00e0y:<\/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-dinh-dang-co-dieu-kien-ngay-thang-va-thoi-gian-trong-excel-nhieu-vi-du-hay.html#Lam_the_nao_de_lam_noi_bat_cac_hang_dua_tren_mot_ngay_nhat_dinh_trong_mot_cot_nhat_dinh\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng d\u1ef1a tr\u00ean m\u1ed9t ng\u00e0y nh\u1ea5t \u0111\u1ecbnh trong m\u1ed9t c\u1ed9t nh\u1ea5t \u0111\u1ecbnh:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng d\u1ef1a tr\u00ean m\u1ed9t ng\u00e0y nh\u1ea5t \u0111\u1ecbnh trong m\u1ed9t c\u1ed9t nh\u1ea5t \u0111\u1ecbnh:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-dinh-dang-co-dieu-kien-ngay-thang-va-thoi-gian-trong-excel-nhieu-vi-du-hay.html#Dinh_dang_co_dieu_kien_ngay_thang_trong_Excel_dua_tren_ngay_hien_tai\" title=\"\n\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n ng\u00e0y th\u00e1ng trong Excel d\u1ef1a tr\u00ean ng\u00e0y hi\u1ec7n t\u1ea1i:\"><br \/>\n\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n ng\u00e0y th\u00e1ng trong Excel d\u1ef1a tr\u00ean ng\u00e0y hi\u1ec7n t\u1ea1i:<\/a><\/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-dinh-dang-co-dieu-kien-ngay-thang-va-thoi-gian-trong-excel-nhieu-vi-du-hay.html#Lam_the_nao_de_lam_noi_bat_ngay_thang_trong_mot_pham_vi_ngay\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt ng\u00e0y th\u00e1ng trong m\u1ed9t ph\u1ea1m vi ng\u00e0y:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt ng\u00e0y th\u00e1ng trong m\u1ed9t ph\u1ea1m vi ng\u00e0y:<\/a><\/li>\n<\/ul>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-dinh-dang-co-dieu-kien-ngay-thang-va-thoi-gian-trong-excel-nhieu-vi-du-hay.html#Cong_thuc_de_lam_noi_bat_ngay_trong_tuong_lai\" title=\"\nC\u00f4ng th\u1ee9c \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt ng\u00e0y trong t\u01b0\u01a1ng lai \"><br \/>\nC\u00f4ng th\u1ee9c \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt ng\u00e0y trong t\u01b0\u01a1ng lai <\/a><\/p>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-dinh-dang-co-dieu-kien-ngay-thang-va-thoi-gian-trong-excel-nhieu-vi-du-hay.html#Lam_the_nao_de_to_mau_cac_khoang_trong_va_khoang_thoi_gian\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00f4 m\u00e0u c\u00e1c kho\u1ea3ng tr\u1ed1ng v\u00e0 kho\u1ea3ng th\u1eddi gian:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00f4 m\u00e0u c\u00e1c kho\u1ea3ng tr\u1ed1ng v\u00e0 kho\u1ea3ng th\u1eddi gian:<\/a><\/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_co_dieu_kien_cho_ngay_thang_cac_quy_tac_cai_san\"><\/span><strong>\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u00a0cho ng\u00e0y th\u00e1ng (c\u00e1c quy t\u1eafc c\u00e0i s\u1eb5n)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Microsoft Excel cung c\u1ea5p 10 t\u00f9y ch\u1ecdn \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn d\u1ef1a tr\u00ean ng\u00e0y hi\u1ec7n t\u1ea1i.<\/p>\n<ol style=\"text-align: justify\">\n<li>\u0110\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng, b\u1ea1n ch\u1ec9 c\u1ea7n v\u00e0o tab <strong>Home<\/strong><strong>&gt; <\/strong><strong>Conditional Formatting&gt;Highlight Cell Rules<\/strong> v\u00e0 ch\u1ecdn <strong>A <\/strong><strong>Date Occurring..<\/strong><strong>.<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-date-occurring.png\" alt=\"Excel conditional formatting built-in rules for dates\" title=\"excel-date-occurring\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Ch\u1ecdn m\u1ed9t trong c\u00e1c t\u00f9y ch\u1ecdn ng\u00e0y t\u1eeb danh s\u00e1ch th\u1ea3 xu\u1ed1ng \u1edf ph\u1ea7n b\u00ean tay tr\u00e1i c\u1ee7a c\u1eeda s\u1ed5, t\u1eeb th\u00e1ng tr\u01b0\u1edbc \u0111\u1ebfn th\u00e1ng sau.<\/li>\n<li>Cu\u1ed1i c\u00f9ng, ch\u1ecdn m\u1ed9t trong c\u00e1c \u0111\u1ecbnh d\u1ea1ng c\u00f3 s\u1eb5n ho\u1eb7c thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng c\u1ee7a b\u1ea1n b\u1eb1ng c\u00e1ch ch\u1ecdn c\u00e1c tu\u1ef3 ch\u1ecdn kh\u00e1c nhau tr\u00ean tab <strong>Font, Border<\/strong> v\u00e0 <strong>Fill<\/strong>. N\u1ebfu b\u1ea3ng t\u00ednh c\u01a1 b\u1ea3n kh\u00f4ng \u0111\u1ee7, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o n\u00fat <strong>More colors\u2026<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-formats-dates.png\" alt=\"Choose one of the pre-defined formats or set up your custom format.\" title=\"excel-formats-dates\"><\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Nh\u1ea5p v\u00e0o OK v\u00e0 t\u1eadn h\u01b0\u1edfng k\u1ebft qu\u1ea3! \ud83d\ude42<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5930\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-103.png\" width=\"600\" height=\"219\" title=\"excel-dialog-box-launcher-1-103\"><\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, c\u00e1ch nhanh v\u00e0 tr\u1ef1c ti\u1ebfp n\u00e0y c\u00f3 hai h\u1ea1n ch\u1ebf \u0111\u00e1ng k\u1ec3 \u2013 1) ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng v\u1edbi c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn v\u00e0 2) \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n lu\u00f4n \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng d\u1ef1a tr\u00ean ng\u00e0y hi\u1ec7n t\u1ea1i.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_dinh_dang_co_dieu_kien_cua_Excel_cho_ngay_thang\"><\/span><strong>C\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel cho ng\u00e0y th\u00e1ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 ho\u1eb7c to\u00e0n b\u1ed9 h\u00e0ng d\u1ef1a tr\u00ean m\u1ed9t ng\u00e0y trong m\u1ed9t \u00f4 kh\u00e1c, ho\u1eb7c t\u1ea1o c\u00e1c quy t\u1eafc cho c\u00e1c kho\u1ea3ng th\u1eddi gian l\u1edbn h\u01a1n (t\u1ee9c l\u00e0 h\u01a1n m\u1ed9t th\u00e1ng k\u1ec3 t\u1eeb ng\u00e0y hi\u1ec7n t\u1ea1i), b\u1ea1n s\u1ebd ph\u1ea3i t\u1ef1 t\u1ea1o ra quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a m\u00ecnh d\u1ef1a tr\u00ean m\u1ed9t c\u00f4ng th\u1ee9c . D\u01b0\u1edbi \u0111\u00e2y b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y m\u1ed9t v\u00e0i v\u00ed d\u1ee5 v\u1ec1 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel cho ng\u00e0y th\u00e1ng.<\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html\">Ca\u0301ch du\u0300ng ha\u0300m IF trong Exel: C\u00f4ng th\u01b0\u0301c cho s\u00f4\u0301, ky\u0301 t\u01b0\u0323, d\u01b0\u0303 li\u00ea\u0323u va\u0300 \u00f4 tr\u00f4\u0301ng<\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_lam_noi_bat_ngay_cuoi_tuan_trong_Excel\"><\/span><strong>C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt ng\u00e0y cu\u1ed1i tu\u1ea7n trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Th\u1eadt \u0111\u00e1ng ti\u1ebfc, Microsoft Excel kh\u00f4ng c\u00f3 l\u1ecbch tr\u00ecnh t\u00edch h\u1ee3p t\u01b0\u01a1ng t\u1ef1 nh\u01b0 Outlook. Ch\u00fang ta h\u00e3y xem l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 th\u1ec3 t\u1ea1o ra l\u1ecbch t\u1ef1 \u0111\u1ed9ng c\u1ee7a ri\u00eang m\u00ecnh.<\/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-50.gif\" title=\"vba101_92019-nho-50\"><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-121.gif\" title=\"ex101_92019-nho-121\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Khi thi\u1ebft k\u1ebf l\u1ecbch, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m<strong> = DATE (n\u0103m, th\u00e1ng, ng\u00e0y)<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb nh\u1eefng ng\u00e0y trong tu\u1ea7n. \u0110\u01a1n gi\u1ea3n ch\u1ec9 c\u1ea7n nh\u1eadp n\u0103m v\u00e0 s\u1ed1 th\u00e1ng v\u00e0o n\u01a1i n\u00e0o \u0111\u00f3 trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n v\u00e0 tham chi\u1ebfu nh\u1eefng \u00f4 \u0111\u00f3 trong c\u00f4ng th\u1ee9c. T\u1ea5t nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp c\u00e1c con s\u1ed1 tr\u1ef1c ti\u1ebfp v\u00e0o c\u00f4ng th\u1ee9c, nh\u01b0ng \u0111\u00e2y kh\u00f4ng ph\u1ea3i l\u00e0 c\u00e1ch l\u00e0m hi\u1ec7u qu\u1ea3 v\u00ec b\u1ea1n ph\u1ea3i \u0111i\u1ec1u ch\u1ec9nh c\u00f4ng th\u1ee9c cho m\u1ed7i th\u00e1ng.<\/p>\n<p style=\"text-align: justify\">H\u00ecnh b\u00ean d\u01b0\u1edbi minh h\u1ecda h\u00e0m DATE. T\u00f4i \u0111\u00e3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c <strong>= DATE ($B$2, $B$1, B$4)<\/strong> \u0111\u01b0\u1ee3c sao ch\u00e9p qua h\u00e0ng th\u1ee9 5.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5931\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-104.png\" width=\"600\" height=\"181\" title=\"excel-dialog-box-launcher-1-104\"><\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o<\/strong>. N\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n hi\u1ec3n th\u1ecb nh\u1eefng ng\u00e0y trong tu\u1ea7n nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh tr\u00ean, h\u00e3y ch\u1ecdn c\u00e1c \u00f4 c\u00f3 c\u00f4ng th\u1ee9c (d\u00f2ng 5 trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a ch\u00fang ta), nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn <strong>Format Cells \u2026&gt; Number&gt; Custom<\/strong>. T\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn d\u01b0\u1edbi <strong>Type<\/strong>, ch\u1ecdn dddd ho\u1eb7c ddd \u0111\u1ec3 hi\u1ec3n th\u1ecb t\u00ean \u0111\u1ea7y \u0111\u1ee7 ho\u1eb7c t\u00ean vi\u1ebft t\u1eaft, t\u01b0\u01a1ng \u1ee9ng. L\u1ecbch Excel c\u1ee7a b\u1ea1n \u0111\u00e3 g\u1ea7n xong, v\u00e0 b\u1ea1n ch\u1ec9 c\u1ea7n thay \u0111\u1ed5i m\u00e0u s\u1eafc cu\u1ed1i tu\u1ea7n. \u0110\u01b0\u01a1ng nhi\u00ean, b\u1ea1n s\u1ebd kh\u00f4ng ph\u1ea3i l\u00e0m th\u1ee7 c\u00f4ng. Ch\u00fang ta s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u1ecbnh d\u1ea1ng c\u00e1c ng\u00e0y cu\u1ed1i tu\u1ea7n b\u1eb1ng c\u00e1ch t\u1ea1o quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean h\u00e0m WEEKDAY.<\/p>\n<ol style=\"text-align: justify\">\n<li>B\u1ea1n b\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch ch\u1ecdn l\u1ecbch Excel c\u1ee7a m\u00ecnh n\u01a1i b\u1ea1n mu\u1ed1n \u0111\u00e1nh d\u1ea5u nh\u1eefng ng\u00e0y cu\u1ed1i tu\u1ea7n. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, \u0111\u00f3 l\u00e0 v\u00f9ng $B$4: $AE$10. H\u00e3y ch\u1eafc ch\u1eafn b\u1eaft \u0111\u1ea7u l\u1ef1a ch\u1ecdn v\u1edbi c\u1ed9t ng\u00e0y \u0111\u1ea7u ti\u00ean \u2013 Colum B trong v\u00ed d\u1ee5 n\u00e0y.<\/li>\n<li>Tr\u00ean tab <strong>Home<\/strong>, nh\u1ea5p v\u00e0o <strong>Conditional Formatting menu<\/strong>&gt; <strong>New Rule<\/strong>.<\/li>\n<li>T\u1ea1o ra m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng m\u1edbi d\u1ef1a tr\u00ean m\u1ed9t c\u00f4ng th\u1ee9c, nh\u01b0 \u0111\u00e3 \u0111\u01b0\u1ee3c gi\u1ea3i th\u00edch trong <strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c<\/strong>.<\/li>\n<li>Trong h\u1ed9p \u201c<strong>Format values where this formula is true<\/strong>\u201d, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c WEEKDAY sau \u0111\u00e2y \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh \u00f4 n\u00e0o l\u00e0 Th\u1ee9 b\u1ea3y v\u00e0 Ch\u1ee7 nh\u1eadt:<strong> = WEEKDAY (B$5,2)&gt; 5<\/strong>.<\/li>\n<li>Nh\u1ea5p v\u00e0o n\u00fat <strong>Format<\/strong> <strong>\u2026<\/strong> v\u00e0 thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh c\u1ee7a b\u1ea1n b\u1eb1ng c\u00e1ch chuy\u1ec3n gi\u1eefa c\u00e1c tab Font, Border v\u00e0 Fill v\u00e0 c\u00e1c t\u00f9y ch\u1ecdn kh\u00e1c. Khi ho\u00e0n t\u1ea5t, nh\u1ea5p v\u00e0o n\u00fat OK \u0111\u1ec3 xem l\u1ea1i quy t\u1eafc.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/conditional-formatting-date-formula.png\" alt=\"Excel conditional formatting rule with the WEEKDAY formula to highlight weekends.\" title=\"conditional-formatting-date-formula\"><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, h\u00e3y \u0111\u1ec3 t\u00f4i gi\u1ea3i th\u00edch ng\u1eafn g\u1ecdn c\u00f4ng th\u1ee9c <strong>WEEKDAY (serial_number, [return_type])<\/strong> \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng \u0111i\u1ec1u ch\u1ec9nh n\u00f3 cho b\u1ea3ng t\u00ednh c\u1ee7a ri\u00eang b\u1ea1n.<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>serial_number<\/strong> \u0111\u1ea1i di\u1ec7n cho ng\u00e0y m\u00e0 b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm. B\u1ea1n nh\u1eadp m\u1ed9t tham chi\u1ebfu \u0111\u1ebfn \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea1n v\u1edbi m\u1ed9t ng\u00e0y, B$5 trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a ch\u00fang t\u00f4i.<\/li>\n<li><strong>[return_type]<\/strong> x\u00e1c \u0111\u1ecbnh lo\u1ea1i tu\u1ea7n (d\u1ea5u ngo\u1eb7c vu\u00f4ng ng\u1ee5 \u00fd n\u00f3 l\u00e0 t\u00f9y ch\u1ecdn). B\u1ea1n nh\u1eadp 2 l\u00e0 lo\u1ea1i tr\u1ea3 v\u1ec1 cho m\u1ed9t tu\u1ea7n b\u1eaft \u0111\u1ea7u t\u1eeb Th\u1ee9 Hai (1) \u0111\u1ebfn Ch\u1ee7 Nh\u1eadt (7).<\/li>\n<li>Cu\u1ed1i c\u00f9ng, b\u1ea1n vi\u1ebft&gt; 5 \u0111\u1ec3 ch\u1ec9 c\u00e1c ng\u00e0y th\u1ee9 b\u1ea3y (6) v\u00e0 ch\u1ee7 nh\u1eadt (7).<\/li>\n<\/ul>\n<p style=\"text-align: justify\">H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y k\u1ebft qu\u1ea3 trong Excel 2013 \u2013 nh\u1eefng ng\u00e0y cu\u1ed1i tu\u1ea7n \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng m\u00e0u \u0111\u1ecf.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5932\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-105.png\" width=\"600\" height=\"471\" title=\"excel-dialog-box-launcher-1-105\"><br \/>\n<strong>M\u1eb9o<\/strong>:<\/p>\n<ul style=\"text-align: justify\">\n<li>N\u1ebfu c\u00f4ng ty b\u1ea1n c\u00f3 ng\u00e0y ngh\u1ec9 kh\u00f4ng theo chu\u1ea9n, v\u00ed d\u1ee5: Th\u1ee9 S\u00e1u v\u00e0 Th\u1ee9 B\u1ea3y, sau \u0111\u00f3 b\u1ea1n c\u1ea7n tinh ch\u1ec9nh c\u00f4ng th\u1ee9c \u0111\u1ec3 b\u1eaft \u0111\u1ea7u \u0111\u1ebfm t\u1eeb Ch\u1ee7 Nh\u1eadt (1) v\u00e0 l\u00e0m n\u1ed5i b\u1eadt ng\u00e0y 6 (Th\u1ee9 6) v\u00e0 7 (Th\u1ee9 7) \u2013 <strong>WEEKDAY(B$5,1)&gt; 5<\/strong>.<\/li>\n<li>N\u1ebfu b\u1ea1n \u0111ang t\u1ea1o l\u1ecbch ngang, h\u00e3y s\u1eed d\u1ee5ng c\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i (kh\u00f4ng c\u00f3 $) v\u00e0 d\u00f2ng tuy\u1ec7t \u0111\u1ed1i (v\u1edbi $) trong tham chi\u1ebfu \u00f4 v\u00ec b\u1ea1n n\u00ean kh\u00f3a tham chi\u1ebfu c\u1ee7a h\u00e0ng \u2013 trong v\u00ed d\u1ee5 tr\u00ean l\u00e0 h\u00e0ng 5, do \u0111\u00f3 Ch\u00fang t\u00f4i \u0111\u00e3 nh\u1eadp v\u00e0o B$5. Nh\u01b0ng n\u1ebfu b\u1ea1n \u0111ang thi\u1ebft k\u1ebf l\u1ecbch theo h\u01b0\u1edbng d\u1ecdc, b\u1ea1n n\u00ean l\u00e0m ng\u01b0\u1ee3c l\u1ea1i, t\u1ee9c l\u00e0 s\u1eed d\u1ee5ng m\u1ed9t c\u1ed9t tuy\u1ec7t \u0111\u1ed1i v\u00e0 h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i, v\u00ed d\u1ee5: $B5 nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/weekends-highlighted-vertical.png\" alt=\"Excel conditional formatting formula to highlight weekends in a vertical orientation calendar.\" title=\"weekends-highlighted-vertical\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_lam_noi_bat_ngay_nghi_trong_Excel\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt ng\u00e0y ngh\u1ec9 trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 c\u1ea3i thi\u1ec7n l\u1ecbch c\u1ee7a b\u1ea1n h\u01a1n n\u1eefa, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 \u0111\u00e1nh d\u1ea5u c\u00e1c ng\u00e0y l\u1ec5. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u \u0111\u00f3, b\u1ea1n s\u1ebd c\u1ea7n li\u1ec7t k\u00ea c\u00e1c ng\u00e0y l\u1ec5 b\u1ea1n mu\u1ed1n l\u00e0m n\u1ed5i b\u1eadt trong c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh ho\u1eb7c m\u1ed9t s\u1ed1 b\u1ea3ng t\u00ednh kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: t\u00f4i \u0111\u00e3 th\u00eam c\u00e1c ng\u00e0y l\u1ec5 sau v\u00e0o c\u1ed9t A ($A$14: $A$17).<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/us-holidays.png\" alt=\"Add list of public holidays to a worksheet.\" title=\"us-holidays\"><br \/>\nM\u1ed9t l\u1ea7n n\u1eefa, b\u1ea1n m\u1edf <strong>Conditional Formatting&gt; New Rule<\/strong>. Trong tr\u01b0\u1eddng h\u1ee3p ngh\u1ec9 l\u1ec5, b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng h\u00e0m MATCH ho\u1eb7c COUNTIF:<\/p>\n<ul style=\"text-align: justify\">\n<li>= COUNTIF ($A$14: $A$17, B$5)&gt; 0<\/li>\n<li>= MATCH (B$5, $A$14: $A$17,0)<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Ch\u00fa th\u00edch. N\u1ebfu b\u1ea1n \u0111\u00e3 ch\u1ecdn m\u00e0u kh\u00e1c cho ng\u00e0y ngh\u1ec9, b\u1ea1n c\u1ea7n di chuy\u1ec3n danh s\u00e1ch ng\u00e0y ngh\u1ec9 l\u1ec5 l\u00ean \u0111\u1ea7u th\u00f4ng qua <strong>Conditional Formatting&gt; Manage Rules<\/strong>\u2026<\/p>\n<p style=\"text-align: justify\">H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y k\u1ebft qu\u1ea3 trong Excel 2013:<\/p>\n<h2 style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5933\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-106.png\" width=\"600\" height=\"349\" title=\"excel-dialog-box-launcher-1-106\"><br \/>\n<strong>\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n m\u1ed9t \u00f4 khi gi\u00e1 tr\u1ecb \u00f4 \u0111\u01b0\u1ee3c thay \u0111\u1ed5i th\u00e0nh m\u1ed9t ng\u00e0y:<\/strong><\/h2>\n<p style=\"text-align: justify\">Kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t v\u1ea5n \u0111\u1ec1 l\u1edbn khi \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n m\u1ed9t \u00f4 khi m\u1ed9t ng\u00e0y \u0111\u01b0\u1ee3c th\u00eam v\u00e0o \u00f4 \u0111\u00f3 ho\u1eb7c b\u1ea5t k\u1ef3 \u00f4 n\u00e0o kh\u00e1c trong c\u00f9ng h\u00e0ng mi\u1ec5n l\u00e0 kh\u00f4ng c\u00f3 lo\u1ea1i gi\u00e1 tr\u1ecb kh\u00e1c. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt kho\u1ea3ng tr\u1ed1ng, nh\u01b0 \u0111\u01b0\u1ee3c m\u00f4 t\u1ea3 trong c\u00e1c c\u00f4ng th\u1ee9c c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel \u0111\u1ed1i v\u1edbi c\u00e1c kho\u1ea3ng tr\u1ed1ng v\u00e0 kh\u00f4ng tr\u1ed1ng. Nh\u01b0ng n\u1ebfu nh\u1eefng \u00f4 \u0111\u00f3 c\u00f3 gi\u00e1 tr\u1ecb, v\u00ed d\u1ee5: v\u0103n b\u1ea3n, v\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i m\u00e0u n\u1ec1n khi v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c thay \u0111\u1ed5i th\u00e0nh m\u1ed9t ng\u00e0y?<\/p>\n<p style=\"text-align: justify\">Nhi\u1ec7m v\u1ee5 \u00a0nghe c\u00f3 v\u1ebb ph\u1ee9c t\u1ea1p, nh\u01b0ng gi\u1ea3i ph\u00e1p r\u1ea5t \u0111\u01a1n gi\u1ea3n.<\/p>\n<ol style=\"text-align: justify\">\n<li>Tr\u01b0\u1edbc h\u1ebft, b\u1ea1n c\u1ea7n ph\u1ea3i x\u00e1c \u0111\u1ecbnh m\u00e3 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ng\u00e0y. \u0110\u00e2y ch\u1ec9 l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5:<\/li>\n<\/ol>\n<ul style=\"text-align: justify\">\n<li>D1: dd-mmm-yy ho\u1eb7c d-mmm-yy<\/li>\n<li>D2: dd-mmm ho\u1eb7c d-mmm<\/li>\n<li>D3: mmm-yy<\/li>\n<li>D4: mm \/ dd \/ yy ho\u1eb7c m \/ d \/ yy ho\u1eb7c m \/ d \/ yy h: mm<\/li>\n<li>B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y danh s\u00e1ch \u0111\u1ea7y \u0111\u1ee7 m\u00e3 s\u1ed1 ng\u00e0y trong <a href=\"http:\/\/office.microsoft.com\/en-001\/excel-help\/cell-function-HP010062392.aspx\">b\u00e0i vi\u1ebft n\u00e0y<\/a>.<\/li>\n<\/ul>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Ch\u1ecdn c\u1ed9t n\u01a1i b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i m\u00e0u c\u1ee7a c\u00e1c \u00f4 ho\u1eb7c to\u00e0n b\u1ed9 b\u1ea3ng trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n \u0111\u00e1nh d\u1ea5u c\u00e1c h\u00e0ng.<\/li>\n<li>V\u00e0 b\u00e2y gi\u1edd t\u1ea1o m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau: <strong>= CELL (\u201cformat\u201d, $ A2) = \u201cD1\u201d<\/strong>. Trong c\u00f4ng th\u1ee9c, A l\u00e0 c\u1ed9t c\u00f3 ng\u00e0y th\u00e1ng v\u00e0 D1 l\u00e0 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n c\u00f3 ng\u00e0y \u1edf 2 ho\u1eb7c nhi\u1ec1u \u0111\u1ecbnh d\u1ea1ng, sau \u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m OR, v\u00ed d\u1ee5: <strong>=OR(cell(\u201cformat\u201d, $A2)=\u201dD1\u2033, cell(\u201cformat\u201d,$A2)=\u201dD2\u2033, cell(\u201cformat\u201d, $A2)=\u201dD3\u2033)<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00ecnh b\u00ean d\u01b0\u1edbi minh h\u1ecda k\u1ebft qu\u1ea3 c\u1ee7a quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho ng\u00e0y th\u00e1ng.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5934\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-107.png\" width=\"600\" height=\"493\" title=\"excel-dialog-box-launcher-1-107\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_lam_noi_bat_cac_hang_dua_tren_mot_ngay_nhat_dinh_trong_mot_cot_nhat_dinh\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng d\u1ef1a tr\u00ean m\u1ed9t ng\u00e0y nh\u1ea5t \u0111\u1ecbnh trong m\u1ed9t c\u1ed9t nh\u1ea5t \u0111\u1ecbnh:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh Excel l\u1edbn c\u00f3 ch\u1ee9a hai c\u1ed9t ng\u00e0y th\u00e1ng (B v\u00e0 C). B\u1ea1n mu\u1ed1n l\u00e0m n\u1ed5i b\u1eadt m\u1ed7i h\u00e0ng c\u00f3 m\u1ed9t ng\u00e0y nh\u1ea5t \u0111\u1ecbnh, v\u00ed d\u1ee5 13-May-14, trong c\u1ed9t C.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho m\u1ed9t ng\u00e0y n\u00e0o \u0111\u00f3, tr\u01b0\u1edbc ti\u00ean b\u1ea1n c\u1ea7n ph\u1ea3i t\u00ecm gi\u00e1 tr\u1ecb s\u1ed1. Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 bi\u1ebft, Microsoft Excel l\u01b0u tr\u1eef c\u00e1c ng\u00e0y nh\u01b0 l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1, b\u1eaft \u0111\u1ea7u t\u1eeb ng\u00e0y 1 th\u00e1ng 1 n\u0103m 1900. V\u00ec v\u1eady, 1 th\u00e1ng 1 n\u0103m 1900 \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef l\u00e0 1, 2 th\u00e1ng 1 n\u0103m 1900 \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef l\u00e0 2 \u2026 v\u00e0 13-May-14 l\u00e0 41772.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ecm s\u1ed1 ng\u00e0y th\u00e1ng, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4, ch\u1ecdn <strong>Format Cells&gt; Number <\/strong>v\u00e0 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng<strong> General<\/strong>. Ghi l\u1ea1i s\u1ed1 b\u1ea1n th\u1ea5y v\u00e0 nh\u1ea5p Cancel b\u1edfi v\u00ec b\u1ea1n kh\u00f4ng th\u1ef1c s\u1ef1 mu\u1ed1n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-numerical-value.png\" alt=\"Find the numerical value of a date.\" title=\"data-numerical-value\"><\/p>\n<p style=\"text-align: justify\">\u0110\u00f3 th\u1ef1c s\u1ef1 l\u00e0 ph\u1ea7n ch\u00ednh c\u1ee7a c\u00f4ng vi\u1ec7c v\u00e0 b\u00e2y gi\u1edd b\u1ea1n ch\u1ec9 c\u1ea7n t\u1ea1o ra m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho to\u00e0n b\u1ed9 b\u1ea3ng v\u1edbi c\u00f4ng th\u1ee9c r\u1ea5t \u0111\u01a1n gi\u1ea3n n\u00e0y:<strong> = $C2 = 41772<\/strong>. C\u00f4ng th\u1ee9c h\u00e0m \u00fd r\u1eb1ng b\u1ea3ng c\u1ee7a b\u1ea1n c\u00f3 ti\u00eau \u0111\u1ec1 v\u00e0 h\u00e0ng 2 l\u00e0 h\u00e0ng \u0111\u1ea7u ti\u00ean c\u00f3 d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\">C\u00e1ch kh\u00e1c l\u00e0 s\u1eed d\u1ee5ng h\u00e0m<strong> DATEVALUE<\/strong> \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i ng\u00e0y th\u00e0nh \u0111\u1ecbnh d\u1ea1ng s\u1ed1, v\u00ed d\u1ee5: = $C2 = DATEVALUE (\u201c5\/13\/2014\u201d)<\/p>\n<p style=\"text-align: justify\">Cho d\u00f9 c\u00f4ng th\u1ee9c b\u1ea1n s\u1eed d\u1ee5ng, n\u00f3 s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 nhau:<\/p>\n<h2 style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/highlight-rows-based-on-date.png\" alt=\"Highlight every row based on a certain date in a certain column.\" title=\"highlight-rows-based-on-date\"><br \/>\n<strong>\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n ng\u00e0y th\u00e1ng trong Excel d\u1ef1a tr\u00ean ng\u00e0y hi\u1ec7n t\u1ea1i:<\/strong><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 bi\u1ebft Microsoft Excel cung c\u1ea5p h\u00e0m <strong>TODAY () <\/strong>cho c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c nhau d\u1ef1a tr\u00ean ng\u00e0y hi\u1ec7n t\u1ea1i. \u0110\u00e2y ch\u1ec9 l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">T<\/a><span data-sheets-value='{\"1\":2,\"2\":\"t\u00e0i li\u1ec7u excel c\u01a1 b\u1ea3n\"}' data-sheets-userformat='{\"2\":513,\"3\":[null,0],\"12\":0}'><a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">\u00e0i li\u1ec7u excel c\u01a1 b\u1ea3n<\/a> hay nh\u00e2\u0301t m\u00f4\u0323t th\u01a1\u0300i \u0111a\u0323i<\/span><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 1. L\u00e0m n\u1ed5i b\u1eadt ng\u00e0y b\u1eb1ng, l\u1edbn h\u01a1n ho\u1eb7c nh\u1ecf h\u01a1n ng\u00e0y h\u00f4m nay<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u00e1c \u00f4 ho\u1eb7c to\u00e0n b\u1ed9 h\u00e0ng d\u1ef1a tr\u00ean ng\u00e0y h\u00f4m nay, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m<strong> TODAY<\/strong> nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">B\u1eb1ng v\u1edbi ng\u00e0y h\u00f4m nay:<strong> = $ B2 = TODAY ()<\/strong><\/p>\n<p style=\"text-align: justify\">L\u1edbn h\u01a1n ng\u00e0y h\u00f4m nay:<strong> = $ B2&gt; TODAY () <\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u1ecf h\u01a1n ng\u00e0y h\u00f4m nay:<strong> = $ B2 &lt;TODAY ()<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00ecnh b\u00ean d\u01b0\u1edbi minh h\u1ecda c\u00e1c quy t\u1eafc tr\u00ean.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/format-dates-today-formula.png\" alt=\"Excel formulas to highlight dates equal to, greater than or less than the current date.\" title=\"format-dates-today-formula\"><br \/>\n<strong>V\u00ed d\u1ee5 2. \u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n ng\u00e0y d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong><\/p>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m<strong> TODAY<\/strong> k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c t\u00ecnh hu\u1ed1ng ph\u1ee9c t\u1ea1p h\u01a1n. V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n c\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n t\u00f4 m\u00e0u c\u1ed9t <strong>Invoice <\/strong>khi Ng\u00e0y Giao h\u00e0ng b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n ng\u00e0y h\u00f4m nay nh\u01b0ng b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng tr\u00ean bi\u1ebfn m\u1ea5t khi nh\u1eadp s\u1ed1 ho\u00e1 \u0111\u01a1n.<\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-if-va-cach-su-dung-ham-if-trong-excel.html\">H\u00e0m IF v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel<\/a><\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi nhi\u1ec7m v\u1ee5 n\u00e0y, b\u1ea1n s\u1ebd c\u1ea7n m\u1ed9t c\u1ed9t b\u1ed5 sung v\u1edbi c\u00f4ng th\u1ee9c sau (trong \u0111\u00f3 E l\u00e0 c\u1ed9t Deliveryv\u00e0 c\u1ed9t F l\u00e0 Invoice:<\/p>\n<p style=\"text-align: justify\"><strong>\u00a0= IF (E2&gt; = TODAY (), IF (F2 = \u201c\u201d, 1, 0), 0)<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu ng\u00e0y giao h\u00e0ng l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng ng\u00e0y hi\u1ec7n t\u1ea1i v\u00e0 kh\u00f4ng c\u00f3 s\u1ed1 trong c\u1ed9t H\u00f3a \u0111\u01a1n, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 1, n\u1ebfu kh\u00f4ng th\u00ec s\u1ed1 \u0111\u00f3 l\u00e0 0.<\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3 b\u1ea1n t\u1ea1o m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng \u0111i\u1ec1u ki\u1ec7n \u0111\u01a1n gi\u1ea3n cho c\u1ed9t<strong> Invoice <\/strong>c\u00f3 c\u00f4ng th\u1ee9c = $G2 = 1 trong \u0111\u00f3 G l\u00e0 c\u1ed9t b\u1ed5 sung c\u1ee7a b\u1ea1n. T\u1ea5t nhi\u00ean, b\u1ea1n s\u1ebd c\u00f3 th\u1ec3 \u1ea9n c\u1ed9t n\u00e0y sau.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5935\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-108.png\" width=\"600\" height=\"518\" title=\"excel-dialog-box-launcher-1-108\"><br \/>\n<strong>V\u00ed d\u1ee5 3. \u0110\u00e1nh d\u1ea5u nh\u1eefng ng\u00e0y s\u1eafp t\u1edbi v\u00e0 \u0111\u00e3 qua<\/strong><\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 l\u1ecbch tr\u00ecnh d\u1ef1 \u00e1n li\u1ec7t k\u00ea c\u00e1c nhi\u1ec7m v\u1ee5, ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 th\u1eddi gian th\u1ef1c hi\u1ec7n c\u1ee7a ch\u00fang. Nh\u1eefng g\u00ec b\u1ea1n mu\u1ed1n l\u00e0 ng\u00e0y k\u1ebft th\u00fac cho m\u1ed7i c\u00f4ng vi\u1ec7c \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n t\u1ef1 \u0111\u1ed9ng. M\u1ed9t th\u00e1ch th\u1ee9c n\u1eefa l\u00e0 \u0111\u1ecbnh d\u1ea1ng n\u00e0y \u0111\u01b0\u1ee3c xem l\u1ea1i v\u1edbi m\u1ed7i cu\u1ed1i tu\u1ea7n. V\u00ed d\u1ee5: n\u1ebfu ng\u00e0y b\u1eaft \u0111\u1ea7u l\u00e0 13 th\u00e1ng 6 n\u0103m 2014 v\u00e0 s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c (Duration) l\u00e0 2, ng\u00e0y k\u1ebft th\u00fac s\u1ebd l\u00e0 v\u00e0o ng\u00e0y 17 th\u00e1ng 6 n\u0103m 2014, v\u00ec 14-th\u00e1ng 6 v\u00e0 15-th\u00e1ng 6 l\u00e0 Th\u1ee9 7 v\u00e0 Ch\u1ee7 Nh\u1eadt .<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, ch\u00fang t\u00f4i s\u1ebd s\u1eed d\u1ee5ng <strong>WORKDAY.INTL (start_date, days, [weekend], [holidays])<\/strong>, ch\u00ednh x\u00e1c h\u01a1n<strong> = WORKDAY.INTL(B2, C2,1)<\/strong>.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/end-date-formula.png\" alt=\"The WORKDAY.INTL formula calculates the End Date for each task taking into account the weekends.\" title=\"end-date-formula\"><br \/>\nTrong c\u00f4ng th\u1ee9c, ch\u00fang ta nh\u1eadp 1 l\u00e0m tham s\u1ed1 th\u1ee9 3 v\u00ec n\u00f3 ch\u1ec9 ra ng\u00e0y th\u1ee9 7 v\u00e0 ch\u1ee7 nh\u1eadt l\u00e0 ng\u00e0y l\u1ec5. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c n\u1ebfu ng\u00e0y cu\u1ed1i tu\u1ea7n c\u1ee7a b\u1ea1n kh\u00e1c, gi\u1ea3 s\u1eed, Th\u1ee9 S\u00e1u v\u00e0 Th\u1ee9 B\u1ea3y Theo t\u00f9y ch\u1ecdn, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng tham s\u1ed1 th\u1ee9 4 [ng\u00e0y l\u1ec5], l\u00e0 m\u1ed9t b\u1ed9 ng\u00e0y th\u00e1ng (ph\u1ea1m vi \u00f4) c\u1ea7n \u0111\u01b0\u1ee3c lo\u1ea1i tr\u1eeb kh\u1ecfi l\u1ecbch l\u00e0m vi\u1ec7c.<\/p>\n<p style=\"text-align: justify\">V\u00e0 cu\u1ed1i c\u00f9ng, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng t\u00f9y thu\u1ed9c v\u00e0o kho\u1ea3ng th\u1eddi gian \u0111\u1ebfn h\u1ea1n. V\u00ed d\u1ee5: c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean hai c\u00f4ng th\u1ee9c sau \u0111\u00e2y l\u00e0m n\u1ed5i b\u1eadt ng\u00e0y s\u1eafp k\u1ebft th\u00fac v\u00e0 ng\u00e0y k\u1ebft th\u00fac g\u1ea7n \u0111\u00e2y, t\u01b0\u01a1ng \u1ee9ng:<\/p>\n<p style=\"text-align: justify\">= V\u00c0 ($ D2-TODAY ()&gt; = 0, $ D2-TODAY () &lt;= 7) \u2013 \u0111\u00e1nh d\u1ea5u t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng c\u00f3 End date (c\u1ed9t D) trong 7 ng\u00e0y ti\u1ebfp theo. C\u00f4ng th\u1ee9c n\u00e0y th\u1ef1c s\u1ef1 h\u1eefu \u00edch khi theo d\u00f5i ng\u00e0y h\u1ebft h\u1ea1n s\u1eafp t\u1edbi ho\u1eb7c thanh to\u00e1n. = V\u00c0 (TODAY () \u2013 $ D2&gt; = 0, TODAY () \u2013 $ D2 &lt;= 7) \u2013 \u0111\u00e1nh d\u1ea5u t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng trong \u0111\u00f3 End Date (c\u1ed9t D) l\u00e0 trong 7 ng\u00e0y qua. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y \u0111\u1ec3 theo d\u00f5i c\u00e1c kho\u1ea3n thanh to\u00e1n qu\u00e1 h\u1ea1n v\u00e0 nh\u1eefng ch\u1eadm tr\u1ec5 kh\u00e1c.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5936\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-109.png\" width=\"600\" height=\"273\" title=\"excel-dialog-box-launcher-1-109\"><\/p>\n<p style=\"text-align: justify\"><strong>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng cho b\u1ea3ng \u1edf tr\u00ean:<\/strong><\/p>\n<p style=\"text-align: justify\">= $ D2 &lt;TODAY () \u2013 l\u00e0m n\u1ed5i b\u1eadt t\u1ea5t c\u1ea3 c\u00e1c ng\u00e0y \u0111\u00e3 qua (t\u1ee9c l\u00e0 ng\u00e0y \u00edt h\u01a1n ng\u00e0y hi\u1ec7n t\u1ea1i). C\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u0111\u0103ng k\u00fd h\u1ebft h\u1ea1n, thanh to\u00e1n qu\u00e1 h\u1ea1n vv<\/p>\n<p style=\"text-align: justify\">= $ D2&gt; TODAY () \u2013 l\u00e0m n\u1ed5i b\u1eadt t\u1ea5t c\u1ea3 c\u00e1c ng\u00e0y trong t\u01b0\u01a1ng lai (ngh\u0129a l\u00e0 ng\u00e0y l\u1edbn h\u01a1n ng\u00e0y hi\u1ec7n t\u1ea1i). B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c s\u1ef1 ki\u1ec7n s\u1eafp t\u1edbi.<\/p>\n<p style=\"text-align: justify\">T\u1ea5t nhi\u00ean, c\u00f3 c\u00e1c bi\u1ebfn th\u1ec3 v\u00f4 h\u1ea1n c\u1ee7a c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean, t\u00f9y thu\u1ed9c v\u00e0o nhi\u1ec7m v\u1ee5 c\u1ee5 th\u1ec3 c\u1ee7a b\u1ea1n. V\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\">= $ D2-TODAY ()&gt; = 6 \u2013 l\u00e0m n\u1ed5i b\u1eadt ng\u00e0y x\u1ea3y ra trong 6 ng\u00e0y tr\u1edf l\u00ean.<\/p>\n<p style=\"text-align: justify\">= $ D2 = TODAY () \u2013 14 \u2013 nh\u1ea5n m\u1ea1nh c\u00e1c ng\u00e0y x\u1ea3y ra ch\u00ednh x\u00e1c 2 tu\u1ea7n tr\u01b0\u1edbc.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_lam_noi_bat_ngay_thang_trong_mot_pham_vi_ngay\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt ng\u00e0y th\u00e1ng trong m\u1ed9t ph\u1ea1m vi ng\u00e0y:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch d\u00e0i c\u00e1c ng\u00e0y trong b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 mu\u1ed1n l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 ho\u1eb7c h\u00e0ng n\u1eb1m trong ph\u1ea1m vi ng\u00e0y nh\u1ea5t \u0111\u1ecbnh, t\u1ee9c l\u00e0 nh\u1ea5n m\u1ea1nh t\u1ea5t c\u1ea3 c\u00e1c ng\u00e0y n\u1eb1m gi\u1eefa hai ng\u00e0y nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 ho\u00e0n th\u00e0nh nhi\u1ec7m v\u1ee5 n\u00e0y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng <strong>TODAY ().<\/strong> B\u1ea1n s\u1ebd ch\u1ec9 c\u1ea7n ph\u1ea3i x\u00e2y d\u1ef1ng m\u1ed9t c\u00f4ng th\u1ee9c tinh vi h\u01a1n m\u1ed9t ch\u00fat nh\u01b0 trong c\u00e1c v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>C\u00f4ng th\u1ee9c \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt ng\u00e0y th\u00e1ng v\u1eeba qua<\/strong><\/li>\n<li>H\u01a1n 30 ng\u00e0y tr\u01b0\u1edbc \u0111\u00e2y: = TODAY () \u2013 $A2&gt; 30<\/li>\n<li>T\u1eeb 30 \u0111\u1ebfn 15 ng\u00e0y tr\u01b0\u1edbc, bao g\u1ed3m: = AND (TODAY () \u2013 $A2&gt; = 15, TODAY () \u2013 $A2 &lt;= 30)<\/li>\n<li>Ch\u01b0a \u0111\u1ebfn 15 ng\u00e0y tr\u01b0\u1edbc: = AND (TODAY () \u2013 $A2&gt; = 1, TODAY () \u2013 $A2 &lt;15)<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Ng\u00e0y hi\u1ec7n t\u1ea1i v\u00e0 b\u1ea5t k\u1ef3 ng\u00e0y th\u00e1ng t\u01b0\u01a1ng lai n\u00e0o kh\u00f4ng \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u.<\/p>\n<h1 style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/highlight-past-dates.png\" alt=\"Formulas to highlight past dates in a certain date range\" title=\"highlight-past-dates\"><br \/>\n<strong>C\u00f4ng th\u1ee9c \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt ng\u00e0y trong t\u01b0\u01a1ng lai <\/strong><\/h1>\n<ul style=\"text-align: justify\">\n<li>S\u1ebd x\u1ea3y ra trong h\u01a1n 30 ng\u00e0y k\u1ec3 t\u1eeb b\u00e2y gi\u1edd: = $A2-TODAY ()&gt; 30<\/li>\n<li>Trong 30 \u0111\u1ebfn 15 ng\u00e0y, bao g\u1ed3m: = AND ($A2-TODAY ()&gt; = 15, $A2-TODAY () &lt;= 30)<\/li>\n<li>Trong ch\u01b0a \u0111\u1ea7y 15 ng\u00e0y: = AND ($A2-TODAY ()&gt; = 1, $A2-TODAY () &lt;15)<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Ng\u00e0y hi\u1ec7n t\u1ea1i v\u00e0 b\u1ea5t k\u1ef3 ng\u00e0y th\u00e1ng v\u1eeba qua n\u00e0o kh\u00f4ng \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/highlight-future-dates.png\" alt=\"Formulas to highlight future dates in a given date range\" title=\"highlight-future-dates\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_to_mau_cac_khoang_trong_va_khoang_thoi_gian\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 <\/strong><strong>t\u00f4 m\u00e0u<\/strong><strong> c\u00e1c kho\u1ea3ng tr\u1ed1ng v\u00e0 kho\u1ea3ng th\u1eddi gian:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 cu\u1ed1i c\u00f9ng n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng th\u00eam m\u1ed9t h\u00e0m date kh\u00e1c c\u1ee7a Excel \u2013 <strong>DATEDIF (start_date, end_date, interval).<\/strong> H\u00e0m n\u00e0y t\u00ednh to\u00e1n s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa hai ng\u00e0y d\u1ef1a tr\u00ean kho\u1ea3ng th\u1eddi gian quy \u0111\u1ecbnh. N\u00f3 kh\u00e1c v\u1edbi t\u1ea5t c\u1ea3 c\u00e1c h\u00e0m kh\u00e1c m\u00e0 ch\u00fang t\u00f4i \u0111\u00e3 th\u1ea3o lu\u1eadn trong h\u01b0\u1edbng d\u1eabn n\u00e0y theo c\u00e1ch m\u00e0 n\u00f3 cho ph\u00e9p b\u1ea1n b\u1ecf qua th\u00e1ng ho\u1eb7c n\u0103m v\u00e0 ch\u1ec9 t\u00ednh s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa c\u00e1c ng\u00e0y ho\u1eb7c th\u00e1ng, t\u00f9y theo b\u1ea1n ch\u1ecdn.<\/p>\n<p style=\"text-align: justify\">H\u00e3y suy ngh\u0129 v\u1ec1 n\u00f3 b\u1eb1ng m\u1ed9t c\u00e1ch kh\u00e1c \u2026 Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c ng\u00e0y sinh c\u1ee7a c\u00e1c th\u00e0nh vi\u00ean gia \u0111\u00ecnh v\u00e0 b\u1ea1n b\u00e8 c\u1ee7a b\u1ea1n. B\u1ea1n c\u00f3 mu\u1ed1n bi\u1ebft c\u00f3 bao nhi\u00eau ng\u00e0y cho \u0111\u1ebfn ng\u00e0y sinh nh\u1eadt ti\u1ebfp theo? H\u01a1n n\u1eefa, c\u00f2n bao nhi\u00eau ng\u00e0y n\u1eefa l\u00e0 \u0111\u1ebfn ng\u00e0y c\u01b0\u1edbi v\u00e0 nh\u1eefng s\u1ef1 ki\u1ec7n kh\u00e1c m\u00e0 b\u1ea1n kh\u00f4ng mu\u1ed1n b\u1ecf l\u1ee1? D\u1ec5 d\u00e0ng!<\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 c\u00f4ng th\u1ee9c b\u1ea1n c\u1ea7n (trong \u0111\u00f3 A l\u00e0 c\u1ed9t Ng\u00e0y c\u1ee7a b\u1ea1n):<\/p>\n<p style=\"text-align: justify\">= DATEDIF (TODAY (), DATE ((N\u0102M (TODAY ()) + 1), MONTH ($A2), DAY ($A2)), \u201cyd\u201d)<\/p>\n<p style=\"text-align: justify\">Lo\u1ea1i kho\u1ea3ng th\u1eddi gian \u201cyd\u201d \u1edf cu\u1ed1i c\u1ee7a c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 b\u1ecf qua n\u0103m v\u00e0 ch\u1ec9 t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa c\u00e1c ng\u00e0y. \u0110\u1ec3 c\u00f3 danh s\u00e1ch \u0111\u1ea7y \u0111\u1ee7 c\u00e1c lo\u1ea1i kho\u1ea3ng th\u1eddi gian kh\u1ea3 d\u1ee5ng, h\u00e3y nh\u00ecn v\u00e0o <a href=\"http:\/\/www.techonthenet.com\/excel\/formulas\/datedif.php\">\u0111\u00e2y<\/a>.<\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o<\/strong>. N\u1ebfu b\u1ea1n qu\u00ean m\u1ea5t ho\u1eb7c \u0111\u1eb7t sai t\u00ean c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p n\u00e0y: <strong>= 365-DATEDIF ($A2, TODAY (), \u201cyd\u201d)<\/strong>. N\u00f3 t\u1ea1o ra k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c nh\u01b0 nhau, ch\u1ec9 c\u1ea7n nh\u1edb thay th\u1ebf 365 th\u00e0nh 366 trong n\u0103m nhu\u1eadn:)<\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd h\u00e3y t\u1ea1o m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 t\u00f4 m\u00e0u c\u00e1c kho\u1ea3ng tr\u1ed1ng kh\u00e1c nhau v\u1edbi c\u00e1c m\u00e0u kh\u00e1c nhau. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng Excel Scales Color (<strong>Conditional formatting<\/strong><strong>&gt; Color Scales<\/strong>) h\u01a1n l\u00e0 t\u1ea1o ra m\u1ed9t quy t\u1eafc ri\u00eang cho t\u1eebng kho\u1ea3ng th\u1eddi gian.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: Kho\u0301a <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">ho\u0323c VBA ta\u0323i Ha\u0300 N\u00f4\u0323i<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y k\u1ebft qu\u1ea3 trong Excel \u2013 m\u1ed9t chu\u1ed7i m\u00e0u v\u1edbi m\u1ee9c \u0111\u1ed9 t\u1eeb m\u00e0u xanh l\u00e1 c\u00e2y \u0111\u1ebfn m\u00e0u \u0111\u1ecf th\u00f4ng qua m\u00e0u v\u00e0ng.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/color-scale-dates.png\" alt=\"The 3-color scale shades cells in different colors based on how many days are left until the event.\" title=\"color-scale-dates\"><\/p>\n<p style=\"text-align: justify\"><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/em><\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel.<\/p>\n<p>M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u01b0:<\/p>\n<ul>\n<li>SUMIF, SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>COUNTIF, COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea, \u0111\u1ebfm theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i, d\u1ea1ng ng\u00e0y th\u00e1ng, d\u1ea1ng s\u1ed1\u2026<\/li>\n<li>C\u00e1c h\u00e0m d\u00f2 t\u00ecm tham chi\u1ebfu Index+Match, h\u00e0m SUMPRODUCT\u2026<\/li>\n<\/ul>\n<p>M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 hay s\u1eed d\u1ee5ng nh\u01b0:<\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi Conditional formatting<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u v\u1edbi Data Validation<\/li>\n<li>C\u00e1ch \u0111\u1eb7t Name v\u00e0 s\u1eed d\u1ee5ng Name trong c\u00f4ng th\u1ee9c<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o v\u1edbi Pivot Table\u2026<\/li>\n<\/ul>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w7Xwqg\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. 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=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener\">HocExcel.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-50.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1662,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1661","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\/1661","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=1661"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1661\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1662"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}