{"id":1831,"date":"2024-12-02T06:11:18","date_gmt":"2024-12-02T06:11:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/su-dung-advanced-filter-de-loc-ra-cac-ngay-cuoi-tuan\/"},"modified":"2024-12-02T06:11:18","modified_gmt":"2024-12-02T06:11:18","slug":"su-dung-advanced-filter-de-loc-ra-cac-ngay-cuoi-tuan","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/su-dung-advanced-filter-de-loc-ra-cac-ngay-cuoi-tuan\/","title":{"rendered":"S\u1eed d\u1ee5ng Advanced Filter \u0111\u1ec3 l\u1ecdc ra c\u00e1c ng\u00e0y cu\u1ed1i tu\u1ea7n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong c\u00f4ng vi\u1ec7c\u00a0\u0111\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng ai l\u00e0m trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n hay nh\u00e2n s\u1ef1 th\u00ec ta th\u01b0\u1eddng xuy\u00ean ph\u1ea3i x\u1eed l\u00fd\u00a0v\u1edbi ki\u1ec3u d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng, vi\u1ec7c x\u00e1c\u00a0\u0111\u1ecbnh th\u1ee9, ng\u00e0y, th\u00e1ng,\u2026 trong\u00a0Excel th\u01b0\u1eddng g\u1eb7p r\u1eafc r\u1ed1i, g\u00e2y c\u1ea3n tr\u1edf kh\u00f4ng\u00a0\u00edt trong c\u00f4ng vi\u1ec7c.<\/em><\/p>\n<p style=\"text-align: justify\">B\u00e0i vi\u1ebft n\u00e0y c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> xin gi\u1edbi thi\u1ec7u c\u00e1ch l\u1ea5y ra danh s\u00e1ch c\u00e1c ng\u00e0y cu\u1ed1i tu\u1ea7n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 <a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html\"><strong>Advanced Filter<\/strong><\/a> trong\u00a0Excel.<\/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-674d4f85b44ee\" 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\/su-dung-advanced-filter-de-loc-ra-cac-ngay-cuoi-tuan.html#Nhac_lai_ve_ham_WEEKDAY\" title=\"Nh\u1eafc l\u1ea1i v\u1ec1 h\u00e0m\u00a0WEEKDAY\">Nh\u1eafc l\u1ea1i v\u1ec1 h\u00e0m\u00a0WEEKDAY<\/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\/su-dung-advanced-filter-de-loc-ra-cac-ngay-cuoi-tuan.html#Loc_ra_danh_sach_cac_ngay_cuoi_tuan_bang_Advanced_Filter\" title=\"L\u1ecdc ra danh s\u00e1ch c\u00e1c ng\u00e0y cu\u1ed1i tu\u1ea7n b\u1eb1ng\u00a0\u00a0Advanced Filter\">L\u1ecdc ra danh s\u00e1ch c\u00e1c ng\u00e0y cu\u1ed1i tu\u1ea7n b\u1eb1ng\u00a0\u00a0Advanced Filter<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Nhac_lai_ve_ham_WEEKDAY\"><\/span>Nh\u1eafc l\u1ea1i v\u1ec1 h\u00e0m\u00a0WEEKDAY<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu nh\u01b0 b\u1ea1n\u00a0\u0111\u00e3 c\u00f3 ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u1ec1\u00a0Excel th\u00ec ch\u1eafc h\u1eb3n kh\u00f4ng c\u00f2n xa l\u1ea1 g\u00ec v\u1edbi h\u00e0m n\u00e0y n\u1eefa r\u1ed3i. h\u00e0m\u00a0WEEKDAY\u00a0 tr\u1ea3 v\u1ec1 th\u1ee9 c\u1ee7a ng\u00e0y trong tu\u1ea7n v\u1edbi c\u00fa ph\u00e1p v\u00e0 c\u00e1c tham s\u1ed1 nh\u01b0 sau:<\/p>\n<blockquote>\n<p style=\"text-align: center\"><strong>WEEKDAY(serial_number,return_type)<\/strong><\/p>\n<\/blockquote>\n<ul style=\"list-style-type: disc\">\n<li><strong>serial_number:<\/strong> l\u00e0 m\u1ed9t bi\u1ec3u th\u1ee9c th\u1eddi gian m\u00e0 b\u1ea1n mu\u1ed1n x\u00e1c\u00a0\u0111\u1ecbnh th\u1ee9<\/li>\n<li><strong>return_type:<\/strong> l\u00e0 m\u1ed9t s\u1ed1, s\u1ed1 n\u00e0y s\u1ebd x\u00e1c\u00a0\u0111\u1ecbnh ki\u1ec3u tr\u1ea3 v\u1ec1 c\u1ee7a th\u1ee9<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-28419\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-9-1024x314-1.png\" width=\"1024\" height=\"314\" title=\"1-9-1024x314-1\"><\/p>\n<p>\u00a0<\/p>\n<p>\u0110\u1ec3 gi\u00fap hi\u1ec3u k\u1ef9 h\u01a1n v\u1ec1 h\u00e0m n\u00e0y H\u1ecdc Excel Online xin \u0111\u1ec3 link b\u00e0i v\u1ec1 v\u1ec1 h\u00e0m\u00a0WEEKDAY t\u1ea1i\u00a0\u0111\u00e2y:<\/p>\n<blockquote>\n<p style=\"text-align: center\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-weekday-trong-excel.html\">C\u00e1ch d\u00f9ng h\u00e0m\u00a0WEEKDAY trong\u00a0Excel<\/a><\/strong><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Loc_ra_danh_sach_cac_ngay_cuoi_tuan_bang_Advanced_Filter\"><\/span>L\u1ecdc ra danh s\u00e1ch c\u00e1c ng\u00e0y cu\u1ed1i tu\u1ea7n b\u1eb1ng\u00a0\u00a0Advanced Filter<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0WEEKDAY\u00a0\u0111\u1ec3 l\u00e0m v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n trong Advanced Filter, ch\u00fang ta s\u1ebd l\u1ea5y ra c\u00e1c ng\u00e0y cu\u1ed1i tu\u1ea7n nh\u01b0 VD sau\u00a0\u0111\u00e2y:<\/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-132.gif\" title=\"ex101_92019-nho-132\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">\u0110\u1ed1i s\u1ed1 th\u1ee9 2 (return_type) c\u1ee7a h\u00e0m\u00a0WEEKDAY ta\u00a0\u0111\u1ec3 l\u00e0 2 (<em>t\u1ee9c ng\u00e0y th\u1ee9 2 s\u1ebd l\u00e0 1, th\u1ee9 3 s\u1ebd l\u00e0 2,\u2026.v\u00e0 Ch\u1ee7 nh\u1eadt s\u1ebd l\u00e0 7<\/em>). V\u1edbi\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0<strong>WEEKDAY(B5,2)&gt;=6<\/strong> th\u00ec\u00a0Excel s\u1ebd l\u1ecdc ra t\u1ea5t c\u1ea3 nh\u1eefng ng\u00e0y cu\u1ed1i tu\u1ea7n (Th\u1ee9 7 v\u00e0 Ch\u1ee7 nh\u1eadt).<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/07\/2-10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-28421\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-10-1024x550-1.png\" width=\"1024\" height=\"550\" title=\"2-10-1024x550-1\"><\/a><\/p>\n<p style=\"text-align: justify\">Qua v\u00ed d\u1ee5\u00a0\u0111\u01a1n gi\u1ea3n tr\u00ean, H\u1ecdc\u00a0Excel Online hy v\u1ecdng b\u1ea1n\u00a0\u0111\u00e3 n\u1eafm\u00a0\u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 l\u1ecdc n\u00e2ng cao trong\u00a0Excel\u00a0\u0111\u1ec3 l\u1ea5y ra danh s\u00e1ch c\u00e1c ng\u00e0y cu\u1ed1i tu\u1ea7n. Ngo\u00e0i ra b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 tu\u1ef3 bi\u1ebfn th\u00eam b\u1eb1ng c\u00e1ch t\u1ea1o ra c\u00e1c c\u1ed9t ph\u1ee5 ho\u1eb7c c\u0169ng s\u1eed d\u1ee5ng h\u00e0m\u00a0WEEKDAY nh\u01b0ng v\u1edbi \u0111\u1ed1i s\u1ed1 th\u1ee9 2 kh\u00e1c \u0111i VD tr\u00ean \u0111\u1ec3 c\u00f3 th\u1ec3 hi\u1ec3u s\u00e2u h\u01a1n v\u00e0 ng\u00e0y c\u00e0ng n\u00e2ng cao k\u1ef9 n\u0103ng Excel cho b\u1ea3n th\u00e2n g\u00f3p ph\u1ea7n l\u00e0m t\u0103ng hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p>\n<hr>\n<p>\u00a0<\/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-132.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1832,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1831","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\/1831","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=1831"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1831\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1832"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1831"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1831"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}