{"id":1036,"date":"2024-12-02T03:56:31","date_gmt":"2024-12-02T03:56:31","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-tinh-so-ngay-cong-ngay-nghi-ngay-lam-viec-trong-excel\/"},"modified":"2024-12-02T03:56:31","modified_gmt":"2024-12-02T03:56:31","slug":"cach-tinh-so-ngay-cong-ngay-nghi-ngay-lam-viec-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-tinh-so-ngay-cong-ngay-nghi-ngay-lam-viec-trong-excel\/","title":{"rendered":"C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y c\u00f4ng, ng\u00e0y ngh\u1ec9, ng\u00e0y l\u00e0m vi\u1ec7c trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>[toggle title=\u201dH\u00f4m nay, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 c\u00e2u chuy\u1ec7n c\u1ed5 t\u00edch sau nh\u00e9:\u201d]<\/p>\n<blockquote>\n<p>Ng\u00e0y x\u1eeda ng\u00e0y x\u01b0a, gi\u1eefa m\u00f9a \u0111\u00f4ng tuy\u1ebft r\u01a1i tr\u1eafng nh\u01b0 b\u00f4ng, m\u1ed9t b\u00e0 ho\u00e0ng h\u1eadu ng\u1ed3i kh\u00e2u b\u00ean c\u1eeda s\u1ed5. B\u00e0 m\u1ea3i nh\u00ecn tuy\u1ebft n\u00ean kim \u0111\u00e2m ph\u1ea3i tay, ba gi\u1ecdt m\u00e1u r\u01a1i xu\u1ed1ng tuy\u1ebft. Th\u1ea5y m\u00e1u \u0111\u1ecf v\u1edbi tuy\u1ebft tr\u1eafng th\u00e0nh m\u1ed9t m\u00e0u tuy\u1ec7t \u0111\u1eb9p, b\u00e0 ngh\u0129 b\u1ee5ng:<i>\u201c\u01af\u1edbc g\u00ec ta <strong>sinh\u00a0\u0111\u01b0\u1ee3c m\u1ed9t ng\u01b0\u1eddi con g\u00e1i<\/strong>, <strong>da tr\u1eafng nh\u01b0 tuy\u1ebft<\/strong>, <strong>m\u00f4i \u0111\u1ecf nh\u01b0 m\u00e1u,<\/strong> v\u00e0 <strong>t\u00f3c \u0111en nh\u01b0 g\u1ed7 khung c\u1eeda n\u00e0y<\/strong>\u201c<\/i>.<\/p>\n<p>Sau \u0111\u00f3 \u00edt l\u00e2u, b\u00e0 sinh \u0111\u01b0\u1ee3c m\u1ed9t ng\u01b0\u1eddi con g\u00e1i nh\u01b0 mong \u01b0\u1edbc; v\u00ec v\u1eady b\u00e0 \u0111\u1eb7t t\u00ean con l\u00e0 <strong>WORKDAY<\/strong>.\u00a0<strong>WORKDAY\u00a0<\/strong>v\u1eeba ra \u0111\u1eddi th\u00ec m\u1eb9 ch\u1ebft.\u00a0M\u1ed9t n\u0103m sau, vua \u0111i l\u1ea5y v\u1ee3 kh\u00e1c. B\u00e0 <strong>HOLIDAYS<\/strong> \u0111\u1eb9p l\u1eafm nh\u01b0ng ki\u00eau c\u0103ng t\u1ef1 ph\u1ee5, kh\u00f4ng mu\u1ed1n ai \u0111\u1eb9p b\u1eb1ng m\u00ecnh. B\u00e0 c\u00f3 m\u1ed9t c\u00e1i g\u01b0\u01a1ng th\u1ea7n, m\u1ed7i khi soi, b\u00e0 h\u1ecfi:<\/p>\n<dl>\n<dd><em>G\u01b0\u01a1ng kia ng\u1ef1 \u1edf tr\u00ean t\u01b0\u1eddng,<\/em><\/dd>\n<dd><em>N\u01b0\u1edbc ta ai \u0111\u1eb9p \u0111\u01b0\u1ee3c d\u01b0\u1eddng nh\u01b0 ta?<\/em><\/dd>\n<\/dl>\n<p>Th\u00ec g\u01b0\u01a1ng \u0111\u00e1p: \u2013 T\u00e2u l\u1ec7nh b\u00e0, b\u00e0 l\u00e0 ng\u01b0\u1eddi \u0111\u1eb9p nh\u1ea5t n\u01b0\u1edbc \u1ea1.<\/p>\n<p>Bi\u1ebft g\u01b0\u01a1ng n\u00f3i th\u1eadt, b\u00e0 r\u1ea5t sung s\u01b0\u1edbng. Nh\u01b0ng\u00a0<strong>WORKDAY.INTL<\/strong> c\u00e0ng l\u1edbn c\u00e0ng \u0111\u1eb9p. C\u00f4 \u0111\u1eb9p nh\u01b0 ti\u00ean sa, \u0111\u1eb9p h\u01a1n c\u1ea3 ho\u00e0ng h\u1eadu. M\u1ed9t h\u00f4m ho\u00e0ng h\u1eadu l\u1ea1i h\u1ecfi g\u01b0\u01a1ng, th\u00ec g\u01b0\u01a1ng \u0111\u00e1p:<\/p>\n<dl>\n<dd><em>X\u01b0a kia b\u00e0 \u0111\u1eb9p nh\u1ea5t tr\u1ea7n,<\/em><\/dd>\n<dd><em>Ng\u00e0y nay\u00a0<strong>WORKDAY.INTL<\/strong> mu\u00f4n ph\u1ea7n \u0111\u1eb9p h\u01a1n.<\/em><\/dd>\n<\/dl>\n<p>Ho\u00e0ng h\u1eadu nghe n\u00f3i gi\u1eadt m\u00ecnh, ghen t\u1ee9c t\u00e1i m\u1eb7t \u0111i. Ng\u00e0y m\u1ed9t th\u00eam ki\u00eau ng\u1ea1o v\u00e0 \u0111\u1ed1 k\u1ef5. M\u1ee5 cho g\u1ecdi m\u1ed9t ng\u01b0\u1eddi \u0111i s\u0103n \u0111\u1ec3 sai b\u1ea3o, \u0111\u01b0a n\u00e0ng <strong>WORKDAY.INTL<\/strong>\u00a0v\u00e0o r\u1eebng v\u00e0 s\u00e1t h\u1ea1i. Ng\u01b0\u1eddi th\u1ee3 s\u0103n v\u00e2ng l\u1ec7nh, \u0111em c\u00f4 b\u00e9 \u0111i. Khi b\u00e1c l\u1ea5y dao ra \u0111\u1ec3 gi\u1ebft th\u00ec c\u00f4 b\u00e9 v\u00f4 t\u1ed9i van kh\u00f3c:\u00a0<i>\u201cB\u00e1c \u01a1i, b\u00e1c \u0111\u1eebng gi\u1ebft ch\u00e1u, ch\u00e1u xin \u1edf l\u1ea1i trong r\u1eebng kh\u00f4ng v\u1ec1 nh\u00e0 n\u1eefa\u201d<\/i>.<\/p>\n<p>B\u00e1c th\u1ee3 s\u0103n x\u00f3t th\u01b0\u01a1ng n\u00ean th\u1ea3 n\u00e0ng \u0111i, c\u00f4 c\u1eafm \u0111\u1ea7u ch\u1ea1y, gi\u1eabm ph\u1ea3i gai v\u00e0 \u0111\u00e1 nh\u1ecdn, ch\u1ea3y c\u1ea3 m\u00e1u ch\u00e2n. Th\u00fa d\u1eef l\u01b0\u1ee3n quanh c\u00f4, nh\u01b0ng kh\u00f4ng \u0111\u1ee5ng ch\u1ea1m \u0111\u1ebfn c\u00f4. C\u00f4 \u0111i m\u1ecfi c\u1ea3 ch\u00e2n, ch\u1eadp t\u1ed1i, th\u1ea5y m\u1ed9t c\u00e1i nh\u00e0 nh\u1ecf, li\u1ec1n v\u00e0o \u0111\u1ec3 ngh\u1ec9.<\/p>\n<p>Trong nh\u00e0, c\u00e1i g\u00ec c\u0169ng b\u00e9 t\u00ed ti, nh\u01b0ng \u0111\u1eb9p v\u00e0 s\u1ea1ch l\u1eafm. Tr\u00ean b\u00e0n tr\u1ea3i kh\u0103n tr\u1eafng tinh c\u00f3 b\u1ea3y c\u00e1i \u0111\u0129a con. S\u00e1t t\u01b0\u1eddng k\u00ea b\u1ea3y chi\u1ebfc gi\u01b0\u1eddng nh\u1ecf ph\u1ee7 kh\u0103n tr\u1eafng nh\u01b0 tuy\u1ebft. C\u00f4 m\u1ec7t qu\u00e1, mu\u1ed1n \u0111i ng\u1ee7, nh\u01b0ng kh\u00f4ng c\u00f3 gi\u01b0\u1eddng n\u00e0o n\u1eb1m v\u1eeba, c\u00e1i th\u00ec d\u00e0i qu\u00e1, c\u00e1i l\u1ea1i ng\u1eafn qu\u00e1. C\u00f4 th\u1eed \u0111\u1ebfn <strong>c\u00e1i th\u1ee9 b\u1ea3y<\/strong> m\u1edbi th\u1ea5y v\u1eeba, li\u1ec1n v\u00e0o \u0111\u00f3 <strong>ng\u1ee7<\/strong>.<\/p>\n<p>T\u1ed1i m\u1ecbt, c\u00e1c ng\u01b0\u1eddi ch\u1ee7 c\u0103n nh\u00e0 m\u1edbi v\u1ec1. \u0110\u00f3 l\u00e0 b\u1ea3y ch\u00fa l\u00f9n <strong>weekend<\/strong> l\u00e0m c\u00f4ng vi\u1ec7c \u0111\u00e0o m\u1ecf. H\u1ecd b\u1ed7ng c\u1ea3m th\u1ea5y h\u00ecnh nh\u01b0 c\u00f3 ai \u0111\u00e3 \u0111\u1ebfn nh\u00e0, v\u00ec th\u1ea5y n\u00f3 khang kh\u00e1c, r\u1ed3i ph\u00e1t hi\u1ec7n ra m\u1ed9t c\u00f4 g\u00e1i xinh \u0111\u1eb9p ng\u1ee7 say tr\u00ean nh\u1eefng chi\u1ebfc gi\u01b0\u1eddng b\u00e9 t\u00ed c\u1ee7a h\u1ecd.\u00a0<strong>WORKDAY.INTL<\/strong> ch\u1ee3t t\u1ec9nh gi\u1ea5c v\u00e0 k\u1ec3 v\u1ec1 c\u00e2u chuy\u1ec7n c\u1ee7a n\u00e0ng cho h\u1ecd nghe. T\u1eeb \u0111\u00f3\u00a0<strong>WORKDAY.INTL<\/strong>\u00a0\u1edf v\u1edbi c\u00e1c ch\u00fa l\u00f9n. C\u00f4 l\u00e0m c\u00f4ng vi\u1ec7c n\u1ed9i tr\u1ee3. S\u00e1ng s\u1edbm, c\u00e1c ch\u00fa l\u00f9n v\u00e0o m\u1ecf l\u1ea5y qu\u1eb7ng v\u00e0 v\u00e0ng cho \u0111\u1ebfn chi\u1ec1u t\u1ed1i.\u00a0<strong>WORKDAY.INTL<\/strong> l\u00e0m th\u1ee9c \u0103n s\u1eb5n \u0111\u1ec3 cho h\u1ecd v\u1ec1 \u0103n.<\/p>\n<p>Nh\u01b0 th\u01b0\u1eddng l\u1ec7, m\u1ee5 ho\u00e0ng h\u1eadu <strong>HOLIDAYS<\/strong> \u00e1c \u0111\u1ed9c c\u1ee9 ngh\u0129 \u0111\u00e3 h\u1ea1 \u0111\u01b0\u1ee3c <strong>WORKDAY.INTL<\/strong>, b\u00e0 li\u1ec1n h\u1ecfi g\u01b0\u01a1ng:<\/p>\n<dl>\n<dd>G\u01b0\u01a1ng kia ng\u1ef1 \u1edf tr\u00ean t\u01b0\u1eddng,<\/dd>\n<dd>N\u01b0\u1edbc ta ai \u0111\u1eb9p \u0111\u01b0\u1ee3c d\u01b0\u1eddng nh\u01b0 ta?<\/dd>\n<\/dl>\n<p>G\u01b0\u01a1ng \u0111\u00e1p:<\/p>\n<dl>\n<dd>X\u01b0a kia b\u00e0 \u0111\u1eb9p nh\u1ea5t tr\u1ea7n,<\/dd>\n<dd>Ng\u00e0y nay\u00a0<strong>WORKDAY.INTL<\/strong> mu\u00f4n ph\u1ea7n \u0111\u1eb9p h\u01a1n.<\/dd>\n<dd>N\u00e0ng ta \u1edf khu\u1ea5t n\u00fai non,<\/dd>\n<dd>T\u1ea1i nh\u00e0 c\u1ee7a b\u1ea3y ch\u00fa l\u00f9n <strong>weekend<\/strong>.<\/dd>\n<\/dl>\n<\/blockquote>\n<p>[\/toggle]<\/p>\n<p>\u0110\u00f3 l\u00e0 c\u00e2u chuy\u1ec7n k\u1ec3 v\u1ec1 s\u1ef1 ra \u0111\u1eddi c\u1ee7a h\u00e0m WORKDAY.INTL theo c\u1ed5 t\u00edch x\u01b0a. B\u1ea1n nh\u1eadn ra \u0111i\u1ec1u g\u00ec? WORKDAY.INTL l\u00e0 ai? C\u00f3 ph\u1ea3i l\u00e0 n\u00e0ng B\u1ea1ch Tuy\u1ebft \u0111\u00e3 h\u00f3a th\u00e2n v\u00e0o trong Excel cho b\u1ea1n \u00e1p d\u1ee5ng m\u1ed7i ng\u00e0y.<\/p>\n<ul>\n<li><strong>WORKDAY.INTL<\/strong> l\u00e0 g\u00ec?<\/li>\n<\/ul>\n<div>\n<h4 class=\"\">C\u00fa ph\u00e1p<\/h4>\n<p>[alert-success]WORKDAY.INTL(start_date, days, [weekend], [holidays])[\/alert-success]<\/p>\n<p>C\u00fa ph\u00e1p h\u00e0m WORKDAY.INTL c\u00f3 ca\u0301c \u0111\u1ed1i s\u1ed1 sau \u0111\u00e2y:<\/p>\n<ol>\n<li><b class=\"ocpRunInHead\">Start_date:<\/b>\u00a0\u00a0\u00a0\u00a0B\u0103\u0301t bu\u00f4\u0323c. Nga\u0300y b\u0103\u0301t \u0111\u00e2\u0300u, \u0111\u01b0\u01a1\u0323c c\u0103\u0301t cu\u0323t \u0111\u00ea\u0309 tr\u01a1\u0309 tha\u0300nh s\u00f4\u0301 nguy\u00ean.<\/li>\n<li><b class=\"ocpRunInHead\">Days:<\/b>\u00a0\u00a0\u00a0\u00a0B\u0103\u0301t bu\u00f4\u0323c. S\u00f4\u0301 nga\u0300y la\u0300m vi\u00ea\u0323c tr\u01b0\u01a1\u0301c ho\u0103\u0323c sau start_date. Gia\u0301 tri\u0323 d\u01b0\u01a1ng cho k\u00ea\u0301t qua\u0309 la\u0300 m\u00f4\u0323t nga\u0300y trong t\u01b0\u01a1ng lai; gia\u0301 tri\u0323 \u00e2m cho k\u00ea\u0301t qua\u0309 la\u0300 m\u00f4\u0323t nga\u0300y trong qua\u0301 kh\u01b0\u0301; gia\u0301 tri\u0323 0 cho k\u00ea\u0301t qua\u0309 la\u0300 start_date. Day-offset se\u0303 \u0111\u01b0\u01a1\u0323c c\u0103\u0301t cu\u0323t \u0111\u00ea\u0309 tr\u01a1\u0309 tha\u0300nh m\u00f4\u0323t s\u00f4\u0301 nguy\u00ean.<\/li>\n<li><b class=\"ocpRunInHead\">Weekend:<\/b>\u00a0 Tu\u0300y cho\u0323n. Cho bi\u00ea\u0301t nh\u01b0\u0303ng nga\u0300y na\u0300o trong tu\u00e2\u0300n la\u0300 nga\u0300y cu\u00f4\u0301i tu\u00e2\u0300n va\u0300 kh\u00f4ng \u0111\u01b0\u01a1\u0323c coi la\u0300 nga\u0300y la\u0300m vi\u00ea\u0323c. Weekend la\u0300 m\u00f4\u0323t s\u00f4\u0301 cu\u0309a nga\u0300y cu\u00f4\u0301i tu\u00e2\u0300n ho\u0103\u0323c m\u00f4\u0323t chu\u00f4\u0303i chi\u0309 ro\u0303 khi na\u0300o thi\u0300 di\u00ea\u0303n ra nga\u0300y cu\u00f4\u0301i tu\u00e2\u0300n. Ca\u0301c gia\u0301 tri\u0323 chu\u00f4\u0303i nga\u0300y cu\u00f4\u0301i tu\u00e2\u0300n da\u0300i ba\u0309y ky\u0301 t\u01b0\u0323 va\u0300 m\u00f4\u0303i m\u00f4\u0323t ky\u0301 t\u01b0\u0323 trong chu\u00f4\u0303i bi\u00ea\u0309u thi\u0323 m\u00f4\u0323t nga\u0300y trong tu\u00e2\u0300n, b\u0103\u0301t \u0111\u00e2\u0300u t\u01b0\u0300 th\u01b0\u0301 hai.<br \/>\n\u2013<b class=\"ocpLiteral\"> 1<\/b>\u00a0th\u00ea\u0309 hi\u00ea\u0323n l\u00e0 nga\u0300y nghi\u0309.<br \/>\n\u2013<b class=\"ocpLiteral\"> 0<\/b>\u00a0th\u00ea\u0309 hi\u00ea\u0323n\u00a0l\u00e0\u00a0nga\u0300y la\u0300m vi\u00ea\u0323c.<br \/>\nChi\u0309 nh\u01b0\u0303ng ky\u0301 t\u01b0\u0323\u00a0<b class=\"ocpLiteral\">1<\/b>\u00a0va\u0300 0 \u0111\u01b0\u01a1\u0323c s\u01b0\u0309 du\u0323ng trong chu\u00f4\u0303i. <strong>1111111<\/strong> la\u0300 m\u00f4\u0323t chu\u00f4\u0303i kh\u00f4ng h\u01a1\u0323p l\u00ea\u0323.<\/p>\n<p class=\"\">V\u00ed d\u1ee5, <strong>\u201c<\/strong><b class=\"ocpLiteral\">0000011\u2033<\/b>\u00a0s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 ng\u00e0y cu\u1ed1i tu\u1ea7n l\u00e0 Th\u1ee9 b\u1ea3y v\u00e0 Ch\u1ee7 nh\u1eadt.<\/p>\n<\/li>\n<li><b class=\"ocpRunInHead\">Holidays:<\/b>\u00a0\u00a0\u00a0\u00a0Tu\u0300y cho\u0323n. M\u00f4\u0323t t\u00e2\u0323p h\u01a1\u0323p tu\u0300y cho\u0323n g\u00f4\u0300m m\u00f4\u0323t ho\u0103\u0323c nhi\u00ea\u0300u nga\u0300y c\u00e2\u0300n \u0111\u01b0\u01a1\u0323c tr\u01b0\u0300 kho\u0309i li\u0323ch nga\u0300y la\u0300m vi\u00ea\u0323c. Holidays se\u0303 la\u0300 m\u00f4\u0323t pha\u0323m vi \u00f4 ch\u01b0\u0301a nga\u0300y ho\u0103\u0323c m\u00f4\u0323t h\u0103\u0300ng s\u00f4\u0301 ma\u0309ng g\u00f4\u0300m ca\u0301c gia\u0301 tri\u0323 s\u00ea-ri bi\u00ea\u0309u thi\u0323 ca\u0301c nga\u0300y \u0111o\u0301. Co\u0301 th\u00ea\u0309 tu\u0300y y\u0301 s\u0103\u0301p x\u00ea\u0301p th\u01b0\u0301 t\u01b0\u0323 cu\u0309a nga\u0300y ho\u0103\u0323c ca\u0301c gia\u0301 tri\u0323 s\u00ea-ri trong \u0111\u00f4\u0301i s\u00f4\u0301 holidays.<\/li>\n<\/ol>\n<\/div>\n<ul>\n<li>V\u1eady li\u00ean quan g\u00ec \u0111\u1ebfn c\u00e2u chuy\u1ec7n c\u1ed5 t\u00edch, t\u00e0o lao qu\u00e1 \u00e0 nghen?<\/li>\n<\/ul>\n<p>Ch\u00fang ta c\u00f3 [1] start_date (ng\u00e0y \u0111\u01b0\u1ee3c sinh ra), [2] days (s\u1ed1 ng\u00e0y \u1edf c\u00f9ng 7 ch\u00fa l\u00f9n), [3] weekend (7 ch\u00fa l\u00f9n v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb tham chi\u1ebfu 1 v\u00e0 0), v\u00e0 [4] holidays (danh s\u00e1ch ng\u00e0y ngh\u1ec9 do m\u1ee5 ph\u00f9 th\u1ee7y t\u00ecm t\u1edbi h\u1ea1 \u0111\u1ed9c).<\/p>\n<p>C\u1ee9 cho l\u00e0 v\u1eady \u0111i, r\u1ed3i xem l\u00e0m \u0111\u01b0\u1ee3c g\u00ec? 7 ch\u00fa l\u00f9n <strong>weekend<\/strong> ra l\u00e0m sao? M\u1ee5 ph\u00f9 th\u1ee7y <strong>holidays<\/strong> \u0111\u00e3 l\u00e0m g\u00ec? R\u1ed3i ch\u1eebng n\u00e0o ho\u00e0ng t\u1eed <strong>NETWORKDAYS.INTL<\/strong>\u00a0\u0111\u1ebfn, v\u00e0 \u0111\u00e3 l\u00e0m g\u00ec?<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/workday.intl-weekend-holidays-cach-tinh-ngay-cho-truoc.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19212 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/workday-intl-weekend-holidays-cach-tinh-ngay-cho-truoc.jpg\" width=\"1343\" height=\"428\" title=\"workday-intl-weekend-holidays-cach-tinh-ngay-cho-truoc\"><\/a><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-21.gif\" title=\"vba101_92019-nho-21\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-71.gif\" title=\"ex101_92019-nho-71\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y th\u00f4ng th\u01b0\u1eddng, l\u1ea5y ng\u00e0y b\u1eaft \u0111\u1ea7u + s\u1ed1 ng\u00e0y, s\u1ebd ra \u0111\u01b0\u1ee3c ng\u00e0y k\u1ebft th\u00fac.<\/li>\n<\/ul>\n<p><em>V\u00ed d\u1ee5: \u00f4 A2 c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 ng\u00e0y \u201c10\/02\/2018\u201d, c\u1ed9ng t\u1edbi 7 ng\u00e0y n\u1eefa, th\u00ec s\u1ebd l\u00e0: 17\/02\/2018.<\/em><\/p>\n<ul>\n<li>Khi WORKDAY c\u00f2n \u0111ang \u0111i h\u1ecdc, th\u00ec m\u1eb7c \u0111\u1ecbnh \u0111\u01b0\u1ee3c ngh\u1ec9 T7, CN r\u1ed3i, v\u00e0 danh s\u00e1ch ng\u00e0y ngh\u1ec9 l\u1ec5 n\u1ebfu c\u00f3.<\/li>\n<\/ul>\n<p><em>C\u0169ng l\u00e0 ng\u00e0y \u201c10\/02\/2018\u201d, c\u1ed9ng th\u00eam 7 ng\u00e0y, v\u00e0 th\u1ee9 7 + CN ngh\u1ec9, th\u00ec k\u1ebft qu\u1ea3 s\u1ebd l\u00e0: 20\/02\/2018. N\u1ebfu t\u00ednh ng\u00e0y ngh\u1ec9 l\u1ec5 s\u1ebd l\u00e0: \u201c01\/03\/2018\u201d.<\/em><\/p>\n<ul>\n<li>Khi WORKDAY l\u1edbn l\u00ean tr\u1edf th\u00e0nh WORKDAY.INTL s\u1ebd c\u00f3 s\u1ed1 ng\u00e0y ngh\u1ec9 trong tu\u1ea7n khi l\u00e0m vi\u1ec7c.<\/li>\n<\/ul>\n<p><em>C\u0169ng l\u00e0 ng\u00e0y \u201c10\/02\/2018\u201d, c\u1ed9ng th\u00eam 7 ng\u00e0y, nh\u01b0ng ch\u1ec9 \u0111i l\u00e0m 2-4-6, c\u00f2n l\u1ea1i ngh\u1ec9, l\u1ec5 l\u1ea1c kh\u00f4ng quan t\u00e2m, th\u00ec k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 l\u00e0: \u201c26\/02\/2018\u201d.<\/em><\/p>\n<p><em>V\u00e0, t\u00ednh lu\u00f4n ng\u00e0y ngh\u1ec9 l\u1ec5 l\u1ea1c, th\u00ec d\u1ecbp \u0111\u00f3, l\u1ea1i r\u01a1i v\u00e0o \u0111\u1ee3t ngh\u1ec9 T\u1ebft Nguy\u00ean \u0110\u00e1n, cu\u1ed1i c\u00f9ng th\u00ec k\u1ebft qu\u1ea3 s\u1ebd l\u00e0: \u201c07\/03\/2018\u201d.<\/em><\/p>\n<p>B\u1ea1n c\u00f3 th\u1eafc m\u1eafc \u201c0101011\u201d ngh\u0129a l\u00e0 nh\u01b0 th\u1ebf n\u00e0o ko? \u0110\u00f3 l\u00e0 tu\u1ea7n t\u1ef1 7 ng\u00e0y trong tu\u1ea7n t\u1eeb T2 t\u1edbi CN. V\u1edbi weekend, 1 c\u00f3 ngh\u0129a l\u00e0 \u0111\u01b0\u1ee3c ngh\u1ec9, v\u00e0 0 ngh\u0129a l\u00e0 ng\u00e0y l\u00e0m vi\u1ec7c, s\u1ebd t\u00ednh ng\u00e0y.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/weekend-7chulun.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19205 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/weekend-7chulun.jpg\" width=\"608\" height=\"212\" title=\"weekend-7chulun\"><\/a><\/p>\n<p>V\u1eabn ch\u01b0a th\u1ea5y \u1ee9ng d\u1ee5ng\u00a0cho vi\u1ec7c g\u00ec? Khi n\u00e0o th\u00ec d\u00f9ng t\u1edbi n\u00f3? D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5, khi ch\u00fang ta c\u00f3 ng\u00e0y nh\u1eadp h\u1ecdc, v\u00e0 s\u1ed1 gi\u1edd h\u1ecdc\/bu\u1ed5i, c\u00f9ng l\u1ecbch h\u1ecdc.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/tinh-ngay-ket-thuc-tu-sogiohoc.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19206\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-ngay-ket-thuc-tu-sogiohoc.jpg\" width=\"1207\" height=\"508\" title=\"tinh-ngay-ket-thuc-tu-sogiohoc\"><\/a><\/p>\n<p>R\u1ed3i, th\u00ec <strong>NETWORKDAYS.INTL<\/strong> l\u00e0m g\u00ec?<strong> NETWORKDAYS.INTL<\/strong>(ng\u00e0y b\u1eaft \u0111\u1ea7u, ng\u00e0y k\u1ebft th\u00fac, weekend, holidays) s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 ng\u00e0y t\u01b0\u01a1ng \u1ee9ng gi\u1eefa 2 ng\u00e0y tr\u00ean. V\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh c\u00f3 bao nhi\u00eau ng\u00e0y th\u1ee9 7 trong tu\u1ea7n, tr\u1eeb ng\u00e0y ngh\u1ec9 l\u1ec5? B\u1ea1n s\u1ebd \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0o?<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/networkdays.intl-weekend-holidays-cach-tinh-ngay-t7-trong-tuan.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19211 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/networkdays-intl-weekend-holidays-cach-tinh-ngay-t7-trong-tuan.jpg\" width=\"1238\" height=\"469\" title=\"networkdays-intl-weekend-holidays-cach-tinh-ngay-t7-trong-tuan\"><\/a><\/p>\n<p>\u1ee8ng d\u1ee5ng d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec? B\u1ea1n c\u00f3 \u0111\u01a1n \u0111\u1eb7t h\u00e0ng, v\u00e0 ng\u00e0y ho\u00e0n th\u00e0nh s\u1ea3n ph\u1ea9m, c\u00f9ng l\u1ecbch giao h\u00e0ng, b\u1ea1n c\u1ea7n ki\u1ec3m tra xem danh s\u00e1ch \u0111\u01a1n h\u00e0ng \u0111\u00f3 c\u00f3 n\u1eb1m trong l\u1ecbch giao h\u00e0ng hay kh\u00f4ng? \u0110\u00e2y l\u00e0 c\u00e2u h\u1ecfi m\u00ecnh nh\u1eadn \u0111\u01b0\u1ee3c tr\u00ean m\u1ea1ng, v\u00e0 gi\u1ea3i ph\u00e1p cho n\u00f3, th\u00f4ng qua h\u00e0m <strong>NETWORKDAYS.INTL<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/networkdays.intl-weekend-holidays-tinh-ngay-giao-hang.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19208 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/networkdays-intl-weekend-holidays-tinh-ngay-giao-hang.jpg\" width=\"1225\" height=\"523\" title=\"networkdays-intl-weekend-holidays-tinh-ngay-giao-hang\"><\/a><\/p>\n<ul>\n<li>L\u1edcI K\u1ebeT:<\/li>\n<\/ul>\n<p>B\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u00ednh ra s\u1ed1 ng\u00e0y c\u00f4ng trong th\u00e1ng v\u1edbi c\u00f4ng th\u1ee9c NETWORKDAYS.INTL v\u1edbi \u00e1p d\u1ee5ng c\u1ee5 th\u1ec3 theo l\u1ecbch l\u00e0m vi\u1ec7c c\u00f3 ngh\u1ec9 th\u1ee9 7 hay kh\u00f4ng? Hay ch\u1ec9 l\u00e0m n\u1eeda ng\u00e0y. R\u1ea5t \u0111\u01a1n gi\u1ea3n r\u1ed3i ph\u1ea3i kh\u00f4ng?<\/p>\n<p>Nh\u01b0 b\u1ea1n \u0111\u00e3 th\u1ea5y, ph\u1ea7n WEEKEND c\u0169ng r\u1ea5t h\u1eefu d\u1ee5ng trong c\u00e1c \u1ee9ng d\u1ee5ng kh\u00e1c nhau. M\u1eb7c \u0111\u1ecbnh tham chi\u1ebfu s\u1ebd \u0111\u01b0\u1ee3c Excel g\u1ee3i \u00fd, nh\u01b0ng t\u00ecm \u0111\u1ebfn ng\u00f4i nh\u00e0 c\u1ee7a 7 ch\u00fa l\u00f9n th\u00ec ph\u1ea3i \u0111i qua b\u1ea3y ng\u1ecdn n\u00fai xa. H\u00e3y nh\u01b0 B\u1ea1ch Tuy\u1ebft, v\u00e0 \u0111\u1eebng \u0103n t\u00e1o \u0111\u1ed9c c\u1ee7a m\u1ee5 ph\u00f9 th\u1ee7y.<\/p>\n<p>N\u1ebfu c\u00f3 th\u1eafc m\u1eafc, \u0111\u1eebng ng\u1ea1i ng\u00f9ng khi h\u1ecfi, b\u1ea1n s\u1ebd lu\u00f4n t\u00ecm th\u1ea5y gi\u1ea3i ph\u00e1p t\u1ed1i \u01b0u nh\u1ea5t cho c\u00e2u h\u1ecfi c\u1ee7a m\u00ecnh.<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-21.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1037,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1036","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\/1036","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=1036"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1036\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1037"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}