{"id":5014,"date":"2024-12-09T01:23:12","date_gmt":"2024-12-09T01:23:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/cach-thiet-lap-chi-nhap-du-lieu-dang-ngay-thang-trong-o-tren-excel\/"},"modified":"2024-12-09T01:23:12","modified_gmt":"2024-12-09T01:23:12","slug":"cach-thiet-lap-chi-nhap-du-lieu-dang-ngay-thang-trong-o-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/cach-thiet-lap-chi-nhap-du-lieu-dang-ngay-thang-trong-o-tren-excel\/","title":{"rendered":"C\u00e1ch thi\u1ebft l\u1eadp ch\u1ec9 nh\u1eadp d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng trong \u00f4 tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi nh\u1eadp d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng trong\u00a0Excel, ch\u00fang ta r\u1ea5t d\u1ec5 m\u1eafc l\u1ed7i. C\u00f3 th\u1ec3 k\u1ec3 t\u1edbi m\u1ed9t s\u1ed1 l\u1ed7i hay g\u1eb7p nh\u01b0:<\/p>\n<ul>\n<li>Nh\u1eadp sai\u00a0\u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng: Nh\u1eadp ng\u00e0y 13\/05\/2018 nh\u01b0ng nh\u1eadp sai\u00a0\u0111\u1ecbnh d\u1ea1ng khi\u1ebfn\u00a0Excel hi\u1ec3u l\u00e0 ng\u00e0y 05 th\u00e1ng 13 n\u0103m 2018 =&gt; D\u1eef li\u1ec7u sai<\/li>\n<li>Nh\u1eadp l\u1eabn k\u00fd t\u1ef1 Text: v\u00ed d\u1ee5 nh\u1eadp ng\u00e0y 25\/05\/2018 nh\u01b0ng nh\u1eadp ch\u1eef O thay v\u00ec s\u1ed1 0<\/li>\n<li>Nh\u1eadp sai s\u1ed1 ng\u00e0y l\u1edbn h\u01a1n 31, nh\u1eadp sai s\u1ed1 th\u00e1ng l\u1edbn h\u01a1n 12<\/li>\n<\/ul>\n<p>Nh\u1eefng l\u1ed7i n\u00e0y th\u01b0\u1eddng l\u00e0 l\u1ed7i v\u00f4 t\u00ecnh, kh\u00f4ng c\u1ed1\u00a0\u00fd, nh\u1eadp\u00a0\u1ea9u, nh\u1ea3y ph\u00edm\u2026 v\u00e0 ch\u00fang ta\u00a0\u0111\u1ec1u kh\u00f4ng mong mu\u1ed1n\u00a0Excel ghi nh\u1eadn c\u00e1c tr\u01b0\u1eddng h\u1ee3p l\u1ed7i n\u00e0y khi ch\u00fang ta nh\u1eadp d\u1eef li\u1ec7u trong\u00a0Excel. V\u1eady <strong>l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 trong c\u00e1c v\u00f9ng nh\u1eadp d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng ch\u1ec9 cho ph\u00e9p ghi nh\u1eadn nh\u1eefng d\u1eef li\u1ec7u nh\u1eadp\u00a0\u0111\u00fang\u00a0\u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng theo quy chu\u1ea9n c\u1ee7a\u00a0Excel<\/strong>? Ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u 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-6756467fe01d6\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-thiet-lap-chi-nhap-du-lieu-dang-ngay-thang-trong-o-tren-excel.html#1_Chuc_nang_can_su_dung\" title=\"1. Ch\u1ee9c n\u0103ng c\u1ea7n s\u1eed d\u1ee5ng\">1. Ch\u1ee9c n\u0103ng c\u1ea7n s\u1eed d\u1ee5ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-thiet-lap-chi-nhap-du-lieu-dang-ngay-thang-trong-o-tren-excel.html#2_Cach_thiet_lap_Data_Validation_chi_nhap_du_lieu_dang_ngay_thang\" title=\"2. C\u00e1ch thi\u1ebft l\u1eadp Data Validation ch\u1ec9 nh\u1eadp d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng\">2. C\u00e1ch thi\u1ebft l\u1eadp Data Validation ch\u1ec9 nh\u1eadp d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Chuc_nang_can_su_dung\"><\/span>1. Ch\u1ee9c n\u0103ng c\u1ea7n s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng <strong>Data Validation<\/strong> trong tab <strong>Data<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16557\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-data-validation-date-01.png\" width=\"793\" height=\"153\" title=\"heo-data-validation-date-01\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Cach_thiet_lap_Data_Validation_chi_nhap_du_lieu_dang_ngay_thang\"><\/span>2. C\u00e1ch thi\u1ebft l\u1eadp Data Validation ch\u1ec9 nh\u1eadp d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong c\u1eeda s\u1ed5 Data validation&gt;tab Settings&gt;M\u1ee5c Allow ch\u1ecdn Date<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16558\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-data-validation-date-02.png\" width=\"586\" height=\"410\" title=\"heo-data-validation-date-02\"><\/p>\n<p>Trong d\u1ea1ng <strong>Date<\/strong> n\u00e0y ch\u00fang ta c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp <strong>Data<\/strong> (d\u1eef li\u1ec7u nh\u1eadp v\u00e0o) theo c\u00e1c gi\u1edbi h\u1ea1n nh\u01b0 sau:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-419.gif\" title=\"ex101_92019-nho-419\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16559\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-data-validation-date-03.png\" width=\"586\" height=\"410\" title=\"heo-data-validation-date-03\"><\/p>\n<ul>\n<li><strong>between<\/strong>: trong kho\u1ea3ng<\/li>\n<li><strong>not between<\/strong>: ngo\u00e0i kho\u1ea3ng<\/li>\n<li><strong>equal to<\/strong>: b\u1eb1ng v\u1edbi<\/li>\n<li><strong>not equal to<\/strong>: kh\u00f4ng b\u1eb1ng<\/li>\n<li><strong>greater than<\/strong>: l\u1edbn h\u01a1n<\/li>\n<li><strong>less than<\/strong>: nh\u1ecf h\u01a1n<\/li>\n<li><strong>greater than\u00a0or equal to<\/strong>: l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng<\/li>\n<li><strong>less than\u00a0or equal to:<\/strong> nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng<\/li>\n<\/ul>\n<p>T\u00f9y theo\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ee7a Data ch\u00fang ta s\u1ebd thi\u1ebft l\u1eadp c\u00e1c gi\u1edbi h\u1ea1n d\u1eef li\u1ec7u\u00a0\u0111\u01b0\u1ee3c ph\u00e9p nh\u1eadp v\u00e0o cho ph\u00f9 h\u1ee3p<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p>Data l\u00e0 Between, t\u1eeb ng\u00e0y 01\/01\/2018 t\u1edbi ng\u00e0y 31\/12\/2018<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16560\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-data-validation-date-04.png\" width=\"580\" height=\"404\" title=\"heo-data-validation-date-04\"><\/p>\n<p>T\u1ee9c l\u00e0 d\u1eef li\u1ec7u nh\u1eadp v\u00e0o ch\u1ec9 gi\u1edbi h\u1ea1n trong n\u0103m 2018 v\u00e0 ph\u1ea3i l\u00e0 d\u1eef li\u1ec7u chu\u1ea9n ng\u00e0y th\u00e1ng<\/p>\n<p>N\u1ebfu b\u1ea1n\u00a0mu\u1ed1n n\u00e2ng cao k\u1ef9 n\u0103ng v\u00e0 ki\u1ebfn th\u1ee9c\u00a0Excel, h\u00e3y tham gia ngay kh\u00f3a h\u1ecdc\u00a0Excel T\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m. Kh\u00f3a h\u1ecdc s\u1ebd gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7, x\u00e2y d\u1ef1ng k\u1ef9 n\u0103ng l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/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\/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-419.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5015,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5014","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\/5014","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=5014"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5014\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5015"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5014"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5014"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}