{"id":10914,"date":"2025-01-15T00:39:12","date_gmt":"2025-01-15T00:39:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-cong-thuc-su-dung-trong-ke-toan-tien-luong-nhan-su-ham-date\/"},"modified":"2025-01-15T00:39:12","modified_gmt":"2025-01-15T00:39:12","slug":"ham-cong-thuc-su-dung-trong-ke-toan-tien-luong-nhan-su-ham-date","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-cong-thuc-su-dung-trong-ke-toan-tien-luong-nhan-su-ham-date\/","title":{"rendered":"H\u00e0m, c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng trong k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, nh\u00e2n s\u1ef1: H\u00e0m DATE"},"content":{"rendered":"
\n

Nh\u1eefng h\u00e0m, c\u00f4ng th\u1ee9c Excel n\u00e0o th\u01b0\u1eddng s\u1eed d\u1ee5ng trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, h\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1? N\u1ed9i dung n\u00e0y\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c t\u1ed5ng h\u1ee3p qua b\u00e0i vi\u1ebft:\u00a0H\u00e0m, c\u00f4ng th\u1ee9c\u00a0excel s\u1eed d\u1ee5ng trong k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng.<\/p>\n

Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u1ee5 th\u1ec3 c\u00e1ch\u00a0\u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m\u00a0\u0111\u00f3 v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 th\u1ebf n\u00e0o nh\u00e9.<\/p>\n

B\u00e0i 3: H\u00e0m DATE(year, month, day)<\/strong><\/p>\n

<\/p>\n

D\u00f9ng khi b\u1ea1n mu\u1ed1n t\u1ea1o ra 1 gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng d\u1ef1a tr\u00ean c\u00e1c ch\u1ec9 ti\u00eau\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c x\u00e1c\u00a0\u0111\u1ecbnh r\u00f5: N\u0103m \/ Th\u00e1ng \/ Ng\u00e0y<\/p>\n

\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m DATE<\/a>: khi mu\u1ed1n x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y\u00a0\u0111\u1ea7u v\u00e0 ng\u00e0y cu\u1ed1i c\u1ee7a c\u00e1c th\u00e1ng trong n\u0103m.<\/em><\/strong><\/p>\n

Ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u sau:<\/p>\n

<\/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

\u0110\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y\u00a0\u0111\u1ea7u th\u00e1ng, ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m DATE nh\u01b0 sau:<\/p>\n

\n

Th\u00e1ng 1 (\u00f4 E3) =DATE($E$1,D3,1)<\/p>\n<\/blockquote>\n

Gi\u00e1 tr\u1ecb n\u0103m t\u1ea1i\u00a0\u00f4 E1 s\u1ebd c\u1ea7n\u00a0\u0111\u01b0\u1ee3c c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ec3 khi filldown c\u00f4ng th\u1ee9c n\u00e0y xu\u1ed1ng c\u00e1c th\u00e1ng ti\u1ebfp theo th\u00ec kh\u00f4ng b\u1ecb thay\u00a0\u0111\u1ed5i n\u0103m<\/p>\n

Gi\u00e1 tr\u1ecb th\u00e1ng t\u1ea1i\u00a0\u00f4 D3 kh\u00f4ng c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ec3 filldown s\u1ebd t\u00ednh cho c\u00e1c th\u00e1ng ti\u1ebfp theo trong c\u1ed9t D<\/p>\n

Gi\u00e1 tr\u1ecb ng\u00e0y l\u00e0 s\u1ed1 1 v\u00ec ng\u00e0y\u00a0\u0111\u1ea7u th\u00e1ng lu\u00f4n l\u00e0 ng\u00e0y 1<\/p>\n

<\/p>\n

Ng\u00e0y cu\u1ed1i th\u00e1ng x\u00e1c\u00a0\u0111\u1ecbnh nh\u01b0 sau:<\/p>\n

T\u1eeb th\u00e1ng 1\u00a0\u0111\u1ebfn th\u00e1ng 11: ng\u00e0y cu\u1ed1i th\u00e1ng s\u1ebd l\u00e0 ng\u00e0y\u00a0\u0111\u1ea7u th\u00e1ng sau tr\u1eeb\u00a0\u0111i 1 ng\u00e0y<\/p>\n

Ng\u00e0y cu\u1ed1i th\u00e1ng 1 = Ng\u00e0y\u00a0\u0111\u1ea7u th\u00e1ng 2 \u2013 1<\/p>\n

V\u1edbi c\u00e1ch l\u00e0m n\u00e0y ch\u00fang ta c\u00f3 th\u1ec3 kh\u00f4ng c\u1ea7n ph\u1ea3i quan t\u00e2m t\u1edbi n\u0103m nhu\u1eadn (ng\u00e0y cu\u1ed1i th\u00e1ng 2 t\u00ednh th\u1ebf n\u00e0o), m\u00e0\u00a0Excel s\u1ebd lu\u00f4n t\u1ef1 t\u00ednh ra k\u1ebft qu\u1ea3\u00a0\u0111\u00fang cho ch\u00fang ta d\u1ef1a tr\u00ean quy lu\u1eadt: Ng\u00e0y cu\u1ed1i th\u00e1ng 2 = Ng\u00e0y\u00a0\u0111\u1ea7u th\u00e1ng 3 \u2013 1<\/p>\n

<\/p>\n

Ng\u00e0y cu\u1ed1i th\u00e1ng 12: lu\u00f4n l\u00e0 ng\u00e0y 31, n\u00ean c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m DATE<\/p>\n

\n

F14 =DATE($E$1,D14,31)<\/p>\n<\/blockquote>\n

<\/p>\n

Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3\u00a0\u1ee9ng d\u1ee5ng h\u00e0m DATE trong vi\u1ec7c t\u00ecm ng\u00e0y\u00a0\u0111\u1ea7u th\u00e1ng, cu\u1ed1i th\u00e1ng trong\u00a0excel.<\/p>\n

Trong c\u00e1c b\u00e0i h\u1ecdc sau, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u th\u00eam c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m kh\u00e1c trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, h\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1 nh\u00e9.<\/p>\n

\n

\u0110\u0103ng k\u00fd ngay:\u00a0h\u1ecdc Excel k\u1ebf to\u00e1n<\/a><\/p>\n<\/blockquote>\n

\u00a0<\/p>\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":10915,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10914","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10914","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=10914"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10914\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10915"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10914"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10914"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}