{"id":4866,"date":"2024-12-08T11:33:28","date_gmt":"2024-12-08T11:33:28","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-xac-dinh-tien-do-du-an-voi-ham-workday-trong-excel\/"},"modified":"2024-12-08T11:33:28","modified_gmt":"2024-12-08T11:33:28","slug":"huong-dan-cach-xac-dinh-tien-do-du-an-voi-ham-workday-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-xac-dinh-tien-do-du-an-voi-ham-workday-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u00e1c \u0111\u1ecbnh ti\u1ebfn \u0111\u1ed9 d\u1ef1 \u00e1n v\u1edbi h\u00e0m workday trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>M\u1ed9t trong nh\u1eefng y\u1ebfu t\u1ed1 quan tr\u1ecdng trong vi\u1ec7c qu\u1ea3n l\u00fd d\u1eef\u00a0\u00e1n ch\u00ednh l\u00e0 vi\u1ec7c ph\u1ea3i x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c ti\u1ebfn\u00a0\u0111\u1ed9 th\u1ef1c hi\u1ec7n c\u1ee7a m\u1ed7i ph\u1ea7n vi\u1ec7c (task) c\u1ee7a d\u1ef1\u00a0\u00e1n\u00a0\u0111\u00f3. Trong b\u00e0i vi\u1ebft n\u00e0y H\u1ecdc\u00a0Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch x\u00e1c\u00a0\u0111\u1ecbnh ti\u1ebfn\u00a0\u0111\u1ed9 d\u1ef1\u00a0\u00e1n v\u1edbi\u00a0h\u00e0m\u00a0Workday trong\u00a0Excel.\u00a0N\u1ed9i dung c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<p>V\u00ed d\u1ee5 nh\u01b0 ch\u00fang ta c\u00f3 1 d\u1ef1\u00a0\u00e1n g\u1ed3m c\u00f3 6 ph\u1ea7n vi\u1ec7c (6 task), trong\u00a0\u0111\u00f3 ch\u00fang ta\u00a0\u0111\u00e3 bi\u1ebft Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u d\u1ef1\u00a0\u00e1n v\u00e0 l\u1ecbch c\u00e1c ng\u00e0y ngh\u1ec9\u00a0nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18232\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-gantt-chart-xac-dinh-tien-do-01.png\" width=\"533\" height=\"246\" title=\"heo-gantt-chart-xac-dinh-tien-do-01\"><\/p>\n<ul>\n<li>Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u: 04\/03\/2018<\/li>\n<li>S\u1ed1 ng\u00e0y th\u1ef1c hi\u1ec7n c\u00e1c task c\u1ee5 th\u1ec3 t\u1ea1i c\u1ed9t D. Th\u1ef1c hi\u1ec7n c\u00e1c task l\u1ea7n l\u01b0\u1ee3t theo th\u1ee9 t\u1ef1<\/li>\n<li>L\u1ecbch ngh\u1ec9: ngh\u1ec9 c\u00e1c ng\u00e0y ch\u1ee7 nh\u1eadt trong th\u00e1ng v\u00e0 ngh\u1ec9 c\u00e1c ng\u00e0y 30\/04 v\u00e0 01\/05<\/li>\n<\/ul>\n<p>Y\u00eau c\u1ea7u: X\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u v\u00e0 ng\u00e0y k\u1ebft th\u00fac c\u1ee7a d\u1ef1\u00a0\u00e1n theo t\u1eebng task, trong\u00a0\u0111\u00f3\u00a0\u0111\u00e3 bao g\u1ed3m c\u00e1c ng\u00e0y ngh\u1ec9, ng\u00e0y l\u1ec5<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6755840724c26\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xac-dinh-tien-do-du-an-voi-ham-workday-trong-excel.html#1_Xac_dinh_danh_sach_ngay_nghi\" title=\"1. X\u00e1c\u00a0\u0111\u1ecbnh danh s\u00e1ch ng\u00e0y ngh\u1ec9\">1. X\u00e1c\u00a0\u0111\u1ecbnh danh s\u00e1ch ng\u00e0y ngh\u1ec9<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xac-dinh-tien-do-du-an-voi-ham-workday-trong-excel.html#2_Su_dung_ham_Workday_de_xac_dinh_Ngay_bat_dau_va_Ngay_ket_thuc_cua_tung_Task\" title=\"2. S\u1eed d\u1ee5ng h\u00e0m\u00a0Workday\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh Ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 Ng\u00e0y\u00a0k\u1ebft th\u00fac c\u1ee7a t\u1eebng Task\">2. S\u1eed d\u1ee5ng h\u00e0m\u00a0Workday\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh Ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 Ng\u00e0y\u00a0k\u1ebft th\u00fac c\u1ee7a t\u1eebng Task<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Xac_dinh_danh_sach_ngay_nghi\"><\/span>1. X\u00e1c\u00a0\u0111\u1ecbnh danh s\u00e1ch ng\u00e0y ngh\u1ec9<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ng\u00e0y ngh\u1ec9\u00a0\u1edf\u00a0\u0111\u00e2y bao g\u1ed3m:<\/p>\n<ul>\n<li>Ng\u00e0y ngh\u1ec9 tu\u1ea7n: ch\u1ec9 1 ng\u00e0y ch\u1ee7 nh\u1eadt<\/li>\n<li>Ng\u00e0y ngh\u1ec9 l\u1ec5: C\u00f3 2 ng\u00e0y: 30\/4 v\u00e0 01\/5<\/li>\n<\/ul>\n<p>Do\u00a0\u0111\u00f3 danh s\u00e1ch ng\u00e0y ngh\u1ec9 l\u1ec5 l\u00e0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18243\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-gantt-chart-xac-dinh-tien-do-ngay-le-01.png\" width=\"626\" height=\"339\" title=\"heo-gantt-chart-xac-dinh-tien-do-ngay-le-01\"><\/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-400.gif\" title=\"ex101_92019-nho-400\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"2_Su_dung_ham_Workday_de_xac_dinh_Ngay_bat_dau_va_Ngay_ket_thuc_cua_tung_Task\"><\/span>2. S\u1eed d\u1ee5ng h\u00e0m\u00a0Workday\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh Ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 Ng\u00e0y\u00a0k\u1ebft th\u00fac c\u1ee7a t\u1eebng Task<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m\u00a0Workday trong\u00a0Excel g\u1ed3m 2 h\u00e0m:<\/p>\n<ul>\n<li>WORKDAY: t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c trong 1 kho\u1ea3ng th\u1eddi gian, trong\u00a0\u0111\u00f3 ng\u00e0y ngh\u1ec9 tu\u1ea7n l\u00e0 th\u1ee9 b\u1ea3y v\u00e0 ch\u1ee7 nh\u1eadt (2 ng\u00e0y)<\/li>\n<li>WORKDAY.INTL: t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c trong 1 kho\u1ea3ng th\u1eddi gian, trong\u00a0\u0111\u00f3 c\u00f3 th\u1ec3 thay\u00a0\u0111\u1ed5i v\u1ec1 ng\u00e0y ngh\u1ec9 tu\u1ea7n.<\/li>\n<\/ul>\n<p>Do\u00a0\u0111\u00f3 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta d\u00f9ng h\u00e0m\u00a0Workday.INTL\u00a0\u0111\u1ec3 t\u00ednh:<\/p>\n<p><strong>a. C\u1ea5u tr\u00fac h\u00e0m\u00a0WORKDAY.INTL<\/strong><\/p>\n<p style=\"padding-left: 30px\">=WORKDAY.INTL(start_date, days, [weekend], [holidays])<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li><strong>start_date<\/strong>: Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u<\/li>\n<li><strong>days<\/strong>: S\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c<\/li>\n<li><strong>weekend<\/strong>: Ng\u00e0y ngh\u1ec9 cu\u1ed1i tu\u1ea7n. Ch\u1ecdn m\u00e3 s\u1ed1 quy\u00a0\u0111\u1ecbnh ng\u00e0y ngh\u1ec9 tu\u1ea7n l\u00e0 ng\u00e0y n\u00e0o<\/li>\n<li><strong>holidays<\/strong>: Ng\u00e0y ngh\u1ec9 l\u1ec5. Ch\u1ecdn danh s\u00e1ch ng\u00e0y l\u1ec5 c\u00f3 th\u1ec3\u00a0\u1ea3nh h\u01b0\u1edfng t\u1edbi t\u00ednh ng\u00e0y l\u00e0m vi\u1ec7c<\/li>\n<\/ul>\n<p><strong>b. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0WORKDAY.INTL<\/strong><\/p>\n<p>T\u1ea1i\u00a0\u00f4 E2 d\u00f9ng h\u00e0m\u00a0Workday.Intl ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18244\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-gantt-chart-xac-dinh-ngay-ket-thuc-01.png\" width=\"986\" height=\"248\" title=\"heo-gantt-chart-xac-dinh-ngay-ket-thuc-01\"><\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>Start_date: ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u l\u00e0 ng\u00e0y t\u1ea1i\u00a0\u00f4 C2<\/li>\n<li>days: S\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c l\u00e0 s\u1ed1 ng\u00e0y t\u01b0\u01a1ng\u00a0\u1ee9ng t\u1ea1i\u00a0\u00f4 D2<\/li>\n<li>weekend: S\u1ed1 11\u00a0\u0111\u01b0\u1ee3c quy\u00a0\u0111\u1ecbnh l\u00e0 <strong>Ch\u1ec9 ngh\u1ec9 ng\u00e0y ch\u1ee7 nh\u1eadt<\/strong><\/li>\n<li>holidays: l\u00e0 danh s\u00e1ch ng\u00e0y l\u1ec5\u00a0\u1edf\u00a0\u00f4 C10, C11<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 l\u00e0 ng\u00e0y 10\/3\/2018 (t\u1eeb ng\u00e0y 04\/03\u00a0\u0111\u1ebfn 10\/03 c\u00f3 7 ng\u00e0y, trong\u00a0\u0111\u00f3 ng\u00e0y 04\/03 l\u00e0 ng\u00e0y ch\u1ee7 nh\u1eadt)<\/p>\n<p><strong>c. X\u00e1c\u00a0\u0111\u1ecbnh nh\u1eefng ng\u00e0y c\u00f2n l\u1ea1i<\/strong><\/p>\n<p>Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u c\u1ee7a Task th\u1ee9 2 s\u1ebd l\u00e0 Ti\u1ebfp sau ng\u00e0y cu\u1ed1i c\u00f9ng c\u1ee7a Task th\u1ee9 1, do\u00a0\u0111\u00f3 t\u1ea1i\u00a0\u00f4 C3 nh\u1eadp c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">C3=E2+1<\/p>\n<p>Ng\u00e0y k\u1ebft th\u00fac c\u1ee7a Task th\u1ee9 2 t\u1ea1i\u00a0\u00f4 E3 s\u1ebd\u00a0\u00e1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 c\u00f4ng th\u1ee9c gi\u1ed1ng nh\u01b0 E2 =&gt; Ch\u1ec9 c\u1ea7n copy c\u00f4ng th\u1ee9c t\u1eeb E2 xu\u1ed1ng E3<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady\u00a0\u00e1p d\u1ee5ng cho c\u00e1c Task ti\u1ebfp theo\u00a0\u0111\u1ebfn h\u1ebft, ch\u00fang ta\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18247\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-gantt-chart-xac-dinh-ngay-ket-thuc-02.png\" width=\"984\" height=\"339\" title=\"heo-gantt-chart-xac-dinh-ngay-ket-thuc-02\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c ti\u1ebfn\u00a0\u0111\u1ed9 th\u1ef1c hi\u1ec7n c\u1ee7a t\u1eebng ph\u1ea7n vi\u1ec7c trong 1 d\u1ef1\u00a0\u00e1n c\u0103n c\u1ee9 v\u00e0o s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c ti\u00eau chu\u1ea9n r\u1ed3i.<\/p>\n<p>B\u00e0i ti\u1ebfp theo:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lap-bang-so-sanh-ke-hoach-voi-thuc-hien-du-an-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u1ea3ng so s\u00e1nh k\u1ebf ho\u1ea1ch v\u1edbi th\u1ef1c hi\u1ec7n d\u1ef1 \u00e1n trong Excel<\/a><\/p>\n<p>Ngo\u00e0i ra\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 n\u00e2ng cao ki\u1ebfn th\u1ee9c v\u1ec1\u00a0Excel v\u00e0\u00a0\u1ee9ng d\u1ee5ng\u00a0Excel v\u00e0o qu\u1ea3n l\u00fd d\u1ef1\u00a0\u00e1n, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham gia kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2kPf8kt\">EX101 \u2013\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a> c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc\u00a0Excel Online. Kh\u00f3a h\u1ecdc s\u1ebd gi\u00fap b\u1ea1n n\u1eafm v\u1eefng c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong Excel,\u00a0\u00a0\u1ee9ng d\u1ee5ng Conditional formatting trong vi\u1ec7c t\u1ea1o gantt chart qu\u1ea3n l\u00fd ti\u1ebfn \u0111\u1ed9 d\u1ef1 \u00e1n. Chi ti\u1ebft kh\u00f3a h\u1ecdc xem t\u1ea1i:<\/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-400.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4867,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4866","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\/4866","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=4866"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4866\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4867"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}