{"id":12145,"date":"2025-01-15T07:21:22","date_gmt":"2025-01-15T07:21:22","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-networkdays-va-cach-dung-ham-networkdays-trong-excel\/"},"modified":"2025-01-15T07:21:22","modified_gmt":"2025-01-15T07:21:22","slug":"ham-networkdays-va-cach-dung-ham-networkdays-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-networkdays-va-cach-dung-ham-networkdays-trong-excel\/","title":{"rendered":"H\u00e0m NETWORKDAYS v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m NETWORKDAYS trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><strong>H\u00e0m\u00a0NETWORKDAYS tr\u1ea3 v\u1ec1t\u1ed5ng s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c tr\u1eeb ng\u00e0y ngh\u1ec9 L\u1ec5 v\u00e0 ng\u00e0y cu\u1ed1i tu\u1ea7n. N\u00f3 l\u00e0 c\u00f4ng c\u1ee5 th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00f4ng vi\u1ec7c t\u00ednh l\u01b0\u01a1ng cho nh\u00e2n vi\u00ean m\u1ed9t t\u1ed5 ch\u1ee9c, doanh nghi\u1ec7p.<\/strong><\/em><\/p>\n<p><strong>C\u00fa ph\u00e1p: <code class=\"excel-formula-inline\">=NETWORKDAYS<\/code><\/strong><code class=\"excel-formula-inline\"><strong>(start_day, end_day, [holidays]).<\/strong><\/code><\/p>\n<p><em>Trong \u0111\u00f3<\/em><strong>:<\/strong><\/p>\n<ul>\n<li><strong>start_day: <\/strong>Ng\u00e0y b\u1eaft \u0111\u1ea7u.<\/li>\n<li><strong> end_day:<\/strong> Ng\u00e0y k\u1ebft th\u00fac.<\/li>\n<li><strong>[holidays]:<\/strong> Nh\u1eefng ng\u00e0y ngh\u1ec9.<\/li>\n<\/ul>\n<h4><strong>V\u00ed d\u1ee5<\/strong><\/h4>\n<p><strong>1<\/strong>\/ S\u1eed d\u1ee5ng h\u00e0m <strong>=NETWORKDAYS(C4;D4<\/strong>), t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c c\u1ee7a nh\u00e2n vi\u00ean.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4037 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-time-3.png\" width=\"600\" height=\"419\" title=\"ham-time-3\"><\/p>\n<p><strong>2<\/strong>\/ N\u1ebfu nh\u00e2n vi\u00ean c\u00f3 1 ng\u00e0y ngh\u1ec9 trong th\u00e1ng, d\u00f9ng c\u00f4ng th\u1ee9c:<strong>=NETWORKDAYS(C5;D5;E5)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4038 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-time-4.png\" width=\"600\" height=\"422\" title=\"ham-time-4\"><\/p>\n<p><strong>3<\/strong>\/ Gi\u1ea3 s\u1eed trong th\u00e1ng c\u00f3 2 ng\u00e0y ngh\u1ec9 L\u1ec5 th\u00ec s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c c\u1ee7a nh\u00e2n vi\u00ean \u0111\u01b0\u1ee3c t\u00ednh theo c\u00f4ng th\u1ee9c: <strong>=NETWORKDAYS(C6;D6;A9:A10)<\/strong><\/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\/2025\/01\/ex101_92019-nho-357.gif\" title=\"ex101_92019-nho-357\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4039 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-time-5.png\" width=\"600\" height=\"405\" title=\"ham-time-5\"><\/p>\n<p>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 xem th\u00eam c\u00e1c b\u00e0i c\u00f9ng ch\u1ee7 \u0111\u1ec1 kh\u00e1c nh\u01b0:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/dem-ngay-lam-khong-tinh-ngay-nghi-tuan-va-ngay-le.html\">H\u00e0m \u0111\u1ebfm s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c<\/a> kh\u00f4ng t\u00ednh ng\u00e0y ngh\u1ec9 tu\u1ea7n v\u00e0 ng\u00e0y l\u1ec5<\/strong><br \/>\n<strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-so-ngay-cong-ngay-nghi-ngay-lam-viec-trong-excel.html\">C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c<\/a>, ng\u00e0y ngh\u1ec9 trong Excel<\/strong><\/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\/2025\/01\/ex101_92019-nho-357.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12146,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12145","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\/12145","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=12145"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12145\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12146"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}