{"id":7783,"date":"2024-12-21T18:29:30","date_gmt":"2024-12-21T18:29:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-tinh-so-tuan-so-ngay-le-trong-tuan-giua-2-moc-thoi-gian\/"},"modified":"2024-12-21T18:29:30","modified_gmt":"2024-12-21T18:29:30","slug":"huong-dan-cach-tinh-so-tuan-so-ngay-le-trong-tuan-giua-2-moc-thoi-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-tinh-so-tuan-so-ngay-le-trong-tuan-giua-2-moc-thoi-gian\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ednh s\u1ed1 tu\u1ea7n, s\u1ed1 ng\u00e0y l\u1ebb trong tu\u1ea7n gi\u1eefa 2 m\u1ed1c th\u1eddi gian"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online <\/a>s\u1ebd h\u01b0\u1edbng d\u1eabn <strong>c\u00e1ch t\u00ednh s\u1ed1 tu\u1ea7n, s\u1ed1 ng\u00e0y l\u1ebb trong tu\u1ea7n gi\u1eefa 2 m\u1ed1c th\u1eddi gian<\/strong> b\u1eb1ng vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n.<\/p>\n<p style=\"text-align: justify\">Vi\u1ec7c x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c t\u1edbi t\u1eebng tu\u1ea7n, t\u1eebng ng\u00e0y l\u1ebb (th\u1eadm ch\u00ed t\u1eebng gi\u1edd) s\u1ebd gi\u00fap \u00edch kh\u00e1 nhi\u1ec1u cho b\u1ea1n trong c\u00f4ng vi\u1ec7c li\u00ean quan t\u1edbi x\u1eed l\u00fd d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng. V\u00ed d\u1ee5, n\u1ebfu nh\u01b0 b\u1ea1n l\u00e0m trong l\u0129nh v\u1ef1c nh\u00e2n s\u1ef1, ti\u1ec1n l\u01b0\u01a1ng th\u00ec y\u00eau c\u1ea7u v\u1ec1 ch\u1ea5m c\u00f4ng, t\u00ednh l\u01b0\u01a1ng lu\u00f4n c\u1ea7n s\u1ef1 ch\u00ednh x\u00e1c \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o l\u1ee3i \u00edch ch\u00ednh \u0111\u00e1ng cho ng\u01b0\u1eddi lao \u0111\u1ed9ng.<\/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-67670909dcd5e\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tinh-tuan-ngay-le-trong-tuan-giua-2-moc-thoi-gian.html#Tinh_so_tuan_giua_2_moc_thoi_gian\" title=\"T\u00ednh s\u1ed1 tu\u1ea7n gi\u1eefa 2 m\u1ed1c th\u1eddi gian\">T\u00ednh s\u1ed1 tu\u1ea7n gi\u1eefa 2 m\u1ed1c th\u1eddi gian<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tinh-tuan-ngay-le-trong-tuan-giua-2-moc-thoi-gian.html#Tinh_so_ngay_le_trong_tuan_giua_2_moc_thoi_gian\" title=\"T\u00ednh s\u1ed1 ng\u00e0y l\u1ebb trong tu\u1ea7n gi\u1eefa 2 m\u1ed1c th\u1eddi gian\">T\u00ednh s\u1ed1 ng\u00e0y l\u1ebb trong tu\u1ea7n gi\u1eefa 2 m\u1ed1c th\u1eddi gian<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tinh_so_tuan_giua_2_moc_thoi_gian\"><\/span>T\u00ednh s\u1ed1 tu\u1ea7n gi\u1eefa 2 m\u1ed1c th\u1eddi gian<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Ta s\u1ebd x\u00e1c \u0111\u1ecbnh s\u1ed1 tu\u1ea7n b\u1eb1ng c\u00e1ch l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a s\u1ed1 ng\u00e0y gi\u1eefa 2 th\u1eddi \u0111i\u1ec3m \u0111\u00f3 chia 7 (V\u00ec sao l\u1ea1i chia 7 th\u00ec \u0111\u01a1n gi\u1ea3n l\u00e0 1 tu\u1ea7n c\u00f3 7 ng\u00e0y )<\/p>\n<p style=\"text-align: justify\">\u0110\u1ea7u ti\u00ean ta s\u1ebd x\u00e1c \u0111\u1ecbnh s\u1ed1 ng\u00e0y gi\u1eefa 2 m\u1ed1c th\u1eddi gian \u0111\u00f3, \u0111\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y ta c\u00f3 kh\u00e1 nhi\u1ec1u c\u00e1ch. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd s\u1eed d\u1ee5ng h\u00e0m DATEDIF \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 ng\u00e0y gi\u1eefa 2 th\u1eddi \u0111i\u1ec3m \u0111\u00f3. C\u1ee5 th\u1ec3 ta c\u00f3 c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y v\u1edbi h\u00e0m DATEDIF nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=DATEDIF(B6,C6,\u201dd\u201d)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>Trong \u0111\u00f3:<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>B6: ng\u00e0y b\u1eaft \u0111\u1ea7u<\/li>\n<li>C6: ng\u00e0y k\u1ebft th\u00fac<\/li>\n<li>\u201cd\u201d: \u0111\u1ec3 l\u1ea5y ra s\u1ed1 ng\u00e0y<\/li>\n<\/ul>\n<blockquote>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/10\/2-11.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30567\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-11-2.png\" width=\"883\" height=\"436\" title=\"2-11-2\"><\/a><\/p>\n<\/blockquote>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/tinh-khoang-thoi-gian-giua-2-thoi-diem-ham-datedif-trong-excel.html\">H\u00e0m DATEDIF <\/a>t\u00ednh kho\u1ea3ng th\u1eddi gian gi\u1eefa 2 th\u1eddi \u0111i\u1ec3m trong Excel<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Sau khi \u0111\u00e3 c\u00f3 s\u1ed1 ng\u00e0y, ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m INT \u0111\u1ec3 l\u1ea5y ra s\u1ed1 tu\u1ea7n b\u1eb1ng c\u00e1ch l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a s\u1ed1 ng\u00e0y chia cho 7.<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-700.gif\" title=\"ex101_92019-nho-700\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-317.gif\" title=\"vba101_92019-nho-317\"><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-700.gif\" title=\"ex101_92019-nho-700\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p><strong>=INT(D6\/7)<\/strong><\/p>\n<h2><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30566\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-10-2.png\" width=\"1002\" height=\"467\" title=\"1-10-2\"><\/h2>\n<p>xem th\u00eam: <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-int-ham-lay-phan-nguyen-trong-excel.html\">H\u00e0m Int<\/a> \u2013 h\u00e0m l\u1ea5y ph\u1ea7n nguy\u00ean trong Excel<\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tinh_so_ngay_le_trong_tuan_giua_2_moc_thoi_gian\"><\/span>T\u00ednh s\u1ed1 ng\u00e0y l\u1ebb trong tu\u1ea7n gi\u1eefa 2 m\u1ed1c th\u1eddi gian<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y l\u1ebb trong tu\u1ea7n ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m MOD, ta co c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=MOD(D6,E6*7)<\/strong><\/p>\n<\/blockquote>\n<ul style=\"text-align: justify\">\n<li>D6: s\u1ed1 ng\u00e0y<\/li>\n<li>E6*7: S\u1ed1 tu\u1ea7n nh\u00e2n v\u1edbi 7<\/li>\n<\/ul>\n<p style=\"text-align: justify\">H\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 ph\u1ea7n d\u01b0, v\u00e0 ph\u1ea7n d\u01b0 n\u00e0y ch\u00ednh l\u00e0 s\u1ed1 ng\u00e0y l\u1ebb trong tu\u1ea7n. <em>(Chi ti\u1ebft h\u00ecnh \u1ea3nh trong ph\u1ea7n t\u00ednh s\u1ed1 tu\u1ea7n \u1edf tr\u00ean)<\/em><\/p>\n<blockquote>\n<p style=\"text-align: justify\"><em>\u0110\u00f3 l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m Excel c\u01a1 b\u1ea3n v\u00e0 \u0111\u01a1n gi\u1ea3n c\u1ea7n bi\u1ebft \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 x\u1eed l\u00fd \u0111\u01b0\u1ee3c nh\u1eefng t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf ph\u00e1t sinh trong c\u00f4ng vi\u1ec7c. Vi\u1ec7c n\u1eafm \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m Excel s\u1ebd gi\u00fap cho b\u1ea1n x\u1eed l\u00fd nhanh ch\u00f3ng v\u1edbi nh\u1eefng y\u00eau c\u1ea7u t\u00ednh to\u00e1n g\u00f3p ph\u1ea7n n\u00e2ng cao n\u0103ng su\u1ea5t l\u00e0m vi\u1ec7c. \u0110\u1ec3 hi\u1ec3u s\u00e2u h\u01a1n v\u1ec1 Excel, c\u00e1c h\u00e0m trong Excel, c\u00e1c th\u1ee7 thu\u1eadt, m\u1eb9o khi l\u00e0m vi\u1ec7c v\u1edbi Excel b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><strong>Kho\u00e1 h\u1ecdc EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn chuy\u00ean gia d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/strong><\/a><\/em><\/p>\n<\/blockquote>\n<hr>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-tin-hoc-van-phong.html\">Kho\u00e1 h\u1ecdc tin h\u1ecdc v\u0103n ph\u00f2ng Excel Word Powerpoint t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-mot-cach-tinh-luy-tien-trong-excel.html\">H\u01b0\u1edbng d\u1eabn m\u1ed9t s\u1ed1 \u0111\u1ec3 c\u00e1ch t\u00ednh lu\u1ef9 ti\u1ebfn trong Excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xoa-tat-tan-tat-cac-ky-tu-khoang-trang-dac-biet-trong-excel-voi-power-query.html\">Xo\u00e1 t\u1ea5t t\u1ea7n t\u1eadt c\u00e1c k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng \u0111\u1eb7c bi\u1ec7t trong Excel kh\u00f4ng c\u1ea7n d\u00f9ng h\u00e0m<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lay-du-lieu-tu-1-file-excel-dang-dong.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ea5y d\u1eef li\u1ec7u t\u1eeb 1 file Excel \u0111ang \u0111\u00f3ng<\/a><\/strong><\/em><\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-700.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7784,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7783","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\/7783","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=7783"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7783\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7784"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7783"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7783"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}