{"id":7332,"date":"2024-12-21T17:23:00","date_gmt":"2024-12-21T17:23:00","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-dem-so-ngay-thu-bay-chu-nhat-trong-mot-khoang-thoi-gian\/"},"modified":"2024-12-21T17:23:00","modified_gmt":"2024-12-21T17:23:00","slug":"huong-dan-cach-dem-so-ngay-thu-bay-chu-nhat-trong-mot-khoang-thoi-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-dem-so-ngay-thu-bay-chu-nhat-trong-mot-khoang-thoi-gian\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ebfm s\u1ed1 ng\u00e0y th\u1ee9 b\u1ea3y, ch\u1ee7 nh\u1eadt trong m\u1ed9t kho\u1ea3ng th\u1eddi gian"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u1ea1n c\u00f3 bi\u1ebft trong qu\u00fd 1 c\u1ee7a n\u0103m 2019 c\u00f3 bao nhi\u00eau ng\u00e0y th\u1ee9 b\u1ea3y, bao nhi\u00eau ng\u00e0y ch\u1ee7 nh\u1eadt kh\u00f4ng?\u00a0\u0110\u1ec3 tr\u1ea3 l\u1eddi c\u00e2u h\u1ecfi n\u00e0y c\u00f3 th\u1ec3 b\u1ea1n s\u1ebd ph\u1ea3i m\u1edf l\u1ecbch ra\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm. T\u1ea1i sao kh\u00f4ng l\u00e0m vi\u1ec7c n\u00e0y m\u1ed9t c\u00e1ch t\u1ef1\u00a0\u0111\u1ed9ng trong\u00a0Excel nh\u1ec9? H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel online t\u00ecm hi\u1ec3u c\u00f4ng th\u1ee9c\u00a0\u0111\u1ebfm s\u1ed1 ng\u00e0y th\u1ee9 b\u1ea3y, ch\u1ee7 nh\u1eadt trong m\u1ed9t kho\u1ea3ng th\u1eddi gian nh\u00e9.<\/p>\n<p>V\u00ed d\u1ee5\u00a0\u0111\u1ec3 x\u00e9t kho\u1ea3ng th\u1eddi gian t\u1eeb ng\u00e0y 01\/01\/2019\u00a0\u0111\u1ebfn ng\u00e0y 12\/01\/2019, ch\u00fang ta c\u00f3 th\u1ec3\u00a0\u0111\u1eb7t 2 gi\u00e1 tr\u1ecb ng\u00e0y v\u00e0o c\u00e1c\u00a0\u00f4 B1 v\u00e0 B2 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25111\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vi-du-dem-so-ngay-t7-cn-theo-khoang-thoi-gian-q1-nam2019.png\" width=\"288\" height=\"87\" title=\"vi-du-dem-so-ngay-t7-cn-theo-khoang-thoi-gian-q1-nam2019\"><\/p>\n<h3>D\u00f9ng h\u00e0m Netwworkdays.INTL\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm s\u1ed1 ng\u00e0y c\u00f3 trong kho\u1ea3ng th\u1eddi gian b\u1ea5t k\u1ef3<\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-so-ngay-cong-ngay-nghi-ngay-lam-viec-trong-excel.html\">H\u00e0m NETWWORKDAYS.INTL<\/a> l\u00e0 h\u00e0m d\u00f9ng\u00a0\u0111\u1ec3 t\u00ednh\u00a0s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c trong tu\u1ea7n, trong\u00a0\u0111\u00f3 lo\u1ea1i tr\u1eeb nh\u1eefng ng\u00e0y ngh\u1ec9. C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m n\u00e0y nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>Start_date l\u00e0 ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u (hay T\u1eeb ng\u00e0y)<\/li>\n<li>End_date l\u00e0 ng\u00e0y k\u1ebft th\u00fac (hay\u00a0\u0110\u1ebfn ng\u00e0y)<\/li>\n<li>Weekend: ng\u00e0y n\u00e0o l\u00e0 ng\u00e0y ngh\u1ec9, ng\u00e0y n\u00e0o l\u00e0 ng\u00e0y l\u00e0m vi\u1ec7c.<\/li>\n<li>Holidays: ng\u00e0y ngh\u1ec9 l\u1ec5 (n\u1ebfu c\u00f3) xen gi\u1eefa trong kho\u1ea3ng th\u1eddi gian T\u1eeb ng\u00e0y\u2026\u00a0\u0110\u1ebfn ng\u00e0y\u2026<\/li>\n<\/ul>\n<p>\u0110\u1ed1i t\u01b0\u1ee3ng\u00a0Weekend\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n b\u1eb1ng chu\u1ed7i 7 con s\u1ed1, trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>M\u1ed7i 1 con s\u1ed1\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n cho 1 ng\u00e0y trong tu\u1ea7n, t\u00ednh t\u1eeb th\u1ee9 2<\/li>\n<li>T\u1ea1i m\u1ed7i v\u1ecb tr\u00ed ng\u00e0y t\u01b0\u01a1ng\u00a0\u1ee9ng, n\u1ebfu ch\u1ecdn s\u1ed1 1 th\u00ec l\u00e0 Ng\u00e0y ngh\u1ec9 tu\u1ea7n, ch\u1ecdn s\u1ed1 0 l\u00e0 Ng\u00e0y l\u00e0m vi\u1ec7c<\/li>\n<\/ul>\n<p>\u0110\u1ec3\u00a0\u0111\u1ebfm s\u1ed1 ng\u00e0y th\u1ee9 7 trong kho\u1ea3ng th\u1eddi gian tr\u00ean, ta c\u00f3 th\u1ec3 coi trong tu\u1ea7n ch\u1ec9 l\u00e0m vi\u1ec7c v\u00e0o th\u1ee9 7, c\u00f2n c\u00e1c ng\u00e0y kh\u00e1c\u00a0\u0111\u1ec1u l\u00e0 ng\u00e0y ngh\u1ec9. Do\u00a0\u0111\u00f3 ta c\u00f3 chu\u1ed7i s\u1ed1 nh\u01b0 sau:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-660.gif\" title=\"ex101_92019-nho-660\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-25113\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-so-ngay-t7-trong-doan-thoi-gian-1024x138-1.png\" width=\"1024\" height=\"138\" title=\"dem-so-ngay-t7-trong-doan-thoi-gian-1024x138-1\"><\/p>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i \u00f4 B4=NETWORKDAYS.INTL($B$1,$B$2,\u201d1111101\u2033)<\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c l\u00e0 2 ng\u00e0y<\/p>\n<p>V\u1edbi ng\u00e0y ch\u1ee7 nh\u1eadt ta c\u00f3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-25114\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-so-ngay-cn-trong-doan-thoi-gian-1024x172-1.png\" width=\"1024\" height=\"172\" title=\"dem-so-ngay-cn-trong-doan-thoi-gian-1024x172-1\"><\/p>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 B5=NETWORKDAYS.INTL($B$1,$B$2,\u201d1111110\u2033)<\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c l\u00e0\u00a01 ng\u00e0y<\/p>\n<p>Nh\u01b0 v\u1eady ch\u1ec9 c\u1ea7n\u00a0\u0111\u1ed5i kho\u1ea3ng th\u1eddi gian b\u1ea5t k\u1ef3 trong\u00a0\u00f4 B1 v\u00e0 B2 l\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0\u00a0\u00fd mu\u1ed1n r\u1ed3i.<\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh cho ng\u00e0y kh\u00e1c trong tu\u1ea7n, ch\u1ec9 c\u1ea7n\u00a0\u0111\u1ed5i v\u1ecb tr\u00ed s\u1ed1 0 t\u01b0\u01a1ng\u00a0\u1ee9ng\u00a0cho ng\u00e0y\u00a0\u0111\u00f3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-25117\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vi-du-dem-so-ngay-t7-cn-theo-khoang-thoi-gian-nua-dau-nam2019-1024x171-1.png\" width=\"1024\" height=\"171\" title=\"vi-du-dem-so-ngay-t7-cn-theo-khoang-thoi-gian-nua-dau-nam2019-1024x171-1\"><\/p>\n<p style=\"text-align: center\"><em>V\u00ed d\u1ee5\u00a0\u0111\u1ebfm s\u1ed1 ng\u00e0y th\u1ee9 7 v\u00e0 s\u1ed1 ng\u00e0y ch\u1ee7 nh\u1eadt trong n\u1eeda\u00a0\u0111\u1ea7u n\u0103m 2019<\/em><\/p>\n<p>\u0110\u1ec3 t\u00ecm hi\u1ec3u th\u00eam v\u1ec1 c\u00e1c h\u00e0m x\u1eed l\u00fd th\u1eddi gian trong\u00a0Excel, m\u1eddi c\u00e1c b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1c b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html\">C\u00e1ch t\u00ednh th\u1eddi gian trong Excel \u2013 ch\u00eanh l\u1ec7ch th\u1eddi gian, c\u1ed9ng\/tr\u1eeb th\u1eddi gian<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-thoi-gian-thong-dung-trong-excel.html\">H\u00e0m th\u1eddi gian th\u00f4ng d\u1ee5ng trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html\">\u0110\u1ecbnh d\u1ea1ng th\u1eddi gian trong Excel &amp; c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m NOW v\u00e0 TIME \u0111\u1ec3 ch\u00e8n th\u1eddi gian<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tinh-khoang-thoi-gian-giua-2-thoi-diem-ham-datedif-trong-excel.html\">H\u00e0m DATEDIF, t\u00ednh kho\u1ea3ng th\u1eddi gian gi\u1eefa 2 th\u1eddi \u0111i\u1ec3m trong Excel<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-660.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7333,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7332","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\/7332","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=7332"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7332\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7333"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}