{"id":5032,"date":"2024-12-09T01:49:01","date_gmt":"2024-12-09T01:49:01","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/tu-dong-dien-thoi-gian-theo-tong-so-ngay\/"},"modified":"2024-12-09T01:49:01","modified_gmt":"2024-12-09T01:49:01","slug":"tu-dong-dien-thoi-gian-theo-tong-so-ngay","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/tu-dong-dien-thoi-gian-theo-tong-so-ngay\/","title":{"rendered":"T\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n th\u1eddi gian theo t\u1ed5ng s\u1ed1 ng\u00e0y"},"content":{"rendered":"
\n

T\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n th\u1eddi gian theo t\u1ed5ng s\u1ed1 ng\u00e0y b\u1eb1ng VBA<\/strong><\/h2>\n

Ch\u00e0o c\u00e1c b\u1ea1n v\u1eeba r\u1ed3i tr\u00ean Group VBA 101<\/a> c\u00f3 b\u1ea1n Minh Dang<\/strong>\u00a0b\u1ea1n \u1ea5y c\u00f3 c\u00e2u h\u1ecfi nh\u01b0 sau : (Download file v\u00ed d\u1ee5 \u1edf cu\u1ed1i b\u00e0i vi\u1ebft)<\/p>\n

\n

Ch\u00e0o c\u1ea3 nh\u00e0!
\nM\u00ecnh c\u00f3 v\u1ea5n \u0111\u1ec1 n\u00e0y mu\u1ed1n h\u1ecfi, m\u00ecnh mu\u1ed1n t\u1ea1o 1 bi\u1ec3u \u0111\u1ed3 nh\u00e2n l\u1ef1c v\u00e0 thi\u1ebft b\u1ecb d\u1ef1a v\u00e0o \u0111\u1ecbnh m\u1ee9c, nh\u01b0ng c\u00f3 v\u1ea5n \u0111\u1ec1 ch\u1ed5 duration( kho\u1ea3ng th\u1eddi gian) c\u00f3 b\u1ea1n n\u00e0o c\u00f3 \u00fd t\u01b0\u1edfng nh\u1eadp s\u1ed1 ng\u00e0y v\u00e0 ng\u00e0y b\u1eaft \u0111\u1ea7u c\u1ea7n l\u00e0m th\u00ec t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n th\u1eddi gian theo s\u1ed1 ng\u00e0y \u0111\u00f3 kh\u00f4ng.
\nVD. CV A: ng\u00e0y b\u1eaft \u0111\u1ea7u 1\/7\/18. Th\u1eddi gian c\u1ea7n l\u00e0m l\u00e0 15 ng\u00e0y
\nTh\u00ec k\u1ebft qu\u1ea3 xu\u1ea5t ra \u1edf 1 c\u1ed9t l\u00e0 t\u1eeb c\u1ed9t C1 -> C15 l\u00e0 1\/7\/18 \u2026 14\/7\/18.
\nM\u00ecnh \u0111\u00e3 th\u1eed d\u00f9ng v\u00e0i l\u1ec7nh rows v\u00e0 counta nh\u01b0ng \u201cfomular refer own cells\u201d n\u00ean k\u1ebft qu\u1ea3 ko\u00a0ch\u00ednh x\u00e1c.
\nHi v\u1ecdng anh em gi\u00fap \u0111\u1edf<\/span><\/p>\n<\/blockquote>\n

<\/p>\n

B\u00e0i n\u00e0y x\u1eed l\u00fd ho\u00e0n to\u00e0n \u0111\u01a1n gi\u1ea3n v\u1edbi m\u1ed9t v\u00f2ng l\u1eb7p For c\u01a1 b\u1ea3n. C\u1ee5 th\u1ec3 nh\u01b0 sau :<\/p>\n<\/p>\n

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

B\u00e2y gi\u1edd ch\u1ec9 c\u1ea7n \u0111i\u1ec1n ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0o \u00f4 A1, \u0111i\u1ec1n t\u1ed5ng s\u1ed1 ng\u00e0y c\u1ea7n xu\u1ea5t ra \u1edf \u00f4 B1 r\u1ed3i ch\u1ea1y code th\u00ec \u1edf c\u1ed9t C s\u1ebd xu\u1ea5t kho\u1ea3ng th\u1eddi gian .<\/p>\n

R\u1ea5t \u0111\u01a1n gi\u1ea3n \u0111\u00fang kh\u00f4ng ? B\u1ea1n t\u1ea3i file b\u00ean d\u01b0\u1edbi nh\u00e9<\/p>\n

Ch\u00fac b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng Hocexcel.online<\/p>\n

H\u1ecdc VBA ngay \u0111\u1ec3 \u1ee9ng d\u1ee5ng trong c\u00f4ng vi\u1ec7c<\/p>\n

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