{"id":896,"date":"2024-12-02T03:01:50","date_gmt":"2024-12-02T03:01:50","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/1-cong-thuc-ra-1-bang-lich-trong-excel-365\/"},"modified":"2024-12-02T03:01:50","modified_gmt":"2024-12-02T03:01:50","slug":"1-cong-thuc-ra-1-bang-lich-trong-excel-365","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/1-cong-thuc-ra-1-bang-lich-trong-excel-365\/","title":{"rendered":"1 c\u00f4ng th\u1ee9c ra 1 b\u1ea3ng l\u1ecbch trong Excel 365"},"content":{"rendered":"
\n

Tr\u01b0\u1edbc \u0111\u00e2y, H\u1ecdc Excel Online \u0111\u00e3 t\u1eebng c\u00f3 m\u1ed9t b\u00e0i vi\u1ebft v\u1ec1 m\u1ed9t c\u00f4ng th\u1ee9c google sheets \u0111\u1ec3 t\u1ea1o ra m\u1ed9t b\u1ea3ng l\u1ecbch<\/strong><\/a>. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch t\u1ea1o ra m\u1ed9t l\u1ecbch trong phi\u00ean b\u1ea3n Excel 365 ch\u1ec9 v\u1edbi duy nh\u1ea5t m\u1ed9t c\u00f4ng th\u1ee9c nh\u00e9.<\/p>\n

T\u1ea1o b\u1ea3ng l\u1ecbch trong Excel 365 ch\u1ec9 v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c<\/h3>\n

C\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng t\u1ea1i:<\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n

\u0110\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c, \u0111\u1ea7u ti\u00ean ta c\u1ea7n chuy\u1ec3n d\u1ea5u ng\u0103n c\u00e1ch trong c\u00f4ng th\u1ee9c v\u1ec1 d\u1ea5u ph\u1ea9y (,) trong tr\u01b0\u1eddng h\u1ee3p m\u00e1y t\u00ednh c\u1ee7a c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng d\u1ea5u ch\u1ea5m ph\u1ea9y \u0111\u1ec3 ng\u0103n c\u00e1ch. C\u00e1ch chuy\u1ec3n b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o trong\u00a0b\u00e0i vi\u1ebft n\u00e0y<\/a>.<\/strong><\/p>\n

Ti\u1ebfp \u0111\u00f3, ta thi\u1ebft l\u1eadp n\u0103m t\u1ea1i \u00f4 A1. Ch\u1eb3ng h\u1ea1n nh\u01b0 2020.<\/p>\n

Cu\u1ed1i c\u00f9ng, copy to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c v\u00e0 paste v\u00e0o 1 \u00f4 b\u1ea5t k\u1ef3 (ch\u1eb3ng h\u1ea1n A3) v\u00e0 \u1ea5n Enter. Thu h\u1eb9p kho\u1ea3ng c\u00e1ch c\u00e1c c\u1ed9t \u0111\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c th\u00e0nh qu\u1ea3.<\/p>\n

\"lich-trong-Excel-365\"<\/p>\n

\u00a0<\/p>\n

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

M\u1ed9t c\u00f4ng th\u1ee9c kh\u00e1c ng\u1eafn h\u01a1n \u0111\u01b0\u1ee3c b\u1ed5 sung t\u1eeb anh Nguy\u1ec5n (D.Nguyen):<\/strong><\/em><\/p>\n

\n
=LET(x,ROW(1:13)-1,y,COLUMN(A1:AQ1),IF(x=0,IF(y=1,\"\",TEXT(\"1\/1\/2018\"+y-2,\"DDD\")),IF(y=1,TEXT(DATE(A1,x,y),\"mmmm\"),TEXT(WORKDAY.INTL(DATE($A$1,x,1)+1,-1,\"1111110\")-2+y,\"[<\"&DATE($A$1,x,1)&\"]\"\"\"\";[>\"&DATE($A$1,x+1,0)&\"]\"\"\"\";DD\"))))<\/pre>\n<\/blockquote>\n
\n
\u0110\u1ecdc th\u00eam c\u00e1c b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 v\u1ec1 l\u1ecbch:<\/p>\n
1 c\u00f4ng th\u1ee9c ra 1 l\u1ecbch trong Google Sheets<\/strong><\/a><\/p>\n
L\u1ecbch v\u1ea1n ni\u00ean trong Excel<\/strong><\/a><\/p>\n
L\u1ecbch v\u1ea1n ni\u00ean trong Excel KH\u00d4NG VBA, ADD-IN<\/strong><\/a><\/p>\n
L\u01b0u tr\u1eef trong Outlook<\/strong><\/a><\/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
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":897,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-896","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\/896","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=896"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/896\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/897"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=896"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}