{"id":280451,"date":"2023-11-04T10:41:20","date_gmt":"2023-11-04T03:41:20","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=280451"},"modified":"2023-11-04T10:41:20","modified_gmt":"2023-11-04T03:41:20","slug":"ham-today","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-today\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TODAY trong Excel t\u00ednh th\u1eddi gian th\u1ef1c c\u00f3 v\u00ed d\u1ee5"},"content":{"rendered":"<p>\u0110\u1ec3 hi\u1ec3n th\u1ecb \u0111\u00fang gi\u00e1 tr\u1ecb ng\u00e0y, th\u00e1ng, n\u0103m hi\u1ec7n t\u1ea1i trong b\u1ea3ng t\u00ednh Excel th\u00ec nhi\u1ec1u ng\u01b0\u1eddi s\u1ebd d\u00f9ng h\u00e0m TODAY. V\u1eady \u0111\u00e2y l\u00e0 h\u00e0m g\u00ec v\u00e0 c\u00f4ng th\u1ee9c t\u00ednh h\u00e0m n\u00e0y ra sao? M\u1ecdi ng\u01b0\u1eddi h\u00e3y xem b\u00e0i vi\u1ebft sau \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00eam th\u00f4ng tin v\u1ec1 h\u00e0m TODAY \u0111\u1ec3 d\u1ec5 t\u00ednh to\u00e1n v\u1edbi c\u00e1c d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh Excel.<\/p>\n<h2>H\u00e0m TODAY l\u00e0 h\u00e0m g\u00ec?<\/h2>\n<p>\u0110\u00e2y l\u00e0 h\u00e0m c\u00f3 ch\u1ee9c n\u0103ng l\u1ea5y ra ng\u00e0y, th\u00e1ng, n\u0103m hi\u1ec7n t\u1ea1i trong b\u1ea3ng t\u00ednh Excel. H\u00e0m n\u00e0y r\u1ea5t c\u00f3 \u00edch \u0111\u1ec3 hi\u1ec3n th\u1ecb \u0111\u00fang ng\u00e0y hi\u1ec7n t\u1ea1i thu\u1ed9c trang t\u00ednh b\u1ea5t k\u1ef3. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m TODAY m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o:<\/p>\n<ul>\n<li style=\"font-weight: 400;\">Hi\u1ec3n th\u1ecb \u0111\u00fang v\u00e0 \u0111\u1ea7y \u0111\u1ee7 ng\u00e0y, th\u00e1ng, n\u0103m trong b\u1ea3ng t\u00ednh Excel.<\/li>\n<li style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 t\u00ednh tu\u1ed5i.<\/li>\n<li style=\"font-weight: 400;\">T\u00ednh \u0111\u00fang kho\u1ea3ng th\u1eddi gian theo y\u00eau c\u1ea7u ph\u1ed1i h\u1ee3p v\u1edbi nh\u1eefng h\u00e0m kh\u00e1c.<\/li>\n<\/ul>\n<figure id=\"attachment_280480\" aria-describedby=\"caption-attachment-280480\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-280480\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-1.jpg\" alt=\"ham-today-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-280480\" class=\"wp-caption-text\">H\u00e0m TODAY l\u00e0 h\u00e0m g\u00ec?<\/figcaption><\/figure>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng c\u00fa ph\u00e1p l\u00e0 =TODAY() v\u00e0 b\u1ea5m Enter. H\u00e0m n\u00e0y s\u1eed d\u1ee5ng th\u1eddi gian th\u1ef1c \u0111\u00e3 t\u1ef1 \u0111\u1ed9ng c\u00e0i \u0111\u1eb7t tr\u00ean m\u00e1y t\u00ednh c\u1ee7a ng\u01b0\u1eddi d\u00f9ng. N\u00f3 s\u1ebd l\u01b0u ng\u00e0y hi\u1ec7n t\u1ea1i v\u00e0o \u00f4 c\u1ea7n tr\u1ea3 k\u1ebft qu\u1ea3 v\u1edbi d\u1ea1ng \u0111\u1ed1i s\u1ed1. Hi\u1ec7n nay c\u00f3 2 c\u00e1ch gi\u00fap m\u1ecdi ng\u01b0\u1eddi nh\u1eadp h\u00e0m v\u00e0o Excel nh\u01b0 sau:<\/p>\n<ul>\n<li>Nh\u1eadp \u0111\u00fang c\u00fa ph\u00e1p h\u00e0m l\u00e0 =TODAY() v\u00e0o m\u1ed9t \u00f4 trong trang t\u00ednh.<\/li>\n<li>B\u1ea1n truy c\u1eadp v\u00e0o h\u1ed9p tho\u1ea1i Insert Function c\u1ee7a b\u1ea3ng t\u00ednh Excel r\u1ed3i nh\u1eadp h\u00e0m.<\/li>\n<\/ul>\n<p>L\u01b0u \u00fd:<\/p>\n<ul>\n<li>C\u00fa ph\u00e1p trong h\u00e0m n\u00e0y s\u1ebd kh\u00f4ng xu\u1ea5t hi\u1ec7n b\u1ea5t c\u1ee9 \u0111\u1ed1i s\u1ed1 n\u00e0o.<\/li>\n<li>Khi \u0111i\u1ec1n c\u00fa ph\u00e1p tr\u00ean v\u00e0o \u00f4 th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 ch\u1ee9a d\u1eef ki\u1ec7n v\u1ec1 ng\u00e0y\/ th\u00e1ng\/ n\u0103m hi\u1ec7n t\u1ea1i. Th\u1eddi gian th\u1ef1c l\u00e0 0 gi\u1edd v\u00e0 kh\u00f4ng ch\u1ee9a b\u1ea5t c\u1ee9 tham s\u1ed1 n\u00e0o.<\/li>\n<\/ul>\n<p>Ngo\u00e0i ra, \u0111\u1ec3 t\u00e1ch ri\u00eang ng\u00e0y, th\u00e1ng, n\u0103m th\u00ec b\u1ea1n h\u00e3y nh\u1eadp theo c\u00fa ph\u00e1p d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<ul>\n<li style=\"font-weight: 400;\">\u0110\u1ec3 t\u00e1ch ng\u00e0y t\u1eeb ng\u00e0y, th\u00e1ng, n\u0103m th\u00ec b\u1ea1n h\u00e3y d\u00f9ng c\u00fa ph\u00e1p l\u00e0: =DAY (TODAY())<\/li>\n<li style=\"font-weight: 400;\">\u0110\u1ec3 t\u00e1ch th\u00e1ng t\u1eeb ng\u00e0y, th\u00e1ng, n\u0103m th\u00ec b\u1ea1n h\u00e3y d\u00f9ng c\u00fa ph\u00e1p l\u00e0: =MONTH(TODAY())<\/li>\n<li style=\"font-weight: 400;\">\u0110\u1ec3 t\u00e1ch n\u0103m t\u1eeb ng\u00e0y, th\u00e1ng, n\u0103m th\u00ec b\u1ea1n h\u00e3y d\u00f9ng c\u00fa ph\u00e1p l\u00e0: =YEAR(TODAY())<\/li>\n<\/ul>\n<h2>C\u00e1ch \u0111\u1ecbnh d\u1ea1ng hi\u1ec3n th\u1ecb ng\u00e0y\/ th\u00e1ng\/ n\u0103m trong h\u00e0m TODAY<\/h2>\n<p>Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng h\u00e0m n\u00e0y m\u00e0 b\u1ea1n th\u1ea5y th\u1ee9 t\u1ef1 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u ng\u00e0y\/th\u00e1ng\/n\u0103m kh\u00f4ng \u0111\u00fang theo \u00fd mu\u1ed1n th\u00ec b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ed5i b\u1eb1ng c\u00e1ch b\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft l\u00e0 \u201cCtrl + 1\u201d \u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 Format Cells. Sau \u0111\u00f3 b\u1ea1n ch\u1ecdn m\u1ee5c Custom, trong m\u1ee5c Type th\u00ec b\u1ea1n ch\u1ecdn ki\u1ec3u hi\u1ec3n th\u1ecb ng\u00e0y\/th\u00e1ng\/n\u0103m m\u00e0 m\u00ecnh mong mu\u1ed1n. Cu\u1ed1i c\u00f9ng b\u1ea1n b\u1ea5m v\u00e0o OK.<\/p>\n<figure id=\"attachment_280481\" aria-describedby=\"caption-attachment-280481\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" class=\"size-full wp-image-280481\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-2.jpg\" alt=\"ham-today-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-280481\" class=\"wp-caption-text\">C\u00e1ch \u0111\u1ecbnh d\u1ea1ng hi\u1ec3n th\u1ecb ng\u00e0y\/ th\u00e1ng\/ n\u0103m trong h\u00e0m TODAY<\/figcaption><\/figure>\n<p>Nh\u1eefng d\u1ea1ng hi\u1ec3n th\u1ecb ng\u00e0y\/th\u00e1ng\/n\u0103m th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng v\u1edbi nh\u1eefng d\u1eef li\u1ec7u th\u1eddi gian trong h\u00e0m TODAY hi\u1ec7n nay bao g\u1ed3m:<\/p>\n<ul>\n<li style=\"font-weight: 400;\">mm\/dd\/yyyy: Ki\u1ec3u hi\u1ec3n th\u1ecb th\u00e1ng\/ng\u00e0y\/n\u0103m \u0111\u1ea7y \u0111\u1ee7 b\u1eb1ng s\u1ed1.<\/li>\n<li style=\"font-weight: 400;\">dd\/mm\/yyyy: Ki\u1ec3u hi\u1ec3n th\u1ecb ng\u00e0y\/th\u00e1ng\/n\u0103m \u0111\u1ea7y \u0111\u1ee7 b\u1eb1ng s\u1ed1.<\/li>\n<li style=\"font-weight: 400;\">dd-mmm-yy: Ki\u1ec3u hi\u1ec3n th\u1ecb \u0111\u1ea7y \u0111\u1ee7 ng\u00e0y\/th\u00e1ng\/n\u0103m. Ng\u00e0y s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb v\u1edbi 2 s\u1ed1, th\u00e1ng s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb v\u1edbi 3 ch\u1eef c\u00e1i \u0111\u1ea7u trong ti\u1ebfng Anh, n\u0103m s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb v\u1edbi 2 ch\u1eef s\u1ed1 cu\u1ed1i.<\/li>\n<li style=\"font-weight: 400;\">dd-mm: Ki\u1ec3u hi\u1ec3n th\u1ecb ng\u00e0y\/th\u00e1ng b\u1eb1ng c\u00e1c s\u1ed1.<\/li>\n<li style=\"font-weight: 400;\">mm-yy: Ki\u1ec3u hi\u1ec3n th\u1ecb th\u00e1ng\/n\u0103m b\u1eb1ng 2 ch\u1eef s\u1ed1.<\/li>\n<\/ul>\n<h2>C\u00e1ch d\u00f9ng h\u00e0m TODAY trong Excel \u0111\u1ec3 t\u00ednh th\u1eddi gian th\u1ef1c<\/h2>\n<p>Sau \u0111\u00e2y l\u00e0 nh\u1eefng v\u00ed d\u1ee5 d\u00f9ng h\u00e0m TODAY trong th\u1ef1c t\u1ebf, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o \u0111\u1ec3 \u00e1p d\u1ee5ng ngay:<\/p>\n<h3>H\u00e0m tr\u1ea3 k\u1ebft qu\u1ea3 v\u1ec1 th\u1eddi gian hi\u1ec7n t\u1ea1i<\/h3>\n<ul>\n<li style=\"font-weight: 400;\">B\u01b0\u1edbc 1: B\u1ea1n nh\u1ea5p v\u00e0o \u00f4 c\u1ea7n tr\u1ea3 k\u1ebft qu\u1ea3 v\u1ec1 l\u00e0 th\u1eddi gian hi\u1ec7n t\u1ea1i. Sau \u0111\u00f3 b\u1ea1n \u0111i\u1ec1n v\u00e0o c\u00fa ph\u00e1p l\u00e0 =TODAY().<\/li>\n<\/ul>\n<figure id=\"attachment_280482\" aria-describedby=\"caption-attachment-280482\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" class=\"size-full wp-image-280482\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-3.jpg\" alt=\"ham-today-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-280482\" class=\"wp-caption-text\">B\u01b0\u1edbc 1<\/figcaption><\/figure>\n<ul>\n<li style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u1ea1n c\u1ea7n b\u1ea5m v\u00e0o Enter. Sau \u0111\u00f3 th\u00ec k\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb \u1edf \u00f4 d\u1eef li\u1ec7u b\u1ea1n v\u1eeba ch\u1ecdn \u1edf tr\u00ean.<\/li>\n<\/ul>\n<figure id=\"attachment_280483\" aria-describedby=\"caption-attachment-280483\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-280483 size-full\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-4.jpg\" alt=\"ham-today-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-280483\" class=\"wp-caption-text\">B\u01b0\u1edbc 2<\/figcaption><\/figure>\n<h3>H\u00e0m tr\u1ea3 k\u1ebft qu\u1ea3 v\u1ec1 ng\u00e0y hi\u1ec7n t\u1ea1i v\u00e0 c\u1ed9ng th\u00eam 5 ng\u00e0y t\u01b0\u01a1ng lai<\/h3>\n<ul>\n<li style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ngay t\u1ea1i \u00f4 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 th\u1eddi gian t\u01b0\u01a1ng lai, b\u1ea1n \u0111i\u1ec1n theo c\u00fa ph\u00e1p n\u00e0y: =TODAY()+5. \u0110\u00e2y l\u00e0 c\u00fa ph\u00e1p h\u00e0m th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng lai trong n\u0103m ng\u00e0y t\u1edbi. V\u00ed d\u1ee5 ng\u00e0y hi\u1ec7n t\u1ea1i l\u00e0 15\/3\/2021 th\u00ec k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 \u0111\u00f3 l\u00e0 ng\u00e0y 20\/3\/2021.<\/li>\n<\/ul>\n<figure id=\"attachment_280484\" aria-describedby=\"caption-attachment-280484\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-280484 size-full\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-5.jpg\" alt=\"ham-today-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-280484\" class=\"wp-caption-text\">B\u01b0\u1edbc 1<\/figcaption><\/figure>\n<ul>\n<li style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u1ea1n h\u00e3y b\u1ea5m v\u00e0o Enter r\u1ed3i k\u1ebft qu\u1ea3 s\u1ebd xu\u1ea5t hi\u1ec7n ngay tr\u00ean \u00f4 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn. H\u00e0m TODAY \u0111\u01b0\u1ee3c coi l\u00e0 m\u1ed9t chu\u1ed7i seri. N\u1ebfu nh\u01b0 ng\u00e0y 15\/3\/2021 c\u00f3 s\u1ed1 seri l\u00e0 44270 th\u00ec ng\u00e0y 20\/3\/2021 c\u00f3 s\u1ed1 seri l\u00e0 44275.<\/li>\n<\/ul>\n<figure id=\"attachment_280485\" aria-describedby=\"caption-attachment-280485\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-280485 size-full\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-6.jpg\" alt=\"ham-today-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-280485\" class=\"wp-caption-text\">B\u01b0\u1edbc 2<\/figcaption><\/figure>\n<h3>H\u00e0m tr\u1ea3 v\u1ec1 s\u1ed1 ng\u00e0y gi\u1eefa 2 th\u1eddi \u0111i\u1ec3m<\/h3>\n<p>V\u00ed d\u1ee5 b\u1ea1n mu\u1ed1n nh\u1eadp h\u00e0m tr\u1ea3 v\u1ec1 s\u1ed1 ng\u00e0y gi\u1eefa ng\u00e0y hi\u1ec7n t\u1ea1i v\u1edbi ng\u00e0y 30\/4\/2021 th\u00ec h\u00e3y th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ngay t\u1ea1i \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 ng\u00e0y gi\u1eefa hai m\u1ed1c th\u1eddi gian th\u00ec b\u1ea1n h\u00e3y \u0111i\u1ec1n c\u00f4ng th\u1ee9c l\u00e0 = =DATEVALUE(&#8220;04\/30\/21&#8221;)-TODAY(). Trong \u0111\u00f3:\n<ul>\n<li style=\"font-weight: 400;\">H\u00e0m DATEVALUE(&#8220;04\/30\/21&#8221;) s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 seri c\u1ee7a ng\u00e0y 30\/04\/2021.<\/li>\n<li style=\"font-weight: 400;\">H\u00e0m TODAY() hi\u1ec3n th\u1ecb s\u1ed1 seri ng\u00e0y hi\u1ec7n t\u1ea1i.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<figure id=\"attachment_280486\" aria-describedby=\"caption-attachment-280486\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280486\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-7.jpg\" alt=\"ham-today-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-280486\" class=\"wp-caption-text\">B\u01b0\u1edbc 1<\/figcaption><\/figure>\n<ul>\n<li style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u1ea1n b\u1ea5m Enter v\u00e0 k\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb ngay tr\u00ean \u00f4 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn. \u0110\u1ec3 \u0111\u1ebfm \u0111\u01b0\u1ee3c s\u1ed1 ng\u00e0y gi\u1eefa 2 m\u1ed1c th\u1eddi gian tr\u00ean th\u00ec ch\u00fang ta ph\u1ea3i l\u1ea5y s\u1ed1 seri c\u1ee7a ng\u00e0y 30\/4\/2021 tr\u1eeb cho s\u1ed1 seri c\u1ee7a ng\u00e0y hi\u1ec7n t\u1ea1i.<\/li>\n<\/ul>\n<figure id=\"attachment_280487\" aria-describedby=\"caption-attachment-280487\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280487\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-8.jpg\" alt=\"ham-today-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-280487\" class=\"wp-caption-text\">B\u01b0\u1edbc 2<\/figcaption><\/figure>\n<p>L\u01b0u \u00fd: \u0110\u1ec3 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 xu\u1ea5t hi\u1ec7n ch\u00ednh x\u00e1c th\u00ec \u00f4 d\u1eef li\u1ec7u tr\u1ea3 k\u1ebft qu\u1ea3 ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng l\u00e0 S\u1ed1 ho\u1eb7c Chung.<\/p>\n<h3>H\u00e0m tr\u1ea3 v\u1ec1 ng\u00e0y hi\u1ec7n t\u1ea1i c\u1ee7a th\u00e1ng<\/h3>\n<p>Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u1edf tr\u00ean th\u00ec h\u00e0m TODAY l\u00e0 h\u00e0m c\u00f3 th\u1ec3 l\u1ea5y ra ng\u00e0y, th\u00e1ng, n\u0103m trong th\u1eddi gian th\u1ef1c. Ch\u1ec9 c\u1ea7n m\u1ecdi ng\u01b0\u1eddi bi\u1ebft c\u00e1ch k\u1ebft h\u1ee3p \u0111\u00fang c\u00f4ng th\u1ee9c h\u00e0m th\u00ec s\u1ebd d\u00f9ng h\u00e0m r\u1ea5t hi\u1ec7u qu\u1ea3. B\u1ea1n c\u1ea7n l\u01b0u \u00fd r\u1eb1ng:<\/p>\n<ul>\n<li style=\"font-weight: 400;\">Th\u00e1ng 4, th\u00e1ng 6, th\u00e1ng 9, th\u00e1ng 11 l\u00e0 nh\u1eefng th\u00e1ng c\u00f3 30 ng\u00e0y.<\/li>\n<li style=\"font-weight: 400;\">Th\u00e1ng 1, th\u00e1ng 3, th\u00e1ng 5, th\u00e1ng 7, th\u00e1ng 8, th\u00e1ng 10, th\u00e1ng 12 l\u00e0 nh\u1eefng th\u00e1ng c\u00f3 31 ng\u00e0y.<\/li>\n<li style=\"font-weight: 400;\">Th\u00e1ng 2 l\u00e0 th\u00e1ng c\u00f3 28 ng\u00e0y v\u00e0 n\u0103m nhu\u1eadn th\u00ec th\u00e1ng 2 s\u1ebd c\u00f3 29 ng\u00e0y.<\/li>\n<\/ul>\n<p>\u0110\u1ec3 d\u00f9ng h\u00e0m n\u00e0y tr\u1ea3 k\u1ebft qu\u1ea3 v\u1ec1 ng\u00e0y hi\u1ec7n t\u1ea1i trong th\u00e1ng th\u00ec b\u1ea1n l\u00e0m theo c\u00e1c b\u01b0\u1edbc nh\u01b0 sau:<\/p>\n<ul>\n<li style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1i \u00f4 d\u1eef li\u1ec7u b\u1ea1n c\u1ea7n tr\u1ea3 k\u1ebft qu\u1ea3 th\u00ec b\u1ea1n nh\u1eadp h\u00e0m theo c\u00fa ph\u00e1p =DAY(TODAY()).<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280488 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-9.jpg\" alt=\"ham-today-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u1ea1n h\u00e3y b\u1ea5m Enter, sau \u0111\u00f3 th\u00ec k\u1ebft qu\u1ea3 s\u1ebd xu\u1ea5t hi\u1ec7n ngay t\u1ea1i \u00f4 d\u1eef li\u1ec7u. K\u1ebft qu\u1ea3 n\u00e0y \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 l\u00e0 ng\u00e0y hi\u1ec7n t\u1ea1i trong th\u00e1ng. N\u1ebfu nh\u01b0 hi\u1ec7n t\u1ea1i l\u00e0 ng\u00e0y 15\/3\/2021 th\u00ec k\u1ebft qu\u1ea3 cho ra l\u00e0 15.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280489 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-10.jpg\" alt=\"ham-today-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h3>H\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 th\u00e1ng hi\u1ec7n t\u1ea1i trong m\u1ed9t n\u0103m (1 &#8211; 12)<\/h3>\n<p>B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m TODAY \u0111\u1ec3 xu\u1ea5t k\u1ebft qu\u1ea3 l\u00e0 th\u00e1ng hi\u1ec7n t\u1ea1i trong m\u1ed9t n\u0103m (th\u00e1ng 1 \u0111\u1ebfn th\u00e1ng 12) theo thao t\u00e1c nh\u01b0 sau:<\/p>\n<ul>\n<li style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ngay t\u1ea1i \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 k\u1ebft qu\u1ea3 th\u00ec b\u1ea1n \u0111i\u1ec1n h\u00e0m theo c\u00fa ph\u00e1p l\u00e0 =MONTH(TODAY()).<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280490 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-11.jpg\" alt=\"ham-today-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u1ea1n h\u00e3y b\u1ea5m Enter r\u1ed3i k\u1ebft qu\u1ea3 s\u1ebd xu\u1ea5t hi\u1ec7n tr\u00ean \u00f4 d\u1eef li\u1ec7u \u0111\u00e3 ch\u1ecdn. C\u00fa ph\u00e1p n\u00e0y s\u1ebd cho ra k\u1ebft qu\u1ea3 l\u00e0 th\u00e1ng hi\u1ec7n t\u1ea1i trong n\u0103m. N\u1ebfu nh\u01b0 ng\u00e0y hi\u1ec7n t\u1ea1i l\u00e0 ng\u00e0y 15\/3\/2021 th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 3.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280491 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-12.jpg\" alt=\"ham-today-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h2>C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i v\u1ec1 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y trong h\u00e0m TODAY<\/h2>\n<p>Khi tr\u1eeb \u0111i 2 ng\u00e0y trong b\u1ea3ng t\u00ednh Excel, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 th\u01b0\u1eddng s\u1ebd hi\u1ec3n th\u1ecb d\u01b0\u1edbi \u0111\u1ecbnh d\u1ea1ng m\u1ed9t ng\u00e0y kh\u00e1c ch\u1ee9 kh\u00f4ng ph\u1ea3i m\u1ed9t s\u1ed1. Vi\u1ec7c n\u00e0y s\u1ebd x\u1ea3y ra khi \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c \u0111\u00e3 \u0111\u1ecbnh d\u1ea1ng tr\u01b0\u1edbc l\u00e0 General.<\/p>\n<p>V\u00ec \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c c\u00f3 ch\u1ee9a ng\u00e0y\/th\u00e1ng n\u00ean Excel s\u1ebd t\u1ef1 \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 th\u00e0nh ki\u1ec3u Date. Trong v\u00ed d\u1ee5 sau, \u00f4 A7 hi\u1ec3n th\u1ecb 1 \u00f4 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng l\u00e0 ng\u00e0y. B\u1edfi v\u1eadt m\u00e0 n\u00f3 hi\u1ec7n \u0111ang ch\u1ee9a m\u1ed9t th\u00f4ng tin sai. \u0110\u1ec3 xem ch\u00ednh x\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u1ecbnh d\u1ea1ng s\u1ed1 th\u00ec \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 ph\u1ea3i \u0111\u1eb7t l\u00e0 General ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng Number. Sau \u0111\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng:<\/p>\n<ul>\n<li style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean b\u1ea1n c\u1ea7n \u0111\u00e1nh d\u1ea5u \u00f4 c\u00f3 \u0111\u1ecbnh d\u1ea1ng kh\u00f4ng \u0111\u00fang.<\/li>\n<li style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u1ea1n click chu\u1ed9t ph\u1ea3i v\u00e0o nh\u1eefng \u00f4 \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u ch\u01b0a \u0111\u1ecbnh d\u1ea1ng \u0111\u00fang \u0111\u1ec3 m\u1edf c\u00e1c menu t\u00f9y ch\u1ecdn.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280492 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-13.jpg\" alt=\"ham-today-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\">B\u01b0\u1edbc 3: B\u1ea1n h\u00e3y ch\u1ecdn m\u1ee5c Format Cells. Sau \u0111\u00f3 m\u1edf nh\u1eefng \u0111\u1ecbnh d\u1ea1ng \u00f4 m\u00e0 b\u1ea3ng t\u00ednh Excel \u0111ang cung c\u1ea5p.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280493 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-14.jpg\" alt=\"ham-today-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\">B\u01b0\u1edbc 4: B\u1ea1n h\u00e3y ch\u1ecdn m\u1ee5c Number ho\u1eb7c General. Sau \u0111\u00f3 b\u1ea1n b\u1ea5m v\u00e0o OK \u0111\u1ec3 k\u1ebft qu\u1ea3 \u0111\u1ecbnh d\u1ea1ng l\u1ea1i \u0111\u00fang h\u01a1n. Ti\u1ebfp \u0111\u00f3 th\u00ec b\u1ea1n s\u1ebd th\u1ea5y \u00f4 tr\u1ea3 k\u1ebft qu\u1ea3 \u0111\u00e3 hi\u1ec3n th\u1ecb \u0111\u00fang nh\u01b0 m\u00ecnh mong \u0111\u1ee3i.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280494 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-15.jpg\" alt=\"ham-today-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h2>C\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi d\u00f9ng h\u00e0m TODAY<\/h2>\n<p>Khi d\u00f9ng h\u00e0m n\u00e0y th\u00ec b\u1ea1n s\u1ebd g\u1eb7p m\u1ed9t v\u00e0i l\u1ed7i c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c d\u1ec5 d\u00e0ng theo c\u00e1c thao t\u00e1c nh\u01b0 sau:<\/p>\n<figure id=\"attachment_280495\" aria-describedby=\"caption-attachment-280495\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280495\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-16.jpg\" alt=\"ham-today-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-280495\" class=\"wp-caption-text\">C\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi d\u00f9ng h\u00e0m TODAY<\/figcaption><\/figure>\n<h3>L\u1ed7i #VALUE<\/h3>\n<p>L\u1ed7i #VALUE c\u00f3 th\u1ec3 x\u1ea3y ra khi b\u1ea1n \u0111\u00e3 \u0111i\u1ec1n sai c\u00fa ph\u00e1p c\u1ee7a h\u00e0m ho\u1eb7c b\u1ea1n \u0111\u00e3 nh\u1eadp gi\u00e1 tr\u1ecb \u0111\u1ea7u v\u00e0o kh\u00f4ng ph\u1ea3i l\u00e0 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y. \u0110\u1ec3 s\u1eeda l\u1ed7i n\u00e0y th\u00ec b\u1ea1n h\u00e3y ki\u1ec3m tra l\u1ea1i c\u00fa ph\u00e1p c\u1ee7a h\u00e0m v\u00e0 ch\u1eafc ch\u1eafn r\u1eb1ng gi\u00e1 tr\u1ecb \u0111\u1ea7u v\u00e0o l\u00e0 m\u1ed9t ng\u00e0y h\u1ee3p l\u1ec7.<\/p>\n<h3>L\u1ed7i #NAME?<\/h3>\n<p>\u0110\u00e2y l\u00e0 lo\u1ea1i l\u1ed7i x\u1ea3y ra khi ng\u01b0\u1eddi d\u00f9ng \u0111i\u1ec1n sai t\u00ean c\u1ee7a h\u00e0m. Ho\u1eb7c c\u00f3 th\u1ec3 m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 \u0111i\u1ec1n c\u00f4ng th\u1ee9c h\u00e0m m\u00e0 thi\u1ebfu d\u1ea5u b\u1eb1ng \u1edf tr\u01b0\u1edbc t\u00ean h\u00e0m. \u0110\u1ec3 s\u1eeda l\u1ed7i n\u00e0y th\u00ec b\u1ea1n c\u1ea7n xem l\u1ea1i t\u00ean h\u00e0m TODAY v\u00e0 \u0111\u1eb7t d\u1ea5u \u201c=\u201d \u1edf tr\u01b0\u1edbc t\u00ean h\u00e0m.<\/p>\n<h3>L\u1ed7i #REF!<\/h3>\n<p>\u0110\u00e2y l\u00e0 l\u1ed7i c\u00f3 th\u1ec3 x\u1ea3y ra khi ng\u01b0\u1eddi d\u00f9ng tham chi\u1ebfu t\u1edbi m\u1ed9t \u00f4 \u0111\u00e3 b\u1ecb x\u00f3a. Ho\u1eb7c b\u1ea1n tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 kh\u00f4ng t\u1ed3n t\u1ea1i trong b\u1ea3ng t\u00ednh. \u0110\u1ec3 s\u1eeda l\u1ed7i n\u00e0y th\u00ec b\u1ea1n ph\u1ea3i ki\u1ec3m tra l\u1ea1i nh\u1eefng \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu v\u00e0 \u0111\u1ea3m b\u1ea3o ch\u00fang v\u1eabn c\u00f2n n\u1eb1m trong b\u1ea3ng t\u00ednh Excel.<\/p>\n<h3>L\u1ed7i #NUM!<\/h3>\n<p>L\u1ed7i n\u00e0y s\u1ebd x\u1ea3y ra khi b\u1ea1n \u0111i\u1ec1n v\u00e0o m\u1ed9t con s\u1ed1 qu\u00e1 l\u1edbn ho\u1eb7c s\u1ed1 qu\u1ea3 nh\u1ecf \u0111\u1ec3 Excel c\u00f3 th\u1ec3 x\u1eed l\u00fd. \u0110\u1ec3 s\u1eeda l\u1ed7i n\u00e0y th\u00ec b\u1ea1n h\u00e3y ki\u1ec3m tra nh\u1eefng s\u1ed1 \u0111\u00e3 \u0111i\u1ec1n v\u00e0o. B\u1ea1n c\u1ea7n ch\u1eafc ch\u1eafn ch\u00fang n\u1eb1m \u0111\u00fang trong kho\u1ea3ng gi\u1edbi h\u1ea1n t\u1eeb Excel.<\/p>\n<h2>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m TODAY trong Excel<\/h2>\n<p>Khi s\u1eed d\u1ee5ng h\u00e0m n\u00e0y trong Excel, c\u00f3 m\u1ed9t s\u1ed1 \u0111i\u1ec1u m\u00e0 m\u1ecdi ng\u01b0\u1eddi c\u1ea7n l\u01b0u \u00fd nh\u01b0 sau:<\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1eadp ch\u00ednh x\u00e1c d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o v\u00e0 c\u00fa ph\u00e1p h\u00e0m: \u0110\u1ec3 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 ch\u00ednh x\u00e1c nh\u1ea5t, b\u1ea1n c\u1ea7n nh\u1eadp \u0111\u00fang d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o v\u00e0 c\u00fa ph\u00e1p h\u00e0m v\u00e0o \u00f4 c\u1ea7n tr\u1ea3 k\u1ebft qu\u1ea3.<\/span><\/li>\n<li style=\"font-weight: 400;\">T\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt: H\u00e0m TODAY() s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt m\u1ed7i khi b\u1ea1n m\u1edf l\u1ea1i ho\u1eb7c t\u00ednh to\u00e1n l\u1ea1i b\u1ea3ng t\u00ednh. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 n\u1ebfu b\u1ea1n m\u1edf t\u1ec7p v\u00e0o ng\u00e0y kh\u00e1c, h\u00e0m s\u1ebd hi\u1ec3n th\u1ecb ng\u00e0y m\u1edbi nh\u1ea5t.<\/li>\n<li style=\"font-weight: 400;\">Kh\u00f4ng c\u1ea7n \u0111\u1ed1i s\u1ed1: H\u00e0m TODAY() kh\u00f4ng y\u00eau c\u1ea7u b\u1ea5t k\u1ef3 \u0111\u1ed1i s\u1ed1 n\u00e0o. B\u1ea1n ch\u1ec9 c\u1ea7n g\u00f5 =TODAY() v\u00e0 n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 ng\u00e0y hi\u1ec7n t\u1ea1i.<\/li>\n<li style=\"font-weight: 400;\">\u0110\u1ecbnh d\u1ea1ng ng\u00e0y: K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m TODAY() c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng theo \u0111\u1ecbnh d\u1ea1ng ng\u00e0y mong mu\u1ed1n th\u00f4ng qua c\u00e1c t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ng\u00e0y th\u00e1ng trong thanh c\u00f4ng c\u1ee5.<\/li>\n<\/ul>\n<figure id=\"attachment_280496\" aria-describedby=\"caption-attachment-280496\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280496\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-17.jpg\" alt=\"ham-today-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-280496\" class=\"wp-caption-text\">L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m TODAY trong Excel<\/figcaption><\/figure>\n<ul>\n<li style=\"font-weight: 400;\">Kh\u00f4ng thay \u0111\u1ed5i ng\u00e0y: H\u00e0m TODAY() kh\u00f4ng thay \u0111\u1ed5i ng\u00e0y khi b\u1ea1n l\u01b0u l\u1ea1i b\u1ea3ng t\u00ednh. N\u00f3 s\u1ebd lu\u00f4n tr\u1ea3 v\u1ec1 ng\u00e0y hi\u1ec7n t\u1ea1i.<\/li>\n<li style=\"font-weight: 400;\">S\u1eed d\u1ee5ng c\u1ea9n th\u1eadn trong c\u00e1c h\u00e0m kh\u00e1c: Tr\u00e1nh s\u1eed d\u1ee5ng h\u00e0m TODAY() trong c\u00e1c h\u00e0m kh\u00e1c m\u00e0 b\u1ea1n kh\u00f4ng mu\u1ed1n t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt ng\u00e0y.<\/li>\n<li style=\"font-weight: 400;\">Ki\u1ec3m so\u00e1t c\u1eadp nh\u1eadt t\u1ef1 \u0111\u1ed9ng: N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n h\u00e0m TODAY() t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng &#8220;Calculation Options&#8221; trong Excel \u0111\u1ec3 chuy\u1ec3n sang ch\u1ebf \u0111\u1ed9 &#8220;Manual&#8221; tr\u01b0\u1edbc khi m\u1edf b\u1ea3ng t\u00ednh.<\/li>\n<\/ul>\n<p>B\u00e0i vi\u1ebft tr\u00ean \u0111\u00e3 chia s\u1ebb c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TODAY trong Excel \u0111\u1ec3 t\u00ednh th\u1eddi gian th\u1ef1c. \u0110\u1ed3ng th\u1eddi b\u00e0i vi\u1ebft c\u0169ng \u0111\u00e3 cung c\u1ea5p v\u00ed d\u1ee5 minh h\u1ecda c\u1ee5 th\u1ec3 \u0111\u1ec3 m\u1ecdi ng\u01b0\u1eddi d\u1ec5 h\u00ecnh dung. Hy v\u1ecdng m\u1ecdi ng\u01b0\u1eddi c\u00f3 th\u1ec3 n\u1eafm \u0111\u01b0\u1ee3c c\u00fa ph\u00e1p ch\u00ednh x\u00e1c c\u1ee7a h\u00e0m v\u00e0 \u00e1p d\u1ee5ng nhanh ch\u00f3ng trong vi\u1ec7c t\u00ednh to\u00e1n, ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh tr\u00ean Excel. \u0110\u1ec3 t\u0103ng \u0111\u1ed9 ch\u00ednh x\u00e1c cho k\u1ebft qu\u1ea3, b\u1ea1n c\u1ea7n nh\u1edb nh\u1eadp ch\u00ednh x\u00e1c c\u00f4ng th\u1ee9c v\u00e0 ki\u1ec3m tra k\u1ef9 tr\u01b0\u1edbc khi xu\u1ea5t k\u1ebft qu\u1ea3.<\/p>\n<p>Tham kh\u1ea3o b\u00e0i vi\u1ebft li\u00ean quan:<\/p>\n<ul>\n<li style=\"font-weight: 400;\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/\">C\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5<\/a><\/li>\n<li style=\"font-weight: 400;\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-search\/\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SEARCH c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u0110\u1ec3 hi\u1ec3n th\u1ecb \u0111\u00fang gi\u00e1 tr\u1ecb ng\u00e0y, th\u00e1ng, n\u0103m hi\u1ec7n t\u1ea1i trong b\u1ea3ng t\u00ednh Excel th\u00ec nhi\u1ec1u ng\u01b0\u1eddi s\u1ebd d\u00f9ng h\u00e0m TODAY. V\u1eady \u0111\u00e2y l\u00e0 h\u00e0m g\u00ec v\u00e0 c\u00f4ng th\u1ee9c t\u00ednh h\u00e0m n\u00e0y ra sao? M\u1ecdi ng\u01b0\u1eddi h\u00e3y xem b\u00e0i vi\u1ebft sau \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00eam th\u00f4ng tin v\u1ec1 h\u00e0m TODAY \u0111\u1ec3 d\u1ec5 t\u00ednh to\u00e1n [&hellip;]<\/p>\n","protected":false},"author":102,"featured_media":280479,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-280451","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TODAY trong Excel t\u00ednh th\u1eddi gian th\u1ef1c c\u00f3 v\u00ed d\u1ee5<\/title>\n<meta name=\"description\" content=\"Hi\u1ec7n nay nhi\u1ec1u ng\u01b0\u1eddi \u0111ang t\u00ecm hi\u1ec3u h\u00e0m TODAY \u0111\u1ec3 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u ng\u00e0y hi\u1ec7n t\u1ea1i. V\u1eady c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u01b0 th\u1ebf n\u00e0o l\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t?\" \/>\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-today\/\" \/>\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 TODAY trong Excel t\u00ednh th\u1eddi gian th\u1ef1c c\u00f3 v\u00ed d\u1ee5\" \/>\n<meta property=\"og:description\" content=\"Hi\u1ec7n nay nhi\u1ec1u ng\u01b0\u1eddi \u0111ang t\u00ecm hi\u1ec3u h\u00e0m TODAY \u0111\u1ec3 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u ng\u00e0y hi\u1ec7n t\u1ea1i. V\u1eady c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u01b0 th\u1ebf n\u00e0o l\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-today\/\" \/>\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:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-04T03:41:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-18.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 Thi\u00ean\" \/>\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 Thi\u00ean\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 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-today\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-today\\\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/person\\\/82f19cb5a6fb9de82c288acacfe400c5\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TODAY trong Excel t\u00ednh th\u1eddi gian th\u1ef1c c\u00f3 v\u00ed d\u1ee5\",\"datePublished\":\"2023-11-04T03:41:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-today\\\/\"},\"wordCount\":3180,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-today\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/ham-today-18.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-today\\\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-today\\\/\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-today\\\/\",\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TODAY trong Excel t\u00ednh th\u1eddi gian th\u1ef1c c\u00f3 v\u00ed d\u1ee5\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-today\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-today\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/ham-today-18.jpg\",\"datePublished\":\"2023-11-04T03:41:20+00:00\",\"description\":\"Hi\u1ec7n nay nhi\u1ec1u ng\u01b0\u1eddi \u0111ang t\u00ecm hi\u1ec3u h\u00e0m TODAY \u0111\u1ec3 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u ng\u00e0y hi\u1ec7n t\u1ea1i. V\u1eady c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u01b0 th\u1ebf n\u00e0o l\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t?\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-today\\\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-today\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-today\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/ham-today-18.jpg\",\"contentUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/ham-today-18.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-today-18\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-today\\\/#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 TODAY trong Excel t\u00ednh th\u1eddi gian th\u1ef1c c\u00f3 v\u00ed d\u1ee5\"}]},{\"@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\\\/82f19cb5a6fb9de82c288acacfe400c5\",\"name\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/52d65c108a45fcdcbf240a10a167941932bf79e5b7a622f78ab464220ab80cef?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/52d65c108a45fcdcbf240a10a167941932bf79e5b7a622f78ab464220ab80cef?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/52d65c108a45fcdcbf240a10a167941932bf79e5b7a622f78ab464220ab80cef?s=96&d=mm&r=g\",\"caption\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\"},\"description\":\"Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Xu\u00e2n Thi\u00ean. Trong k\u1ef7 nguy\u00ean s\u1ed1 thay \u0111\u1ed5i t\u1eebng gi\u1edd, m\u00ecnh \u1edf \u0111\u00e2y \u0111\u1ec3 c\u00f9ng b\u1ea1n c\u1eadp nh\u1eadt v\u00e0 ph\u00e2n t\u00edch nh\u1eefng chuy\u1ec3n \u0111\u1ed9ng m\u1edbi nh\u1ea5t c\u1ee7a th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7. B\u1eb1ng s\u1ef1 am hi\u1ec3u v\u1ec1 h\u1ec7 sinh th\u00e1i c\u00e1c s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, m\u00ecnh cam k\u1ebft mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng g\u00f3c nh\u00ecn tr\u1ef1c quan, h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch th\u00f4ng minh nh\u1ea5t.\",\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hoanghamobilecom\"],\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/author\\\/nguyen-xuan-thien\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TODAY trong Excel t\u00ednh th\u1eddi gian th\u1ef1c c\u00f3 v\u00ed d\u1ee5","description":"Hi\u1ec7n nay nhi\u1ec1u ng\u01b0\u1eddi \u0111ang t\u00ecm hi\u1ec3u h\u00e0m TODAY \u0111\u1ec3 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u ng\u00e0y hi\u1ec7n t\u1ea1i. V\u1eady c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u01b0 th\u1ebf n\u00e0o l\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t?","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-today\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TODAY trong Excel t\u00ednh th\u1eddi gian th\u1ef1c c\u00f3 v\u00ed d\u1ee5","og_description":"Hi\u1ec7n nay nhi\u1ec1u ng\u01b0\u1eddi \u0111ang t\u00ecm hi\u1ec3u h\u00e0m TODAY \u0111\u1ec3 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u ng\u00e0y hi\u1ec7n t\u1ea1i. V\u1eady c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u01b0 th\u1ebf n\u00e0o l\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t?","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-today\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-11-04T03:41:20+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-18.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"16 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-today\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-today\/"},"author":{"name":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/82f19cb5a6fb9de82c288acacfe400c5"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TODAY trong Excel t\u00ednh th\u1eddi gian th\u1ef1c c\u00f3 v\u00ed d\u1ee5","datePublished":"2023-11-04T03:41:20+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-today\/"},"wordCount":3180,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-today\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-18.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-today\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-today\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-today\/","name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TODAY trong Excel t\u00ednh th\u1eddi gian th\u1ef1c c\u00f3 v\u00ed d\u1ee5","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-today\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-today\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-18.jpg","datePublished":"2023-11-04T03:41:20+00:00","description":"Hi\u1ec7n nay nhi\u1ec1u ng\u01b0\u1eddi \u0111ang t\u00ecm hi\u1ec3u h\u00e0m TODAY \u0111\u1ec3 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u ng\u00e0y hi\u1ec7n t\u1ea1i. V\u1eady c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u01b0 th\u1ebf n\u00e0o l\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t?","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-today\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-today\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-today\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-18.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-today-18.jpg","width":1200,"height":628,"caption":"ham-today-18"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-today\/#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 TODAY trong Excel t\u00ednh th\u1eddi gian th\u1ef1c c\u00f3 v\u00ed d\u1ee5"}]},{"@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\/82f19cb5a6fb9de82c288acacfe400c5","name":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/secure.gravatar.com\/avatar\/52d65c108a45fcdcbf240a10a167941932bf79e5b7a622f78ab464220ab80cef?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/52d65c108a45fcdcbf240a10a167941932bf79e5b7a622f78ab464220ab80cef?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/52d65c108a45fcdcbf240a10a167941932bf79e5b7a622f78ab464220ab80cef?s=96&d=mm&r=g","caption":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean"},"description":"Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Xu\u00e2n Thi\u00ean. Trong k\u1ef7 nguy\u00ean s\u1ed1 thay \u0111\u1ed5i t\u1eebng gi\u1edd, m\u00ecnh \u1edf \u0111\u00e2y \u0111\u1ec3 c\u00f9ng b\u1ea1n c\u1eadp nh\u1eadt v\u00e0 ph\u00e2n t\u00edch nh\u1eefng chuy\u1ec3n \u0111\u1ed9ng m\u1edbi nh\u1ea5t c\u1ee7a th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7. B\u1eb1ng s\u1ef1 am hi\u1ec3u v\u1ec1 h\u1ec7 sinh th\u00e1i c\u00e1c s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, m\u00ecnh cam k\u1ebft mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng g\u00f3c nh\u00ecn tr\u1ef1c quan, h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch th\u00f4ng minh nh\u1ea5t.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-thien\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/280451","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\/102"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=280451"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/280451\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/280479"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=280451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=280451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=280451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}