{"id":7774,"date":"2024-12-21T18:28:57","date_gmt":"2024-12-21T18:28:57","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-dung-ham-date-trong-excel-cach-tinh-toan-ngay-thang\/"},"modified":"2024-12-21T18:28:57","modified_gmt":"2024-12-21T18:28:57","slug":"cach-dung-ham-date-trong-excel-cach-tinh-toan-ngay-thang","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-dung-ham-date-trong-excel-cach-tinh-toan-ngay-thang\/","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m DATE trong Excel \u2013 c\u00e1ch t\u00ednh to\u00e1n ng\u00e0y th\u00e1ng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Khi t\u00ednh to\u00e1n ng\u00e0y trong Excel, <strong>DATE<\/strong> l\u00e0 h\u00e0m c\u01a1 b\u1ea3n nh\u1ea5t. Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 bi\u1ebft, Excel kh\u00f4ng l\u01b0u tr\u1eef ng\u00e0y, th\u00e1ng d\u01b0\u1edbi \u0111\u1ecbnh d\u1ea1ng ng\u00e0y. Thay v\u00e0o \u0111\u00f3, Microsoft Excel l\u01b0u tr\u1eef ng\u00e0y nh\u01b0 m\u1ed9t d\u00e3y s\u1ed1 v\u00e0 \u0111\u00e2y l\u00e0 ch\u00ednh l\u00e0 nguy\u00ean ng\u00e2n ch\u00ednh g\u00e2y nh\u1ea7m l\u1eabn. H\u00e3y c\u00f9ng xem <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd mang \u0111\u1ebfn nh\u1eefng g\u00ec v\u1edbi <strong>H\u00e0m Date<\/strong> v\u00e0o ng\u00e0y h\u00f4m nay nh\u00e9!<\/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-676708e88b7bc\" 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-dung-ham-date-trong-excel-cach-tinh-toan-ngay-thang.html#Cu_phap_ham_DATE\" title=\"C\u00fa ph\u00e1p h\u00e0m DATE\">C\u00fa ph\u00e1p h\u00e0m DATE<\/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-dung-ham-date-trong-excel-cach-tinh-toan-ngay-thang.html#Vi_du_ham_DATE\" title=\"V\u00ed d\u1ee5 h\u00e0m DATE\">V\u00ed d\u1ee5 h\u00e0m DATE<\/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-dung-ham-date-trong-excel-cach-tinh-toan-ngay-thang.html#Su_dung_ham_DATE_trong_dinh_dang_co_dieu_kien\" title=\"S\u1eed d\u1ee5ng h\u00e0m DATE trong \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n\">S\u1eed d\u1ee5ng h\u00e0m DATE trong \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cu_phap_ham_DATE\"><\/span><strong>C\u00fa ph\u00e1p h\u00e0m DATE<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u1eefng g\u00ec <strong>h\u00e0m DATE<\/strong> l\u00e0m l\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 s\u1ed1 cho m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3. N\u00f3 c\u00f3 c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong>DATE(year, month, day)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Year<\/strong> \u2013 ch\u1ec9 n\u0103m. Excel di\u1ec5n gi\u1ea3i \u0111\u1ed1i s\u1ed1 n\u0103m theo h\u1ec7 th\u1ed1ng ng\u00e0y \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp tr\u00ean m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n. Theo m\u1eb7c \u0111\u1ecbnh, Microsoft Excel cho Windows s\u1eed d\u1ee5ng h\u1ec7 th\u1ed1ng 1900. Trong h\u1ec7 th\u1ed1ng ng\u00e0y th\u00e1ng n\u00e0y:<\/p>\n<ul style=\"text-align: justify\">\n<li>N\u1ebfu n\u0103m trong kho\u1ea3ng 1900 v\u00e0 9999, ch\u00ednh gi\u00e1 tr\u1ecb \u0111\u00f3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong n\u0103m. V\u00ed d\u1ee5: = DATE (2015, 12, 31) tr\u1ea3 v\u1ec1 ng\u00e0y 31 th\u00e1ng 12 n\u0103m 2015.<\/li>\n<li>N\u1ebfu n\u0103m trong kho\u1ea3ng gi\u1eefa 0 v\u00e0 1899, Excel t\u00ednh n\u0103m b\u1eb1ng c\u00e1ch c\u1ed9ng th\u00eam s\u1ed1 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh v\u00e0o n\u0103m 1900. V\u00ed d\u1ee5: = DATE (100, 12, 31) tr\u1ea3 v\u1ec1 ng\u00e0y 31 th\u00e1ng 12 n\u0103m 2000 (1900 + 100).<\/li>\n<li>N\u1ebfu n\u0103m nh\u1ecf h\u01a1n 0 ho\u1eb7c l\u1edbn h\u01a1n 9999, h\u00e0m DATE s\u1ebd tr\u1ea3 v\u1ec1 #NUM! l\u1ed7i.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>M\u1eb9o<\/strong>. \u0110\u1ec3 tr\u00e1nh nh\u1ea7m l\u1eabn, lu\u00f4n lu\u00f4n ghi b\u1ed1n ch\u1eef s\u1ed1 c\u1ee7a n\u0103m. V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n nh\u1eadp \u201c01\u201d ho\u1eb7c \u201c1\u201d v\u00e0o \u0111\u1ed1i s\u1ed1 n\u0103m, h\u00e0m DATE s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 n\u0103m 1901.<\/p>\n<p style=\"text-align: justify\"><strong>Month<\/strong> \u2013 m\u1ed9t s\u1ed1 nguy\u00ean \u0111\u1ea1i di\u1ec7n cho th\u00e1ng trong n\u0103m, t\u1eeb 1 (January) \u0111\u1ebfn 12 (December).<\/p>\n<ul style=\"text-align: justify\">\n<li>N\u1ebfu th\u00e1ng l\u1edbn h\u01a1n 12, Excel s\u1ebd c\u1ed9ng s\u1ed1 \u0111\u00f3 v\u00e0o th\u00e1ng 1 c\u1ee7a n\u0103m \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. V\u00ed d\u1ee5: = DATE (2015, 15, 5) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ng\u00e0y 1 th\u00e1ng 3 n\u0103m 2016 (ng\u00e0y 5 th\u00e1ng 1 n\u0103m 2015 c\u1ed9ng v\u1edbi 15 th\u00e1ng).<\/li>\n<li>N\u1ebfu th\u00e1ng nh\u1ecf h\u01a1n 1 (s\u1ed1 kh\u00f4ng ho\u1eb7c gi\u00e1 tr\u1ecb \u00e2m), Excel tr\u1eeb \u0111i s\u1ed1 th\u00e1ng \u0111\u00f3 v\u00e0 tr\u1eeb th\u00eam 1, k\u1ec3 t\u1eeb th\u00e1ng \u0111\u1ea7u ti\u00ean c\u1ee7a n\u0103m \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. V\u00ed d\u1ee5: = DATE (2015, -5, 1) tr\u1ea3 l\u1ea1i ng\u00e0y 1 th\u00e1ng 7 n\u0103m 2014 (ng\u00e0y 1 th\u00e1ng 1 n\u0103m 2015 tr\u1eeb \u0111i 6 th\u00e1ng).<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>Day<\/strong> \u2013 m\u1ed9t s\u1ed1 nguy\u00ean t\u01b0\u01a1ng \u1ee9ng v\u1edbi ng\u00e0y trong th\u00e1ng, t\u1eeb 1 \u0111\u1ebfn 31.<\/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-316.gif\" title=\"vba101_92019-nho-316\"><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-699.gif\" title=\"ex101_92019-nho-699\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">C\u0169ng nh\u01b0 th\u00e1ng, \u0111\u1ed1i s\u1ed1 ng\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c cung c\u1ea5p nh\u01b0 m\u1ed9t s\u1ed1 d\u01b0\u01a1ng v\u00e0 \u00e2m, v\u00e0 Excel t\u00ednh gi\u00e1 tr\u1ecb c\u1ee7a n\u00f3 d\u1ef1a tr\u00ean c\u00e1c nguy\u00ean t\u1eafc t\u01b0\u01a1ng t\u1ef1 nh\u01b0 m\u00f4 t\u1ea3 \u1edf tr\u00ean.<\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o<\/strong>. L\u00fac \u0111\u1ea7u, vi\u1ec7c cung c\u1ea5p gi\u00e1 tr\u1ecb \u00e2m trong \u0111\u1ed1i s\u1ed1 th\u00e1ng ho\u1eb7c ng\u00e0y c\u1ee7a h\u00e0m DATE c\u00f3 v\u1ebb nh\u01b0 v\u00f4 l\u00fd, nh\u01b0ng tr\u00ean th\u1ef1c t\u1ebf n\u00f3 c\u00f3 th\u1ec3 tr\u1edf n\u00ean kh\u00e1 h\u1eefu \u00edch, v\u00ed d\u1ee5 trong c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p chuy\u1ec3n \u0111\u1ed5i tu\u1ea7n.<\/p>\n<p style=\"text-align: justify\">H\u00e0m DATE c\u00f3 s\u1eb5n trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n c\u1ee7a Excel 2016, Excel 2013, Excel 2010, Excel 2007, 2003, XP, 2000 c\u0169ng nh\u01b0 trong Excel 2016.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">L\u00e0m ch\u1ee7 Excel trong 7 ng\u00e0y, t\u0103ng 300% hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_ham_DATE\"><\/span><strong>V\u00ed d\u1ee5 h\u00e0m DATE<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng c\u00e1i \u0111\u01a1n gi\u1ea3n nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng r\u00f5 r\u00e0ng nh\u1ea5t c\u1ee7a h\u00e0m DATE trong Excel:<\/p>\n<p style=\"text-align: justify\"><strong>= DATE (2015, 5, 20)<\/strong> \u2013 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ng\u00e0y 20 th\u00e1ng 5 n\u0103m 2015.<\/p>\n<p style=\"text-align: justify\">Thay v\u00ec ch\u1ec9 \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ea1i di\u1ec7n cho n\u0103m, th\u00e1ng v\u00e0 ng\u00e0y tr\u1ef1c ti\u1ebfp trong m\u1ed9t c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 ho\u1eb7c t\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ed1i s\u1ed1 nh\u01b0 l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a c\u00e1c h\u00e0mkh\u00e1c:<\/p>\n<p style=\"text-align: justify\"><strong>=DATE(YEAR(TODAY()), 1, 1)<\/strong> \u2013 cho k\u1ebft qu\u1ea3 ng\u00e0y \u0111\u1ea7u ti\u00ean c\u1ee7a n\u0103m hi\u1ec7n t\u1ea1i.<\/p>\n<p style=\"text-align: justify\"><strong>=DATE(YEAR(TODAY()), MONTH(TODAY(), 1)<\/strong>\u2013 cho k\u1ebft qu\u1ea3 ng\u00e0y \u0111\u1ea7u ti\u00ean c\u1ee7a th\u00e1ng hi\u1ec7n t\u1ea1i trong n\u0103m hi\u1ec7n t\u1ea1i.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5428 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-42.png\" width=\"600\" height=\"157\" title=\"excel-find-replace-highlight-42\"><\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 2. H\u00e0mDATE \u0111\u1ec3 tr\u1ea3 l\u1ea1i m\u1ed9t ng\u00e0y d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 kh\u00e1c<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00e0m DATE r\u1ea5t h\u1eefu \u00edch cho vi\u1ec7c t\u00ednh c\u00e1c ng\u00e0y m\u00e0 c\u00e1c gi\u00e1 tr\u1ecb n\u0103m, th\u00e1ng v\u00e0 ng\u00e0y \u0111\u01b0\u1ee3c l\u1ea5y t\u1eeb \u00f4 kh\u00e1c. V\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><strong>= DATE (A2, A3, A4)<\/strong> \u2013 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ng\u00e0y, th\u00e1ng , n\u0103m t\u1eeb \u00f4 A2, A3 v\u00e0 A4.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5429\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-43-300x51-1.png\" width=\"600\" height=\"102\" title=\"excel-find-replace-highlight-43-300x51-1\"><\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 3. H\u00e0m DATE chuy\u1ec3n \u0111\u1ed5i m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh m\u1ed9t ng\u00e0y<\/strong><\/p>\n<p style=\"text-align: justify\">Khi c\u00e1c ng\u00e0y \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef \u1edf \u0111\u1ecbnh d\u1ea1ng m\u00e0 Microsoft Excel kh\u00f4ng nh\u1eadn ra, v\u00ed d\u1ee5 DDMMYYYY. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng DATE v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i m\u1ed9t ng\u00e0y \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef nh\u01b0 l\u00e0 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh ng\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong>= DATE (RIGHT (A2,4), MID (A2,3,2), LEFT (A2,2))<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5430 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-44.png\" width=\"600\" height=\"83\" title=\"excel-find-replace-highlight-44\"><\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 4. C\u1ed9ng v\u00e0 tr\u1eeb ng\u00e0y trong Excel<\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp, Microsoft Excel l\u01b0u tr\u1eef c\u00e1c ng\u00e0y nh\u01b0 l\u00e0 m\u1ed9t chu\u1ed7i s\u1ed1 v\u00e0 ho\u1ea1t \u0111\u1ed9ng tr\u00ean nh\u1eefng con s\u1ed1 trong c\u00f4ng th\u1ee9c v\u00e0 t\u00ednh to\u00e1n. \u0110\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao khi b\u1ea1n mu\u1ed1n c\u1ed9ng ho\u1eb7c tr\u1eeb m\u1ed9t s\u1ed1 ng\u00e0y v\u00e0o \/ t\u1eeb m\u1ed9t ng\u00e0y nh\u1ea5t \u0111\u1ecbnh, b\u1ea1n c\u1ea7n ph\u1ea3i chuy\u1ec3n \u0111\u1ed5i ng\u00e0y \u0111\u00f3 sang s\u1ed1 th\u1ee9 t\u1ef1 \u0111\u1ea7u ti\u00ean b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m DATE. V\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><strong>Th\u00eam ng\u00e0y<\/strong> v\u00e0o m\u1ed9t ng\u00e0y:<\/p>\n<p style=\"text-align: justify\">= DATE (2015, 5, 20) + 15<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c c\u1ed9ng th\u00eam 15 ng\u00e0y cho ng\u00e0y 20 th\u00e1ng 5 n\u0103m 2015 v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ng\u00e0y 4 th\u00e1ng 6 n\u0103m 2015.<\/p>\n<p style=\"text-align: justify\"><strong>Tr\u1eeb ng\u00e0y<\/strong> k\u1ec3 t\u1eeb ng\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong>= DATE (2015, 5, 20) \u2013 15<\/strong><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c tr\u00ean l\u00e0 ng\u00e0y 5 th\u00e1ng 5 n\u0103m 2015, t\u1ee9c l\u00e0 ng\u00e0y 20 th\u00e1ng 5 n\u0103m 2015 tr\u1eeb \u0111i 15 ng\u00e0y.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 tr\u1eeb m\u1ed9t ng\u00e0y t\u1eeb ng\u00e0y h\u00f4m nay:<\/p>\n<p style=\"text-align: justify\"><strong>= TODAY () \u2013 NG\u00c0Y (2015,5,20)<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 ng\u00e0y n\u1eb1m gi\u1eefa ng\u00e0y hi\u1ec7n t\u1ea1i v\u00e0 m\u1ed9t ng\u00e0y kh\u00e1c m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5431 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-45.png\" width=\"600\" height=\"133\" title=\"excel-find-replace-highlight-45\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ed9ng ho\u1eb7c tr\u1eeb hai ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong 2 \u00f4, th\u00ec c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n l\u00e0 = A1 + B1 ho\u1eb7c A1-B1.<\/p>\n<p style=\"text-align: justify\"><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<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_DATE_trong_dinh_dang_co_dieu_kien\"><\/span><strong>S\u1eed d\u1ee5ng h\u00e0m DATE trong \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n kh\u00f4ng ch\u1ec9 t\u00ednh to\u00e1n m\u00e0 c\u00f2n \u0111\u00e1nh d\u1ea5u ng\u00e0y th\u00e1ng trong b\u1ea3ng t\u00ednh Excel, sau \u0111\u00f3 t\u1ea1o c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean h\u00e0m DATE.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c ng\u00e0y trong c\u1ed9t A v\u00e0 b\u1ea1n mu\u1ed1n t\u00f4 m\u00e0u cam ng\u00e0y tr\u01b0\u1edbc ng\u00e0y 1 th\u00e1ng 5 n\u0103m 2015 v\u00e0 xanh l\u00e1 c\u00e2y nh\u1eefng ng\u00e0y x\u1ea3y ra sau ng\u00e0y 31 th\u00e1ng 5 n\u0103m 2015.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c DATE b\u1ea1n mu\u1ed1n l\u00e0 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">M\u00e0u cam: <strong>= $A2 &lt;NG\u00c0Y (2015, 5, 1)<\/strong> \u2013 t\u00f4 m\u00e0u ng\u00e0y tr\u01b0\u1edbc 1 th\u00e1ng 5 n\u0103m 2015<\/p>\n<p style=\"text-align: justify\">M\u00e0u xanh l\u00e1 c\u00e2y: <strong>= $A2&gt; NG\u00c0Y (2015, 5, 31)<\/strong> \u2013 t\u00f4 m\u00e0u c\u00e1c ng\u00e0y l\u1edbn h\u01a1n 31 th\u00e1ng 5 n\u0103m 2015.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5434 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-47.png\" width=\"600\" height=\"308\" title=\"excel-find-replace-highlight-47\"><\/p>\n<p style=\"text-align: justify\">Ngu\u1ed3n: Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/p>\n<p><strong>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cach-cong-tru-ngay-thang-nam-trong-excel.html\">C\u00e1ch tr\u1eeb ng\u00e0y th\u00e1ng n\u0103m trong Excel<\/a> \u0111\u01a1n gi\u1ea3n<\/strong><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>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 <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">kh\u00f3a h\u1ecdc Excel c\u01a1 b\u1ea3n \u0111\u1ebfn chuy\u00ean gia d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/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-316.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7775,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7774","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\/7774","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=7774"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7774\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7775"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}