{"id":29113,"date":"2023-11-30T14:51:28","date_gmt":"2023-11-30T07:51:28","guid":{"rendered":"https:\/\/hocvienit.vn\/?p=29113"},"modified":"2024-07-01T19:23:41","modified_gmt":"2024-07-01T12:23:41","slug":"tinh-so-ngay-lam-viec-trong-khoang-thoi-gian-voi-ham-networkdays-trong-excel","status":"publish","type":"post","link":"https:\/\/hocvienit.vn\/?p=29113","title":{"rendered":"T\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c trong kho\u1ea3ng th\u1eddi gian v\u1edbi h\u00e0m NETWORKDAYS trong Excel"},"content":{"rendered":"

Trong c\u00e1c doanh nghi\u1ec7p, vi\u1ec7c t\u00ednh ng\u00e0y c\u00f4ng cho nh\u00e2n vi\u00ean l\u00e0 m\u1ed9t c\u00f4ng vi\u1ec7c quan tr\u1ecdng v\u00e0 c\u1ea7n thi\u1ebft. Tuy nhi\u00ean, n\u1ebfu t\u00ednh to\u00e1n th\u1ee7 c\u00f4ng s\u1ebd r\u1ea5t m\u1ea5t th\u1eddi gian v\u00e0 d\u1ec5 x\u1ea3y ra sai s\u00f3t. \u0110\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m NETWORKDAYS trong Excel<\/strong>.<\/span><\/p>\n

\"T\u00ednh
T\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c trong kho\u1ea3ng th\u1eddi gian v\u1edbi h\u00e0m NETWORKDAYS trong Excel<\/figcaption><\/figure>\n

Xem th\u00eam: <\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm \u00f4 c\u00f3 d\u1eef li\u1ec7u trong Excel<\/span><\/a><\/p>\n

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

H\u00e0m NETWORKDAYS l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n t\u1ed5ng s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c c\u1ee7a nh\u00e2n vi\u00ean trong m\u1ed9t kho\u1ea3ng th\u1eddi gian c\u1ee5 th\u1ec3, kh\u00f4ng bao g\u1ed3m ng\u00e0y cu\u1ed1i tu\u1ea7n v\u00e0 nh\u1eefng ng\u00e0y ngh\u1ec9 l\u1ec5 \u0111\u00e3 x\u00e1c \u0111\u1ecbnh.<\/span><\/p>\n

C\u00f4ng th\u1ee9c h\u00e0m NETWORKDAYS nh\u01b0 sau:<\/span><\/p>\n

=NETWORKDAYS(start_day; end_day; holidays)<\/strong><\/p>\n

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