{"id":18170,"date":"2026-04-17T15:07:51","date_gmt":"2026-04-17T08:07:51","guid":{"rendered":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/?p=18170"},"modified":"2026-05-28T12:05:43","modified_gmt":"2026-05-28T05:05:43","slug":"ham-date-trong-excel","status":"publish","type":"post","link":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/goc-ky-nang\/ham-date-trong-excel","title":{"rendered":"H\u00e0m DATE trong Excel: C\u00fa ph\u00e1p, v\u00ed d\u1ee5 th\u1ef1c t\u1ebf v\u00e0 c\u00e1ch k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m ng\u00e0y"},"content":{"rendered":"\n

Khi x\u1eed l\u00fd d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng trong Excel, h\u00e0m DATE<\/strong> l\u00e0 c\u00f4ng c\u1ee5 n\u1ec1n t\u1ea3ng gi\u00fap t\u1ea1o ng\u00e0y t\u1eeb c\u00e1c gi\u00e1 tr\u1ecb n\u0103m, th\u00e1ng, ng\u00e0y ri\u00eang l\u1ebb, tr\u00e1nh l\u1ed7i \u0111\u1ecbnh d\u1ea1ng ph\u1ed5 bi\u1ebfn khi nh\u1eadp li\u1ec7u th\u1ee7 c\u00f4ng. B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn c\u00fa ph\u00e1p, v\u00ed d\u1ee5 \u00e1p d\u1ee5ng v\u00e0 c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m DATE v\u1edbi YEAR, MONTH, DAY, EDATE \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c b\u00e0i to\u00e1n ng\u00e0y th\u00e1ng trong k\u1ebf to\u00e1n, nh\u00e2n s\u1ef1 v\u00e0 qu\u1ea3n l\u00fd d\u1ef1 \u00e1n.<\/p>\n\n\n\n

\"H\u00e0m
H\u00e0m DATE trong Excel<\/figcaption><\/figure>\n\n\n\n
\n

T\u1ed5ng quan nhanh v\u1ec1 h\u00e0m DATE<\/strong><\/p>\n

<\/p>\n

\u2013 Ch\u1ee9c n\u0103ng: t\u1ea1o m\u1ed9t gi\u00e1 tr\u1ecb ng\u00e0y t\u1eeb 3 tham s\u1ed1: n\u0103m, th\u00e1ng, ng\u00e0y.<\/p>\n

<\/p>\n

\u2013 C\u00fa ph\u00e1p: =DATE(year, month, day)<\/p>\n

<\/p>\n

\u2013 K\u1ebft qu\u1ea3: m\u1ed9t serial number \u0111\u1ea1i di\u1ec7n cho ng\u00e0y, Excel t\u1ef1 hi\u1ec3n th\u1ecb theo format ng\u00e0y.<\/p>\n

<\/p>\n

\u2013 Ph\u1ea1m vi: n\u0103m 1900\u20139999, th\u00e1ng 1\u201312, ng\u00e0y 1\u201331 (t\u1ef1 \u0111i\u1ec1u ch\u1ec9nh n\u1ebfu v\u01b0\u1ee3t qu\u00e1).<\/p>\n<\/div>\n\n\n\n

1. C\u00fa ph\u00e1p h\u00e0m DATE trong Excel<\/h2>\n\n\n\n

C\u00fa ph\u00e1p: `=DATE(year, month, day)` trong \u0111\u00f3:<\/p>\n\n\n\n

\u2013 `year`: s\u1ed1 nguy\u00ean t\u1eeb 1900 \u0111\u1ebfn 9999 (n\u1ebfu nh\u1eadp 0\u201329, Excel hi\u1ec3u 2000\u20132029; 30\u201399 hi\u1ec3u 1930\u20131999).<\/p>\n\n\n\n

\u2013 `month`: s\u1ed1 nguy\u00ean 1\u201312 (n\u1ebfu >12, Excel t\u1ef1 c\u1ed9ng n\u0103m; n\u1ebfu <1, Excel tr\u1eeb ng\u01b0\u1ee3c).<\/p>\n\n\n\n

\u2013 `day`: s\u1ed1 nguy\u00ean 1\u201331 (n\u1ebfu >31, Excel t\u1ef1 c\u1ed9ng th\u00e1ng; n\u1ebfu <1, Excel tr\u1eeb ng\u01b0\u1ee3c).<\/p>\n\n\n\n

V\u00ed d\u1ee5: `=DATE(2026, 4, 17)` tr\u1ea3 v\u1ec1 ng\u00e0y 17\/04\/2026. `=DATE(2026, 13, 1)` tr\u1ea3 v\u1ec1 01\/01\/2027 (th\u00e1ng 13 = th\u00e1ng 1 n\u0103m sau). T\u00ednh n\u0103ng t\u1ef1 \u0111i\u1ec1u ch\u1ec9nh n\u00e0y r\u1ea5t h\u1eefu \u00edch khi t\u00ednh ng\u00e0y t\u01b0\u01a1ng lai b\u1eb1ng ph\u00e9p c\u1ed9ng th\u00e1ng.<\/p>\n\n\n\n

\n

\u201cH\u00e0m DATE t\u01b0\u1edfng \u0111\u01a1n gi\u1ea3n nh\u01b0ng ch\u00ednh l\u00e0 n\u1ec1n t\u1ea3ng c\u1ee7a m\u1ecdi ph\u00e9p t\u00ednh ng\u00e0y th\u00e1ng trong Excel. Thi\u1ebfu DATE, b\u1ea1n d\u1ec5 g\u1eb7p l\u1ed7i v\u00f9ng mi\u1ec1n khi chia s\u1ebb file gi\u1eefa VN (dd\/mm\/yyyy) v\u00e0 M\u1ef9 (mm\/dd\/yyyy).\u201d \u2013 Chia s\u1ebb ph\u1ed5 bi\u1ebfn t\u1eeb c\u1ed9ng \u0111\u1ed3ng k\u1ebf to\u00e1n Excel Vi\u1ec7t Nam.<\/p>\n<\/blockquote>\n\n\n\n

2. V\u00ed d\u1ee5 th\u1ef1c t\u1ebf h\u00e0m DATE<\/h2>\n\n\n\n
T\u00ecnh hu\u1ed1ng<\/th>C\u00f4ng th\u1ee9c<\/th>K\u1ebft qu\u1ea3<\/th><\/tr><\/thead>
T\u1ea1o ng\u00e0y t\u1eeb 3 c\u1ed9t N\u0103m, Th\u00e1ng, Ng\u00e0y<\/td>=DATE(A2, B2, C2)<\/td>Ng\u00e0y ho\u00e0n ch\u1ec9nh, format t\u1ef1 \u0111\u1ed9ng<\/td><\/tr>
Ng\u00e0y \u0111\u1ea7u th\u00e1ng hi\u1ec7n t\u1ea1i<\/td>=DATE(YEAR(TODAY()), MONTH(TODAY()), 1)<\/td>01\/04\/2026 (v\u00ed d\u1ee5)<\/td><\/tr>
Ng\u00e0y cu\u1ed1i th\u00e1ng tr\u01b0\u1edbc<\/td>=DATE(YEAR(TODAY()), MONTH(TODAY()), 0)<\/td>31\/03\/2026 (ng\u00e0y 0 = cu\u1ed1i th\u00e1ng tr\u01b0\u1edbc)<\/td><\/tr>
C\u1ed9ng 6 th\u00e1ng t\u1eeb ng\u00e0y k\u00fd H\u0110<\/td>=DATE(YEAR(A2), MONTH(A2)+6, DAY(A2))<\/td>Ng\u00e0y h\u1ebft h\u1ea1n H\u0110 sau 6 th\u00e1ng<\/td><\/tr>
T\u00ednh tu\u1ed5i nh\u00e2n vi\u00ean<\/td>=DATEDIF(A2, TODAY(), \u201cY\u201d)<\/td>S\u1ed1 n\u0103m tu\u1ed5i tr\u00f2n (k\u1ebft h\u1ee3p DATE gi\u00e1n ti\u1ebfp)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u1ee8ng d\u1ee5ng trong k\u1ebf to\u00e1n v\u00e0 nh\u00e2n s\u1ef1<\/h3>\n\n\n\n

\u2013 K\u1ebf to\u00e1n<\/strong>: t\u1ea1o ng\u00e0y ch\u1ed1t s\u1ed5 cu\u1ed1i th\u00e1ng, ng\u00e0y ph\u00e1t h\u00e0nh h\u00f3a \u0111\u01a1n, ng\u00e0y \u0111\u00e1o h\u1ea1n kho\u1ea3n vay.<\/p>\n\n\n\n

\u2013 Nh\u00e2n s\u1ef1<\/strong>: t\u00ednh ng\u00e0y h\u1ebft th\u1eed vi\u1ec7c (ng\u00e0y k\u00fd + 2 th\u00e1ng), ng\u00e0y ngh\u1ec9 ph\u00e9p t\u00edch l\u0169y, ng\u00e0y sinh nh\u1eadt nh\u00e2n vi\u00ean trong th\u00e1ng.<\/p>\n\n\n\n

\u2013 Qu\u1ea3n l\u00fd d\u1ef1 \u00e1n<\/strong>: t\u1ea1o timeline d\u1ef1 \u00e1n b\u1eb1ng c\u00e1ch c\u1ed9ng ng\u00e0y\/th\u00e1ng t\u1eeb m\u1ed1c kh\u1edfi \u0111\u1ed9ng.<\/p>\n\n\n\n

3. K\u1ebft h\u1ee3p h\u00e0m DATE v\u1edbi c\u00e1c h\u00e0m ng\u00e0y kh\u00e1c<\/h2>\n\n\n\n
\n

L\u01b0u \u00fd quan tr\u1ecdng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y<\/strong><\/p>\n

<\/p>\n

\u2013 Excel l\u01b0u ng\u00e0y d\u01b0\u1edbi d\u1ea1ng serial number (1 = 01\/01\/1900). Khi so s\u00e1nh ng\u00e0y, lu\u00f4n d\u00f9ng h\u00e0m DATE thay v\u00ec nh\u1eadp text \u201c17\/04\/2026\u201d \u0111\u1ec3 tr\u00e1nh l\u1ed7i v\u00f9ng mi\u1ec1n.<\/p>\n

<\/p>\n

\u2013 Thay \u0111\u1ed5i format hi\u1ec3n th\u1ecb ng\u00e0y: Right click \u2192 Format Cells \u2192 Date \u2192 ch\u1ecdn dd\/mm\/yyyy (Vi\u1ec7t Nam).<\/p>\n

<\/p>\n

\u2013 Khi import CSV c\u00f3 ng\u00e0y, ki\u1ec3m tra c\u1ed9t ng\u00e0y c\u00f3 format Date th\u1eadt (kh\u00f4ng ph\u1ea3i Text) \u2013 n\u1ebfu sai, d\u00f9ng DATE(LEFT, MID, RIGHT) \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i.<\/p>\n<\/div>\n\n\n\n

DATE + YEAR\/MONTH\/DAY<\/strong>: t\u00e1ch ng\u00e0y th\u00e0nh 3 ph\u1ea7n r\u1ed3i \u0111i\u1ec1u ch\u1ec9nh. V\u00ed d\u1ee5 thay \u0111\u1ed5i n\u0103m: `=DATE(2027, MONTH(A2), DAY(A2))` gi\u1eef nguy\u00ean th\u00e1ng\/ng\u00e0y, \u0111\u1ed5i n\u0103m sang 2027.<\/p>\n\n\n\n

DATE + EDATE<\/strong>: h\u00e0m EDATE c\u1ed9ng\/tr\u1eeb th\u00e1ng ch\u00ednh x\u00e1c h\u01a1n DATE khi c\u00f3 th\u00e1ng 28\/29\/30\/31 ng\u00e0y. `=EDATE(A2, 3)` c\u1ed9ng 3 th\u00e1ng t\u1eeb A2 m\u00e0 kh\u00f4ng lo tr\u00e0n ng\u00e0y (v\u00ed d\u1ee5 31\/01 + 1 th\u00e1ng = 28\/02, kh\u00f4ng ph\u1ea3i 03\/03).<\/p>\n\n\n\n

DATE + EOMONTH<\/strong>: t\u00ecm ng\u00e0y cu\u1ed1i th\u00e1ng sau n th\u00e1ng. `=EOMONTH(A2, 2)` tr\u1ea3 ng\u00e0y cu\u1ed1i th\u00e1ng sau 2 th\u00e1ng \u2013 r\u1ea5t h\u1eefu \u00edch cho k\u1ebf to\u00e1n ch\u1ed1t s\u1ed5.<\/p>\n\n\n\n

DATE + NETWORKDAYS<\/strong>: t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c gi\u1eefa hai m\u1ed1c, lo\u1ea1i tr\u1eeb T7\/CN v\u00e0 ng\u00e0y l\u1ec5.<\/p>\n\n\n\n

N\u1ebfu b\u1ea1n mu\u1ed1n luy\u1ec7n th\u00eam c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n kh\u00e1c, c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c h\u00e0m trong Excel th\u00f4ng d\u1ee5ng d\u00e0nh cho nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng<\/a>. N\u1ebfu \u0111ang t\u00ecm c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n \u2013 h\u00e0nh ch\u00ednh \u0111\u00f2i h\u1ecfi Excel, xem chuy\u00ean m\u1ee5c vi\u1ec7c l\u00e0m k\u1ebf to\u00e1n \u2013 ki\u1ec3m to\u00e1n<\/a>.<\/p>\n\n\n\n

\n

L\u1eddi khuy\u00ean khi l\u00e0m vi\u1ec7c v\u1edbi ng\u00e0y th\u00e1ng trong Excel<\/strong><\/p>\n

<\/p>\n

\u2013 Lu\u00f4n d\u00f9ng h\u00e0m DATE thay v\u00ec g\u00f5 tr\u1ef1c ti\u1ebfp \u201c17\/04\/2026\u201d \u2013 tr\u00e1nh l\u1ed7i khi chia s\u1ebb file gi\u1eefa c\u00e1c m\u00e1y kh\u00e1c v\u00f9ng mi\u1ec1n.<\/p>\n

<\/p>\n

\u2013 Ki\u1ec3m tra format c\u1ed9t ng\u00e0y b\u1eb1ng c\u00e1ch nh\u00ecn thanh Formula Bar: n\u1ebfu hi\u1ec7n 46121 (serial number) th\u00ec \u0111\u00fang, n\u1ebfu hi\u1ec7n text th\u00ec c\u1ea7n chuy\u1ec3n \u0111\u1ed5i.<\/p>\n

<\/p>\n

\u2013 V\u1edbi file CSV import, d\u00f9ng Text to Columns \u2192 Date (DMY) \u0111\u1ec3 chuy\u1ec3n c\u1ed9t text sang ng\u00e0y \u0111\u00fang.<\/p>\n<\/div>\n\n\n\n

4. \u1ee8ng d\u1ee5ng h\u00e0m DATE trong k\u1ebf to\u00e1n v\u00e0 nh\u00e2n s\u1ef1<\/h2>\n\n\n\n\n\n

T\u00ednh ng\u00e0y h\u1ebft h\u1ea1n h\u1ee3p \u0111\u1ed3ng lao \u0111\u1ed9ng<\/h3>\n\n\n\n

Theo B\u1ed9 lu\u1eadt Lao \u0111\u1ed9ng 2019, h\u1ee3p \u0111\u1ed3ng lao \u0111\u1ed9ng x\u00e1c \u0111\u1ecbnh th\u1eddi h\u1ea1n t\u1ed1i \u0111a 36 th\u00e1ng. \u0110\u1ec3 t\u00ednh ng\u00e0y h\u1ebft h\u1ea1n t\u1eeb ng\u00e0y k\u00fd, d\u00f9ng: `=EDATE(A2, 36)` ho\u1eb7c `=DATE(YEAR(A2), MONTH(A2)+36, DAY(A2))`. Hai c\u00f4ng th\u1ee9c cho k\u1ebft qu\u1ea3 g\u1ea7n gi\u1ed1ng nhau, nh\u01b0ng EDATE x\u1eed l\u00fd t\u1ed1t h\u01a1n khi ng\u00e0y k\u00fd l\u00e0 cu\u1ed1i th\u00e1ng (v\u00ed d\u1ee5 31\/01 + 1 th\u00e1ng = 28\/02 thay v\u00ec l\u1ed7i). Ph\u00f2ng nh\u00e2n s\u1ef1 n\u00ean d\u00f9ng EDATE cho ch\u00ednh x\u00e1c.<\/p>\n\n\n\n

\u1ee8ng d\u1ee5ng m\u1edf r\u1ed9ng: t\u1ea1o c\u1ed9t c\u1ea3nh b\u00e1o \u201cs\u1eafp h\u1ebft h\u1ea1n\u201d b\u1eb1ng Conditional Formatting: t\u00f4 v\u00e0ng n\u1ebfu ng\u00e0y h\u1ebft h\u1ea1n trong 30 ng\u00e0y t\u1edbi, t\u00f4 \u0111\u1ecf n\u1ebfu \u0111\u00e3 h\u1ebft h\u1ea1n. C\u00f4ng th\u1ee9c: `=AND(EDATE(A2,36)>=TODAY(), EDATE(A2,36)<=TODAY()+30)` cho \u0111i\u1ec1u ki\u1ec7n \u201cs\u1eafp h\u1ebft h\u1ea1n\u201d.<\/p>\n\n\n\n

T\u00ednh ng\u00e0y ch\u1ed1t s\u1ed5 k\u1ebf to\u00e1n cu\u1ed1i th\u00e1ng<\/h3>\n\n\n\n

K\u1ebf to\u00e1n c\u1ea7n bi\u1ebft ng\u00e0y cu\u1ed1i m\u1ed7i th\u00e1ng \u0111\u1ec3 ch\u1ed1t s\u1ed5. H\u00e0m EOMONTH k\u1ebft h\u1ee3p DATE gi\u00fap t\u1ef1 \u0111\u1ed9ng h\u00f3a: `=EOMONTH(DATE(2026, B2, 1), 0)` \u2013 trong \u0111\u00f3 B2 l\u00e0 s\u1ed1 th\u00e1ng (1\u201312). K\u1ebft qu\u1ea3: ng\u00e0y cu\u1ed1i th\u00e1ng t\u01b0\u01a1ng \u1ee9ng (31\/01, 28\/02, 31\/03\u2026). \u0110\u00e2y l\u00e0 c\u00e1ch t\u1ea1o l\u1ecbch ch\u1ed1t s\u1ed5 t\u1ef1 \u0111\u1ed9ng cho c\u1ea3 12 th\u00e1ng m\u00e0 kh\u00f4ng c\u1ea7n nh\u1edb th\u00e1ng n\u00e0o 28, 30 hay 31 ng\u00e0y.<\/p>\n\n\n\n

T\u1ea1o b\u1ea3ng timeline d\u1ef1 \u00e1n t\u1ef1 \u0111\u1ed9ng<\/h3>\n\n\n\n

Trong qu\u1ea3n l\u00fd d\u1ef1 \u00e1n, h\u00e0m DATE gi\u00fap t\u1ea1o timeline t\u1ef1 \u0111\u1ed9ng: m\u1ed1c b\u1eaft \u0111\u1ea7u + s\u1ed1 ng\u00e0y\/tu\u1ea7n\/th\u00e1ng cho m\u1ed7i giai \u0111o\u1ea1n. V\u00ed d\u1ee5: `=DATE(YEAR($A$2), MONTH($A$2)+C3, DAY($A$2))` \u2013 trong \u0111\u00f3 A2 l\u00e0 ng\u00e0y kh\u1edfi \u0111\u1ed9ng, C3 l\u00e0 s\u1ed1 th\u00e1ng offset. K\u1ebft h\u1ee3p v\u1edbi Gantt chart (bar chart ngang), b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o dashboard qu\u1ea3n l\u00fd ti\u1ebfn \u0111\u1ed9 d\u1ef1 \u00e1n ngay trong Excel m\u00e0 kh\u00f4ng c\u1ea7n MS Project.<\/p>\n\n\n\n

X\u1eed l\u00fd l\u1ed7i ng\u00e0y th\u00e1ng ph\u1ed5 bi\u1ebfn<\/h3>\n\n\n\n

L\u1ed7i ng\u00e0y th\u00e1ng l\u00e0 m\u1ed9t trong nh\u1eefng v\u1ea5n \u0111\u1ec1 hay g\u1eb7p nh\u1ea5t khi chia s\u1ebb file Excel gi\u1eefa c\u00e1c m\u00e1y t\u00ednh c\u00f3 c\u00e0i \u0111\u1eb7t v\u00f9ng mi\u1ec1n kh\u00e1c nhau. M\u00e1y c\u00e0i ti\u1ebfng Vi\u1ec7t hi\u1ec3u \u201c01\/04\/2026\u201d l\u00e0 ng\u00e0y 1 th\u00e1ng 4, nh\u01b0ng m\u00e1y c\u00e0i ti\u1ebfng M\u1ef9 hi\u1ec3u l\u00e0 th\u00e1ng 1 ng\u00e0y 4. Gi\u1ea3i ph\u00e1p: lu\u00f4n d\u00f9ng h\u00e0m DATE \u0111\u1ec3 t\u1ea1o ng\u00e0y thay v\u00ec g\u00f5 tr\u1ef1c ti\u1ebfp text. Khi import CSV, d\u00f9ng Text to Columns \u2192 ch\u1ecdn Date format DMY (Day-Month-Year) cho file Vi\u1ec7t Nam.<\/p>\n\n\n\n

M\u1ed9t l\u1ed7i ph\u1ed5 bi\u1ebfn kh\u00e1c: \u00f4 hi\u1ec3n th\u1ecb s\u1ed1 serial (v\u00ed d\u1ee5 46121) thay v\u00ec ng\u00e0y. Nguy\u00ean nh\u00e2n: \u00f4 ch\u01b0a format Date. C\u00e1ch fix: Right click \u2192 Format Cells \u2192 Number \u2192 Date \u2192 ch\u1ecdn ki\u1ec3u dd\/mm\/yyyy. N\u1ebfu \u00f4 \u0111\u00e3 format Date m\u00e0 v\u1eabn hi\u1ec7n s\u1ed1, th\u1eed nh\u1eadp l\u1ea1i b\u1eb1ng h\u00e0m DATE.<\/p>\n\n\n\n

B\u1ea3ng so s\u00e1nh c\u00e1c h\u00e0m ng\u00e0y ph\u1ed5 bi\u1ebfn<\/h3>\n\n\n\n
H\u00e0m<\/th>Ch\u1ee9c n\u0103ng<\/th>V\u00ed d\u1ee5<\/th><\/tr><\/thead>
DATE<\/td>T\u1ea1o ng\u00e0y t\u1eeb n\u0103m, th\u00e1ng, ng\u00e0y<\/td>=DATE(2026,4,17)<\/td><\/tr>
EDATE<\/td>C\u1ed9ng\/tr\u1eeb th\u00e1ng ch\u00ednh x\u00e1c<\/td>=EDATE(A2, 3)<\/td><\/tr>
EOMONTH<\/td>Ng\u00e0y cu\u1ed1i th\u00e1ng sau n th\u00e1ng<\/td>=EOMONTH(A2, 0)<\/td><\/tr>
DATEDIF<\/td>T\u00ednh kho\u1ea3ng c\u00e1ch ng\u00e0y\/th\u00e1ng\/n\u0103m<\/td>=DATEDIF(A2,TODAY(),\u201dY\u201d)<\/td><\/tr>
NETWORKDAYS<\/td>S\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c (tr\u1eeb T7\/CN)<\/td>=NETWORKDAYS(A2,B2)<\/td><\/tr>
DATEVALUE<\/td>Chuy\u1ec3n text sang ng\u00e0y<\/td>=DATEVALUE(\u201c17\/04\/2026\u201d)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n

M\u1eb9o chuy\u00ean gia v\u1edbi h\u00e0m DATE<\/strong><\/p>\n

<\/p>\n

\u2013 Mu\u1ed1n l\u1ea5y ng\u00e0y \u0111\u1ea7u th\u00e1ng hi\u1ec7n t\u1ea1i: =DATE(YEAR(TODAY()), MONTH(TODAY()), 1).<\/p>\n

<\/p>\n

\u2013 Mu\u1ed1n l\u1ea5y ng\u00e0y cu\u1ed1i th\u00e1ng tr\u01b0\u1edbc: =DATE(YEAR(TODAY()), MONTH(TODAY()), 0).<\/p>\n

<\/p>\n

\u2013 Mu\u1ed1n c\u1ed9ng 90 ng\u00e0y: =A2+90 (Excel t\u1ef1 hi\u1ec3u khi \u00f4 A2 l\u00e0 Date).<\/p>\n

<\/p>\n

\u2013 Mu\u1ed1n t\u00ednh tu\u1ed5i ch\u00ednh x\u00e1c: =DATEDIF(ng\u00e0y_sinh, TODAY(), \u201cY\u201d) & \u201d tu\u1ed5i \u201d & DATEDIF(ng\u00e0y_sinh, TODAY(), \u201cYM\u201d) & \u201d th\u00e1ng\u201d.<\/p>\n<\/div>\n\n\n\n

T\u1ea1o l\u1ecbch t\u1ef1 \u0111\u1ed9ng b\u1eb1ng h\u00e0m DATE<\/h3>\n\n\n\n

M\u1ed9t \u1ee9ng d\u1ee5ng n\u00e2ng cao r\u1ea5t h\u1eefu \u00edch l\u00e0 t\u1ea1o l\u1ecbch th\u00e1ng t\u1ef1 \u0111\u1ed9ng trong Excel. C\u00e1ch l\u00e0m: t\u1ea1o \u00f4 nh\u1eadp th\u00e1ng v\u00e0 n\u0103m (v\u00ed d\u1ee5 B1=4, B2=2026), sau \u0111\u00f3 d\u00f9ng c\u00f4ng th\u1ee9c `=DATE(B2, B1, ROW()-2)` cho c\u00e1c \u00f4 t\u1eeb A3 tr\u1edf xu\u1ed1ng. K\u1ebft h\u1ee3p v\u1edbi TEXT \u0111\u1ec3 hi\u1ec3n th\u1ecb th\u1ee9: `=TEXT(DATE(B2,B1,ROW()-2),\u201ddddd\u201d)`. Th\u00eam Conditional Formatting t\u00f4 \u0111\u1ecf T7\/CN v\u00e0 b\u1ea1n c\u00f3 l\u1ecbch th\u00e1ng ho\u00e0n ch\u1ec9nh ch\u1ec9 b\u1eb1ng 2 c\u00f4ng th\u1ee9c.<\/p>\n\n\n\n

X\u1eed l\u00fd ng\u00e0y trong Power Query v\u00e0 Power BI<\/h3>\n\n\n\n

Khi d\u1eef li\u1ec7u chuy\u1ec3n t\u1eeb Excel sang Power Query ho\u1eb7c Power BI, ng\u00e0y th\u00e1ng th\u01b0\u1eddng b\u1ecb nh\u1ea7m format. Gi\u1ea3i ph\u00e1p: trong Power Query, sau khi import, click c\u1ed9t ng\u00e0y \u2192 Change Type \u2192 Date \u2192 ch\u1ecdn format Locale \u201cVietnamese\u201d. Trong Power BI, t\u1ea1o Date Table ri\u00eang b\u1eb1ng DAX: `DateTable = CALENDAR(DATE(2020,1,1), DATE(2030,12,31))` r\u1ed3i th\u00eam c\u00e1c c\u1ed9t Year, Month, Day, Quarter. H\u00e0m DATE trong Excel l\u00e0 n\u1ec1n t\u1ea3ng \u0111\u1ec3 hi\u1ec3u c\u00e1ch ng\u00e0y ho\u1ea1t \u0111\u1ed9ng tr\u01b0\u1edbc khi chuy\u1ec3n sang c\u00e1c c\u00f4ng c\u1ee5 BI n\u00e2ng cao.<\/p>\n\n\n\n

H\u00e0m DATE trong Google Sheets \u2013 kh\u00e1c bi\u1ec7t v\u1edbi Excel<\/h3>\n\n\n\n

Google Sheets c\u0169ng c\u00f3 h\u00e0m DATE v\u1edbi c\u00fa ph\u00e1p t\u01b0\u01a1ng t\u1ef1: `=DATE(year, month, day)`. Tuy nhi\u00ean c\u00f3 m\u1ed9t s\u1ed1 kh\u00e1c bi\u1ec7t nh\u1ecf: Google Sheets kh\u00f4ng h\u1ed7 tr\u1ee3 DATEDIF g\u1ed1c (ph\u1ea3i d\u00f9ng custom formula), EDATE y\u00eau c\u1ea7u enable add-on Analysis ToolPak, v\u00e0 format ng\u00e0y m\u1eb7c \u0111\u1ecbnh ph\u1ee5 thu\u1ed9c locale c\u1ee7a Google account (Settings \u2192 General \u2192 Locale). N\u1ebfu b\u1ea1n l\u00e0m vi\u1ec7c song song Excel v\u00e0 Google Sheets, n\u00ean th\u1ed1ng nh\u1ea5t format ng\u00e0y dd\/mm\/yyyy \u1edf c\u1ea3 hai \u0111\u1ec3 tr\u00e1nh nh\u1ea7m l\u1eabn khi copy d\u1eef li\u1ec7u.<\/p>\n\n\n\n

B\u00e0i t\u1eadp th\u1ef1c h\u00e0nh h\u00e0m DATE<\/h3>\n\n\n\n

\u0110\u1ec3 th\u00e0nh th\u1ea1o h\u00e0m DATE, h\u00e3y th\u1eed 3 b\u00e0i t\u1eadp sau tr\u00ean file Excel th\u1eadt. B\u00e0i 1: t\u1ea1o b\u1ea3ng 12 th\u00e1ng v\u1edbi ng\u00e0y \u0111\u1ea7u th\u00e1ng v\u00e0 ng\u00e0y cu\u1ed1i th\u00e1ng t\u1ef1 \u0111\u1ed9ng t\u1eeb 1 \u00f4 nh\u1eadp n\u0103m. B\u00e0i 2: t\u00ednh s\u1ed1 ng\u00e0y c\u00f2n l\u1ea1i \u0111\u1ebfn h\u1ebft h\u1ea1n h\u1ee3p \u0111\u1ed3ng cho 20 nh\u00e2n vi\u00ean, t\u00f4 \u0111\u1ecf n\u1ebfu c\u00f2n d\u01b0\u1edbi 30 ng\u00e0y. B\u00e0i 3: t\u1ea1o Gantt chart \u0111\u01a1n gi\u1ea3n cho d\u1ef1 \u00e1n 5 giai \u0111o\u1ea1n, m\u1ed7i giai \u0111o\u1ea1n c\u00f3 ng\u00e0y b\u1eaft \u0111\u1ea7u t\u00ednh t\u1ef1 \u0111\u1ed9ng t\u1eeb ng\u00e0y k\u1ebft th\u00fac giai \u0111o\u1ea1n tr\u01b0\u1edbc.<\/p>\n\n\n\n

T\u00ednh s\u1ed1 ng\u00e0y ngh\u1ec9 ph\u00e9p c\u00f2n l\u1ea1i b\u1eb1ng h\u00e0m DATE<\/h3>\n\n\n\n

Trong qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1, m\u1ed9t b\u00e0i to\u00e1n th\u01b0\u1eddng g\u1eb7p l\u00e0 t\u00ednh s\u1ed1 ng\u00e0y ngh\u1ec9 ph\u00e9p t\u00edch l\u0169y theo th\u00e2m ni\u00ean. V\u00ed d\u1ee5: m\u1ed7i th\u00e1ng l\u00e0m vi\u1ec7c \u0111\u01b0\u1ee3c 1 ng\u00e0y ph\u00e9p, t\u1ed1i \u0111a 12 ng\u00e0y\/n\u0103m. C\u00f4ng th\u1ee9c: `=MIN(12, DATEDIF(DATE(YEAR(TODAY()),1,1), TODAY(), \u201cM\u201d))` \u2013 t\u00ednh s\u1ed1 th\u00e1ng \u0111\u00e3 qua trong n\u0103m hi\u1ec7n t\u1ea1i, t\u1ed1i \u0111a 12. Tr\u1eeb \u0111i s\u1ed1 ng\u00e0y \u0111\u00e3 ngh\u1ec9 (c\u1ed9t ri\u00eang) \u2192 ra s\u1ed1 ph\u00e9p c\u00f2n l\u1ea1i. K\u1ebft h\u1ee3p Conditional Formatting t\u00f4 \u0111\u1ecf khi ph\u00e9p c\u00f2n d\u01b0\u1edbi 2 ng\u00e0y gi\u00fap HR nh\u1eafc nh\u1edf nh\u00e2n vi\u00ean ngh\u1ec9 ph\u00e9p k\u1ecbp th\u1eddi.<\/p>\n\n\n\n

H\u00e0m DATE trong b\u00e1o c\u00e1o t\u00e0i ch\u00ednh qu\u00fd<\/h3>\n\n\n\n

K\u1ebf to\u00e1n th\u01b0\u1eddng c\u1ea7n ph\u00e2n nh\u00f3m d\u1eef li\u1ec7u theo qu\u00fd. C\u00f4ng th\u1ee9c t\u1ea1o ng\u00e0y \u0111\u1ea7u qu\u00fd t\u1eeb ng\u00e0y b\u1ea5t k\u1ef3: `=DATE(YEAR(A2), INT((MONTH(A2)-1)\/3)3+1, 1)`. C\u00f4ng th\u1ee9c t\u1ea1o ng\u00e0y cu\u1ed1i qu\u00fd: `=EOMONTH(DATE(YEAR(A2), INT((MONTH(A2)-1)\/3)<\/em>3+3, 1), 0)`. Hai c\u00f4ng th\u1ee9c n\u00e0y gi\u00fap t\u1ea1o c\u1ed9t \u201cQu\u00fd\u201d t\u1ef1 \u0111\u1ed9ng trong PivotTable, ph\u1ee5c v\u1ee5 b\u00e1o c\u00e1o t\u00e0i ch\u00ednh qu\u00fd m\u00e0 kh\u00f4ng c\u1ea7n nh\u1eadp tay.<\/p>\n\n\n\n

T\u00edch h\u1ee3p h\u00e0m DATE v\u1edbi VBA Macro<\/h3>\n\n\n\n

V\u1edbi nh\u1eefng b\u00e0i to\u00e1n ng\u00e0y ph\u1ee9c t\u1ea1p (v\u00ed d\u1ee5: t\u00ednh ng\u00e0y l\u00e0m vi\u1ec7c tr\u1eeb ng\u00e0y l\u1ec5 Vi\u1ec7t Nam, t\u00ednh s\u1ed1 ng\u00e0y gi\u1eefa hai m\u1ed1c theo l\u1ecbch \u00e2m), b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft VBA Function t\u00f9y ch\u1ec9nh d\u00f9ng DATE b\u00ean trong. V\u00ed d\u1ee5 Function \u0111\u1ebfm ng\u00e0y l\u00e0m vi\u1ec7c tr\u1eeb l\u1ec5 VN: t\u1ea1o m\u1ea3ng ch\u1ee9a c\u00e1c ng\u00e0y l\u1ec5 c\u1ed1 \u0111\u1ecbnh (1\/1, 30\/4, 1\/5, 2\/9) v\u00e0 ng\u00e0y l\u1ec5 bi\u1ebfn \u0111\u1ed9ng (T\u1ebft \u00e2m l\u1ecbch), r\u1ed3i d\u00f9ng v\u00f2ng l\u1eb7p FOR t\u1eeb ng\u00e0y b\u1eaft \u0111\u1ea7u \u0111\u1ebfn ng\u00e0y k\u1ebft th\u00fac, \u0111\u1ebfm nh\u1eefng ng\u00e0y kh\u00f4ng ph\u1ea3i T7\/CN v\u00e0 kh\u00f4ng n\u1eb1m trong m\u1ea3ng l\u1ec5. \u0110\u00e2y l\u00e0 c\u00e1ch ch\u00ednh x\u00e1c nh\u1ea5t m\u00e0 NETWORKDAYS kh\u00f4ng h\u1ed7 tr\u1ee3 ho\u00e0n to\u00e0n cho ng\u00e0y l\u1ec5 Vi\u1ec7t Nam.<\/p>\n\n\n\n

H\u00e0m DATE v\u00e0 qu\u1ea3n l\u00fd deadline \u2013 tips cho project manager<\/h3>\n\n\n\n

Qu\u1ea3n l\u00fd d\u1ef1 \u00e1n th\u01b0\u1eddng c\u1ea7n t\u00ednh ng\u00e0y deadline t\u1ef1 \u0111\u1ed9ng d\u1ef1a tr\u00ean ng\u00e0y b\u1eaft \u0111\u1ea7u + s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c (kh\u00f4ng t\u00ednh T7\/CN). C\u00f4ng th\u1ee9c ch\u00ednh x\u00e1c: `=WORKDAY(A2, 30)` \u2013 c\u1ed9ng 30 ng\u00e0y l\u00e0m vi\u1ec7c t\u1eeb A2. N\u1ebfu c\u1ea7n t\u00ednh c\u1ea3 ng\u00e0y l\u1ec5 VN, t\u1ea1o b\u1ea3ng Holiday (1\/1, 30\/4, 1\/5, 2\/9, T\u1ebft 3 ng\u00e0y) r\u1ed3i d\u00f9ng `=WORKDAY(A2, 30, Holiday_Range)`. K\u1ebft h\u1ee3p v\u1edbi DATE \u0111\u1ec3 t\u1ea1o m\u1ed1c qu\u00fd: `=IF(MONTH(WORKDAY(A2,30))<=3, \u201cQ1\u201d, IF(MONTH(WORKDAY(A2,30))<=6, \u201cQ2\u201d, IF(MONTH(WORKDAY(A2,30))<=9, \u201cQ3\u201d, \u201cQ4\u201d)))`.<\/p>\n\n\n\n

M\u1ed9t m\u1eb9o n\u00e2ng cao: d\u00f9ng WORKDAY.INTL \u0111\u1ec3 t\u00f9y ch\u1ec9nh ng\u00e0y ngh\u1ec9 cu\u1ed1i tu\u1ea7n. \u1ede Vi\u1ec7t Nam, m\u1ed9t s\u1ed1 c\u00f4ng ty ngh\u1ec9 T7 bu\u1ed5i chi\u1ec1u \u2013 d\u00f9ng `=WORKDAY.INTL(A2, 30, \u201c0000010\u201d)` (ch\u1ec9 ngh\u1ec9 CN). Ho\u1eb7c c\u00e1c c\u00f4ng ty n\u01b0\u1edbc ngo\u00e0i ngh\u1ec9 T6 \u2013 T7 \u1edf Trung \u0110\u00f4ng: `=WORKDAY.INTL(A2, 30, \u201c0000110\u201d)`. H\u00e0m n\u00e0y k\u1ebft h\u1ee3p DATE t\u1ea1o b\u1ed9 c\u00f4ng c\u1ee5 m\u1ea1nh cho qu\u1ea3n l\u00fd timeline xuy\u00ean qu\u1ed1c gia.<\/p>\n\n\n\n

L\u1eddi khuy\u00ean t\u1eeb chuy\u00ean gia k\u1ebf to\u00e1n v\u1ec1 h\u00e0m DATE<\/h3>\n\n\n\n

C\u00e1c chuy\u00ean gia k\u1ebf to\u00e1n nhi\u1ec1u n\u0103m kinh nghi\u1ec7m t\u1ea1i Vi\u1ec7t Nam th\u01b0\u1eddng chia s\u1ebb r\u1eb1ng vi\u1ec7c th\u00e0nh th\u1ea1o h\u00e0m DATE v\u00e0 c\u00e1c h\u00e0m ng\u00e0y th\u00e1ng li\u00ean quan gi\u00fap ti\u1ebft ki\u1ec7m trung b\u00ecnh t\u1eeb hai \u0111\u1ebfn ba gi\u1edd m\u1ed7i tu\u1ea7n trong c\u00f4ng vi\u1ec7c b\u00e1o c\u00e1o t\u00e0i ch\u00ednh, \u0111\u1ed1i chi\u1ebfu s\u1ed1 li\u1ec7u v\u00e0 x\u1eed l\u00fd h\u1ed3 s\u01a1 nh\u00e2n s\u1ef1. \u0110\u1eb7c bi\u1ec7t trong giai \u0111o\u1ea1n cu\u1ed1i th\u00e1ng khi ph\u1ea3i ch\u1ed1t s\u1ed5 k\u1ebf to\u00e1n, vi\u1ec7c t\u1ef1 \u0111\u1ed9ng h\u00f3a ng\u00e0y ch\u1ed1t s\u1ed5, ng\u00e0y ph\u00e1t h\u00e0nh h\u00f3a \u0111\u01a1n v\u00e0 ng\u00e0y thanh to\u00e1n b\u1eb1ng c\u00f4ng th\u1ee9c gi\u00fap gi\u1ea3m \u0111\u00e1ng k\u1ec3 sai s\u00f3t so v\u1edbi nh\u1eadp tay truy\u1ec1n th\u1ed1ng.<\/p>\n\n\n\n

M\u1ed9t nguy\u00ean t\u1eafc quan tr\u1ecdng m\u00e0 nhi\u1ec1u ng\u01b0\u1eddi b\u1ecf qua l\u00e0 lu\u00f4n ki\u1ec3m tra format ng\u00e0y tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9c. N\u1ebfu \u00f4 ch\u1ee9a ng\u00e0y d\u01b0\u1edbi d\u1ea1ng text thay v\u00ec Date serial number, m\u1ecdi ph\u00e9p t\u00ednh c\u1ed9ng tr\u1eeb ng\u00e0y \u0111\u1ec1u cho k\u1ebft qu\u1ea3 sai m\u00e0 kh\u00f4ng b\u00e1o l\u1ed7i r\u00f5 r\u00e0ng, ch\u1ec9 hi\u1ec7n gi\u00e1 tr\u1ecb sai l\u1ec7ch. C\u00e1ch ki\u1ec3m tra nhanh nh\u1ea5t l\u00e0 click v\u00e0o \u00f4 v\u00e0 nh\u00ecn thanh Formula Bar, n\u1ebfu hi\u1ec7n serial number th\u00ec \u0111\u00fang, n\u1ebfu hi\u1ec7n text d\u1ea1ng ng\u00e0y th\u00ec c\u1ea7n chuy\u1ec3n \u0111\u1ed5i b\u1eb1ng h\u00e0m DATEVALUE ho\u1eb7c nh\u1eadp l\u1ea1i b\u1eb1ng h\u00e0m DATE.<\/p>\n\n\n\n

\u0110\u1ed1i v\u1edbi c\u00e1c doanh nghi\u1ec7p \u0111ang chuy\u1ec3n \u0111\u1ed5i t\u1eeb s\u1ed5 s\u00e1ch gi\u1ea5y sang qu\u1ea3n l\u00fd tr\u00ean Excel, vi\u1ec7c chu\u1ea9n h\u00f3a c\u1ed9t ng\u00e0y th\u00e1ng ngay t\u1eeb \u0111\u1ea7u l\u00e0 r\u1ea5t quan tr\u1ecdng. N\u00ean t\u1ea1o template file m\u1eabu c\u00f3 c\u00e1c c\u1ed9t ng\u00e0y \u0111\u00e3 format s\u1eb5n d\u1ea1ng Date, kh\u00f3a format b\u1eb1ng Protection \u0111\u1ec3 ng\u0103n nh\u00e2n vi\u00ean v\u00f4 t\u00ecnh \u0111\u1ed5i sang text. \u0110\u1ed3ng th\u1eddi, t\u1ea1o Data Validation cho c\u1ed9t ng\u00e0y \u0111\u1ec3 gi\u1edbi h\u1ea1n ph\u1ea1m vi nh\u1eadp li\u1ec7u h\u1ee3p l\u1ec7, v\u00ed d\u1ee5 ch\u1ec9 cho nh\u1eadp ng\u00e0y trong th\u00e1ng hi\u1ec7n t\u1ea1i \u0111\u1ec3 tr\u00e1nh nh\u1eadp nh\u1ea7m n\u0103m ho\u1eb7c th\u00e1ng tr\u01b0\u1edbc.<\/p>\n\n\n\n

T\u1ed5ng h\u1ee3p 10 c\u00f4ng th\u1ee9c DATE hay d\u00f9ng nh\u1ea5t<\/h3>\n\n\n\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 10 c\u00f4ng th\u1ee9c DATE m\u00e0 m\u1ecdi nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng n\u00ean l\u01b0u s\u1eb5n trong file template c\u00e1 nh\u00e2n \u0111\u1ec3 s\u1eed d\u1ee5ng nhanh khi c\u1ea7n.<\/p>\n\n\n\n

\u2013 Ng\u00e0y \u0111\u1ea7u th\u00e1ng hi\u1ec7n t\u1ea1i: `=DATE(YEAR(TODAY()), MONTH(TODAY()), 1)`<\/p>\n\n\n\n

\u2013 Ng\u00e0y cu\u1ed1i th\u00e1ng hi\u1ec7n t\u1ea1i: `=EOMONTH(TODAY(), 0)`<\/p>\n\n\n\n

\u2013 Ng\u00e0y cu\u1ed1i th\u00e1ng tr\u01b0\u1edbc: `=DATE(YEAR(TODAY()), MONTH(TODAY()), 0)`<\/p>\n\n\n\n

\u2013 C\u1ed9ng 6 th\u00e1ng t\u1eeb ng\u00e0y A2: `=EDATE(A2, 6)`<\/p>\n\n\n\n

\u2013 Ng\u00e0y \u0111\u1ea7u qu\u00fd hi\u1ec7n t\u1ea1i: `=DATE(YEAR(TODAY()), INT((MONTH(TODAY())-1)\/3)*3+1, 1)`<\/p>\n\n\n\n

\u2013 Ng\u00e0y cu\u1ed1i qu\u00fd hi\u1ec7n t\u1ea1i: `=EOMONTH(DATE(YEAR(TODAY()), INT((MONTH(TODAY())-1)\/3)*3+3, 1), 0)`<\/p>\n\n\n\n

\u2013 S\u1ed1 ng\u00e0y c\u00f2n l\u1ea1i trong th\u00e1ng: `=EOMONTH(TODAY(), 0) \u2013 TODAY()`<\/p>\n\n\n\n

\u2013 Tu\u1ed5i ch\u00ednh x\u00e1c t\u1eeb ng\u00e0y sinh: `=DATEDIF(A2, TODAY(), \u201cY\u201d)`<\/p>\n\n\n\n

\u2013 T\u00ean th\u1ee9 trong tu\u1ea7n: `=TEXT(A2, \u201cdddd\u201d)`<\/p>\n\n\n\n

\u2013 S\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c gi\u1eefa 2 m\u1ed1c: `=NETWORKDAYS(A2, B2)`<\/p>\n\n\n\n

M\u1ed7i c\u00f4ng th\u1ee9c \u0111\u1ec1u d\u1ef1a tr\u00ean h\u00e0m DATE ho\u1eb7c c\u00e1c h\u00e0m li\u00ean quan. Khi \u0111\u00e3 thu\u1ed9c 10 c\u00f4ng th\u1ee9c n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 x\u1eed l\u00fd 90% b\u00e0i to\u00e1n ng\u00e0y th\u00e1ng g\u1eb7p trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y m\u00e0 kh\u00f4ng c\u1ea7n tra Google. H\u00e3y t\u1ea1o 1 sheet ri\u00eang t\u00ean \u201cCheat Sheet DATE\u201d v\u00e0 l\u01b0u c\u00e1c c\u00f4ng th\u1ee9c n\u00e0y c\u00f9ng v\u00ed d\u1ee5 \u2013 \u0111\u00e2y l\u00e0 t\u00e0i li\u1ec7u tham kh\u1ea3o nhanh h\u1eefu \u00edch cho c\u1ea3 \u0111\u1ed9i.<\/p>\n\n\n\n

Vai tr\u00f2 h\u00e0m DATE trong ph\u00e2n t\u00edch d\u1eef li\u1ec7u hi\u1ec7n \u0111\u1ea1i<\/h3>\n\n\n\n

Trong b\u1ed1i c\u1ea3nh doanh nghi\u1ec7p Vi\u1ec7t Nam ng\u00e0y c\u00e0ng chuy\u1ec3n sang ph\u00e2n t\u00edch d\u1eef li\u1ec7u (data-driven decision making), h\u00e0m DATE \u0111\u00f3ng vai tr\u00f2 n\u1ec1n t\u1ea3ng kh\u00f4ng ch\u1ec9 trong Excel m\u00e0 c\u00f2n trong t\u01b0 duy x\u1eed l\u00fd d\u1eef li\u1ec7u th\u1eddi gian n\u00f3i chung. Khi b\u1ea1n hi\u1ec3u c\u00e1ch DATE ho\u1ea1t \u0111\u1ed9ng trong Excel, vi\u1ec7c chuy\u1ec3n sang c\u00e1c c\u00f4ng c\u1ee5 n\u00e2ng cao h\u01a1n nh\u01b0 Power Query, Power BI, SQL ho\u1eb7c Python pandas tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n v\u00ec logic x\u1eed l\u00fd ng\u00e0y th\u00e1ng l\u00e0 t\u01b0\u01a1ng t\u1ef1: t\u1ea1o ng\u00e0y t\u1eeb c\u00e1c th\u00e0nh ph\u1ea7n, c\u1ed9ng tr\u1eeb kho\u1ea3ng th\u1eddi gian, so s\u00e1nh v\u00e0 nh\u00f3m theo chu k\u1ef3.<\/p>\n\n\n\n

Nhi\u1ec1u doanh nghi\u1ec7p v\u1eeba v\u00e0 nh\u1ecf t\u1ea1i Vi\u1ec7t Nam v\u1eabn s\u1eed d\u1ee5ng Excel l\u00e0m c\u00f4ng c\u1ee5 b\u00e1o c\u00e1o ch\u00ednh, n\u00ean vi\u1ec7c th\u00e0nh th\u1ea1o h\u00e0m DATE v\u00e0 c\u00e1c h\u00e0m ng\u00e0y li\u00ean quan l\u00e0 k\u1ef9 n\u0103ng c\u00f3 gi\u00e1 tr\u1ecb th\u1ef1c t\u1ebf cao tr\u00ean th\u1ecb tr\u01b0\u1eddng lao \u0111\u1ed9ng. Theo kh\u1ea3o s\u00e1t c\u00e1c tin tuy\u1ec3n d\u1ee5ng tr\u00ean c\u00e1c n\u1ec1n t\u1ea3ng vi\u1ec7c l\u00e0m, k\u1ef9 n\u0103ng Excel n\u1eb1m trong top ba y\u00eau c\u1ea7u ph\u1ed5 bi\u1ebfn nh\u1ea5t cho v\u1ecb tr\u00ed k\u1ebf to\u00e1n, nh\u00e2n s\u1ef1, h\u00e0nh ch\u00ednh v\u00e0 ph\u00e2n t\u00edch kinh doanh. Trong \u0111\u00f3, x\u1eed l\u00fd ng\u00e0y th\u00e1ng l\u00e0 ph\u1ea7n m\u00e0 nhi\u1ec1u \u1ee9ng vi\u00ean hay m\u1eafc l\u1ed7i nh\u1ea5t khi l\u00e0m b\u00e0i test \u0111\u1ea7u v\u00e0o.<\/p>\n\n\n\n

N\u1ebfu b\u1ea1n mu\u1ed1n n\u00e2ng cao k\u1ef9 n\u0103ng x\u1eed l\u00fd ng\u00e0y th\u00e1ng trong Excel, h\u00e3y b\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch th\u1ef1c h\u00e0nh 15 ph\u00fat m\u1ed7i ng\u00e0y v\u1edbi d\u1eef li\u1ec7u th\u1eadt t\u1eeb c\u00f4ng vi\u1ec7c hi\u1ec7n t\u1ea1i. T\u1ea1o m\u1ed9t file luy\u1ec7n t\u1eadp ri\u00eang, th\u1eed c\u00e1c c\u00f4ng th\u1ee9c t\u1eeb b\u00e0i vi\u1ebft n\u00e0y v\u00e0 ghi ch\u00fa l\u1ea1i nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p. Sau hai tu\u1ea7n th\u1ef1c h\u00e0nh \u0111\u1ec1u \u0111\u1eb7n, b\u1ea1n s\u1ebd c\u1ea3m th\u1ea5y t\u1ef1 tin h\u01a1n \u0111\u00e1ng k\u1ec3 khi x\u1eed l\u00fd b\u1ea5t k\u1ef3 b\u00e0i to\u00e1n ng\u00e0y th\u00e1ng n\u00e0o trong Excel.<\/p>\n\n\n\n

5. Th\u1ecb tr\u01b0\u1eddng ngh\u1ec1 Excel & h\u00e0m DATE cho HC \u2013 k\u1ebf to\u00e1n tr\u00ean CareerLink (Th\u00e1ng 5\/2026)<\/h2>\n\n\n\n

Theo d\u1eef li\u1ec7u c\u1eadp nh\u1eadt tr\u00ean CareerLink th\u00e1ng 5\/2026, h\u00e0m DATE v\u00e0 c\u00e1c h\u00e0m x\u1eed l\u00fd ng\u00e0y th\u00e1ng (DATEDIF, EDATE, NETWORKDAYS) l\u00e0 k\u1ef9 n\u0103ng b\u1eaft bu\u1ed9c v\u1edbi v\u1ecb tr\u00ed th\u01b0 k\u00fd, h\u00e0nh ch\u00ednh, k\u1ebf to\u00e1n<\/strong>. H\u1ec7 th\u1ed1ng ghi nh\u1eadn kho\u1ea3ng 400\u2013550 tin Th\u01b0 k\u00fd \u2013 H\u00e0nh ch\u00e1nh + 600+ tin K\u1ebf to\u00e1n \u2013 Ki\u1ec3m to\u00e1n<\/strong>, h\u01a1n 80% JD y\u00eau c\u1ea7u Excel v\u1edbi h\u00e0m ng\u00e0y th\u00e1ng \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng, ng\u00e0y l\u00e0m vi\u1ec7c, h\u1ee3p \u0111\u1ed3ng v\u00e0 l\u1ecbch d\u1ef1 \u00e1n.<\/p>\n\n\n\n

\n

T\u1ed5ng quan d\u1eef li\u1ec7u ngh\u1ec1 Excel & h\u00e0m DATE (CareerLink, T5\/2026)<\/strong><\/p>\n

\u2013 S\u1ed1 tin Th\u01b0 k\u00fd \u2013 HC: 400\u2013550 tin.<\/p>\n

\u2013 S\u1ed1 tin K\u1ebf to\u00e1n: 600+ tin (K\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, k\u1ebf to\u00e1n t\u1ed5ng h\u1ee3p).<\/p>\n

\u2013 M\u1ee9c l\u01b0\u01a1ng k\u1ebf to\u00e1n + HC: 9\u201325 tri\u1ec7u\/th\u00e1ng (junior 9\u201313, senior 18\u201332).<\/p>\n

\u2013 H\u00e0m Excel ng\u00e0y th\u00e1ng \u01b0u ti\u00ean: DATE, DATEDIF, EDATE, NETWORKDAYS, EOMONTH, WORKDAY.<\/p>\n<\/div>\n\n\n

H\u00e0m DATE gi\u00fap t\u1ea1o ng\u00e0y t\u1eeb n\u0103m\/th\u00e1ng\/ng\u00e0y, k\u1ebft h\u1ee3p v\u1edbi DATEDIF t\u00ednh s\u1ed1 n\u0103m c\u00f4ng t\u00e1c, EDATE t\u00ednh ng\u00e0y \u0111\u00e1o h\u1ea1n h\u1ee3p \u0111\u1ed3ng, NETWORKDAYS t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c th\u1ef1c t\u1ebf (lo\u1ea1i tr\u1eeb th\u1ee9 b\u1ea3y, ch\u1ee7 nh\u1eadt, ng\u00e0y l\u1ec5). Theo B\u1ed9 lu\u1eadt Lao \u0111\u1ed9ng 45\/2019\/QH14 (\u0110i\u1ec1u 105\u2013115), k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng ph\u1ea3i t\u00ednh ch\u00ednh x\u00e1c gi\u1edd c\u00f4ng, ng\u00e0y l\u00e0m vi\u1ec7c, ng\u00e0y ph\u00e9p \u2013 sai s\u1ed1 d\u1ec5 d\u1eabn t\u1edbi khi\u1ebfu n\u1ea1i lao \u0111\u1ed9ng v\u00e0 x\u1eed ph\u1ea1t h\u00e0nh ch\u00ednh theo Ngh\u1ecb \u0111\u1ecbnh 12\/2022\/N\u0110-CP. Tools: Microsoft Excel 365, MISA, FAST Accounting, MOS Excel Specialist\/Expert.<\/p>\n\n\n\n\n\n\n
Vai tr\u00f2<\/th>\nM\u1ee9c l\u01b0\u01a1ng<\/th>\nY\u00eau c\u1ea7u h\u00e0m DATE<\/th>\nTool\/Ch\u1ee9ng ch\u1ec9<\/th>\n<\/tr>\n<\/thead>\n
H\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1<\/td>10\u201318 tri\u1ec7u\/th\u00e1ng<\/td>DATEDIF (th\u00e2m ni\u00ean), EDATE (\u0111\u00e1o h\u1ea1n H\u0110L\u0110)<\/td>MOS Excel, SAP HR<\/td><\/tr>\n
K\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng<\/td>11\u201320 tri\u1ec7u\/th\u00e1ng<\/td>NETWORKDAYS, WORKDAY<\/td>MISA, FAST, MOS<\/td><\/tr>\n
K\u1ebf to\u00e1n t\u1ed5ng h\u1ee3p<\/td>12\u201322 tri\u1ec7u\/th\u00e1ng<\/td>EOMONTH (cu\u1ed1i k\u1ef3), DATE<\/td>MISA, IFRS c\u01a1 b\u1ea3n<\/td><\/tr>\n
Tr\u1ee3 l\u00fd \/ Office Manager<\/td>15\u201332 tri\u1ec7u\/th\u00e1ng<\/td>Power Query v\u1edbi DATE, dashboard<\/td>MOS Expert, Power BI<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n\n

B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c v\u1ecb tr\u00ed \u0111ang tuy\u1ec3n t\u1ea1i chuy\u00ean m\u1ee5c vi\u1ec7c l\u00e0m th\u01b0 k\u00fd \u2013 h\u00e0nh ch\u00e1nh<\/a> \u0111\u1ec3 h\u00ecnh dung r\u00f5 h\u01a1n JD, m\u1ee9c l\u01b0\u01a1ng v\u00e0 y\u00eau c\u1ea7u Excel h\u00e0m ng\u00e0y th\u00e1ng cho t\u1eebng vai tr\u00f2.<\/p>\n\n\n

\n

L\u1eddi khuy\u00ean cho ng\u01b0\u1eddi l\u00e0m HC \u2013 k\u1ebf to\u00e1n mu\u1ed1n th\u00e0nh th\u1ea1o h\u00e0m DATE<\/strong><\/p>\n

\u2013 Luy\u1ec7n 5 c\u1eb7p h\u00e0m DATE ph\u1ed5 bi\u1ebfn: DATE+DATEDIF (th\u00e2m ni\u00ean), DATE+EDATE (\u0111\u00e1o h\u1ea1n), DATE+NETWORKDAYS (ng\u00e0y c\u00f4ng), DATE+EOMONTH (cu\u1ed1i k\u1ef3), DATE+TODAY (so s\u00e1nh hi\u1ec7n t\u1ea1i).<\/p>\n

\u2013 C\u1eadp nh\u1eadt danh m\u1ee5c ng\u00e0y l\u1ec5 Vi\u1ec7t Nam v\u00e0o file Excel theo Ngh\u1ecb \u0111\u1ecbnh 145\/2020\/N\u0110-CP \u2013 sai s\u00f3t ng\u00e0y l\u1ec5 l\u00e0 l\u1ed7i ph\u1ed5 bi\u1ebfn khi t\u00ednh l\u01b0\u01a1ng v\u00e0 d\u1ec5 b\u1ecb thanh tra S\u1edf L\u0110TBXH ph\u00e1t hi\u1ec7n.<\/p>\n

\u2013 L\u1ea5y ch\u1ee9ng ch\u1ec9 MOS Excel Specialist (240 USD) ho\u1eb7c Expert (340 USD) trong v\u00f2ng 6 th\u00e1ng \u2013 \u0111\u00e2y l\u00e0 minh ch\u1ee9ng k\u1ef9 n\u0103ng \u0111\u01b0\u1ee3c Microsoft c\u00f4ng nh\u1eadn to\u00e0n c\u1ea7u, \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi \u1ee9ng tuy\u1ec3n doanh nghi\u1ec7p FDI.<\/p>\n<\/div>\n\n\n\n

6. C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 h\u00e0m DATE<\/h2>\n\n\n\n

1. H\u00e0m DATE kh\u00e1c g\u00ec h\u00e0m DATEVALUE?<\/em><\/strong><\/p>\n\n\n\n

DATE t\u1ea1o ng\u00e0y t\u1eeb 3 s\u1ed1 (n\u0103m, th\u00e1ng, ng\u00e0y). DATEVALUE chuy\u1ec3n chu\u1ed7i text \u201c17\/04\/2026\u201d sang serial number ng\u00e0y. D\u00f9ng DATE khi c\u00f3 3 c\u1ed9t ri\u00eang, d\u00f9ng DATEVALUE khi c\u00f3 1 c\u1ed9t ch\u1ee9a ng\u00e0y d\u01b0\u1edbi d\u1ea1ng text.<\/p>\n\n\n\n

2. T\u1ea1i sao h\u00e0m DATE tr\u1ea3 v\u1ec1 s\u1ed1 46121 thay v\u00ec ng\u00e0y?<\/em><\/strong><\/p>\n\n\n\n

Do \u00f4 ch\u01b0a \u0111\u01b0\u1ee3c format d\u1ea1ng Date. Right click \u2192 Format Cells \u2192 Number \u2192 Date \u2192 ch\u1ecdn ki\u1ec3u hi\u1ec3n th\u1ecb dd\/mm\/yyyy. Serial number 46121 t\u01b0\u01a1ng \u1ee9ng 17\/04\/2026 \u2013 Excel v\u1eabn nh\u1eadn \u0111\u00fang, ch\u1ec9 l\u00e0 hi\u1ec3n th\u1ecb sai.<\/p>\n\n\n\n

3. H\u00e0m DATE c\u00f3 h\u1ed7 tr\u1ee3 n\u0103m \u00e2m l\u1ecbch kh\u00f4ng?<\/em><\/strong><\/p>\n\n\n\n

Kh\u00f4ng. H\u00e0m DATE ch\u1ec9 l\u00e0m vi\u1ec7c v\u1edbi l\u1ecbch Gregorian (d\u01b0\u01a1ng l\u1ecbch). Mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i \u00e2m l\u1ecbch, c\u1ea7n d\u00f9ng add-in ho\u1eb7c b\u1ea3ng tra chuy\u1ec3n \u0111\u1ed5i ri\u00eang, kh\u00f4ng c\u00f3 h\u00e0m t\u00edch h\u1ee3p s\u1eb5n.<\/p>\n\n\n\n

H\u00e0m DATE trong Excel<\/strong> l\u00e0 n\u1ec1n t\u1ea3ng cho m\u1ecdi ph\u00e9p t\u00ednh ng\u00e0y th\u00e1ng: t\u1eeb t\u1ea1o ng\u00e0y, c\u1ed9ng tr\u1eeb th\u00e1ng, t\u00ecm ng\u00e0y cu\u1ed1i th\u00e1ng \u0111\u1ebfn t\u00ednh tu\u1ed5i nh\u00e2n vi\u00ean. Khi k\u1ebft h\u1ee3p v\u1edbi YEAR, MONTH, DAY, EDATE, EOMONTH, b\u1ea1n c\u00f3 b\u1ed9 c\u00f4ng c\u1ee5 \u0111\u1ee7 m\u1ea1nh cho c\u00e1c b\u00e0i to\u00e1n k\u1ebf to\u00e1n, nh\u00e2n s\u1ef1 v\u00e0 qu\u1ea3n l\u00fd d\u1ef1 \u00e1n. H\u00e3y luy\u1ec7n t\u1eadp tr\u00ean d\u1eef li\u1ec7u th\u1eadt v\u00e0 lu\u00f4n d\u00f9ng DATE thay v\u00ec nh\u1eadp text ng\u00e0y th\u00e1ng \u2013 \u0111\u00e2y l\u00e0 th\u00f3i quen nh\u1ecf nh\u01b0ng gi\u00fap tr\u00e1nh nhi\u1ec1u l\u1ed7i l\u1edbn.<\/p>\n\n\n\n

Minh An<\/strong><\/p>\n\n\n\n

B\u00e0i vi\u1ebft mang t\u00ednh tham kh\u1ea3o, giao di\u1ec7n v\u00e0 ch\u1ee9c n\u0103ng h\u00e0m c\u00f3 th\u1ec3 kh\u00e1c nhau t\u00f9y phi\u00ean b\u1ea3n Excel v\u00e0 ng\u00f4n ng\u1eef c\u00e0i \u0111\u1eb7t tr\u00ean m\u00e1y t\u00ednh.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

T\u00ecm hi\u1ec3u h\u00e0m DATE trong Excel v\u1edbi c\u00fa ph\u00e1p, v\u00ed d\u1ee5 minh h\u1ecda v\u00e0 c\u00e1ch k\u1ebft h\u1ee3p YEAR, MONTH, DAY, EDATE. Xem ngay h\u01b0\u1edbng d\u1eabn chi ti\u1ebft d\u00e0nh cho k\u1ebf to\u00e1n v\u00e0 HR.<\/p>\n","protected":false},"author":58,"featured_media":18263,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-18170","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-goc-ky-nang"],"_links":{"self":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/18170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/users\/58"}],"replies":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/comments?post=18170"}],"version-history":[{"count":24,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/18170\/revisions"}],"predecessor-version":[{"id":19542,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/18170\/revisions\/19542"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/media\/18263"}],"wp:attachment":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/media?parent=18170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/categories?post=18170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/tags?post=18170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}