{"id":571,"date":"2024-12-02T02:30:15","date_gmt":"2024-12-02T02:30:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/xac-dinh-ngay-bat-ky-la-thu-may-trong-tuan\/"},"modified":"2024-12-02T02:30:15","modified_gmt":"2024-12-02T02:30:15","slug":"xac-dinh-ngay-bat-ky-la-thu-may-trong-tuan","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/xac-dinh-ngay-bat-ky-la-thu-may-trong-tuan\/","title":{"rendered":"X\u00e1c \u0111\u1ecbnh ng\u00e0y b\u1ea5t k\u1ef3 l\u00e0 th\u1ee9 m\u1ea5y trong tu\u1ea7n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>B\u1ea1n s\u1ebd l\u00e0m th\u1ebf n\u00e0o khi g\u1eb7p nh\u1eefng v\u1ea5n\u00a0\u0111\u1ec1 sau:<\/p>\n<ul style=\"list-style-type: circle\">\n<li>Khi mu\u1ed1n bi\u1ebft 1 ng\u00e0y b\u1ea5t k\u1ef3 l\u00e0 th\u1ee9 m\u1ea5y trong tu\u1ea7n\u00a0ch\u1ec9 c\u00f3 m\u1ed7i c\u00f4ng c\u1ee5 duy nh\u1ea5t l\u00e0\u00a0excel?<\/li>\n<li>Khi l\u1eadp b\u1ea3ng ch\u1ea5m c\u00f4ng v\u00e0 mu\u1ed1n bi\u1ebft t\u1eebng ng\u00e0y trong th\u00e1ng l\u00e0 th\u1ee9 m\u1ea5y?<\/li>\n<li>Khi c\u00f3 ai\u00a0\u0111\u00f3 h\u1ecfi \u201cd\u00f9ng h\u00e0m\u00a0excel n\u00e0o\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh th\u1ee9 trong tu\u1ea7n\u201d?<\/li>\n<\/ul>\n<p>B\u00e0i vi\u1ebft n\u00e0y c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Onine<\/strong><\/a> s\u1ebd gi\u00fap b\u1ea1n tr\u1ea3 l\u1eddi nh\u1eefng c\u00e2u h\u1ecfi tr\u00ean.<\/p>\n<p><strong>1, <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-weekday-trong-excel.html\">H\u00e0m\u00a0WEEKDAY<\/a><\/strong><\/p>\n<figure id=\"attachment_10363\" aria-describedby=\"caption-attachment-10363\" style=\"width: 496px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-10363 size-full\" title=\"1 - h\u00e0m \u0111\u1ed5i ng\u00e0y sang th\u1ee9\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic01-hc3a0m-weekday.png\" alt=\"1 - h\u00e0m \u0111\u1ed5i ng\u00e0y sang th\u1ee9\" width=\"496\" height=\"368\"><figcaption id=\"caption-attachment-10363\" class=\"wp-caption-text\">1 \u2013 h\u00e0m \u0111\u1ed5i ng\u00e0y sang th\u1ee9<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<p>\u0110\u1ed1i t\u01b0\u1ee3ng Serial_number trong<a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-weekday-trong-excel.html\"> h\u00e0m\u00a0WEEKDAY<\/a> ch\u00ednh l\u00e0\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng ng\u00e0y m\u00e0 ch\u00fang ta c\u1ea7n x\u00e1c\u00a0\u0111\u1ecbnh th\u1ee9.<\/p>\n<p>\u0110\u1ed1i t\u01b0\u1ee3ng Return_type l\u00e0 c\u00e1c d\u1ea1ng k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a h\u00e0m\u00a0WEEKDAY. V\u00ec m\u1ed7i n\u01a1i l\u1ea1i c\u00f3 c\u00e1ch quy\u00a0\u01b0\u1edbc kh\u00e1c nhau, n\u00ean\u00a0excel h\u1ed7 tr\u1ee3 r\u1ea5t nhi\u1ec1u d\u1ea1ng quy\u00a0\u01b0\u1edbc v\u1ec1 th\u1ee9.\u00a0\u1ede\u00a0\u0111\u00e2y m\u00ecnh m\u00f4 t\u1ea3 3 d\u1ea1ng ph\u1ed5 bi\u1ebfn:<\/p>\n<figure id=\"attachment_10364\" aria-describedby=\"caption-attachment-10364\" style=\"width: 496px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-10364 size-full\" title=\"2 - h\u00e0m \u0111\u1ed5i ng\u00e0y sang th\u1ee9\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic02-hc3a0m-weekday-return-type.png\" alt=\"2 - h\u00e0m \u0111\u1ed5i ng\u00e0y sang th\u1ee9\" width=\"496\" height=\"203\"><figcaption id=\"caption-attachment-10364\" class=\"wp-caption-text\">2 \u2013 h\u00e0m \u0111\u1ed5i ng\u00e0y sang th\u1ee9<\/figcaption><\/figure>\n<p>D\u1ea1ng 1 l\u00e0 d\u1ea1ng m\u1eb7c\u00a0\u0111\u1ecbnh trong <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-weekday-trong-excel.html\">h\u00e0m\u00a0WEEKDAY<\/a> (t\u1ee9c l\u00e0 n\u1ebfu b\u1ea1n kh\u00f4ng nh\u1eadp c\u1ee5 th\u1ec3 gi\u00e1 tr\u1ecb Return_type th\u00ec h\u00e0m t\u1ef1\u00a0\u0111\u1ed9ng hi\u1ec3u theo Return_type = 1<\/p>\n<p>Tuy nhi\u00ean v\u1edbi h\u00e0m n\u00e0y, ch\u00fang ta v\u1eabn ch\u01b0a th\u1ea5y\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u00fang c\u00e1i ch\u00fang ta c\u1ea7n, v\u00ec \u201cTh\u1ee9\u201d ch\u00fang ta th\u01b0\u1eddng coi n\u00f3\u00a0\u1edf d\u1ea1ng \u201cCh\u1eef \/ Text\u201d ch\u1ee9 kh\u00f4ng ph\u1ea3i d\u1ea1ng \u201cS\u1ed1 \/ Number\u201d nh\u01b0 h\u00e0m\u00a0WEEKDAY mang l\u1ea1i.<\/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-28.gif\" title=\"ex101_92019-nho-28\"><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-5.gif\" title=\"vba101_92019-nho-5\"><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-28.gif\" title=\"ex101_92019-nho-28\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>V\u00ec v\u1eady ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u ti\u1ebfp v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/ham-choose-trong-excel.html\">h\u00e0m CHOOSE<\/a>\u00a0\u0111\u1ec3 k\u1ebft h\u01a1p v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-weekday-trong-excel.html\">h\u00e0m\u00a0WEEKDAY<\/a><\/p>\n<p><strong>2.\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-choose-trong-excel.html\">H\u00e0m CHOOSE<\/a><\/strong><\/p>\n<figure id=\"attachment_10365\" aria-describedby=\"caption-attachment-10365\" style=\"width: 1213px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-10365 size-full\" title=\"3 - h\u00e0m \u0111\u1ed5i ng\u00e0y sang th\u1ee9\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic03-hc3a0m-choose-01.png\" alt=\"3 - h\u00e0m \u0111\u1ed5i ng\u00e0y sang th\u1ee9\" width=\"1213\" height=\"425\"><figcaption id=\"caption-attachment-10365\" class=\"wp-caption-text\">3 \u2013 h\u00e0m \u0111\u1ed5i ng\u00e0y sang th\u1ee9<\/figcaption><\/figure>\n<p>Do <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-weekday-trong-excel.html\">h\u00e0m\u00a0WEEKDAY<\/a> tr\u1ea3 v\u1ec1 c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb 1\u00a0\u0111\u1ebfn 7, v\u00ec v\u1eady <a href=\"http:\/\/blog.ezworkapp.com\/ham-choose-trong-excel.html\">h\u00e0m CHOOSE<\/a> s\u1ebd c\u00f3 t\u01b0\u01a1ng\u00a0\u1ee9ng 7\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng value<\/p>\n<p>C\u00e1c b\u1ea1n ho\u00e0n\u00a0to\u00e0n c\u00f3 th\u1ec3\u00a0\u0111\u01b0a c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng value1 = $I$4 thay th\u1ebf b\u1eb1ng \u201cCh\u1ee7 nh\u1eadt\u201d<\/p>\n<p>value2 = $J$4 thay th\u1ebf b\u1eb1ng \u201cTh\u1ee9 hai\u201d\u2026<\/p>\n<p>* Ch\u00fa\u00a0\u00fd 1: v\u1edbi h\u00e0m\u00a0Weekday s\u1eed d\u1ee5ng Return_type = 2 th\u00ec ph\u1ea3i\u00a0\u00e1p d\u1ee5ng h\u00e0m Choose nh\u01b0 sau:<\/p>\n<figure id=\"attachment_10366\" aria-describedby=\"caption-attachment-10366\" style=\"width: 1221px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-10366 size-full\" title=\"4 - h\u00e0m \u0111\u1ed5i ng\u00e0y sang th\u1ee9\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic03-hc3a0m-choose-02.png\" alt=\"4 - h\u00e0m \u0111\u1ed5i ng\u00e0y sang th\u1ee9\" width=\"1221\" height=\"433\"><figcaption id=\"caption-attachment-10366\" class=\"wp-caption-text\">4 \u2013 h\u00e0m \u0111\u1ed5i ng\u00e0y sang th\u1ee9<\/figcaption><\/figure>\n<p>* Ch\u00fa\u00a0\u00fd 2: v\u1edbi h\u00e0m\u00a0Weekday s\u1eed d\u1ee5ng Return_type =\u00a03 th\u00ec ph\u1ea3i\u00a0\u00e1p d\u1ee5ng h\u00e0m Choose nh\u01b0 sau:<\/p>\n<figure id=\"attachment_10367\" aria-describedby=\"caption-attachment-10367\" style=\"width: 1283px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-10367 size-full\" title=\"5 - h\u00e0m \u0111\u1ed5i ng\u00e0y sang th\u1ee9\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic03-hc3a0m-choose-03.png\" alt=\"5 - h\u00e0m \u0111\u1ed5i ng\u00e0y sang th\u1ee9\" width=\"1283\" height=\"433\"><figcaption id=\"caption-attachment-10367\" class=\"wp-caption-text\">5 \u2013 h\u00e0m \u0111\u1ed5i ng\u00e0y sang th\u1ee9<\/figcaption><\/figure>\n<p>V\u00ec <a href=\"http:\/\/blog.ezworkapp.com\/ham-choose-trong-excel.html\">H\u00e0m Choose<\/a> b\u1eaft\u00a0\u0111\u1ea7u t\u1eeb gi\u00e1 tr\u1ecb 1, n\u00ean khi index_num = 0 (tr\u01b0\u1eddng h\u1ee3p h\u00e0m\u00a0Weekday\u00a0\u00e1p d\u1ee5ng Return_type = 3) s\u1ebd g\u00e2y ra l\u1ed7i kh\u00f4ng x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>Do\u00a0\u0111\u00f3\u00a0\u0111\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i, ch\u00fang ta c\u1ea7n bi\u1ec7n lu\u1eadn tr\u01b0\u1edbc tr\u01b0\u1eddng h\u1ee3p k\u1ebft qu\u1ea3 h\u00e0m\u00a0Weekday = 0, sau\u00a0\u0111\u00f3 d\u00f9ng h\u00e0m Choose(Weekday(\u2026)) nh\u01b0 b\u00ecnh th\u01b0\u1eddng<\/p>\n<p>\u2014\u2013<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 n\u00e2ng cao k\u1ef9 n\u0103ng\u00a0Excel trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, nh\u00e2n s\u1ef1,\u00a0c\u00e1c b\u1ea1n c\u00f3 th\u1ec3\u00a0tham gia kh\u00f3a h\u1ecdc<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/tl01-tu-tao-phan-mem-quan-ly-tien-luong-nhan-su-cham-cong-tren-excel-va-vba\">TL01 \u2013\u00a0\u1ee9ng d\u1ee5ng\u00a0EXCEL VBA trong TI\u1ec0N L\u01af\u01a0NG \u2013 NH\u00c2N S\u1ef0<\/a><\/p>\n<p>kh\u00f3a h\u1ecdc s\u1ebd cung c\u1ea5p cho b\u1ea1n nh\u1eefng ki\u1ebfn th\u1ee9c v\u1ec1 c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, h\u00e0nh ch\u00ednh, nh\u00e2n s\u1ef1 trong th\u1ef1c t\u1ebf v\u00e0 c\u00e1c k\u1ef9 n\u0103ng\u00a0excel k\u1ebft h\u1ee3p v\u1edbi VBA\u00a0\u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c, t\u1ed1i\u00a0\u01b0u hi\u1ec7u su\u1ea5t c\u1ee7a b\u1ea1n.<\/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-28.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":572,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-571","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\/571","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=571"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/571\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/572"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}