{"id":6698,"date":"2024-12-21T15:58:04","date_gmt":"2024-12-21T15:58:04","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-xac-dinh-nhung-ngay-chu-nhat-trong-khoang-thoi-gian-bat-ky\/"},"modified":"2024-12-21T15:58:04","modified_gmt":"2024-12-21T15:58:04","slug":"huong-dan-cach-xac-dinh-nhung-ngay-chu-nhat-trong-khoang-thoi-gian-bat-ky","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-xac-dinh-nhung-ngay-chu-nhat-trong-khoang-thoi-gian-bat-ky\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u00e1c \u0111\u1ecbnh nh\u1eefng ng\u00e0y ch\u1ee7 nh\u1eadt trong kho\u1ea3ng th\u1eddi gian b\u1ea5t k\u1ef3"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>N\u1ebfu b\u1ea1n c\u1ea7n ph\u1ea3i x\u1ebfp l\u1ecbch l\u00e0m m\u1ed9t vi\u1ec7c v\u00e0o t\u1ea5t c\u1ea3 c\u00e1c ng\u00e0y ch\u1ee7 nh\u1eadt trong th\u00e1ng th\u00ec b\u1ea1n s\u1ebd l\u00e0m th\u1ebf n\u00e0o? Ch\u1eafc l\u00e0 ph\u1ea3i m\u1edf l\u1ecbch l\u00ean v\u00e0 xem th\u00e1ng\u00a0\u0111\u00f3 ng\u00e0y n\u00e0o l\u00e0 ch\u1ee7 nh\u1eadt\u00a0\u0111\u00fang kh\u00f4ng? V\u1eady trong tr\u01b0\u1eddng h\u1ee3p ch\u00fang ta kh\u00f4ng c\u00f3 l\u1ecbch th\u00ec sao? Tin vui l\u00e0 b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng\u00a0excel\u00a0\u0111\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y.<\/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-6766e58b2ea8d\" 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-xac-dinh-nhung-ngay-chu-nhat-trong-khoang-thoi-gian-bat-ky.html#Cach_xac_dinh_nhung_ngay_chu_nhat_trong_khoang_thoi_gian_bat_ky\" title=\"C\u00e1ch x\u00e1c \u0111\u1ecbnh nh\u1eefng ng\u00e0y ch\u1ee7 nh\u1eadt trong kho\u1ea3ng th\u1eddi gian b\u1ea5t k\u1ef3\">C\u00e1ch x\u00e1c \u0111\u1ecbnh nh\u1eefng ng\u00e0y ch\u1ee7 nh\u1eadt trong kho\u1ea3ng th\u1eddi gian b\u1ea5t k\u1ef3<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xac-dinh-nhung-ngay-chu-nhat-trong-khoang-thoi-gian-bat-ky.html#Co_bao_nhieu_ngay_chu_nhat_trong_thang\" title=\"C\u00f3 bao nhi\u00eau ng\u00e0y ch\u1ee7 nh\u1eadt trong th\u00e1ng?\">C\u00f3 bao nhi\u00eau ng\u00e0y ch\u1ee7 nh\u1eadt trong th\u00e1ng?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xac-dinh-nhung-ngay-chu-nhat-trong-khoang-thoi-gian-bat-ky.html#Cu_the_ngay_chu_nhat_trong_thang_la_ngay_nao\" title=\"C\u1ee5 th\u1ec3 ng\u00e0y ch\u1ee7 nh\u1eadt trong th\u00e1ng l\u00e0 ng\u00e0y n\u00e0o?\">C\u1ee5 th\u1ec3 ng\u00e0y ch\u1ee7 nh\u1eadt trong th\u00e1ng l\u00e0 ng\u00e0y n\u00e0o?<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_xac_dinh_nhung_ngay_chu_nhat_trong_khoang_thoi_gian_bat_ky\"><\/span>C\u00e1ch x\u00e1c \u0111\u1ecbnh nh\u1eefng ng\u00e0y ch\u1ee7 nh\u1eadt trong kho\u1ea3ng th\u1eddi gian b\u1ea5t k\u1ef3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u00f3 kho\u1ea3ng th\u1eddi gian b\u1ea5t k\u1ef3 l\u00e0 t\u1eeb ng\u00e0y\u00a0\u0111\u1ea7u th\u00e1ng\u00a0\u0111\u1ebfn ng\u00e0y cu\u1ed1i th\u00e1ng 8\u00a0n\u0103m 2022:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27903\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/yeu-cau-tim-so-ngay-chu-nhat-trong-thang.png\" width=\"659\" height=\"135\" title=\"yeu-cau-tim-so-ngay-chu-nhat-trong-thang\"><\/p>\n<p>c\u00e2u h\u1ecfi\u00a0\u0111\u1eb7t ra l\u00e0:<\/p>\n<p>1. C\u00f3 bao nhi\u00eau ng\u00e0y ch\u1ee7 nh\u1eadt trong th\u00e1ng?<\/p>\n<p>2. C\u1ee5 th\u1ec3 ng\u00e0y ch\u1ee7 nh\u1eadt trong th\u00e1ng l\u00e0 ng\u00e0y n\u00e0o?<\/p>\n<p>Sau\u00a0\u0111\u00e2y ch\u00fang ta l\u1ea7n l\u01b0\u1ee3t tr\u1ea3 l\u1eddi t\u1eebng c\u00e2u h\u1ecfi nh\u01b0 sau:<\/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-601.gif\" title=\"ex101_92019-nho-601\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Co_bao_nhieu_ngay_chu_nhat_trong_thang\"><\/span>C\u00f3 bao nhi\u00eau ng\u00e0y ch\u1ee7 nh\u1eadt trong th\u00e1ng?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong b\u00e0i vi\u1ebft\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dem-so-ngay-thu-bay-chu-nhat-trong-mot-khoang-thoi-gian.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ebfm s\u1ed1 ng\u00e0y th\u1ee9 b\u1ea3y, ch\u1ee7 nh\u1eadt trong m\u1ed9t kho\u1ea3ng th\u1eddi gian<\/a>\u00a0ch\u00fang ta th\u1ea5y c\u00f3 1 c\u00e1ch r\u1ea5t hay\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm s\u1ed1 ng\u00e0y ch\u1ee7 nh\u1eadt trong 1 kho\u1ea3ng th\u1eddi gian,\u00a0\u0111\u00f3 l\u00e0 d\u00f9ng h\u00e0m Networkdays.INTL<\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean,\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh s\u1ed1 ng\u00e0y ch\u1ee7 nh\u1eadt trong kho\u1ea3ng gi\u1eefa hai ng\u00e0y t\u1ea1i\u00a0\u00f4 B3 v\u00e0 B4 ta c\u00f3 th\u1ec3 vi\u1ebft nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=NETWORKDAYS.INTL(B3,B4,\u201d1111110\u2033)<\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27904\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-networkdays-intl-xac-dinh-so-ngay-chu-nhat-trong-thang.png\" width=\"681\" height=\"202\" title=\"ham-networkdays-intl-xac-dinh-so-ngay-chu-nhat-trong-thang\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cu_the_ngay_chu_nhat_trong_thang_la_ngay_nao\"><\/span>C\u1ee5 th\u1ec3 ng\u00e0y ch\u1ee7 nh\u1eadt trong th\u00e1ng l\u00e0 ng\u00e0y n\u00e0o?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh c\u00e1c ng\u00e0y ch\u1ee7 nh\u1eadt c\u1ee5 th\u1ec3 trong th\u00e1ng, ch\u00fang ta c\u1ea7n s\u1eed d\u1ee5ng c\u00e1c h\u00e0m x\u00e9t th\u1ee9 trong tu\u1ea7n. Trong\u00a0\u0111\u00f3 quan tr\u1ecdng nh\u1ea5t l\u00e0 t\u00ecm ra ng\u00e0y ch\u1ee7 nh\u1eadt\u00a0\u0111\u1ea7u ti\u00ean trong th\u00e1ng l\u00e0 ng\u00e0y n\u00e0o.<\/p>\n<p>Logic\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y ch\u1ee7 nh\u1eadt\u00a0\u0111\u1ea7u ti\u00ean trong th\u00e1ng nh\u01b0 sau:<\/p>\n<ul>\n<li>Ki\u1ec3m tra xem ng\u00e0y\u00a0\u0111\u1ea7u th\u00e1ng (t\u1ea1i\u00a0\u00f4 B3) c\u00f3 ph\u1ea3i ng\u00e0y ch\u1ee7 nh\u1eadt kh\u00f4ng. N\u1ebfu\u00a0\u0111\u00fang th\u00ec l\u1ea5y lu\u00f4n ng\u00e0y n\u00e0y.<\/li>\n<li>N\u1ebfu kh\u00f4ng ph\u1ea3i, x\u00e9t xem ng\u00e0y\u00a0\u0111\u00f3 l\u00e0 th\u1ee9 m\u1ea5y.<\/li>\n<li>D\u1ef1a v\u00e0o th\u1ee9, ch\u00fang ta bi\u1ebft\u00a0\u0111\u01b0\u1ee3c c\u1ea7n th\u00eam bao nhi\u00eau ng\u00e0y n\u1eefa l\u00e0 t\u1edbi ch\u1ee7 nh\u1eadt =&gt; X\u00e1c\u00a0\u0111\u1ecbnh kho\u1ea3ng c\u00e1ch n\u00e0y<\/li>\n<li>C\u1ed9ng th\u00eam kho\u1ea3ng c\u00e1ch\u00a0\u0111\u00f3 v\u00e0o ng\u00e0y\u00a0\u0111\u1ea7u th\u00e1ng =&gt; Thu\u00a0\u0111\u01b0\u1ee3c ng\u00e0y ch\u1ee7 nh\u1eadt\u00a0\u0111\u1ea7u ti\u00ean.<\/li>\n<\/ul>\n<p>C\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 x\u00e2y d\u1ef1ng nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=B3+IF(WEEKDAY(B3,2)=7, 0, 7-WEEKDAY(B3,2))<\/p>\n<p>Ta c\u00f3:<\/p>\n<p>WEEKDAY(B3,2) l\u00e0 x\u00e9t th\u1ee9 c\u1ee7a ng\u00e0y t\u1ea1i\u00a0\u00f4 B3 b\u1eb1ng h\u00e0m\u00a0Weekday. Tham s\u1ed1 2\u00a0\u0111\u1ec3 th\u1ec3 hi\u1ec7n gi\u00e1 tr\u1ecb ng\u00e0y t\u1eeb 1\u00a0\u0111\u1ebfn 7 t\u01b0\u01a1ng\u00a0\u1ee9ng t\u1eeb Th\u1ee9 hai t\u1edbi Ch\u1ee7 nh\u1eadt (Th\u1ee9 hai = 1, th\u1ee9 3 = 2\u2026 ch\u1ee7 nh\u1eadt = 7)<\/p>\n<p>IF(WEEKDAY(B3,2)=7,\u00a00 l\u00e0 n\u1ebfu ng\u00e0y t\u1ea1i\u00a0\u00f4 B3 l\u00e0 ch\u1ee7 nh\u1eadt, s\u1ebd coi gi\u00e1 tr\u1ecb s\u1ed1 ng\u00e0y c\u1ea7n c\u1ed9ng th\u00eam l\u00e0 0<\/p>\n<p>7-WEEKDAY(B3,2) tr\u01b0\u1eddng h\u1ee3p ng\u00e0y t\u1ea1i\u00a0\u00f4 B3 kh\u00f4ng ph\u1ea3i ch\u1ee7 nh\u1eadt, s\u1ebd l\u1ea5y 7 (\u1ee9ng v\u1edbi ch\u1ee7 nh\u1eadt) tr\u1eeb\u00a0\u0111i gi\u00e1 tr\u1ecb th\u1ee9 c\u1ee7a\u00a0\u00f4 B2\u00a0\u0111\u1ec3 t\u00ednh kho\u1ea3ng c\u00e1ch s\u1ed1 ng\u00e0y c\u1ea7n c\u1ed9ng th\u00eam.<\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27905\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xac-dinh-ngay-chu-nhat-dau-tien-trong-thang.png\" width=\"930\" height=\"295\" title=\"xac-dinh-ngay-chu-nhat-dau-tien-trong-thang\"><\/p>\n<p>Nh\u1eefng ng\u00e0y ch\u1ee7 nh\u1eadt ti\u1ebfp theo, ch\u00fang ta ch\u1ec9 c\u1ea7n l\u1ea5y Ng\u00e0y ch\u1ee7 nh\u1eadt\u00a0\u0111\u1ea7u ti\u00ean + 7.<\/p>\n<p>L\u01b0u\u00a0\u00fd: X\u00e9t\u00a0\u0111i\u1ec1u ki\u1ec7n n\u1ebfu Ng\u00e0y ch\u1ee7 nh\u1eadt tr\u01b0\u1edbc\u00a0\u0111\u00f3 + 7 v\u01b0\u1ee3t qu\u00e1 ng\u00e0y cu\u1ed1i th\u00e1ng th\u00ec kh\u00f4ng c\u1ed9ng n\u1eefa.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27906\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-cac-ngay-chu-nhat-trong-thang.png\" width=\"934\" height=\"299\" title=\"ket-qua-cac-ngay-chu-nhat-trong-thang\"><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n\u00a0\u00e1p d\u1ee5ng t\u1ed1t ki\u1ebfn th\u1ee9c n\u00e0y v\u00e0o c\u00f4ng vi\u1ec7c!<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft th\u00fa v\u1ecb kh\u00e1c v\u1ec1 Ng\u00e0y th\u00e1ng trong\u00a0Excel:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-chinh-dung-dinh-dang-ngay-thang-nam-trong-excel.html\">\u0110\u1ecbnh d\u1ea1ng Ng\u00e0y Th\u00e1ng N\u0103m trong Excel \u0111\u00fang c\u00e1ch<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tinh-khoang-thoi-gian-giua-2-thoi-diem-ham-datedif-trong-excel.html\">H\u00e0m DATEDIF, t\u00ednh kho\u1ea3ng th\u1eddi gian gi\u1eefa 2 th\u1eddi \u0111i\u1ec3m trong Excel<\/a><\/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-601.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6699,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6698","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\/6698","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=6698"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6698\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6699"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6698"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6698"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}