{"id":6031,"date":"2024-12-21T12:13:46","date_gmt":"2024-12-21T12:13:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/xu-ly-du-lieu-ngay-thang-cho-dung-quy-chuan-excel\/"},"modified":"2024-12-21T12:13:46","modified_gmt":"2024-12-21T12:13:46","slug":"xu-ly-du-lieu-ngay-thang-cho-dung-quy-chuan-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/xu-ly-du-lieu-ngay-thang-cho-dung-quy-chuan-excel\/","title":{"rendered":"X\u1eed l\u00fd d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng cho \u0111\u00fang quy chu\u1ea9n Excel"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, Blog\u00a0h\u1ecdc Excel v\u0103n ph\u00f2ng<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1c thao t\u00e1c x\u1eed l\u00fd d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng tr\u00edch xu\u1ea5t t\u1eeb ph\u1ea7n m\u1ec1m kh\u00e1c\u00a0v\u1ec1\u00a0\u0111\u00fang quy chu\u1ea9n\u00a0\u0111\u1ecbnh d\u1ea1ng c\u1ee7a\u00a0excel nh\u01b0 sau:<\/p>\n

D\u1eef li\u1ec7u g\u1ed1c: c\u00e1c b\u1ea1n xem trong b\u00e0i vi\u1ebft n\u00e0y:<\/p>\n

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\u00a0excel<\/a><\/p>\n

B\u01b0\u1edbc 1: D\u00f9ng h\u00e0m Date\u00a0\u0111\u1ec3 l\u1ea5y c\u00e1c d\u1eef li\u1ec7u d\u1ea1ng Ng\u00e0y, Th\u00e1ng, N\u0103m t\u1eeb d\u1eef li\u1ec7u g\u1ed1c<\/p>\n

<\/p>\n

B\u01b0\u1edbc 2:\u00a0\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u\u00a0\u1edf c\u1ed9t k\u1ebft qu\u1ea3 b\u01b0\u1edbc 1 v\u1ec1 d\u1ea1ng ng\u00e0y th\u00e1ng\u00a0dd\/mm\/yyyy<\/p>\n

<\/p>\n

B\u01b0\u1edbc 3:\u00a0\u00c1p d\u1ee5ng Data Filter v\u00e0o c\u1ed9t k\u1ebft qu\u1ea3 b\u01b0\u1edbc 1, t\u00ecm ki\u1ebfm nh\u1eefng gi\u00e1 tr\u1ecb #VALUE! v\u00e0 s\u1eeda l\u1ea1i ng\u00e0y\u00a0\u1edf d\u1eef li\u1ec7u g\u1ed1c v\u1ec1\u00a0\u0111\u00fang\u00a0\u0111\u1ecbnh d\u1ea1ng<\/p>\n

\n
\n

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


\n
\n<\/a>\n<\/div>\n<\/div>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

<\/p>\n

X\u1eed l\u1ef9 d\u1eef li\u1ec7u g\u1ed1c\u00a0\u1edf nh\u1eefng d\u00f2ng m\u00e0 h\u00e0m DATE b\u00e1o l\u1ed7i v\u1ec1\u00a0\u0111\u00fang\u00a0\u0111\u1ecbnh d\u1ea1ng ng\u00e0y b\u1eb1ng c\u00e1ch s\u1eeda\u00a0tr\u1ef1c ti\u1ebfp t\u1eebng\u00a0\u00f4\u00a0\u1edf c\u1ed9t D<\/p>\n

<\/p>\n

Sau khi s\u1eeda ta\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau (\u00e1p d\u1ee5ng cho c\u1ea3 2 c\u1ed9t K v\u00e0 L)<\/p>\n

<\/p>\n

\n

Xem th\u00eam: T\u00e0i li\u1ec7u\u00a0h\u1ecdc Excel c\u01a1 b\u1ea3n 2007<\/a><\/p>\n<\/blockquote>\n

B\u01b0\u1edbc 4: B\u1ecf ch\u1ebf\u00a0\u0111\u1ed9 l\u1ecdc, copy to\u00e0n b\u1ed9 k\u1ebft qu\u1ea3\u00a0\u1edf c\u1ed9t K v\u00e0 c\u1ed9t L, paste gi\u00e1 tr\u1ecb (Paste special \u2013 Value) sang c\u1ed9t d\u1eef li\u1ec7u g\u1ed1c<\/p>\n

<\/p>\n

Sau khi paste value xong,\u00a0\u0111\u1ecbnh d\u1ea1ng l\u1ea1i d\u1eef li\u1ec7u\u00a0\u1edf c\u1ed9t D v\u00e0 E d\u1ea1ng\u00a0dd\/mm\/yyyy<\/p>\n

<\/p>\n

B\u01b0\u1edbc 5: V\u00ec d\u1eef li\u1ec7u c\u00f3 2 c\u1ed9t Ng\u00e0y v\u00e0o v\u00e0 Ng\u00e0y ra, n\u00ean c\u1ea7n ki\u1ec3m tra th\u00eam 1 quy \u01b0\u1edbc n\u1eefa l\u00e0 Ng\u00e0y ra ph\u1ea3i l\u1edbn h\u01a1n ng\u00e0y v\u00e0o. Ta l\u1ea5y Ng\u00e0y ra \u2013 Ng\u00e0y v\u00e0o \u0111\u1ec3 ki\u1ec3m tra<\/p>\n

<\/p>\n

V\u1edbi nh\u1eefng gi\u00e1 tr\u1ecb c\u00f3 k\u1ebft qu\u1ea3 <0, s\u1eeda tay tr\u1ef1c ti\u1ebfp v\u00e0o\u00a0\u00f4 Ng\u00e0y ra (do d\u1eef li\u1ec7u ng\u00e0y\u00a0\u1edf\u00a0\u0111\u00e2y khi tr\u00edch xu\u1ea5t ra\u00a0excel b\u1ecb hi\u1ec3u l\u00e0 d\u1ea1ng mm\/dd\/yyyy ch\u1ee9 kh\u00f4ng ph\u1ea3i\u00a0dd\/mm\/yyyy<\/p>\n

Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh xong thao t\u00e1c x\u1eed l\u00fd d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng trong\u00a0excel.<\/p>\n

C\u1ea3m\u00a0\u01a1n c\u00e1c b\u1ea1n\u00a0\u0111\u00e3 theo d\u00f5i.<\/p>\n

\n

T\u00ecm hi\u1ec3u th\u00eam kh\u00f3a ho\u0323c Excel k\u1ebf to\u00e1n b\u00e1n h\u00e0ng<\/a><\/p>\n

Xem th\u00eam: C\u00e1ch \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong Excel<\/a> c\u1ef1c chu\u1ea9n<\/strong><\/p>\n<\/blockquote>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n

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


\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6032,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6031","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\/6031","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=6031"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6031\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6032"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}