{"id":1611,"date":"2020-10-23T01:15:17","date_gmt":"2020-10-22T18:15:17","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1611"},"modified":"2020-10-23T01:15:19","modified_gmt":"2020-10-22T18:15:19","slug":"ham-weekday-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/ham-weekday-trong-excel\/","title":{"rendered":"C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m WEEKDAY Trong Excel V\u00e0 V\u00ed D\u1ee5 Chi Ti\u1ebft"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1611\" class=\"elementor elementor-1611\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-12679fb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"12679fb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bb2dc65\" data-id=\"bb2dc65\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-25e0f71 elementor-widget elementor-widget-heading\" data-id=\"25e0f71\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><i><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 16px; text-align: justify;\">H\u00e0m WEEKDAY l\u00e0 g\u00ec? T\u1ea1i sao ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m WEEKDAY?<\/span><\/i><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a91649d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a91649d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9192657\" data-id=\"9192657\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-514f70d elementor-widget elementor-widget-text-editor\" data-id=\"514f70d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-4c21e7cb-7fff-d8d4-a2b0-0ac9f0313e25\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng trong Excel, nhi\u1ec1u l\u00fac b\u1ea1n c\u1ea7n x\u1eed l\u00fd d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng \u0111\u00f3 l\u00e0 th\u1ee9 m\u1ea5y trong tu\u1ea7n, v\u00ed d\u1ee5 nh\u01b0 trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n, nh\u00e0 cung c\u1ea5p c\u1ee7a b\u1ea1n quy \u0111\u1ecbnh n\u1ebfu ng\u00e0y \u0111\u1ebfn h\u1ea1n thanh to\u00e1n h\u00f3a \u0111\u01a1n l\u00e0 ng\u00e0y th\u1ee9 b\u1ea3y, ch\u1ee7 nh\u1eadt th\u00ec c\u00f4ng ty b\u1ea1n ph\u1ea3i thanh to\u00e1n v\u00e0o ng\u00e0y th\u1ee9 s\u00e1u tr\u01b0\u1edbc \u0111\u00f3,&#8230;<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0357c98 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0357c98\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c551432\" data-id=\"c551432\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dded483 elementor-widget elementor-widget-text-editor\" data-id=\"dded483\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">B\u1ea1n c\u00f3 th\u1ec3 x\u1eed l\u00fd nhanh t\u00ecnh hu\u1ed1ng n\u00e0y b\u1eb1ng c\u00e1ch ki\u1ec3m tra l\u1ecbch. Tuy nhi\u00ean \u0111\u1ec3 l\u1eadp k\u1ebf ho\u1ea1ch thanh to\u00e1n v\u1edbi h\u00e0ng tr\u0103m, h\u00e0ng ngh\u00ecn h\u00f3a \u0111\u01a1n, th\u00ec s\u1eed d\u1ee5ng h\u00e0m Excel \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ng\u00e0y th\u1ee9 b\u1ea3y, ch\u1ee7 nh\u1eadt ti\u1ec7n \u00edch h\u01a1n r\u1ea5t nhi\u1ec1u.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4920c0a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4920c0a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d996449\" data-id=\"d996449\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b606904 elementor-widget elementor-widget-text-editor\" data-id=\"b606904\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-35f0eb98-7fff-35b3-d039-207510f51b10\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m WEEKDAY trong Excel gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00f4ng vi\u1ec7c quy \u0111\u1ed5i ng\u00e0y th\u00e1ng sang th\u1ee9 trong tu\u1ea7n.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-872aa7d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"872aa7d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-dda129d\" data-id=\"dda129d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-285fdae elementor-widget elementor-widget-heading\" data-id=\"285fdae\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-8e5df2bc-7fff-55dd-fcc5-ecb80bbd4ab7\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1, C\u00fa Ph\u00e1p H\u00e0m WEEKDAY<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-35bf3f8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"35bf3f8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c4cd25b\" data-id=\"c4cd25b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9de250d elementor-widget elementor-widget-text-editor\" data-id=\"9de250d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m WEEKDAY trong Excel l\u00e0 h\u00e0m t\u00ednh th\u1ee9 trong tu\u1ea7n, tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 1 s\u1ed1 nguy\u00ean d\u01b0\u01a1ng, c\u00f3 c\u00fa ph\u00e1p:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-weight: bold; white-space: pre-wrap;\">=WEEKDAY(serial_number, [return_type])<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-aa6d56c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"aa6d56c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b631208\" data-id=\"b631208\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bcc39f4 elementor-widget elementor-widget-text-editor\" data-id=\"bcc39f4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-0968be32-7fff-9602-02a8-34d48839de68\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Trong \u0111\u00f3:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c8e7f00 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c8e7f00\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fb12cc0\" data-id=\"fb12cc0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-409b88e elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"409b88e\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-chevron-circle-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-e56c6b94-7fff-4bb8-d38f-a01f09ba766c\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Serial_number<\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">:&nbsp; \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c, ng\u00e0y th\u00e1ng n\u0103m m\u00e0 b\u1ea1n c\u1ea7n ki\u1ec3m tra ng\u00e0y \u0111\u00f3 l\u00e0 th\u1ee9 m\u1ea5y trong tu\u1ea7n.<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-db9cd5b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"db9cd5b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-20aa1af\" data-id=\"20aa1af\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-531c3b5 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"531c3b5\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-chevron-circle-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-bc306b27-7fff-73df-15c4-1ec8bd204890\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Return_type<\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">:&nbsp; l\u00e0 m\u1ed9t s\u1ed1 x\u00e1c \u0111\u1ecbnh ki\u1ec3u gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1, c\u00f3 th\u1ec3 l\u00e0 1 trong c\u00e1c gi\u00e1 tr\u1ecb sau: 1, 2, 3, 11, 12, 13, 14, 15, 16, 17.<\/span><\/span><br><span id=\"docs-internal-guid-52666392-7fff-9303-62e6-7f5e7776d92d\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"><br>C\u1ea7n l\u01b0u \u00fd k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m WEEKDAY tr\u1ea3 v\u1ec1 th\u1ee9 trong tu\u1ea7n \u1edf d\u1ea1ng gi\u00e1 tr\u1ecb s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 7 ho\u1eb7c t\u1eeb 0 \u0111\u1ebfn 6 (t\u00f9y v\u00e0o return_type b\u1ea1n ch\u1ecdn cho c\u00f4ng th\u1ee9c h\u00e0m). M\u1ed7i gi\u00e1 tr\u1ecb s\u1ed1 \u1edf k\u1ebft qu\u1ea3 h\u00e0m WEEKDAY \u0111\u1ea1i di\u1ec7n cho m\u1ed9t ng\u00e0y trong tu\u1ea7n.<\/span><\/span><br><span id=\"docs-internal-guid-5679f277-7fff-bb97-7bd0-5f148115e3a8\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"><br>V\u00ed d\u1ee5:<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fb4c750 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fb4c750\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b796235\" data-id=\"b796235\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4be7700 elementor-widget elementor-widget-text-editor\" data-id=\"4be7700\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre; margin-left: 36pt;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u1edbi return_type tr\u1ed1ng ho\u1eb7c b\u1eb1ng s\u1ed1 1<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">: k\u1ebft qu\u1ea3 h\u00e0m l\u00e0 1 t\u01b0\u01a1ng \u1ee9ng v\u1edbi ng\u00e0y ch\u1ee7 nh\u1eadt, 2 l\u00e0 th\u1ee9 hai, \u2026, c\u1ee9 l\u1ea7n l\u01b0\u1ee3t nh\u01b0 v\u1eady cho \u0111\u1ebfn 7 \u0111\u1ea1i di\u1ec7n cho ng\u00e0y th\u1ee9 b\u1ea3y.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre; margin-left: 36pt;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u1edbi return_type b\u1eb1ng s\u1ed1 2<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">: ng\u00e0y th\u1ee9 hai l\u00e0 s\u1ed1 1, th\u1ee9 ba l\u00e0 s\u1ed1 2, \u2026, ng\u00e0y ch\u1ee7 nh\u1eadt l\u00e0 s\u1ed1 7.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre; margin-left: 36pt;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"background-color: transparent; font-size: 12pt; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">V\u1edbi return_type b\u1eb1ng s\u1ed1 3<\/span><span style=\"background-color: transparent; font-size: 12pt; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">: k\u1ebft qu\u1ea3 h\u00e0m WEEKDAY kh\u00f4ng c\u00f2n l\u00e0 s\u1ed1 nguy\u00ean ch\u1ea1y t\u1eeb 1 \u0111\u1ebfn 7 n\u1eefa m\u00e0 l\u00e0 t\u1eeb 0 \u0111\u1ebfn 6: ng\u00e0y th\u1ee9 hai l\u00e0 s\u1ed1 0, th\u1ee9 ba l\u00e0 s\u1ed1 1, \u2026, ng\u00e0y ch\u1ee7 nh\u1eadt l\u00e0 s\u1ed1 6.<\/span><\/p><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1fc174d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1fc174d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4e49ec7\" data-id=\"4e49ec7\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b51d79c elementor-widget elementor-widget-text-editor\" data-id=\"b51d79c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Nh\u1edd \u0111\u1ed1i s\u1ed1 Return_type, b\u1ea1n c\u00f3 th\u1ec3 t\u00f9y \u00fd th\u1ee9 n\u00e0o l\u00e0 ng\u00e0y b\u1eaft \u0111\u1ea7u tu\u1ea7n (g\u00e1n gi\u00e1 tr\u1ecb 0 ho\u1eb7c 1).<\/span><\/p><p><span id=\"docs-internal-guid-fdb95cb3-7fff-db0f-e9b6-d062d8ae652d\"><br \/><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1c ki\u1ec3u gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u1ed7i return_type c\u00f3 th\u1ec3 kh\u00f4ng d\u1ec5 d\u00e0ng \u0111\u1ec3 ghi nh\u1edb, nh\u01b0ng \u0111\u1eebng lo v\u00ec Excel c\u00f3 ch\u1ee9c n\u0103ng g\u1ee3i \u00fd c\u00fa ph\u00e1p h\u00e0m, b\u1ea1n ch\u1ec9 c\u1ea7n g\u00f5 \u201c<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">=weekday(gi\u00e1 tr\u1ecb ng\u00e0y,<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u201d th\u00ec Excel s\u1ebd g\u1ee3i \u00fd c\u00e1c return_type nh\u01b0 sau:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3481c19 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3481c19\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6084c5c\" data-id=\"6084c5c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b471b3c elementor-widget elementor-widget-image\" data-id=\"b471b3c\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/10\/cach-nho-cong-thuc-cu-phap-ham-weekday-trong-excel.png\" title=\"cach-nho-cong-thuc-cu-phap-ham-weekday-trong-excel\" alt=\"H\u00e0m WEEKDAY L\u00e0 G\u00ec? C\u00fa Ph\u00e1p H\u00e0m WEEKDAY \u0110\u1ec3 G\u1ee3i \u00dd Ki\u1ec3u D\u1eef Li\u1ec7u S\u1ed1 \u0110\u1ea1i Di\u1ec7n Ng\u00e0y N\u00e0o Trong Tu\u1ea7n\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6ab9264 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6ab9264\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3b5bcef\" data-id=\"3b5bcef\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-96672f8 elementor-widget elementor-widget-text-editor\" data-id=\"96672f8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7f2c0b2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7f2c0b2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-11116e5\" data-id=\"11116e5\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-92c0cff elementor-widget elementor-widget-text-editor\" data-id=\"92c0cff\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p>\u00a0<\/p><div dir=\"ltr\" style=\"margin-left: 0pt;\" align=\"left\"><span style=\"color: #000000; font-family: Arial; font-size: 16px; font-style: italic; font-weight: bold; white-space: pre-wrap;\">T\u1ed5ng h\u1ee3p c\u00e1c Return_type v\u00e0 s\u1ed1 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 \u1edf k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m WEEKDAY theo h\u01b0\u1edbng d\u1eabn c\u1ee7a Microsoft:<\/span><\/div><p>\u00a0<\/p><div dir=\"ltr\" style=\"margin-left: 0pt;\" align=\"left\"><table style=\"border-collapse: collapse; border: initial none initial;\"><colgroup> <col width=\"135\" \/> <col width=\"329\" \/><\/colgroup><tbody><tr style=\"height: 0pt;\"><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Return_type\u00a0\u00a0\u00a0<\/span><\/p><\/td><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">S\u1ed1 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1<\/span><\/p><\/td><\/tr><tr style=\"height: 0pt;\"><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">1 ho\u1eb7c b\u1ecf qua<\/span><\/p><\/td><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">La\u0300 ca\u0301c s\u00f4\u0301 t\u01b0\u0300 1 (chu\u0309 nh\u00e2\u0323t) \u0111\u00ea\u0301n 7 (th\u01b0\u0301 ba\u0309y)<\/span><\/p><\/td><\/tr><tr style=\"height: 0pt;\"><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">2<\/span><\/p><\/td><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">La\u0300 ca\u0301c s\u00f4\u0301 t\u01b0\u0300 1 (th\u01b0\u0301 hai) \u0111\u00ea\u0301n 7 (chu\u0309 nh\u00e2\u0323t)<\/span><\/p><\/td><\/tr><tr style=\"height: 0pt;\"><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">3<\/span><\/p><\/td><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">La\u0300 ca\u0301c s\u00f4\u0301 t\u01b0\u0300 0 (th\u01b0\u0301 hai) \u0111\u00ea\u0301n 6 (chu\u0309 nh\u00e2\u0323t)<\/span><\/p><\/td><\/tr><tr style=\"height: 0pt;\"><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">11<\/span><\/p><\/td><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">La\u0300 ca\u0301c s\u00f4\u0301 t\u01b0\u0300 1 (th\u01b0\u0301 hai) \u0111\u00ea\u0301n 7 (chu\u0309 nh\u00e2\u0323t)<\/span><\/p><\/td><\/tr><tr style=\"height: 0pt;\"><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">12<\/span><\/p><\/td><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">La\u0300 ca\u0301c s\u00f4\u0301 t\u01b0\u0300 1 (th\u01b0\u0301 ba) \u0111\u00ea\u0301n 7 (th\u01b0\u0301 hai)<\/span><\/p><\/td><\/tr><tr style=\"height: 0pt;\"><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">13<\/span><\/p><\/td><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">La\u0300 ca\u0301c s\u00f4\u0301 t\u01b0\u0300 1 (th\u01b0\u0301 t\u01b0) \u0111\u00ea\u0301n 7 (th\u01b0\u0301 ba)<\/span><\/p><\/td><\/tr><tr style=\"height: 0pt;\"><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">14<\/span><\/p><\/td><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">La\u0300 ca\u0301c s\u00f4\u0301 t\u01b0\u0300 1 (th\u01b0\u0301 n\u0103m) \u0111\u00ea\u0301n 7 (th\u01b0\u0301 t\u01b0)<\/span><\/p><\/td><\/tr><tr style=\"height: 0pt;\"><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">15<\/span><\/p><\/td><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">La\u0300 ca\u0301c s\u00f4\u0301 t\u01b0\u0300 1 (th\u01b0\u0301 sa\u0301u) \u0111\u00ea\u0301n 7 (th\u01b0\u0301 n\u0103m)<\/span><\/p><\/td><\/tr><tr style=\"height: 0pt;\"><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">16<\/span><\/p><\/td><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">La\u0300 ca\u0301c s\u00f4\u0301 t\u01b0\u0300 1 (th\u01b0\u0301 ba\u0309y) \u0111\u00ea\u0301n 7 (th\u01b0\u0301 sa\u0301u)<\/span><\/p><\/td><\/tr><tr style=\"height: 0pt;\"><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">17<\/span><\/p><\/td><td style=\"border-width: 0.5pt; border-color: #000000; vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">La\u0300 ca\u0301c s\u00f4\u0301 t\u01b0\u0300 1 (chu\u0309 nh\u00e2\u0323t) \u0111\u00ea\u0301n 7 (th\u01b0\u0301 ba\u0309y)<\/span><\/p><\/td><\/tr><\/tbody><\/table><\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-307b206 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"307b206\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0b29277\" data-id=\"0b29277\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-647196b elementor-widget elementor-widget-heading\" data-id=\"647196b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-a0c7f329-7fff-7261-da73-f41481929707\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2, V\u00ed D\u1ee5 Chuy\u1ec3n Ng\u00e0y Sang Th\u1ee9 Trong Excel V\u1edbi T\u1ea5t C\u1ea3 C\u00e1c Return_type<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8385cbd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8385cbd\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-718ff92\" data-id=\"718ff92\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-084d15f elementor-widget elementor-widget-text-editor\" data-id=\"084d15f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-ae85b73a-7fff-aad8-4fb9-842f056beecf\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y cho c\u00f4ng th\u1ee9c t\u00ednh th\u1ee9 trong tu\u1ea7n c\u1ee7a ng\u00e0y 1\/1\/2020 v\u1edbi c\u00e1c return_type kh\u00e1c nhau trong Excel:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9ffeb5c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9ffeb5c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0072f72\" data-id=\"0072f72\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4c9da3a elementor-widget elementor-widget-image\" data-id=\"4c9da3a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/10\/su-dung-ham-weekday-trong-excel-tinh-thu-trong-tuan.png\" title=\"su-dung-ham-weekday-trong-excel-tinh-thu-trong-tuan\" alt=\"V\u00ed D\u1ee5 Chuy\u1ec3n Ng\u00e0y Sang Th\u1ee9 Trong Excel V\u1edbi T\u1ea5t C\u1ea3 C\u00e1c Return_type c\u1ee7a h\u00e0m WEEKDAY\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b142ba4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b142ba4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0fa1658\" data-id=\"0fa1658\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ac1b282 elementor-widget elementor-widget-text-editor\" data-id=\"ac1b282\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00f3 th\u1ec3 th\u1ea5y c\u00f9ng m\u1ed9t ng\u00e0y 1 th\u00e1ng 1 n\u0103m 2020 l\u00e0 th\u1ee9 t\u01b0, m\u1ed7i return_type l\u00e0m cho h\u00e0m l\u1ea5y th\u1ee9 c\u1ee7a ng\u00e0y trong Excel tr\u1ea3 v\u1ec1 c\u00e1c s\u1ed1 kh\u00e1c nhau.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 d\u1ec5 d\u00e0ng ghi nh\u1edb, b\u1ea1n ch\u1ec9 n\u00ean d\u00f9ng 1 ki\u1ec3u return_type v\u00e0 quy \u0111\u1ed5i s\u1ed1 sang d\u1ea1ng v\u0103n b\u1ea3n t\u00ean c\u1ee7a th\u1ee9 trong tu\u1ea7n b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m WEEKDAY c\u00f9ng h\u00e0m VLOOKUP.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a846be1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a846be1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-48ca049\" data-id=\"48ca049\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e28a4e0 elementor-widget elementor-widget-heading\" data-id=\"e28a4e0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-1d101602-7fff-8d80-3e98-4cfcefcef48f\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3, K\u1ebft H\u1ee3p H\u00e0m Weekday C\u00f9ng H\u00e0m Vlookup Tr\u1ea3 V\u1ec1 Th\u1ee9 Trong Tu\u1ea7n D\u1ea1ng V\u0103n B\u1ea3n<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0190635 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0190635\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-63b2df0\" data-id=\"63b2df0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-502a3e6 elementor-widget elementor-widget-text-editor\" data-id=\"502a3e6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m VLOOKUP l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m ph\u1ed5 bi\u1ebfn nh\u1ea5t trong Excel nh\u01b0ng nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng c\u00f2n th\u1ea5y kh\u00f3 hi\u1ec3u v\u1ec1 n\u00f3. Hoctin.vn \u0111\u00e3 c\u00f3 b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn chi ti\u1ebft v\u1ec1 h\u00e0m n\u00e0y, m\u1eddi c\u00e1c b\u1ea1n \u0111\u00f3n \u0111\u1ecdc: <\/span><a href=\"https:\/\/hoctin.vn\/cach-su-dung-ham-vlookup-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m VLOOKUP Trong Excel<\/a><span style=\"color: #1155cc; font-family: Arial;\"><span style=\"font-size: 16px; white-space: pre-wrap;\"><i>.<\/i><\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5feaa0d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5feaa0d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-60d834d\" data-id=\"60d834d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bd96590 elementor-widget elementor-widget-text-editor\" data-id=\"bd96590\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p 2 h\u00e0m VLOOKUP v\u00e0 WEEKDAY \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh giao d\u1ecbch v\u00e0o th\u1ee9 m\u1ea5y trong tu\u1ea7n:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-weight: bold; white-space: pre-wrap;\">=VLOOKUP(WEEKDAY(B6),$E$5:$F$11,2,0)<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0cc263a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0cc263a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5fa71fd\" data-id=\"5fa71fd\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a59e9de elementor-widget elementor-widget-text-editor\" data-id=\"a59e9de\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Trong \u0111\u00f3:<\/span><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">WEEKDAY(B6) <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb s\u1ed1 c\u1ee7a th\u1ee9 trong tu\u1ea7n t\u01b0\u01a1ng \u1ee9ng v\u1edbi ng\u00e0y t\u1ea1i \u00f4 B6. V\u00ec return_type \u0111\u00e3 \u0111\u01b0\u1ee3c b\u1ecf qua n\u00ean h\u00e0m n\u00e0y tr\u1ea3 v\u1ec1 c\u00e1c s\u1ed1 t\u1eeb 1 (ch\u1ee7 nh\u1eadt) \u0111\u1ebfn 7 (th\u1ee9 b\u1ea3y). Ng\u00e0y 03\/10\/2020 \u1edf \u00f4 B6 l\u00e0 th\u1ee9 b\u1ea3y n\u00ean h\u00e0m WEEKDAY(B6) tr\u1ea3 v\u1ec1 s\u1ed1 7.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"background-color: transparent; font-size: 12pt; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m VLOOKUP<\/span><span style=\"background-color: transparent; font-size: 12pt; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">: c\u00f3 t\u00e1c d\u1ee5ng t\u00ecm ki\u1ebfm k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c WEEKDAY(B6) trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a d\u1ea3i \u00f4 $E$5:$F$11 l\u00e0 v\u00f9ng t\u1eeb \u00f4 E5 \u0111\u1ebfn E11. N\u1ebfu tr\u00f9ng kh\u1edbp th\u00ec h\u00e0m VLOOKUP tr\u1ea3 v\u1ec1 t\u00ean c\u1ee7a th\u1ee9 t\u01b0\u01a1ng \u1ee9ng, n\u1eb1m trong c\u1ed9t th\u1ee9 2 c\u1ee7a v\u00f9ng $E$5:$F$11, ch\u00ednh l\u00e0 ph\u1ea1m vi t\u1eeb \u00f4 F5 \u0111\u1ebfn F11.<\/span><\/p><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f45ab08 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f45ab08\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fae879f\" data-id=\"fae879f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-af67154 elementor-widget elementor-widget-image\" data-id=\"af67154\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/10\/su-dung-ham-weekday-trong-excel-tinh-thu-trong-tuan-cach-xac-dinh-ngay-chu-nhat-trong-excel.png\" title=\"su-dung-ham-weekday-trong-excel-tinh-thu-trong-tuan-cach-xac-dinh-ngay-chu-nhat-trong-excel\" alt=\"K\u1ebft H\u1ee3p H\u00e0m Weekday C\u00f9ng H\u00e0m Vlookup Tr\u1ea3 V\u1ec1 Th\u1ee9 Trong Tu\u1ea7n D\u1ea1ng V\u0103n B\u1ea3n\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e1b51f4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e1b51f4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4658f33\" data-id=\"4658f33\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f29026a elementor-widget elementor-widget-text-editor\" data-id=\"f29026a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Hi v\u1ecdng b\u00e0i vi\u1ebft c\u1ee7a hoctin.vn \u0111\u00e3 mang l\u1ea1i cho c\u00e1c b\u1ea1n c\u00e1c th\u00f4ng tin h\u1eefu \u00edch.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">Ngo\u00e0i vi\u1ec7c \u1ee9ng d\u1ee5ng h\u00e0m WEEKDAY \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c th\u1ee9 trong tu\u1ea7n, b\u1ea1n c\u00f3 th\u1ec3 x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng v\u1edbi c\u00e1c c\u00f4ng c\u1ee5 h\u1eefu \u00edch trong Excel:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-datedif-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m DATEDIF<\/a><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/dinh-dang-ngay-thang-trong-excel\/\" target=\"_blank\" rel=\"noopener\">\u0110\u1ecbnh D\u1ea1ng Ng\u00e0y Th\u00e1ng Trong Excel<\/a><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/cach-loc-du-lieu-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch l\u1ecdc v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong Excel<\/a><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/cach-tinh-so-ngay-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch T\u00ednh S\u1ed1 Ng\u00e0y Trong Excel<\/a><\/p><div>\u00a0<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>H\u00e0m WEEKDAY l\u00e0 g\u00ec? T\u1ea1i sao ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m WEEKDAY? Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng trong Excel, nhi\u1ec1u l\u00fac b\u1ea1n c\u1ea7n x\u1eed l\u00fd d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng \u0111\u00f3 l\u00e0 th\u1ee9 m\u1ea5y trong tu\u1ea7n, v\u00ed d\u1ee5 nh\u01b0 trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n, nh\u00e0 cung c\u1ea5p c\u1ee7a b\u1ea1n quy \u0111\u1ecbnh n\u1ebfu ng\u00e0y \u0111\u1ebfn &#8230; <a title=\"C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m WEEKDAY Trong Excel V\u00e0 V\u00ed D\u1ee5 Chi Ti\u1ebft\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/ham-weekday-trong-excel\/\">Read more <span class=\"screen-reader-text\">C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m WEEKDAY Trong Excel V\u00e0 V\u00ed D\u1ee5 Chi Ti\u1ebft<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":1620,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[64,56],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1611"}],"collection":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/comments?post=1611"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1611\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/1620"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=1611"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=1611"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=1611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}