{"id":6053,"date":"2024-12-21T13:08:44","date_gmt":"2024-12-21T13:08:44","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-kiem-tra-du-lieu-dang-ngay-thang-trich-xuat-tu-phan-mem-khac-ra-excel\/"},"modified":"2024-12-21T13:08:44","modified_gmt":"2024-12-21T13:08:44","slug":"cach-kiem-tra-du-lieu-dang-ngay-thang-trich-xuat-tu-phan-mem-khac-ra-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-kiem-tra-du-lieu-dang-ngay-thang-trich-xuat-tu-phan-mem-khac-ra-excel\/","title":{"rendered":"C\u00e1ch ki\u1ec3m tra d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng tr\u00edch xu\u1ea5t t\u1eeb ph\u1ea7n m\u1ec1m kh\u00e1c ra excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi s\u1eed d\u1ee5ng nh\u1eefng ph\u1ea7n m\u1ec1m kh\u00e1c, m\u00e0 ch\u00fang ta c\u1ea7n tr\u00edch xu\u1ea5t ra\u00a0Excel\u00a0\u0111\u1ec3 t\u00ednh to\u00e1n, x\u1eed l\u00fd th\u00ec ch\u00fang ta th\u01b0\u1eddng g\u1eb7p ph\u1ea3i 1 v\u1ea5n\u00a0\u0111\u1ec1,\u00a0\u0111\u00f3 l\u00e0 d\u1eef li\u1ec7u\u00a0\u1edf c\u00e1c c\u1ed9t d\u1ea1ng Ng\u00e0y th\u00e1ng kh\u00f4ng hi\u1ec3n th\u1ecb\u00a0\u0111\u00fang b\u1ea3n ch\u1ea5t d\u1eef li\u1ec7u Ng\u00e0y th\u00e1ng m\u00e0\u00a0excel quy\u00a0\u01b0\u1edbc.<\/p>\n<p>V\u00ed d\u1ee5 v\u1ec1 1 b\u1ea3ng t\u00ednh tr\u00edch xu\u1ea5t t\u1eeb ph\u1ea7n m\u1ec1m nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11011 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic01-de1bbaf-lie1bb87u-trc3adch-xue1baa5t-te1bbab-pm.png\" width=\"886\" height=\"516\" title=\"pic01-de1bbaf-lie1bb87u-trc3adch-xue1baa5t-te1bbab-pm\"><\/p>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y c\u1ed9t D v\u00e0 E c\u00f3 d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y, nh\u01b0ng c\u00f3 ph\u1ea3i d\u1eef li\u1ec7u n\u00e0y\u00a0\u0111\u00e3\u00a0\u0111\u00fang\u00a0\u0111\u1ecbnh d\u1ea1ng h\u1ebft ch\u01b0a, c\u00e1ch ki\u1ec3m tra th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 t\u00ecm ra nh\u1eefng\u00a0\u00f4 n\u00e0o\u00a0\u0111\u1ecbnh d\u1ea1ng\u00a0\u0111\u00fang,\u00a0\u00f4 n\u00e0o\u00a0\u0111\u1ecbnh d\u1ea1ng sai?<\/p>\n<p>hocexcel.online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n 1 s\u1ed1 k\u1ef9 thu\u1eadt ki\u1ec3m tra d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y nh\u01b0 sau:<\/p>\n<p><strong>1. Quy\u00a0\u01b0\u1edbc v\u1ec1 d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y trong\u00a0excel<\/strong><\/p>\n<ul>\n<li>D\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y l\u00e0 1 con s\u1ed1, khi format cell\u00a0\u00f4 ch\u1ee9a d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y (v\u00ed d\u1ee5 09\/10\/2017) \u1edf d\u1ea1ng General, ta s\u1ebd th\u1ea5y d\u1eef li\u1ec7u ng\u00e0y l\u00e0\u00a0s\u1ed1 43017, c\u00f2n\u00a0\u0111\u1ecbnh d\u1ea1ng\u00a0dd\/mm\/yyyy th\u00ec m\u1edbi hi\u1ec3n th\u1ecb l\u00e0 09\/10\/2017<\/li>\n<li>V\u1edbi d\u1eef li\u1ec7u nh\u1eadp tr\u1ef1c ti\u1ebfp trong\u00a0excel th\u00ec quy\u00a0\u01b0\u1edbc tr\u00ean l\u00e0\u00a0\u0111\u00fang, c\u00f2n nh\u1eefng d\u1eef li\u1ec7u t\u1eeb ph\u1ea7n m\u1ec1m kh\u00e1c tr\u00edch xu\u1ea5t ra\u00a0excel th\u00ec l\u1ea1i kh\u00f4ng\u00a0\u0111\u00fang quy\u00a0\u01b0\u1edbc\u00a0\u0111\u00f3, t\u1ee9c l\u00e0 v\u1eabn\u00a0\u0111\u00fang\u00a0\u0111\u1ecbnh d\u1ea1ng ng\u00e0y, khi format v\u1ec1 d\u1ea1ng General v\u1eabn l\u00e0 d\u1eef li\u1ec7u d\u1ea1ng\u00a0dd\/mm\/yyyy<\/li>\n<\/ul>\n<p><strong>2. Ki\u1ec3m tra b\u1eb1ng Data Filter<\/strong><\/p>\n<p>B\u1ea1n t\u1ea1o ch\u1ee9c n\u0103ng Filter cho b\u1ea3ng t\u00ednh, t\u1ea1i c\u1ed9t Ng\u00e0y th\u00e1ng c\u1ea7n ki\u1ec3m tra, b\u1ea1n b\u1ea5m v\u00e0o d\u1ea5u l\u1ecdc v\u00e0 xem nh\u1eefng d\u1ea5u hi\u1ec7u sau:<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-542.gif\" title=\"ex101_92019-nho-542\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-229.gif\" title=\"vba101_92019-nho-229\"><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-542.gif\" title=\"ex101_92019-nho-542\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11020 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic02-filter-de1baa5u-hie1bb87u-1.png\" width=\"884\" height=\"512\" title=\"pic02-filter-de1baa5u-hie1bb87u-1\"><\/p>\n<p style=\"text-align: center\">D\u1ea5u hi\u1ec7u 1: D\u1eef li\u1ec7u d\u1ea1ng\u00a0dd\/mm\/yyyy m\u00e0 xu\u1ea5t hi\u1ec7n s\u1ed1 th\u00e1ng &gt;12 th\u00ec nh\u1eefng d\u1eef li\u1ec7u\u00a0\u0111\u00f3 l\u00e0 sai<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11026 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic03-filter-de1baa5u-hie1bb87u-2.png\" width=\"876\" height=\"516\" title=\"pic03-filter-de1baa5u-hie1bb87u-2\"><\/p>\n<p style=\"text-align: center\">D\u1ea5u hi\u1ec7u 2: Th\u00e1ng 9 x\u1ebfp sau th\u00e1ng 10. Ch\u1ee9c n\u0103ng Data Filter khi b\u1ea5m v\u00e0o n\u00fat l\u1ec7nh l\u1ecdc th\u00ec d\u1eef li\u1ec7u\u00a0\u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong b\u1ea3ng n\u00e0y l\u00e0 d\u1eef li\u1ec7u\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u1eeb nh\u1ecf t\u1edbi l\u1edbn. N\u00ean n\u1ebfu d\u1eef li\u1ec7u ch\u01b0a s\u1eafp x\u1ebfp\u00a0\u0111\u00fang tr\u1eadt t\u1ef1 th\u00ec ch\u1eafc ch\u1eafn d\u1eef li\u1ec7u\u00a0\u0111\u00f3\u00a0\u0111ang b\u1ecb sai, kh\u00f4ng\u00a0\u0111\u00fang chu\u1ea9n quy\u00a0\u01b0\u1edbc n\u00ean kh\u00f4ng s\u1eafp x\u1ebfp\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11036 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic04-filter-de1baa5u-hie1bb87u-3.png\" width=\"874\" height=\"513\" title=\"pic04-filter-de1baa5u-hie1bb87u-3\"><\/p>\n<p style=\"text-align: center\">D\u1ea5u hi\u1ec7u 3: D\u1eef li\u1ec7u d\u1ea1ng\u00a0dd\/mm\/yyyy hay mm\/dd\/yyyy\u00a0\u0111ang b\u1ecb l\u1eabn l\u1ed9n, v\u00e0 d\u00f9 theo d\u1ea1ng n\u00e0o th\u00ec c\u0169ng\u00a0\u0111ang ch\u01b0a\u00a0\u0111\u00fang quy chu\u1ea9n v\u1ec1 s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 trong Filter.<\/p>\n<p style=\"text-align: left\">Khi g\u1eb7p c\u00e1c d\u1ea5u hi\u1ec7u n\u00e0y, c\u00e1c b\u1ea1n h\u00e3y ngh\u0129 t\u1edbi vi\u1ec7c x\u1eed l\u00fd n\u00f3\u00a0\u0111\u1ec3\u00a0\u0111\u01b0a v\u1ec1 d\u1ea1ng chu\u1ea9n quy\u00a0\u01b0\u1edbc c\u1ee7a\u00a0excel tr\u01b0\u1edbc ti\u00ean nh\u00e9, n\u1ebfu kh\u00f4ng quy chu\u1ea9n l\u1ea1i th\u00ec s\u1ebd kh\u00f4ng th\u1ec3 t\u00ednh to\u00e1n\u00a0\u0111\u00fang\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p style=\"text-align: left\">B\u00e0i vi\u1ebft v\u1ec1 c\u00e1ch x\u1eed l\u00fd d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng cho\u00a0\u0111\u00fang quy chu\u1ea9n m\u1eddi c\u00e1c b\u1ea1n xem\u00a0\u1edf\u00a0\u0111\u00e2y:<\/p>\n<p style=\"text-align: left\"><a href=\"http:\/\/blog.ezworkapp.com\/xu-ly-du-lieu-ngay-thang-cho-dung-quy-chuan-excel.html\">X\u1eed l\u00fd d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng cho\u00a0\u0111\u00fang quy chu\u1ea9n\u00a0Excel<\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-542.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6054,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6053","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\/6053","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=6053"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6053\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6054"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6053"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6053"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6053"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}