{"id":4895,"date":"2025-11-19T18:19:17","date_gmt":"2025-11-19T11:19:17","guid":{"rendered":"https:\/\/autofillform.com\/blog\/ham-networkdays-trong-excel-va-huong-dan-cach-dung\/"},"modified":"2025-11-19T18:19:17","modified_gmt":"2025-11-19T11:19:17","slug":"ham-networkdays-trong-excel-va-huong-dan-cach-dung","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/ham-networkdays-trong-excel-va-huong-dan-cach-dung\/","title":{"rendered":"H\u00e0m NETWORKDAYS trong Excel v\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng"},"content":{"rendered":"
\n

Khi c\u1ea7n x\u00e1c \u0111\u1ecbnh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c th\u1ef1c t\u1ebf trong m\u1ed9t kho\u1ea3ng th\u1eddi gian, h\u00e0m NETWORKDAYS trong Excel l\u00e0 l\u1ef1a ch\u1ecdn gi\u00fap b\u1ea1n t\u00ednh to\u00e1n nhanh v\u00e0 h\u1ea1n ch\u1ebf sai s\u00f3t. H\u00e0m t\u1ef1 \u0111\u1ed9ng tr\u1eeb \u0111i ng\u00e0y cu\u1ed1i tu\u1ea7n v\u00e0 c\u00e1c d\u1ecbp ngh\u1ec9 l\u1ec5, h\u1ed7 tr\u1ee3 t\u1ed1t cho c\u00e1c c\u00f4ng vi\u1ec7c li\u00ean quan \u0111\u1ebfn ch\u1ea5m c\u00f4ng, l\u1eadp k\u1ebf ho\u1ea1ch ho\u1eb7c qu\u1ea3n l\u00fd ti\u1ebfn \u0111\u1ed9. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u00fang v\u00e0 hi\u1ec7u qu\u1ea3.<\/p>\n

\"H\u00e0mS\u1eed d\u1ee5ng h\u00e0m NETWORKDAYS trong Excel \u0111\u1ec3 t\u00ednh ng\u00e0y l\u00e0m vi\u1ec7c<\/em><\/p>\n

\n

1. H\u00e0m NETWORKDAYS trong Excel l\u00e0 g\u00ec?<\/h2>\n<\/div>\n

H\u00e0m NETWORKDAYS \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c th\u1ef1c t\u1ebf gi\u1eefa hai m\u1ed1c th\u1eddi gian, t\u1ef1 \u0111\u1ed9ng lo\u1ea1i tr\u1eeb ng\u00e0y cu\u1ed1i tu\u1ea7n v\u00e0 c\u00e1c ng\u00e0y ngh\u1ec9 L\u1ec5 \u0111\u00e3 x\u00e1c \u0111\u1ecbnh. Nh\u1edd \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng bi\u1ebft \u0111\u01b0\u1ee3c t\u1ed5ng s\u1ed1 ng\u00e0y c\u00f4ng, ph\u1ee5c v\u1ee5 cho vi\u1ec7c t\u00ednh l\u01b0\u01a1ng, ph\u00fac l\u1ee3i hay theo d\u00f5i ti\u1ebfn \u0111\u1ed9 l\u00e0m vi\u1ec7c trong m\u1ed9t kho\u1ea3ng th\u1eddi gian c\u1ee5 th\u1ec3.<\/p>\n

\n

2. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m NETWORKDAYS<\/h2>\n<\/div>\n

C\u00fa ph\u00e1p h\u00e0m NETWORKDAYS \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 sau:<\/p>\n

=NETWORKDAYS(start_date, end_date, [holidays])<\/strong><\/p>\n

Trong \u0111\u00f3:<\/p>\n

    \n
  • start_date (B\u1eaft bu\u1ed9c):<\/strong> Ng\u00e0y b\u1eaft \u0111\u1ea7u t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c.<\/li>\n
  • end_date (B\u1eaft bu\u1ed9c):<\/strong> Ng\u00e0y k\u1ebft th\u00fac kho\u1ea3ng th\u1eddi gian c\u1ea7n t\u00ednh.<\/li>\n
  • holidays (Tu\u1ef3 ch\u1ecdn):<\/strong> Danh s\u00e1ch m\u1ed9t ho\u1eb7c nhi\u1ec1u ng\u00e0y ngh\u1ec9 l\u1ec5 c\u1ea7n lo\u1ea1i tr\u1eeb kh\u1ecfi l\u1ecbch l\u00e0m vi\u1ec7c.<\/li>\n<\/ul>\n

    \"C\u00faC\u00fa ph\u00e1p c\u1ee7a h\u00e0m NETWORKDAYS trong Excel<\/em><\/p>\n

    Xem th\u00eam: <\/strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m CHAR trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng<\/div>\n
    \n

    3. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m NETWORKDAYS trong Excel<\/h2>\n<\/div>\n
    \n

    3.1 C\u00e1ch s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n<\/h3>\n<\/div>\n

    V\u00ed d\u1ee5:<\/strong> T\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c cho m\u1ed9t d\u1ef1 \u00e1n di\u1ec5n ra t\u1eeb 01\/09\/2025 \u0111\u1ebfn 30\/09\/2025, kh\u00f4ng bao g\u1ed3m ng\u00e0y ngh\u1ec9 l\u1ec5.<\/p>\n

    B\u01b0\u1edbc 1:<\/strong> Nh\u1eadp ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 ng\u00e0y k\u1ebft th\u00fac v\u00e0o c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng trong b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n

      \n
    • Ng\u00e0y b\u1eaft \u0111\u1ea7u: 01\/09\/2025<\/li>\n
    • Ng\u00e0y k\u1ebft th\u00fac: 30\/09\/2025<\/li>\n<\/ul>\n

      B\u01b0\u1edbc 2:<\/strong> T\u1ea1i \u00f4 d\u00f9ng \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, nh\u1eadp c\u00f4ng th\u1ee9c: =NETWORKDAYS(D4,E4)<\/strong><\/p>\n

      \"C\u00f4ngNh\u1eadp c\u00f4ng th\u1ee9c NETWORKDAYS kh\u00f4ng k\u00e8m ng\u00e0y l\u1ec5<\/em><\/p>\n

      B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 Excel t\u00ednh to\u00e1n. H\u00e0m s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u1ebfm s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c trong kho\u1ea3ng th\u1eddi gian tr\u00ean, lo\u1ea1i tr\u1eeb th\u1ee9 B\u1ea3y v\u00e0 Ch\u1ee7 nh\u1eadt v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 22 ng\u00e0y.<\/p>\n

      \"K\u1ebftK\u1ebft qu\u1ea3 s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c tr\u1ea3 v\u1ec1<\/em><\/p>\n

      \n

      3.2 S\u1eed d\u1ee5ng khi c\u00f3 ng\u00e0y l\u1ec5<\/h3>\n<\/div>\n

      V\u00ed d\u1ee5:<\/strong> T\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c cho m\u1ed9t d\u1ef1 \u00e1n di\u1ec5n ra t\u1eeb 01\/09\/2025 \u0111\u1ebfn 30\/09\/2025, c\u00f3 t\u00ednh ng\u00e0y ngh\u1ec9 L\u1ec5.<\/p>\n

      B\u01b0\u1edbc 1:<\/strong> C\u0169ng v\u1edbi d\u1eef li\u1ec7u c\u1ee7a v\u00ed d\u1ee5 \u1edf m\u1ee5c 3.1, h\u00e3y b\u1ed5 sung ng\u00e0y l\u1ec5 v\u00e0o m\u1ed9t \u00f4 ri\u00eang (v\u00ed d\u1ee5 \u00f4 F4 ch\u1ee9a ng\u00e0y 02\/09\/2025).<\/p>\n

      B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn \u00f4 d\u00f9ng \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c: =NETWORKDAYS(D4,E4,F4)<\/strong><\/p>\n

      \"S\u1eedNh\u1eadp c\u00f4ng th\u1ee9c NETWORKDAYS c\u00f3 ng\u00e0y L\u1ec5<\/em><\/p>\n

      B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n Enter<\/strong>. Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng tr\u1eeb ng\u00e0y l\u1ec5 ra kh\u1ecfi kho\u1ea3ng th\u1eddi gian v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 21 ng\u00e0y l\u00e0m vi\u1ec7c.<\/p>\n

      \"K\u1ebftK\u1ebft qu\u1ea3 s\u1ed1 ng\u00e0y c\u00f4ng \u0111\u00e3 tr\u1eeb ng\u00e0y l\u1ec5<\/em><\/p>\n

      \n

      3.3 K\u1ebft h\u1ee3p NETWORKDAYS v\u1edbi c\u00e1c h\u00e0m TODAY<\/h3>\n<\/div>\n

      V\u00ed d\u1ee5:<\/strong> K\u1ebft h\u1ee3p h\u00e0m NETWORKDAYS v\u1edbi h\u00e0m TODAY \u0111\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c t\u1eeb h\u00f4m nay \u0111\u1ebfn m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3.<\/p>\n

      B\u01b0\u1edbc 1:<\/strong> Nh\u1eadp c\u00fa ph\u00e1p =NETWORKDAYS(TODAY(),D9)<\/strong> v\u00e0o \u00f4 mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3<\/p>\n

      Gi\u1ea3i th\u00edch:<\/p>\n

        \n
      • TODAY():<\/strong> H\u00e0m n\u00e0y t\u1ef1 \u0111\u1ed9ng tr\u1ea3 v\u1ec1 ng\u00e0y hi\u1ec7n t\u1ea1i c\u1ee7a h\u1ec7 th\u1ed1ng, gi\u00fap b\u1ea1n t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c b\u1eaft \u0111\u1ea7u t\u1eeb \u201ch\u00f4m nay\u201d m\u00e0 kh\u00f4ng c\u1ea7n nh\u1eadp th\u1ee7 c\u00f4ng.<\/li>\n
      • D9:<\/strong> \u0110\u00e2y l\u00e0 \u00f4 ch\u1ee9a ng\u00e0y k\u1ebft th\u00fac m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh \u0111\u1ebfn.<\/li>\n<\/ul>\n

        \"NETWORKDAYSC\u00f4ng th\u1ee9c NETWORKDAYS k\u1ebft h\u1ee3p TODAY<\/em><\/p>\n

        B\u01b0\u1edbc 2:<\/strong> Sau khi nh\u1eadp h\u00e0m, nh\u1ea5n Enter<\/strong> \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3.<\/p>\n

        \"Hi\u1ec3nK\u1ebft qu\u1ea3 s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c t\u00ednh t\u1eeb ng\u00e0y hi\u1ec7n t\u1ea1i<\/em><\/p>\n

        \n

        4. L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m NETWORKDAYS<\/h2>\n<\/div>\n

        D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng gi\u00fap b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m NETWORKDAYS ch\u00ednh x\u00e1c v\u00e0 h\u1ea1n ch\u1ebf l\u1ed7i trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n:<\/p>\n

          \n
        • Excel qu\u1ea3n l\u00fd ng\u00e0y th\u00e1ng d\u01b0\u1edbi d\u1ea1ng s\u1ed1 s\u00ea-ri li\u00ean t\u1ee5c, v\u1edbi m\u1ed1c b\u1eaft \u0111\u1ea7u l\u00e0 01\/01\/1900. \u0110i\u1ec1u n\u00e0y gi\u00fap vi\u1ec7c t\u00ednh to\u00e1n ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c th\u1ed1ng nh\u1ea5t.<\/li>\n
        • H\u00e3y nh\u1eadp ng\u00e0y b\u1eb1ng h\u00e0m DATE ho\u1eb7c s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng chu\u1ea9n. N\u1ebfu nh\u1eadp ng\u00e0y d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n, Excel c\u00f3 th\u1ec3 kh\u00f4ng nh\u1eadn di\u1ec7n \u0111\u00fang v\u00e0 d\u1eabn \u0111\u1ebfn l\u1ed7i.<\/li>\n
        • Khi m\u1ed9t trong c\u00e1c \u0111\u1ed1i s\u1ed1 kh\u00f4ng ph\u1ea3i l\u00e0 ng\u00e0y h\u1ee3p l\u1ec7, h\u00e0m NETWORKDAYS s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!.<\/li>\n<\/ul>\n

          H\u00e0m NETWORKDAYS mang l\u1ea1i l\u1ee3i \u00edch r\u00f5 r\u1ec7t khi x\u1eed l\u00fd c\u00e1c m\u1ed1c th\u1eddi gian trong c\u00f4ng vi\u1ec7c. Khi \u0111\u00e3 quen v\u1edbi c\u00e1ch thi\u1ebft l\u1eadp tham s\u1ed1 v\u00e0 nh\u1eadp ng\u00e0y \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng, b\u1ea1n s\u1ebd d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng h\u00e0m n\u00e0y cho nhi\u1ec1u b\u1ea3ng t\u00ednh kh\u00e1c nhau. H\u00e3y th\u1eed th\u1ef1c h\u00e0nh tr\u1ef1c ti\u1ebfp \u0111\u1ec3 n\u1eafm ch\u1eafc c\u00e1ch v\u1eadn d\u1ee5ng trong c\u00e1c t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf.<\/p>\n

          \u0110\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u m\u1eb9o hay ph\u1ee5c v\u1ee5 c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y.<\/p>\n

          \u0110\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi Excel thu\u1eadn ti\u1ec7n h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c d\u00f2ng m\u00e1y t\u00ednh b\u1ea3ng h\u1ed7 tr\u1ee3 t\u1ed1t cho h\u1ecdc t\u1eadp v\u00e0 v\u0103n ph\u00f2ng t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

          Khi c\u1ea7n x\u00e1c \u0111\u1ecbnh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c th\u1ef1c t\u1ebf trong m\u1ed9t kho\u1ea3ng th\u1eddi gian, h\u00e0m NETWORKDAYS trong Excel l\u00e0 l\u1ef1a ch\u1ecdn gi\u00fap b\u1ea1n t\u00ednh to\u00e1n nhanh v\u00e0 h\u1ea1n ch\u1ebf sai s\u00f3t. H\u00e0m t\u1ef1 \u0111\u1ed9ng tr\u1eeb \u0111i ng\u00e0y cu\u1ed1i tu\u1ea7n v\u00e0 c\u00e1c d\u1ecbp ngh\u1ec9 l\u1ec5, h\u1ed7 tr\u1ee3 t\u1ed1t cho c\u00e1c c\u00f4ng vi\u1ec7c li\u00ean quan \u0111\u1ebfn […]<\/p>\n","protected":false},"author":1,"featured_media":4896,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4895","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19376.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4895","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=4895"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4895\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4896"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}