{"id":286114,"date":"2023-11-20T19:14:54","date_gmt":"2023-11-20T12:14:54","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=286114"},"modified":"2023-11-20T19:14:54","modified_gmt":"2023-11-20T12:14:54","slug":"ham-weekday","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Weekday trong Excel chi ti\u1ebft v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t"},"content":{"rendered":"<p><i><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi ng\u01b0\u1eddi l\u00e0m vi\u1ec7c v\u1edbi Microsoft Excel, <\/span><\/i><b><i>h\u00e0m Weekday<\/i><\/b><i><span style=\"font-weight: 400;\"> l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap x\u00e1c \u0111\u1ecbnh ng\u00e0y trong tu\u1ea7n m\u1ed9t c\u00e1ch linh ho\u1ea1t v\u00e0 hi\u1ec7u qu\u1ea3. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft c\u00e1ch t\u1eadn d\u1ee5ng m\u1ed9t c\u00e1ch t\u1ed1i \u01b0u c\u00e1c t\u00ednh n\u0103ng \u0111\u1eb7c bi\u1ec7t h\u00e0m n\u00e0y. B\u1edfi l\u1ebd, Weekday l\u00e0 h\u00e0m s\u1edf h\u1eefu c\u00fa ph\u00e1p v\u00e0 c\u00e1ch tri\u1ec3n khai kh\u00e1 ph\u1ee9c t\u1ea1p. Th\u1ebf nh\u01b0ng, b\u1ea1n s\u1ebd ho\u00e0n to\u00e0n kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y n\u1ebfu theo d\u00f5i c\u00e1c g\u1ee3i \u00fd c\u1ee7a <\/span><\/i><b><i>Ho\u00e0ng H\u00e0 Mobile<\/i><\/b><i><span style=\"font-weight: 400;\"> trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.\u00a0<\/span><\/i><\/p>\n<h2><span style=\"font-weight: 400;\">Nh\u1eefng \u0111i\u1ec1u c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m Weekday tr\u00ean c\u00f4ng c\u1ee5 Excel<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Weekday trong Microsoft Excel \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn l\u00e0 m\u1ed9t h\u00e0m gi\u00fap ng\u01b0\u1eddi th\u1ef1c hi\u1ec7n x\u00e1c \u0111\u1ecbnh ng\u00e0y trong tu\u1ea7n t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3. Hi\u1ec3u \u0111\u01a1n gi\u1ea3n, \u0111\u00e2y l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 nguy\u00ean \u0111\u1ea1i di\u1ec7n cho ng\u00e0y trong tu\u1ea7n (t\u1eeb 1 \u0111\u1ebfn 7). T\u1eeb \u0111\u00f3 gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng ph\u00e2n lo\u1ea1i v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng theo th\u1ee9 t\u1ef1 tu\u1ea7n m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 nhanh ch\u00f3ng.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-286116 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-1.jpg\" alt=\"ham-weekday-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Th\u1eadm ch\u00ed, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c c\u00f4ng vi\u1ec7c kh\u00e1c khi thao t\u00e1c v\u1edbi Excel nh\u01b0:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m Weekday c\u00f3 kh\u1ea3 n\u0103ng gi\u00fap ng\u01b0\u1eddi d\u00f9ng x\u00e1c \u0111\u1ecbnh ng\u00e0y trong tu\u1ea7n c\u1ee7a m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3. \u0110i\u1ec1u n\u00e0y h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n bi\u1ebft ng\u00e0y \u0111\u00f3 l\u00e0 th\u1ee9 m\u1ea5y \u0111\u1ec3 t\u1ed5 ch\u1ee9c c\u00f4ng vi\u1ec7c ho\u1eb7c hi\u1ec3n th\u1ecb th\u00f4ng tin trong c\u00e1c b\u00e1o c\u00e1o.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u ng\u00e0y th\u00e0nh c\u00e1c nh\u00f3m t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c ng\u00e0y trong tu\u1ea7n. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng t\u1ed5 ch\u1ee9c v\u00e0 t\u1ed5ng h\u1ee3p m\u1ecdi d\u1eef li\u1ec7u trong Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Weekday c\u0169ng l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 theo c\u00e1c chu k\u1ef3 ng\u00e0y trong tu\u1ea7n. B\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i xu h\u01b0\u1edbng ho\u1ea1t \u0111\u1ed9ng theo th\u1ee9 t\u1ef1 tu\u1ea7n, \u0111i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch trong l\u0129nh v\u1ef1c kinh doanh v\u00e0 ti\u1ebfp th\u1ecb.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi b\u1ea1n c\u00f3 ng\u00e0y b\u1eaft \u0111\u1ea7u c\u1ee7a m\u1ed9t s\u1ef1 ki\u1ec7n ho\u1eb7c d\u1ef1 \u00e1n, Weekday c\u00f3 th\u1ec3 gi\u00fap d\u1ef1 \u0111o\u00e1n ng\u00e0y trong tu\u1ea7n m\u00e0 s\u1ef1 ki\u1ec7n ho\u1eb7c c\u00f4ng vi\u1ec7c s\u1ebd di\u1ec5n ra, gi\u00fap b\u1ea1n l\u00ean k\u1ebf ho\u1ea1ch m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m Weekday trong c\u00f4ng c\u1ee5 Excel<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u01b0\u1ee3c bi\u1ebft, m\u1ed7i h\u00e0m tr\u00ean c\u00f4ng c\u1ee5 Excel \u0111\u1ec1u s\u1ebd s\u1edf h\u1eefu m\u1ed9t c\u00fa ph\u00e1p tri\u1ec3n khai kh\u00e1c nhau. Do \u0111\u00f3, \u0111\u1ec3 s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3 c\u00e1c h\u00e0m n\u00e0y th\u00ec b\u1eaft bu\u1ed9c b\u1ea1n ph\u1ea3i n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c c\u00e1ch tri\u1ec3n khai c\u00f4ng th\u1ee9c. Th\u1ea5u hi\u1ec3u \u0111i\u1ec1u \u0111\u00f3, n\u1ed9i dung d\u01b0\u1edbi \u0111\u00e2y Ho\u00e0ng H\u00e0 Mobile s\u1ebd g\u1ee3i \u00fd chi ti\u1ebft v\u1ec1 c\u00e1c c\u00e1ch v\u1eadn h\u00e0nh h\u00e0m x\u00e1c \u0111\u1ecbnh ng\u00e0y trong tu\u1ea7n (Weekday) cho b\u1ea1n nh\u01b0 sau:<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p \u0111\u1ec3 tri\u1ec3n khai h\u00e0m Weekday trong Excel<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">V\u1ec1 c\u01a1 b\u1ea3n, Weekday trong c\u00f4ng c\u1ee5 Excel s\u1ebd \u0111\u01b0\u1ee3c tri\u1ec3n khai v\u1edbi m\u1ed9t c\u00fa ph\u00e1p \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: center;\"><b>\u201cWEEKDAY(serial_number, [return_type])\u201d<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Serial_number l\u00e0 ng\u00e0y c\u1ea7n x\u00e1c \u0111\u1ecbnh ng\u00e0y trong tu\u1ea7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">[return_type] l\u00e0 m\u1ed9t tham s\u1ed1 t\u00f9y ch\u1ecdn \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh \u0111\u1ecbnh d\u1ea1ng c\u1ee7a k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 (1 \u0111\u1ebfn 7 ho\u1eb7c 0 \u0111\u1ebfn 6).<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-286117 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-2.jpg\" alt=\"ham-weekday-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 hi\u1ec3u h\u01a1n v\u1ec1 c\u00e1c th\u00e0nh ph\u1ea7n c\u00f3 trong c\u00fa ph\u00e1p th\u1ef1c hi\u1ec7n h\u00e0m x\u00e1c \u0111\u1ecbnh n\u00e0y trong tu\u1ea7n (Weekday), b\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam v\u00ed d\u1ee5 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu ng\u01b0\u1eddi d\u00f9ng nh\u1eadp serial_number = 7 v\u00e0 [return_type] = 1, ngay l\u1eadp t\u1ee9c\u00a0 Weekday s\u1ebd cho ra k\u1ebft qu\u1ea3 c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 7. \u0110\u1ed3ng ngh\u0129a, ng\u00e0y b\u1ea1n \u0111ang c\u1ea7n t\u00ecm l\u00e0 th\u1ee9 7.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu ng\u01b0\u1eddi d\u00f9ng nh\u1eadp serial_number = 7 v\u00e0 [return_type] = 2, h\u00e0m n\u00e0y s\u1ebd nhanh ch\u00f3ng cho ra gi\u00e1 tr\u1ecb 6. Tuy nhi\u00ean, ng\u00e0y b\u1ea1n c\u1ea7n t\u00ecm c\u0169ng s\u1ebd l\u00e0 th\u1ee9 7 theo \u0111\u00fang gi\u00e1 tr\u1ecb ng\u00e0y b\u1ea1n nh\u1eadp trong ph\u1ea7n serial_number.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Cu\u1ed1i c\u00f9ng, n\u1ebfu b\u1ea1n nh\u1eadp serial_number = 7 v\u00e0 [return_type] = 3, h\u00e0m trong Excel n\u00e0y s\u1ebd hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb 5. C\u00f3 ngh\u0129a l\u00e0, n\u00e0y b\u1ea1n c\u1ea7n t\u00ecm v\u1eabn l\u00e0 th\u1ee9 7 nh\u1eefng \u1edf \u0111\u1ecbnh d\u1ea1ng ki\u1ec3u gi\u00e1 tr\u1ecb l\u00e0 5.\u00a0<\/span><\/li>\n<\/ul>\n<h3><span style=\"font-weight: 400;\">C\u00e1c d\u1ea1ng [return_type] ng\u01b0\u1eddi d\u00f9ng hay s\u1eed d\u1ee5ng<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Tham s\u1ed1 c\u1ee7a [return_type] c\u00f3 l\u1ebd l\u00e0 th\u00e0nh ph\u1ea7n g\u00e2y ra s\u1ef1 kh\u00f3 hi\u1ec3u nh\u1ea5t \u0111\u1ecbnh trong c\u00fa ph\u00e1p th\u1ef1c hi\u1ec7n h\u00e0m Weekday. Do \u0111\u00f3, ch\u00fang t\u00f4i c\u0169ng s\u1ebd g\u1ee3i \u00fd cho b\u1ea1n c\u00e1ch m\u00e0 Excel hi\u1ec3u v\u00e0 hi\u1ec3n th\u1ecb ch\u00fang trong n\u1ed9i dung d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p style=\"text-align: center;\"><b>[return_type]<\/b><\/p>\n<\/td>\n<td style=\"text-align: center;\"><b>C\u00e1ch hi\u1ec3n th\u1ecb<\/b><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">=1 ho\u1eb7c tr\u1ed1ng<\/span><\/td>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">Ng\u00e0y 1 s\u1ebd l\u00e0 ch\u1ee7 nh\u1eadt, ng\u00e0y 2 s\u1ebd l\u00e0 th\u1ee9 ba,&#8230; v\u00e0 ng\u00e0y 7 s\u1ebd r\u01a1i v\u00e0o th\u1ee9 b\u1ea3y.<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">= 2<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">Ng\u00e0y 1 s\u1ebd l\u00e0 th\u1ee9 hai, ng\u00e0y 2 s\u1ebd l\u00e0 th\u1ee9 ba,&#8230; v\u00e0 ng\u00e0y 7 s\u1ebd r\u01a1i v\u00e0o ch\u1ee7 nh\u1eadt.<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">= 3<\/span><\/td>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">Ng\u00e0y 0 s\u1ebd l\u00e0 th\u1ee9 hai, ng\u00e0y 1 s\u1ebd l\u00e0 th\u1ee9 ba,&#8230; v\u00e0 ng\u00e0y 6 s\u1ebd r\u01a1i v\u00e0o ch\u1ee7 nh\u1eadt. \u0110\u00e2y l\u00e0 tr\u01b0\u1eddng h\u1ee3p tham s\u1ed1 [return_type] c\u00f3 gi\u00e1 tr\u1ecb t\u1eeb 0 \u0111\u1ebfn 6.<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">= 11<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">Ng\u00e0y 1 s\u1ebd l\u00e0 th\u1ee9 hai, ng\u00e0y 2 s\u1ebd l\u00e0 th\u1ee9 ba,&#8230; v\u00e0 ng\u00e0y 7 s\u1ebd r\u01a1i v\u00e0o ch\u1ee7 nh\u1eadt.<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">= 12<\/span><\/td>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">Ng\u00e0y 1 s\u1ebd l\u00e0 th\u1ee9 ba, ng\u00e0y 2 s\u1ebd l\u00e0 th\u1ee9 t\u01b0,&#8230; v\u00e0 ng\u00e0y 7 s\u1ebd r\u01a1i v\u00e0o th\u1ee9 hai.<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">= 13<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">Ng\u00e0y 1 s\u1ebd l\u00e0 th\u1ee9 t\u01b0, ng\u00e0y 2 s\u1ebd l\u00e0 th\u1ee9 n\u0103m,&#8230; v\u00e0 ng\u00e0y 7 s\u1ebd r\u01a1i v\u00e0o th\u1ee9 ba.<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">= 14<\/span><\/td>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">Ng\u00e0y 1 s\u1ebd l\u00e0 th\u1ee9 n\u0103m, ng\u00e0y 2 s\u1ebd l\u00e0 th\u1ee9 s\u00e1u,&#8230; v\u00e0 ng\u00e0y 7 s\u1ebd r\u01a1i v\u00e0o th\u1ee9 t\u01b0.<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">= 15<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">Ng\u00e0y 1 s\u1ebd l\u00e0 th\u1ee9 s\u00e1u, ng\u00e0y 2 s\u1ebd l\u00e0 th\u1ee9 b\u1ea3y,&#8230; v\u00e0 ng\u00e0y 7 s\u1ebd r\u01a1i v\u00e0o th\u1ee9 n\u0103m.<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-weight: 400;\">= 16<\/span><\/td>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">Ng\u00e0y 1 s\u1ebd l\u00e0 th\u1ee9 b\u1ea3y, ng\u00e0y 2 s\u1ebd l\u00e0 ch\u1ee7 nh\u1eadt,&#8230; v\u00e0 ng\u00e0y 7 s\u1ebd r\u01a1i v\u00e0o th\u1ee9 s\u00e1u.<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">=17<\/span><\/p>\n<\/td>\n<td>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">Ng\u00e0y 1 s\u1ebd l\u00e0 ch\u1ee7 nh\u1eadt, ng\u00e0y 2 s\u1ebd l\u00e0 th\u1ee9 hai,&#8230; v\u00e0 ng\u00e0y 7 s\u1ebd r\u01a1i v\u00e0o th\u1ee9 b\u1ea3y.<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Weekday \u0111\u01a1n gi\u1ea3n trong c\u00f4ng c\u1ee5 Excel<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Th\u1ef1c t\u1ebf, h\u00e0m x\u00e1c \u0111\u1ecbnh ng\u00e0y trong tu\u1ea7n &#8211; Weekday kh\u00f4ng kh\u00f3 \u00e1p d\u1ee5ng nh\u01b0 b\u1ea1n \u0111\u00e3 t\u1eebng ngh\u0129, ch\u1ec9 c\u1ea7n b\u1ea1n n\u1eafm r\u00f5 \u0111\u01b0\u1ee3c c\u00e1ch th\u1ee9c \u0111\u1ec3 v\u1eadn h\u00e0nh v\u00e0 \u00e1p d\u1ee5ng ch\u00fang th\u1eed trong v\u00e0i tr\u01b0\u1eddng h\u1ee3p th\u1ef1c t\u1ebf l\u00e0 c\u00f3 th\u1ec3 thu\u1ea7n th\u1ee5c thao t\u00e1c. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng h\u00e0m n\u00e0y.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec1 b\u00e0i: H\u00e3y s\u1eed d\u1ee5ng h\u00e0m Weekday \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c ng\u00e0y trong tu\u1ea7n trong b\u1ea3ng s\u1ed1 li\u1ec7u sau:<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-286118 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-3.jpg\" alt=\"ham-weekday-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Weekday v\u1edbi h\u00e0m If trong Excel<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 k\u1ebft h\u1ee3p h\u00e0m If v\u00e0 Weekday trong c\u00f4ng c\u1ee5 Excel, b\u1ea1n n\u00ean th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n theo v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<p><b>B\u01b0\u1edbc 1<\/b><span style=\"font-weight: 400;\">: B\u1ea1n n\u00ean \u00e1p d\u1ee5ng h\u00e0m Weekday t\u1ea1i \u00f4 \u0111\u1ea7u ti\u00ean \u1edf c\u1ed9t \u201cTh\u1ee9 d\u1ea1ng s\u1ed1\u201d b\u1eb1ng c\u00e1ch nh\u1eadp c\u00fa ph\u00e1p c\u1ee7a h\u00e0m n\u00e0y. Ch\u1eb3ng h\u1ea1n, c\u00fa ph\u00e1p c\u1ee7a h\u00e0m n\u00e0y l\u00e0 \u201c=Weekday(serial_number,[return_type])\u201d th\u00ec b\u1ea1n s\u1ebd nh\u1eadp t\u01b0\u01a1ng t\u1ef1 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 \u201c=Weekday(B3;1)\u201d.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-286119 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-4.jpg\" alt=\"ham-weekday-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Serial_number: \u00d4 th\u1ec3 hi\u1ec7n ng\u00e0y \u0111\u1ea7u ti\u00ean (v\u00ed d\u1ee5: B3 l\u00e0 ng\u00e0y 5\/19\/2021).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">[return_type]: Ch\u1ecdn ch\u1ec9 s\u1ed1 1 t\u01b0\u01a1ng \u1ee9ng v\u1edbi Ch\u1ee7 Nh\u1eadt ho\u1eb7c b\u1ecf qua n\u1ebfu s\u1eed d\u1ee5ng m\u1eb7c \u0111\u1ecbnh. Trong v\u00ed d\u1ee5 c\u1ee7a ch\u00fang ta, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 b\u1ecf qua ho\u1eb7c c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c ng\u1eafn g\u1ecdn: =Weekday(B3).v\u00ec ch\u1ec9 s\u1ed1 1 \u0111\u01b0\u1ee3c g\u00e1n m\u1eb7c \u0111\u1ecbnh l\u00e0 Ch\u1ee7 nh\u1eadt.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Sau khi ho\u00e0n th\u00e0nh vi\u1ec7c \u0111i\u1ec1n c\u00fa ph\u00e1p nh\u01b0 h\u01b0\u1edbng d\u1eabn th\u00ec b\u1ea1n ti\u1ebfn h\u00e0nh nh\u1ea5n n\u00fat Enter \u0111\u1ec3 h\u1ec7 th\u1ed1ng Excel hi\u1ec3n th\u1ecb k\u1ebft qu\u00e1. N\u1ebfu b\u1ea1n nh\u1eadp \u0111\u00fang c\u00fa ph\u00e1p, k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb gi\u1ed1ng h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-286120 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-5.jpg\" alt=\"ham-weekday-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>B\u01b0\u1edbc 2<\/b><span style=\"font-weight: 400;\">: B\u1ea1n ti\u1ebfp t\u1ee5c d\u00f9ng con tr\u1ecf \u0111\u1ec3 k\u00e9o \u0111\u1ebfn c\u00e1c \u00f4 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng c\u00fa ph\u00e1p. T\u1ea1i \u0111\u00e2y, h\u1ec7 th\u1ed1ng Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt c\u00f4ng th\u1ee9c v\u00e0 cho ra k\u1ebft qu\u1ea3 b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm. Nh\u01b0 v\u1eady, ng\u00e0y ch\u1ee7 nh\u1eadt m\u00e0 b\u1ea1n \u0111ang t\u00ecm s\u1ebd l\u00e0 ng\u00e0y 5\/30\/2021.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-286121 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-6.jpg\" alt=\"ham-weekday-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>B\u01b0\u1edbc 3<\/b><span style=\"font-weight: 400;\">: N\u1ebfu \u0111\u1ec1 b\u00e0i mu\u1ed1n b\u1ea1n chuy\u1ec3n gi\u00e1 tr\u1ecb c\u1ee7a k\u1ebft qu\u1ea3 b\u1eb1ng s\u1ed1 v\u1ec1 d\u1ea1ng ch\u1eef th\u00ec b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng th\u00eam h\u00e0m If theo c\u00fa ph\u00e1p sau:<\/span><\/p>\n<p style=\"text-align: center;\"><b>\u201c=If(Weekday(B3)=1;\u201cCh\u1ee7 nh\u1eadt\u201d;\u201cTh\u1ee9\u201dWeekday(B3))\u201d<\/b><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-286122 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-7.jpg\" alt=\"ham-weekday-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Sau khi \u00e1p d\u1ee5ng c\u00fa ph\u00e1p tr\u00ean, gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 \u0111\u00fang s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-286123 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-8.jpg\" alt=\"ham-weekday-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Weekday v\u1edbi h\u00e0m Choose trong Excel<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Choose trong Excel c\u0169ng l\u00e0 m\u1ed9t h\u00e0m linh ho\u1ea1t trong vi\u1ec7c gi\u00fap tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 d\u1ef1a tr\u00ean v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t chu\u1ed7i gi\u00e1 tr\u1ecb trong b\u1ea3ng d\u1eef li\u1ec7u. H\u00e0m n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng c\u00f9ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea nh\u01b0 h\u00e0m Weekday \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p v\u00e0 truy xu\u1ea5t hi\u1ec7u qu\u1ea3 c\u00e1c d\u1eef li\u1ec7u c\u1ea7n t\u00ecm tr\u00ean Excel.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-286124 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-9.jpg\" alt=\"ham-weekday-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Tuy nhi\u00ean, \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c h\u00e0m Choose th\u00ec b\u1ea1n c\u1ea7n n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c c\u1ea5u tr\u00fac c\u1ee7a h\u00e0m n\u00e0y nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: center;\"><b>\u201c=Choose(index_num, value_1, [value_2],\u2026,[value_n])\u201d<\/b><\/p>\n<p><b>L\u01b0u \u00fd<\/b><span style=\"font-weight: 400;\">: Trong Excel, h\u00e0m Choose s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 d\u1ef1a theo s\u1ed1 index_num m\u00e0 b\u1ea1n \u0111i\u1ec1n trong chu\u1ed7i gi\u00e1 tr\u1ecb t\u1eeb value_1, value_2, \u2026 \u0111\u1ebfn value_n. Song, \u0111\u1ec3 h\u00e0m n\u00e0y \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t th\u00ec ph\u1ea7n index_num ng\u01b0\u1eddi d\u00f9ng c\u1ea7n ph\u1ea3i l\u00e0 nh\u1eadp gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1 nguy\u00ean t\u1eeb 1 \u0111\u1ebfn n.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Theo \u0111\u00f3, n\u1ebfu \u00e1p d\u1ee5ng h\u00e0m Choose k\u1ebft h\u1ee3p v\u1edbi h\u00e0m x\u00e1c \u0111\u1ecbnh ng\u00e0y trong tu\u1ea7n (Weekday) trong v\u00ed d\u1ee5 tr\u00ean th\u00ec b\u1ea1n s\u1ebd \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c nh\u01b0 sau:\u00a0<\/span><\/p>\n<p style=\"text-align: center;\"><b>\u201c=Choose(Weekday(B3); \u201cCh\u1ee7 nh\u1eadt\u201d;\u201cTh\u1ee9 2\u201d;\u201cTh\u1ee9 3\u201d;\u201cTh\u1ee9 4\u201d;\u201cTh\u1ee9 5\u201d;\u201cTh\u1ee9 6\u201d;\u201cTh\u1ee9 7\u201d)\u201d<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Sau khi \u00e1p d\u1ee5ng c\u00fa ph\u00e1p, k\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-286125 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-10.jpg\" alt=\"ham-weekday-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m Weekday<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Th\u1ef1c t\u1ebf, trong qu\u00e1 tr\u00ecnh \u00e1p d\u1ee5ng h\u00e0m x\u00e1c \u0111\u1ecbnh ng\u00e0y trong tu\u1ea7n (Weekday), ng\u01b0\u1eddi d\u00f9ng s\u1ebd hay m\u1ea5t nhi\u1ec1u th\u1eddi gian trong vi\u1ec7c x\u1eed l\u00fd c\u00e1c l\u1ed7i trong thao t\u00e1c nh\u1eadp gi\u00e1 tr\u1ecb. B\u1edfi l\u1ebd, \u0111\u00e2y l\u00e0 h\u00e0m g\u1ed3m nhi\u1ec1u th\u00e0nh ph\u1ea7n v\u00e0 m\u1ed7i th\u00e0nh ph\u1ea7n l\u1ea1i s\u1edf h\u1eefu c\u00e1c y\u00eau c\u1ea7u \u0111\u1eb7c bi\u1ec7t ri\u00eang. Song, b\u1ea1n s\u1ebd ho\u00e0n to\u00e0n h\u1ea1n ch\u1ebf \u0111\u01b0\u1ee3c v\u1ea5n \u0111\u1ec1 n\u00e0y khi tham kh\u1ea3o qua hai l\u1ed7i th\u01b0\u1eddng xuy\u00ean g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m n\u00e0y d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">L\u1ed7i #VALUE!<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng h\u00e0m Weekday, l\u1ed7i #VALUE! s\u1ebd th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n trong tr\u01b0\u1eddng h\u1ee3p nh\u01b0:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gi\u00e1 tr\u1ecb c\u1ee7a ph\u1ea7n serial_number ho\u1eb7c ph\u1ea7n [return_type] tr\u00ean b\u1ea3n d\u1eef li\u1ec7u kh\u00f4ng ph\u1ea3i \u1edf d\u1ea1ng s\u1ed1. V\u00ed d\u1ee5, \u00f4 truy xu\u1ea5t d\u1eef li\u1ec7u c\u00f3 ch\u1ee9a v\u0103n b\u1ea3n v\u00e0 kh\u00f4ng th\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u00e0nh ng\u00e0y.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ng\u00e0y b\u1ea1n mu\u1ed1n t\u00ecm kh\u00f4ng n\u1eb1m trong ph\u1ea1m vi truy xu\u1ea5t c\u1ee7a m\u1ed9t th\u00e1ng. Ch\u1eb3ng h\u1ea1n, c\u00e1c \u00f4 nh\u01b0 32\/12\/2020, 35\/12\/2020 ho\u1eb7c th\u00e0nh ph\u1ea7n [return_type] kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1 nguy\u00ean t\u1eeb 1 \u0111\u1ebfn 17 th\u00ec ng\u01b0\u1eddi d\u00f9ng s\u1ebd kh\u00f4ng th\u1ec3 truy xu\u1ea5t d\u1eef li\u1ec7u.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-286126 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-11.jpg\" alt=\"ham-weekday-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 gi\u1ea3i quy\u1ebft l\u1ed7i #VALUE! trong Excel, ng\u01b0\u1eddi d\u00f9ng n\u00ean ki\u1ec3m tra k\u1ef9 l\u01b0\u1ee1ng \u0111\u1ecbnh d\u1ea1ng c\u1ee7a serial_number v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng ch\u00fang l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1. \u0110\u1ed3ng th\u1eddi, b\u1ea1n x\u00e1c minh r\u1eb1ng [return_type] l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7 t\u1eeb 1 \u0111\u1ebfn 17. N\u1ebfu ng\u00e0y cung c\u1ea5p n\u1eb1m ngo\u00e0i ph\u1ea1m vi th\u00e1ng, h\u00e3y ki\u1ec3m tra l\u1ea1i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh h\u1ee3p l\u1ec7 c\u1ee7a d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">L\u1ed7i #NUM!<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh thao t\u00e1c v\u1edbi h\u00e0m t\u00ednh Weekday, l\u1ed7i #NUM! xu\u1ea5t hi\u1ec7n khi ph\u1ea7n [return_type] \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh nh\u01b0ng trong b\u1ea3ng d\u1eef li\u1ec7u th\u00ec ch\u00fang kh\u00f4ng ph\u1ea3i l\u00e0 gi\u00e1 tr\u1ecb t\u1eeb 1 \u0111\u1ebfn 3 ho\u1eb7c 11 \u0111\u1ebfn 17. Ch\u1eb3ng h\u1ea1n, khi ph\u1ea7n [return_type] c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 0, 4, 5, 6, 7, 8, 9 ho\u1eb7c 10 thi h\u1ec7 th\u1ed1ng Excel s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i #NUM! ngay l\u1eadp t\u1ee9c.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-weekday-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-286127 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-12.jpg\" alt=\"ham-weekday-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, \u0111\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n ki\u1ec3m tra k\u1ef9 l\u01b0\u1ee1ng ph\u1ea7n [return_type] sao cho ch\u00fang ph\u1ea3i l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7 t\u1eeb 1 \u0111\u1ebfn 3 ho\u1eb7c 11 \u0111\u1ebfn 17. N\u1ebfu kh\u00f4ng mu\u1ed1n ch\u1ec9 \u0111\u1ecbnh [return_type], b\u1ea1n n\u00ean \u0111\u1ec3 h\u00e0m s\u1eed d\u1ee5ng gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh \u0111\u1ec3 ch\u1eafc ch\u1eafn r\u1eb1ng kh\u00f4ng c\u00f3 b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o kh\u00f4ng h\u1ee3p l\u1ec7 khi s\u1eed d\u1ee5ng h\u00e0m x\u00e1c \u0111\u1ecbnh ng\u00e0y trong tu\u1ea7n n\u00e0y.<\/span><\/p>\n<h2>L\u1eddi k\u1ebft<\/h2>\n<p><i><span style=\"font-weight: 400;\">\u0110\u00f3 l\u00e0 nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi b\u1ea1n thao t\u00e1c v\u1edbi <\/span><\/i><b><i>h\u00e0m Weekday<\/i><\/b><i><span style=\"font-weight: 400;\"> tr\u00ean c\u00f4ng c\u1ee5 Excel m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o. Mong r\u1eb1ng, c\u00e1c g\u1ee3i \u00fd c\u1ee7a <\/span><\/i><b><i>Ho\u00e0ng H\u00e0 Mobile<\/i><\/b><i><span style=\"font-weight: 400;\"> trong b\u00e0i vi\u1ebft tr\u00ean s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 v\u1ec1 c\u00e1ch th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m \u0111\u1eb7c bi\u1ec7t n\u00e0y. T\u1eeb \u0111\u00f3, nhanh ch\u00f3ng gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c c\u00e1c nhi\u1ec7m v\u1ee5 trong qu\u00e1 l\u00e0m vi\u1ec7c h\u1ecdc t\u1eadp v\u00e0 l\u00e0m vi\u1ec7c l\u00e0m c\u1ee7a m\u00ecnh. Ngo\u00e0i ra, n\u1ebfu b\u1ea1n th\u1eafc m\u1eafc v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y b\u00ean hay mu\u1ed1n ch\u00fang t\u00f4i tr\u00ecnh b\u00e0y nhi\u1ec1u h\u01a1n v\u1ec1 c\u00e1c k\u1ebft h\u1ee3p Weekday v\u1edbi c\u00e1c h\u00e0m kh\u00e1c th\u00ec h\u00e3y \u0111\u1ec3 l\u1ea1i nhu c\u1ea7u c\u1ea7u c\u1ee7a m\u00ecnh b\u00ean d\u01b0\u1edbi \u0111\u1ec3 ch\u00fang t\u00f4i l\u00e0m ti\u1ebfp trong b\u00e0i vi\u1ebft sau nh\u00e9!<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">XEM TH\u00caM<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-max\/\">C\u00e1ch d\u00f9ng h\u00e0m MIN, MAX trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 hi\u1ec3u nh\u1ea5t<\/a><\/strong><\/li>\n<li style=\"font-weight: 400;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-subtotal\/\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUBTOTAL trong Excel d\u1ec5 hi\u1ec3u k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda<\/a><\/strong><\/li>\n<li style=\"font-weight: 400;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-and-trong-excel\/\">H\u00e0m AND trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 chi ti\u1ebft<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u0110\u1ed1i v\u1edbi ng\u01b0\u1eddi l\u00e0m vi\u1ec7c v\u1edbi Microsoft Excel, h\u00e0m Weekday l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap x\u00e1c \u0111\u1ecbnh ng\u00e0y trong tu\u1ea7n m\u1ed9t c\u00e1ch linh ho\u1ea1t v\u00e0 hi\u1ec7u qu\u1ea3. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft c\u00e1ch t\u1eadn d\u1ee5ng m\u1ed9t c\u00e1ch t\u1ed1i \u01b0u c\u00e1c t\u00ednh n\u0103ng \u0111\u1eb7c bi\u1ec7t h\u00e0m n\u00e0y. B\u1edfi l\u1ebd, Weekday l\u00e0 h\u00e0m [&hellip;]<\/p>\n","protected":false},"author":101,"featured_media":286906,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-286114","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Weekday trong Excel chi ti\u1ebft v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"H\u00e0m Weekday l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap x\u00e1c \u0111\u1ecbnh ng\u00e0y th\u00e1ng m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. B\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang trong b\u00e0i vi\u1ebft sau.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Weekday trong Excel chi ti\u1ebft v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m Weekday l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap x\u00e1c \u0111\u1ecbnh ng\u00e0y th\u00e1ng m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. B\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang trong b\u00e0i vi\u1ebft sau.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-20T12:14:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-13.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8e2486d5b72154b4200037e1bf6c063d\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Weekday trong Excel chi ti\u1ebft v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t\",\"datePublished\":\"2023-11-20T12:14:54+00:00\",\"dateModified\":\"2023-11-20T12:14:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/\"},\"wordCount\":3087,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-13.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/\",\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Weekday trong Excel chi ti\u1ebft v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-13.jpg\",\"datePublished\":\"2023-11-20T12:14:54+00:00\",\"dateModified\":\"2023-11-20T12:14:54+00:00\",\"description\":\"H\u00e0m Weekday l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap x\u00e1c \u0111\u1ecbnh ng\u00e0y th\u00e1ng m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. B\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang trong b\u00e0i vi\u1ebft sau.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-13.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-13.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-weekday\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Weekday trong Excel chi ti\u1ebft v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8e2486d5b72154b4200037e1bf6c063d\",\"name\":\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2d2d280f97630fa8c32ae987d44b99e6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2d2d280f97630fa8c32ae987d44b99e6?s=96&d=mm&r=g\",\"caption\":\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-hieu\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Weekday trong Excel chi ti\u1ebft v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t","description":"H\u00e0m Weekday l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap x\u00e1c \u0111\u1ecbnh ng\u00e0y th\u00e1ng m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. B\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang trong b\u00e0i vi\u1ebft sau.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Weekday trong Excel chi ti\u1ebft v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t","og_description":"H\u00e0m Weekday l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap x\u00e1c \u0111\u1ecbnh ng\u00e0y th\u00e1ng m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. B\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang trong b\u00e0i vi\u1ebft sau.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-11-20T12:14:54+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-13.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"15 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/"},"author":{"name":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8e2486d5b72154b4200037e1bf6c063d"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Weekday trong Excel chi ti\u1ebft v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t","datePublished":"2023-11-20T12:14:54+00:00","dateModified":"2023-11-20T12:14:54+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/"},"wordCount":3087,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-13.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/","name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Weekday trong Excel chi ti\u1ebft v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-13.jpg","datePublished":"2023-11-20T12:14:54+00:00","dateModified":"2023-11-20T12:14:54+00:00","description":"H\u00e0m Weekday l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap x\u00e1c \u0111\u1ecbnh ng\u00e0y th\u00e1ng m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. B\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang trong b\u00e0i vi\u1ebft sau.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-13.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-weekday-13.jpg","width":1200,"height":628,"caption":"ham-weekday"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-weekday\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Weekday trong Excel chi ti\u1ebft v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8e2486d5b72154b4200037e1bf6c063d","name":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2d2d280f97630fa8c32ae987d44b99e6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2d2d280f97630fa8c32ae987d44b99e6?s=96&d=mm&r=g","caption":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-hieu\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/286114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/101"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=286114"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/286114\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/286906"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=286114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=286114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=286114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}