{"id":606,"date":"2024-12-02T02:34:05","date_gmt":"2024-12-02T02:34:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-cong-tru-ngay-thang-nam-trong-excel\/"},"modified":"2024-12-02T02:34:05","modified_gmt":"2024-12-02T02:34:05","slug":"cach-cong-tru-ngay-thang-nam-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-cong-tru-ngay-thang-nam-trong-excel\/","title":{"rendered":"C\u00e1ch c\u1ed9ng tr\u1eeb ng\u00e0y, th\u00e1ng, n\u0103m trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed9ng tr\u1eeb th\u1eddi gian trong Excel, c\u1ed9ng tr\u1eeb ng\u00e0y, c\u1ed9ng th\u00e1ng trong excel; ch\u1eb3ng h\u1ea1n nh\u01b0 tr\u1eeb hai ng\u00e0y, th\u00eam ng\u00e0y, tu\u1ea7n, th\u00e1ng v\u00e0 n\u0103m cho m\u1ed9t ng\u00e0y\u2026 giu\u0301p thu\u00e2\u0323n ti\u0301nh cho c\u00f4ng vi\u00ea\u0323c cu\u0303ng nh\u01b0 trong ho\u0323c t\u00e2\u0323p.<\/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-674d1c9c09b1c\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-cong-tru-ngay-thang-nam-trong-excel.html#Lam_thenao_de_tru_ngay_trong_Excel\" title=\"L\u00e0m th\u1ebfn\u00e0o \u0111\u1ec3 tr\u1eeb ng\u00e0y trong Excel:\">L\u00e0m th\u1ebfn\u00e0o \u0111\u1ec3 tr\u1eeb ng\u00e0y trong Excel:<\/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\/cach-cong-tru-ngay-thang-nam-trong-excel.html#Lam_the_nao_de_tru_hoac_cong_them_ngay_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 tr\u1eeb ho\u1eb7c c\u1ed9ng th\u00eam ng\u00e0y trong Excel:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 tr\u1eeb ho\u1eb7c c\u1ed9ng th\u00eam ng\u00e0y trong Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-cong-tru-ngay-thang-nam-trong-excel.html#Lam_the_nao_de_tru_hoac_them_nam_vao_ngay_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 tr\u1eeb ho\u1eb7c th\u00eam n\u0103m v\u00e0o ng\u00e0y trong Excel:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 tr\u1eeb ho\u1eb7c th\u00eam n\u0103m v\u00e0o ng\u00e0y trong Excel:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_thenao_de_tru_ngay_trong_Excel\"><\/span><strong>L\u00e0m th\u1ebfn\u00e0o \u0111\u1ec3 tr\u1eeb ng\u00e0y trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 hai ng\u00e0y trong \u00f4 A2 v\u00e0 B2, v\u00e0 b\u00e2y gi\u1edd b\u1ea1n mu\u1ed1n tr\u1eeb ch\u00fang \u0111\u1ec3 bi\u1ebft <strong>s\u1ed1 ng\u00e0y n\u1eb1m gi\u1eefa hai \u00a0ng\u00e0y<\/strong> n\u00e0y. K\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c b\u1eb1ng nhi\u1ec1u c\u00e1ch.<\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 1. Tr\u1eeb m\u1ed9t ng\u00e0y tr\u1ef1c ti\u1ebfp<\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 bi\u1ebft, Microsoft Excel l\u01b0u tr\u1eef m\u1ed7i ng\u00e0y nh\u01b0 m\u1ed9t s\u1ed1 serial \u0111\u1ed9c \u0111\u00e1o b\u1eaft \u0111\u1ea7u b\u1eb1ng 1 \u0111\u1ea1i di\u1ec7n cho 1 th\u00e1ng 1 n\u0103m 1900. V\u00ec v\u1eady, khi b\u1ea1n tr\u1eeb ch\u00fang, m\u1ed9t ph\u00e9p t\u00ednh s\u1ed1 h\u1ecdc b\u00ecnh th\u01b0\u1eddng x\u1ea3y ra:<\/p>\n<p style=\"text-align: justify\"><strong>=<\/strong><strong> B2-A2<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 2. <\/strong><strong>Tr\u1eeb<\/strong><strong> ng\u00e0y s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/tinh-khoang-thoi-gian-giua-2-thoi-diem-ham-datedif-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m DATEDIF<\/a><\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu c\u00f4ng th\u1ee9c tr\u00ean c\u00f3 v\u1ebb qu\u00e1 \u0111\u01a1n gi\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c c\u00f9ng m\u1ed9t k\u1ebft qu\u1ea3 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m DATEDIF c\u1ee7a Excel:<\/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-8.gif\" title=\"vba101_92019-nho-8\"><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-31.gif\" title=\"ex101_92019-nho-31\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong>= DATEDIF (A2, B2, \u201cd\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00ecnh sau \u0111\u00e2y cho th\u1ea5y r\u1eb1ng c\u1ea3 hai ph\u00e9p t\u00ednh \u0111\u1ec1u tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 gi\u1ed1ng h\u1ec7t nhau, ngo\u1ea1i tr\u1eeb d\u00f2ng 4 trong \u0111\u00f3 h\u00e0m DATEDIF tr\u1ea3 v\u1ec1 l\u1ed7i #NUM. H\u00e3y t\u00ecm ra l\u00fd do t\u1ea1i sao \u0111i\u1ec1u \u0111\u00f3 x\u1ea3y ra.<\/p>\n<p style=\"text-align: justify\">Khi b\u1ea1n tr\u1eeb m\u1ed9t ng\u00e0y nh\u1ecf h\u01a1n (1 th\u00e1ng 5 n\u0103m 2015) cho m\u1ed9t ng\u00e0y l\u1edbn h\u01a1n (6 th\u00e1ng 5 n\u0103m 2015), k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 \u00e2m (-5). Tuy nhi\u00ean, c\u00fa ph\u00e1p c\u1ee7a h\u00e0m DATEDIF kh\u00f4ng cho ph\u00e9p ng\u00e0y b\u1eaft \u0111\u1ea7u l\u1edbn h\u01a1n ng\u00e0y k\u1ebft th\u00fac v\u00e0 do \u0111\u00f3 n\u00f3 tr\u1ea3 v\u1ec1 l\u1ed7i.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5287 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-12.png\" width=\"449\" height=\"140\" title=\"excel-find-replace-highlight-12\"><\/p>\n<p style=\"text-align: justify\">Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cac-cach-tinh-tuoi-tu-ngay-sinh-trong-excel.html\">Ca\u0301ch ti\u0301nh tu\u00f4\u0309i t\u01b0\u0300 nga\u0300y sinh trong Excel<\/a><\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 3. Tr\u1eeb m\u1ed9t ng\u00e0y t\u1eeb ng\u00e0y hi\u1ec7n t\u1ea1i<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 tr\u1eeb m\u1ed9t ng\u00e0y t\u1eeb ng\u00e0y h\u00f4m nay, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t trong hai c\u00f4ng th\u1ee9c tr\u00ean. Ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng TODAY () thay v\u00ec ng\u00e0y:<\/p>\n<p style=\"text-align: justify\">= TODAY () \u2013 A2<\/p>\n<p style=\"text-align: justify\">ho\u1eb7c l\u00e0<\/p>\n<p style=\"text-align: justify\">= DATEDIF (A2, TODAY (), \u201cd\u201d)<\/p>\n<p style=\"text-align: justify\">Gi\u1ed1ng nh\u01b0 trong v\u00ed d\u1ee5 tr\u01b0\u1edbc, c\u1ea3 hai c\u00f4ng th\u1ee9c \u0111\u1ec1u l\u00e0m vi\u1ec7c t\u1ed1t khi ng\u00e0y h\u00f4m nay l\u1edbn h\u01a1n ng\u00e0y b\u1ea1n tr\u1eeb \u0111i, n\u1ebfu kh\u00f4ng DATEDIF s\u1ebd b\u00e1o l\u1ed7i:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5288 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-13.png\" width=\"400\" height=\"141\" title=\"excel-find-replace-highlight-13\"><\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 4. Tr\u1eeb ng\u00e0y s\u1eed d\u1ee5ng h\u00e0m DATE<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n l\u1ea5y ng\u00e0y c\u1ee7a c\u00f4ng th\u1ee9c cung c\u1ea5p, nh\u1eadp ng\u00e0y, s\u1eed d\u1ee5ng h\u00e0m DATE (n\u0103m, th\u00e1ng, ng\u00e0y) v\u00e0 tr\u1eeb \u0111i m\u1ed9t ng\u00e0y kh\u00e1c.V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c sau tr\u1eeb ng\u00e0y 20 th\u00e1ng 5 n\u0103m 2015 cho ng\u00e0y 15 th\u00e1ng 5 n\u0103m 2015 v\u00e0 tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 5 ng\u00e0y:<strong>= DATE (2015, 5, 20) \u2013 NG\u00c0Y (2015, 5, 15)<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5291 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-15.png\" width=\"270\" height=\"81\" title=\"excel-find-replace-highlight-15\"><\/p>\n<p style=\"text-align: justify\">T\u00f3m l\u1ea1i, \u0111\u1ec3 tr\u1eeb ng\u00e0y th\u00e1ng trong Excel, b\u1ea1n n\u00ean d\u00f9ng t\u00f9y ch\u1ecdn \u0111\u01a1n gi\u1ea3n v\u00e0 r\u00f5 r\u00e0ng nh\u1ea5t \u2013 ch\u1ec9 c\u1ea7n tr\u1eeb m\u1ed9t ng\u00e0y tr\u1ef1c ti\u1ebfp t\u1eeb m\u1ed9t ng\u00e0y kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh s\u1ed1 th\u00e1ng ho\u1eb7c n\u0103m gi\u1eefa hai ng\u00e0y, h\u00e0m DATEDIF l\u00e0 gi\u1ea3i ph\u00e1p duy nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd ta \u0111\u00e3 bi\u1ebft c\u00e1ch tr\u1eeb hai ng\u00e0y, ta h\u00e3y xem l\u00e0m th\u1ebf n\u00e0o c\u00f3 th\u1ec3 th\u00eam ho\u1eb7c tr\u1eeb ng\u00e0y, th\u00e1ng, ho\u1eb7c n\u0103m cho m\u1ed9t ng\u00e0y nh\u1ea5t \u0111\u1ecbnh. C\u00f3 m\u1ed9t s\u1ed1 h\u00e0m Excel th\u00edch h\u1ee3p cho m\u1ee5c \u0111\u00edch n\u00e0y, vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1i n\u00e0o ph\u1ee5 thu\u1ed9c v\u00e0o \u0111\u01a1n v\u1ecb b\u1ea1n mu\u1ed1n c\u1ed9ng ho\u1eb7c tr\u1eeb.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">T\u00ecm hi\u1ec3u th\u00eam: Kho\u00e1 h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">h\u01b0\u01a1\u0301ng d\u00e2\u0303n ho\u0323c Excel c\u01a1 ba\u0309n<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_tru_hoac_cong_them_ngay_trong_Excel\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 tr\u1eeb ho\u1eb7c c\u1ed9ng th\u00eam ng\u00e0y trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t ng\u00e0y trong m\u1ed9t \u00f4 n\u00e0o \u0111\u00f3 ho\u1eb7c m\u1ed9t danh s\u00e1ch ng\u00e0y trong c\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 c\u1ed9ng ho\u1eb7c ng\u00e0y tr\u1eeb ng\u00e0y trong excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t ph\u00e9p to\u00e1n s\u1ed1 h\u1ecdc t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 1. C\u00e1ch c\u1ed9ng th\u00eam ng\u00e0y v\u00e0o m\u1ed9t ng\u00e0y trong Excel<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c chung \u0111\u1ec3 th\u00eam m\u1ed9t s\u1ed1 ng\u00e0y c\u1ee5 th\u1ec3 cho m\u1ed9t ng\u00e0y nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=<\/strong><em><strong>Date<\/strong><\/em><strong>\u00a0<\/strong><strong>+<\/strong><strong>\u00a0<\/strong><em><strong>N ng\u00e0y<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Ng\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c nh\u1eadp b\u1eb1ng nhi\u1ec1u c\u00e1ch:<\/p>\n<ul style=\"text-align: justify\">\n<li>L\u00e0 m\u1ed9t \u00f4 tham chi\u1ebfu, v\u00ed d\u1ee5: = A2 + 10<\/li>\n<li>S\u1eed d\u1ee5ng h\u00e0m DATE (n\u0103m, th\u00e1ng, ng\u00e0y), v\u00ed d\u1ee5: <strong>= DATE (2015, 5, 6) + 10<\/strong><\/li>\n<li>L\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a m\u1ed9t h\u00e0m kh\u00e1c. V\u00ed d\u1ee5: \u0111\u1ec3 th\u00eam s\u1ed1 ng\u00e0y cho ng\u00e0y hi\u1ec7n t\u1ea1i, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m TODAY (): <strong>= TODAY () + 10<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\">H\u00ecnh sau minh h\u1ecda c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean. Ng\u00e0y hi\u1ec7n t\u1ea1i l\u00e0 6 th\u00e1ng 5 n\u0103m 2015:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5292 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-16.png\" width=\"535\" height=\"140\" title=\"excel-find-replace-highlight-16\"><br \/>\n<strong>Ch\u00fa \u00fd:<\/strong> K\u1ebft qu\u1ea3 c\u1ee7a c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean l\u00e0 m\u1ed9t s\u1ed1 th\u1ee9 t\u1ef1 \u0111\u1ea1i di\u1ec7n cho ng\u00e0y. \u0110\u1ec3 hi\u1ec3n th\u1ecb n\u00f3 d\u01b0\u1edbi d\u1ea1ng ng\u00e0y th\u00e1ng, h\u00e3y ch\u1ecdn (c\u00e1c) \u00f4 v\u00e0 nh\u1ea5n Ctrl + 1 \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>Format Cells<\/strong>. Tr\u00ean tab Number, ch\u1ecdn Date trong danh m\u1ee5c Category, v\u00e0 sau \u0111\u00f3 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng ng\u00e0y b\u1ea1n mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 2. Tr\u1eeb ng\u00e0y t\u1eeb ng\u00e0y trong Excel<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f2n \u0111\u01b0\u1ee3c hi\u1ec3u \u0111\u01a1n s\u01a1 l\u00e0 thao t\u00e1c <strong>ng\u00e0y tr\u1eeb ng\u00e0y trong excel<\/strong>. \u0110\u1ec3 tr\u1eeb m\u1ed9t s\u1ed1 ng\u00e0y t\u1eeb m\u1ed9t ng\u00e0y nh\u1ea5t \u0111\u1ecbnh, b\u1ea1n th\u1ef1c hi\u1ec7n l\u1ea1i m\u1ed9t ph\u00e9p t\u00ednh s\u1ed1 h\u1ecdc th\u00f4ng th\u01b0\u1eddng. S\u1ef1 kh\u00e1c bi\u1ec7t duy nh\u1ea5t t\u1eeb \u200b\u200bv\u00ed d\u1ee5 tr\u01b0\u1edbc \u0111\u00f3 l\u00e0 b\u1ea1n g\u00f5 d\u1ea5u tr\u1eeb cho d\u1ea5u c\u1ed9ng \ud83d\ude42<\/p>\n<p style=\"text-align: justify\"><strong>=<\/strong><em><strong>Date<\/strong><\/em><strong>\u00a0<\/strong><strong>\u2013<\/strong><strong>\u00a0<\/strong><em><strong>N ng\u00e0y<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5:<\/p>\n<ul style=\"text-align: justify\">\n<li>= A2 \u2013 10<\/li>\n<li>= DATE (2015, 5, 6) \u2013 10<\/li>\n<li>= TODAY () \u2013 10<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5293 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-17.png\" width=\"552\" height=\"140\" title=\"excel-find-replace-highlight-17\"><\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch c\u1ed9ng ho\u1eb7c tr\u1eeb tu\u1ea7n (t\u1eeb ng\u00e0y):<\/strong><\/p>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n c\u1ed9ng ho\u1eb7c tr\u1eeb tu\u1ea7n cho m\u1ed9t ng\u00e0y nh\u1ea5t \u0111\u1ecbnh, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c nh\u01b0 th\u00eam \/ b\u1edbt ng\u00e0y, v\u00e0 nh\u00e2n s\u1ed1 s\u1ed1 tu\u1ea7n cho 7:<\/p>\n<p style=\"text-align: justify\"><strong>C\u1ed9ng th\u00eam tu\u1ea7n<\/strong> v\u00e0o m\u1ed9t ng\u00e0y trong Excel:<\/p>\n<p style=\"text-align: justify\">= A2 + N tu\u1ea7n * 7<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, b\u1ea1n c\u1ed9ng 3 tu\u1ea7n cho ng\u00e0y trong \u00a0\u00f4 A2, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau: = A2 + 3 * 7.<\/p>\n<p style=\"text-align: justify\"><strong>Tr\u1eeb tu\u1ea7n k\u1ec3 t\u1eeb ng\u00e0y trong Excel:<\/strong><\/p>\n<p style=\"text-align: justify\">= A2 \u2013 N tu\u1ea7n * 7<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 tr\u1eeb 2 tu\u1ea7n k\u1ec3 t\u1eeb ng\u00e0y h\u00f4m nay, b\u1ea1n vi\u1ebft <strong>= TODAY () \u2013 2 * 7<\/strong>.<\/p>\n<p style=\"text-align: justify\"><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed9ng, tr\u1eeb th\u00e1ng t\u1eeb ng\u00e0y trong Excel:<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n <strong>c\u1ed9ng th\u00e1ng trong excel<\/strong> ho\u1eb7c l\u00e0 <strong>tr\u1eeb th\u00e1ng trong excel<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng DATE ho\u1eb7c EDATE, nh\u01b0 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 1. C\u1ed9ng th\u00e1ng cho m\u1ed9t ng\u00e0y v\u1edbi h\u00e0m DATE<\/strong><\/p>\n<p style=\"text-align: justify\">Ch\u1eb3ng h\u1ea1n, l\u1ea5y m\u1ed9t danh s\u00e1ch ng\u00e0y trong c\u1ed9t A, nh\u1eadp s\u1ed1 th\u00e1ng b\u1ea1n mu\u1ed1n c\u1ed9ng (s\u1ed1 d\u01b0\u01a1ng) ho\u1eb7c tr\u1eeb (s\u1ed1 \u00e2m) trong m\u1ed9t s\u1ed1 \u00f4, g\u1ecdi l\u00e0 C2.<\/p>\n<p style=\"text-align: justify\">Nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 B2 v\u00e0 k\u00e9o g\u00f3c c\u1ee7a \u00f4 xu\u1ed1ng \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c \u00f4 kh\u00e1c:<\/p>\n<p style=\"text-align: justify\"><strong>= DATE (YEAR (A2), MONTH (A2) + $ C $ 2, DAY (A2))<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5294 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-18.png\" width=\"354\" height=\"207\" title=\"excel-find-replace-highlight-18\"><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y xem k\u1ebft qu\u1ea3. Logic c\u1ee7a c\u00f4ng th\u1ee9c l\u00e0 hi\u1ec3n nhi\u00ean v\u00e0 \u0111\u01a1n gi\u1ea3n. <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-date-trong-excel-cach-tinh-toan-ngay-thang.html\"><strong>H\u00e0m DATE<\/strong><\/a> (n\u0103m, th\u00e1ng, ng\u00e0y) c\u00f3 nh\u1eefng l\u1eadp lu\u1eadn sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>N\u0103m c\u1ee7a ng\u00e0y trong \u00f4 A2;<\/li>\n<li>Th\u00e1ng c\u1ee7a ng\u00e0y trong A2 + s\u1ed1 th\u00e1ng m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh trong \u00f4 C2 v\u00e0<\/li>\n<li>Ng\u00e0y c\u1ee7a ng\u00e0y trong A2.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">\u0110\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o. N\u1ebfu b\u1ea1n g\u00f5 m\u1ed9t s\u1ed1 \u00e2m trong C2, c\u00f4ng th\u1ee9c s\u1ebd tr\u1eeb \u0111i c\u00e1c th\u00e1ng thay v\u00ec th\u00eam ch\u00fang:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5295 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-19.png\" width=\"358\" height=\"200\" title=\"excel-find-replace-highlight-19\"><\/p>\n<p style=\"text-align: justify\">\u0110\u01b0\u01a1ng nhi\u00ean, kh\u00f4ng c\u00f3 g\u00ec ng\u0103n c\u1ea3n b\u1ea1n g\u00f5 d\u1ea5u tr\u1eeb tr\u1ef1c ti\u1ebfp trong c\u00f4ng th\u1ee9c \u0111\u1ec3 tr\u1eeb \u0111i th\u00e1ng k\u1ec3 t\u1eeb ng\u00e0y:<strong>\u00a0<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>=DATE (YEAR (A2), MONTH (A2) \u2013 $ C $ 2, DAY (A2))<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00e0 d\u0129 nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 g\u00f5 s\u1ed1 th\u00e1ng \u0111\u1ec3 c\u1ed9ng ho\u1eb7c tr\u1eeb trong c\u00f4ng th\u1ee9c thay v\u00ec tham chi\u1ebfu \u00f4:<\/p>\n<p style=\"text-align: justify\"><strong>= DATE (YEAR (ng\u00e0y), MONTH (ng\u00e0y) + N th\u00e1ng, DAY (ng\u00e0y))<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00e1c c\u00f4ng th\u1ee9c th\u1ef1c s\u1ef1 c\u00f3 th\u1ec3 tr\u00f4ng gi\u1ed1ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>C\u1ed9ng<\/strong> th\u00e1ng v\u00e0o ng\u00e0y:<strong>= DATE (YEAR (A2), MONTH (A2) + 2, DAY (A2))<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Tr\u1eeb<\/strong> th\u00e1ng v\u00e0o ng\u00e0y:<strong>= <\/strong><strong>DATE <\/strong><strong>(<\/strong><strong>YEAR<\/strong><strong> (A2), MONTH (A2) \u2013 2, <\/strong><strong>DAY<\/strong><strong> (A2))<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 2. C\u1ed9ng ho\u1eb7c tr\u1eeb th\u00e1ng cho m\u1ed9t ng\u00e0y v\u1edbi Excel EDATE<\/strong><\/p>\n<p style=\"text-align: justify\">Microsoft Excel cung c\u1ea5p m\u1ed9t h\u00e0m tr\u1ea3 v\u1ec1 m\u1ed9t ng\u00e0y l\u00e0 m\u1ed9t s\u1ed1 nh\u1ea5t \u0111\u1ecbnh tr\u01b0\u1edbc ho\u1eb7c sau ng\u00e0y b\u1eaft \u0111\u1ea7u n th\u00e1ng \u2013 h\u00e0m EDATE. N\u00f3 c\u00f3 s\u1eb5n trong c\u00e1c phi\u00ean b\u1ea3n hi\u1ec7n \u0111\u1ea1i c\u1ee7a Excel 2007, 2010, 2013 v\u00e0 2016.<\/p>\n<p style=\"text-align: justify\">Trong h\u00e0m\u00a0<strong>EDATE (start_date, months)<\/strong>, b\u1ea1n cung c\u1ea5p hai \u0111\u1ed1i s\u1ed1 sau:<\/p>\n<ul>\n<li style=\"text-align: justify\"><strong>Start_date<\/strong> \u2013 ng\u00e0y b\u1eaft \u0111\u1ea7u \u0111\u1ebfm s\u1ed1 th\u00e1ng.<\/li>\n<li style=\"text-align: justify\"><strong>Months<\/strong> \u2013 s\u1ed1 th\u00e1ng \u0111\u1ec3 c\u1ed9ng (m\u1ed9t gi\u00e1 tr\u1ecb d\u01b0\u01a1ng) ho\u1eb7c tr\u1eeb (m\u1ed9t gi\u00e1 tr\u1ecb \u00e2m).<\/li>\n<\/ul>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c sau \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng tr\u00ean c\u1ed9t th\u1eddi gian cho k\u1ebft qu\u1ea3 gi\u1ed1ng h\u1ec7t nh\u01b0 h\u00e0m DATE trong v\u00ed d\u1ee5 tr\u01b0\u1edbc:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5296 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-20.png\" width=\"301\" height=\"221\" title=\"excel-find-replace-highlight-20\"><br \/>\nKhi s\u1eed d\u1ee5ng h\u00e0m EDATE, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ch\u1ec9 \u0111\u1ecbnh ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 s\u1ed1 th\u00e1ng \u0111\u1ec3 th\u00eam \/ tr\u1eeb tr\u1ef1c ti\u1ebfp trong c\u00f4ng th\u1ee9c. Ng\u00e0y n\u00ean \u0111\u01b0\u1ee3c nh\u1eadp b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng DATE ho\u1eb7c l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c. V\u00ed d\u1ee5:<\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1ec3 c\u1ed9ng th\u00eam:<strong> = EDATE (DATE (2015,5,7), 10)<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c th\u00eam 10 th\u00e1ng t\u1eeb 7 th\u00e1ng 5 n\u0103m 2015.<\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1ec3 tr\u1eeb th\u00e1ng: <strong>= EDATE (TODAY (), -10)<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c tr\u1eeb 10 th\u00e1ng k\u1ec3 t\u1eeb ng\u00e0y h\u00f4m nay.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd<\/strong>. H\u00e0m EDATE tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 \u0111\u1ea1i di\u1ec7n cho ng\u00e0y. \u0110\u1ec3 bu\u1ed9c Excel hi\u1ec3n th\u1ecb n\u00f3 nh\u01b0 m\u1ed9t ng\u00e0y, b\u1ea1n n\u00ean \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng Ng\u00e0y cho c\u00e1c \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c.<\/p>\n<blockquote>\n<p style=\"text-align: justify\"><a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\" target=\"_blank\" rel=\"noopener noreferrer\">Excel d\u00e0nh cho chuy\u00ean gia: T\u0103ng hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c th\u00eam 50% v\u1edbi VBA trong Excel<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_tru_hoac_them_nam_vao_ngay_trong_Excel\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 tr\u1eeb ho\u1eb7c th\u00eam n\u0103m v\u00e0o ng\u00e0y trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Th\u00eam n\u0103m v\u00e0o m\u1ed9t ng\u00e0y trong Excel \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 nh\u01b0 th\u00eam th\u00e1ng. B\u1ea1n s\u1eed d\u1ee5ng l\u1ea1i h\u00e0m DATE (n\u0103m, th\u00e1ng, ng\u00e0y), nh\u01b0ng l\u1ea7n n\u00e0y b\u1ea1n ch\u1ec9 \u0111\u1ecbnh b\u1ea1n mu\u1ed1n th\u00eam bao nhi\u00eau n\u0103m n\u1eefa:<\/p>\n<p style=\"text-align: justify\"><strong>= DATE (YEAR (ng\u00e0y) + N n\u0103m, MONTH (ng\u00e0y), DAY (ng\u00e0y))<\/strong><\/p>\n<p style=\"text-align: justify\">Trong b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n, c\u00e1c c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 tr\u00f4ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 th\u00eam n\u0103m v\u00e0o m\u1ed9t ng\u00e0y trong Excel:<\/p>\n<p style=\"text-align: justify\"><strong>= DATE (YEAR (A2) + 5, MONTH (A2), DAY (A2))<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c th\u00eam 5 n\u0103m cho ng\u00e0y trong \u00f4 A2.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 tr\u1eeb n\u0103m k\u1ec3 t\u1eeb ng\u00e0y trong Excel:<\/p>\n<p style=\"text-align: justify\"><strong>= DATE (YEAR (A2) \u2013 5, MONTH (A2), DAY (A2))<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c tr\u1eeb 5 n\u0103m k\u1ec3 t\u1eeb ng\u00e0y trong \u00f4 A2.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n g\u00f5 s\u1ed1 n\u0103m \u0111\u1ec3 th\u00eam (s\u1ed1 d\u01b0\u01a1ng) ho\u1eb7c tr\u1eeb (s\u1ed1 \u00e2m) trong m\u1ed9t s\u1ed1 \u00f4 v\u00e0 sau \u0111\u00f3 tham chi\u1ebfu \u00f4 \u0111\u00f3 trong h\u00e0m DATE, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c m\u1ed9t c\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5298 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-22.png\" width=\"384\" height=\"204\" title=\"excel-find-replace-highlight-22\"><\/p>\n<p style=\"text-align: justify\"><strong>Th\u00eam \/ x\u00f3a ng\u00e0y, th\u00e1ng v\u00e0 n\u0103m.<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n quan s\u00e1t c\u1ea9n th\u1eadn hai v\u00ed d\u1ee5 tr\u01b0\u1edbc \u0111\u00f3, ch\u1eafc b\u1ea1n \u0111\u00e3 \u0111o\u00e1n \u0111\u01b0\u1ee3c c\u00e1ch c\u1ed9ng tr\u1eeb ng\u00e0y th\u00e1ng trong Excel t\u1eeb m\u1ed9t ng\u00e0y trong c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 th\u00eam n\u0103m, th\u00e1ng, ng\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong>= DATE (YEAR (ng\u00e0y) + X n\u0103m, MONTH (ng\u00e0y) + Y th\u00e1ng, DAY (ng\u00e0y) + Z ng\u00e0y)<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 tr\u1eeb n\u0103m, th\u00e1ng, ng\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong>= DATE (YEAR (ng\u00e0y) \u2013 X n\u0103m, MONTH (ng\u00e0y) \u2013 Y th\u00e1ng, DAY (ng\u00e0y) \u2013 Z ng\u00e0y)<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c sau th\u00eam 2 n\u0103m, 3 th\u00e1ng v\u00e0 tr\u1eeb 15 ng\u00e0y k\u1ec3 t\u1eeb ng\u00e0y trong \u00f4 A2:<\/p>\n<p style=\"text-align: justify\"><strong>= DATE (YEAR (A2) + 2, MONTH (A2) + 3, DAY (A2) \u2013 15)<\/strong><\/p>\n<p style=\"text-align: justify\">\u00c1p d\u1ee5ng cho c\u1ed9t ng\u00e0y th\u00e1ng c\u1ee7a v\u00ed d\u1ee5, c\u00f4ng th\u1ee9c c\u00f3 d\u1ea1ng sau:<\/p>\n<p style=\"text-align: justify\"><strong>= DATE (YEAR (A2) + $ C $ 2, MONTH (A2) + $ D $ 2, DAY (A2) + $ E $ 2)<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5299 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-23.png\" width=\"519\" height=\"231\" title=\"excel-find-replace-highlight-23\"><\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch <\/strong><strong>c\u1ed9ng <\/strong><strong>v\u00e0 tr\u1eeb th\u1eddi gian trong Excel<\/strong><\/p>\n<p style=\"text-align: justify\">Trong Microsoft Excel, b\u1ea1n c\u00f3 th\u1ec3 c\u1ed9ng ho\u1eb7c tr\u1eeb th\u1eddi gian b\u1eb1ng h\u00e0m TIME. N\u00f3 cho ph\u00e9p b\u1ea1n ho\u1ea1t \u0111\u1ed9ng theo th\u1eddi gian \u0111\u01a1n v\u1ecb (gi\u1edd, ph\u00fat v\u00e0 gi\u00e2y) ch\u00ednh x\u00e1c theo c\u00e1ch b\u1ea1n x\u1eed l\u00fd n\u0103m, th\u00e1ng v\u00e0 ng\u00e0y v\u1edbi h\u00e0m DATE.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 th\u00eam th\u1eddi gian trong Excel:<\/p>\n<p style=\"text-align: justify\"><strong>= A2 + TIME (gi\u1edd, ph\u00fat, gi\u00e2y)<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 tr\u1eeb th\u1eddi gian trong Excel:<\/p>\n<p style=\"text-align: justify\"><strong>= A2 \u2013 TIME (gi\u1edd, ph\u00fat, gi\u00e2y)<\/strong><\/p>\n<p style=\"text-align: justify\">\u00d4 A2 ch\u1ee9a gi\u00e1 tr\u1ecb th\u1eddi gian m\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 th\u00eam 2 gi\u1edd, 30 ph\u00fat v\u00e0 15 gi\u00e2y v\u00e0o th\u1eddi gian trong \u00f4 A2, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong>= A2 + TIME (2, 30, 15)<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n c\u1ed9ng v\u00e0 tr\u1eeb th\u1eddi gian h\u1ee3p nh\u1ea5t trong m\u1ed9t c\u00f4ng th\u1ee9c, ch\u1ec9 c\u1ea7n th\u00eam d\u1ea5u tr\u1eeb v\u00e0o c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng:<\/p>\n<p style=\"text-align: justify\"><strong>= A2 + TIME (2, 30, -15)<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c tr\u00ean th\u00eam 2 gi\u1edd 30 ph\u00fat v\u00e0o \u00f4 A2 v\u00e0 tr\u1eeb 15 gi\u00e2y.<\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp th\u1eddi gian b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i trong m\u1ed9t s\u1ed1 \u00f4, v\u00e0 tham chi\u1ebfu nh\u1eefng \u00f4 \u0111\u00f3 trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n:<\/p>\n<p style=\"text-align: justify\"><strong>= A2 + TIME ($ C $ 2, $ D $ 2, $ E $ 2)<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5300 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-24.png\" width=\"434\" height=\"203\" title=\"excel-find-replace-highlight-24\"><\/p>\n<p style=\"text-align: justify\">V\u1eabn c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c tr\u00ean n\u1ebfu d\u1eef li\u1ec7u ngu\u1ed3n ch\u1ee9a c\u1ea3 ng\u00e0y th\u00e1ng v \u00e0 th\u1eddi gian.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5301 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-25.png\" width=\"489\" height=\"203\" title=\"excel-find-replace-highlight-25\"><\/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>\u0110\u00f3 l\u00e0 to\u00e0n b\u1ed9 c\u00e1c tr\u01b0\u1eddng h\u1ee3p <strong>c\u1ed9ng tr\u1eeb ng\u00e0y th\u00e1ng trong Excel<\/strong>. H\u00e3y l\u01b0u l\u1ea1i \u0111\u1ec3 m\u1edf ra khi c\u1ea7n nh\u00e9 c\u00e1c b\u1ea1n.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ed1t Excel trong c\u00f4ng vi\u1ec7c, ch\u00fang ta c\u00f2n ph\u1ea3i bi\u1ebft s\u1eed d\u1ee5ng c\u00e1c h\u00e0m n\u00e2ng cao nh\u01b0 Sumproduct, Sumifs, Countifs\u2026 \u0110\u1ed3ng th\u1eddi n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel nh\u01b0 Conditional formatting, Data Validation, Pivot Table\u2026 Nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00f4ng qua kh\u00f3a h\u1ecdc<strong><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"> EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a><\/strong> c\u1ee7a H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n tham gia \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i: H\u1ecdc Excel Online<\/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-8.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":607,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-606","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\/606","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=606"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/606\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/607"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}