{"id":1628,"date":"2020-10-26T09:23:07","date_gmt":"2020-10-26T02:23:07","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1628"},"modified":"2020-10-26T09:25:48","modified_gmt":"2020-10-26T02:25:48","slug":"ham-date-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/ham-date-trong-excel\/","title":{"rendered":"C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m DATE &#8211; H\u00e0m Ng\u00e0y Th\u00e1ng N\u0103m Trong Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1628\" class=\"elementor elementor-1628\">\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-d1339a7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d1339a7\" 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-584dbd0\" data-id=\"584dbd0\" 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-a8141c4 elementor-widget elementor-widget-text-editor\" data-id=\"a8141c4\" 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-671b349b-7fff-0740-bd8c-cea8aa6c763c\"><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;\">H\u00e0m DATE L\u00e0 G\u00ec? T\u1ea1i Sao Ph\u1ea3i S\u1eed D\u1ee5ng H\u00e0m DATE?<\/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-7b354dc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7b354dc\" 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-c81492d\" data-id=\"c81492d\" 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-f6e9e88 elementor-widget elementor-widget-text-editor\" data-id=\"f6e9e88\" 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;\">Khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh Excel, ch\u1eafc h\u1eb3n b\u1ea1n \u0111\u00e3 t\u1eebng l\u00e0m vi\u1ec7c v\u1edbi ki\u1ec3u d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng. C\u00e1ch hi\u1ec3n th\u1ecb\/ \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng c\u00f3 th\u1ec3 kh\u00e1c nhau, nh\u01b0ng khi x\u1eed l\u00fd d\u1eef li\u1ec7u t\u00ednh ng\u00e0y th\u00e1ng th\u00ec Excel th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n v\u1edbi \u0111\u1ecbnh d\u1ea1ng s\u1ed1 s\u00ea-ri.<\/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-ad7ca8c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ad7ca8c\" 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-378ee0e\" data-id=\"378ee0e\" 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-2b35376 elementor-widget elementor-widget-text-editor\" data-id=\"2b35376\" 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, \u0111\u1ec3 t\u00ednh t\u1eeb ng\u00e0y 8\/3\/2019 \u0111\u1ebfn ng\u00e0y 1\/1\/2020 c\u00f3 bao nhi\u00eau ng\u00e0y, Excel s\u1ebd th\u1ef1c hi\u1ec7n ph\u00e9p tr\u1eeb gi\u1eefa 2 s\u1ed1 s\u00ea-ri t\u01b0\u01a1ng \u1ee9ng l\u00e0 43532 v\u00e0 43831.<\/span><\/p>\n<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;\">B\u1ea1n kh\u00f4ng th\u1ec3 nh\u1eadp tr\u1ef1c ti\u1ebfp c\u00f4ng th\u1ee9c =1\/1\/2020 \u2013 8\/3\/2019 v\u00ec Excel s\u1ebd hi\u1ec3u \u0111\u00e2y l\u00e0 ph\u00e9p tr\u1eeb c\u1ee7a 2 ph\u00e9p chia.<\/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;\"><br><\/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-9e1d150 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9e1d150\" 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-505a91c\" data-id=\"505a91c\" 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-c2c82a1 elementor-widget elementor-widget-text-editor\" data-id=\"c2c82a1\" 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-691bd70e-7fff-7aea-a051-171daecae023\"><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;\">Ngo\u00e0i ra, khi s\u1eed d\u1ee5ng d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng ki\u1ec3u mm\/dd\/yyyy (th\u00e1ng\/ ng\u00e0y\/ n\u0103m) ho\u1eb7c dd\/mm\/yyy (ng\u00e0y\/ th\u00e1ng\/ n\u0103m), b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea7m l\u1eabn, v\u00ed d\u1ee5 ng\u00e0y 08\/03\/2020, b\u1ea1n c\u00f3 th\u1ec3 kh\u00f4ng bi\u1ebft h\u1ec7 th\u1ed1ng \u0111ang ghi nh\u1eadn ng\u00e0y hay th\u00e1ng tr\u01b0\u1edbc.<\/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-5f5ebd9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5f5ebd9\" 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-44cc5fb\" data-id=\"44cc5fb\" 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-dbb2d18 elementor-widget elementor-widget-text-editor\" data-id=\"dbb2d18\" 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-12815598-7fff-a5ba-e435-e794566e8463\"><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 DATE gi\u00fap b\u1ea1n x\u00e1c \u0111\u1ecbnh r\u00f5 ng\u00e0y, th\u00e1ng, n\u0103m c\u1ee7a 1 ng\u00e0y c\u1ee5 th\u1ec3 m\u00e0 kh\u00f4ng g\u00e2y nh\u1ea7m l\u1eabn gi\u1eefa th\u00e1ng v\u00e0 ng\u00e0y, \u0111\u1ed3ng th\u1eddi b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp tr\u1ef1c ti\u1ebfp ng\u00e0y v\u00e0o ph\u00e9p t\u00ednh trong Excel b\u1eb1ng c\u00e1ch nh\u1eadp qua h\u00e0m DATE.<\/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-826bfbb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"826bfbb\" 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-f3395cc\" data-id=\"f3395cc\" 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-e281ab2 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"e281ab2\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;bullets&quot;,&quot;icon&quot;:{&quot;value&quot;:&quot;&quot;,&quot;library&quot;:&quot;&quot;},&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h4 class=\"elementor-toc__header-title\">M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\"><i class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\"><i class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-loading eicon-animation-spin\" aria-hidden=\"true\"><\/i>\n\t\t\t<\/div>\n\t\t<\/div>\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-77572e9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"77572e9\" 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-92f9b02\" data-id=\"92f9b02\" 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-bd82b6b elementor-widget elementor-widget-heading\" data-id=\"bd82b6b\" 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-b3ebef49-7fff-f8bb-27e0-6df46c9d2bfe\"><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 DATE Trong Excel<\/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-44f46ad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"44f46ad\" 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-05403ff\" data-id=\"05403ff\" 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-b42aabe elementor-widget elementor-widget-text-editor\" data-id=\"b42aabe\" 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; margin-top: 0pt; margin-bottom: 0pt;\"><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;\">=DATE(year, month, day)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">Trong \u0111\u00f3 year, month, day l\u1ea7n l\u01b0\u1ee3t l\u00e0 n\u0103m, th\u00e1ng, ng\u00e0y c\u1ee7a ng\u00e0y c\u1ea7n nh\u1eadp.<\/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-b8fbfa1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b8fbfa1\" 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-e0656fd\" data-id=\"e0656fd\" 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-a582b5f elementor-widget elementor-widget-text-editor\" data-id=\"a582b5f\" 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, \u0111\u1ec3 nh\u1eadp ng\u00e0y 8 th\u00e1ng 3 n\u0103m 2020, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c DATE(2020,3,8).<\/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;\">Khi \u0111\u00f3 d\u00f9 h\u1ec7 th\u1ed1ng m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n \u0111ang ghi nh\u1eadn c\u00e1ch hi\u1ec3n th\u1ecb ng\u00e0y th\u00e1ng m\u1eb7c \u0111\u1ecbnh l\u00e0 mm\/dd\/yyyy hay dd\/mm\/yyyy th\u00ec \u00f4 Excel \u0111\u01b0\u1ee3c nh\u1eadp b\u1eb1ng c\u00f4ng th\u1ee9c h\u00e0m DATE tr\u00ean v\u1eabn tr\u1ea3 v\u1ec1 \u0111\u00fang s\u1ed1 s\u00ea-ri 43898 c\u1ee7a ng\u00e0y ng\u00e0y 8 th\u00e1ng 3 n\u0103m 2020.<\/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-4f5fa41 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4f5fa41\" 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-f2f9243\" data-id=\"f2f9243\" 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-2b1e5b8 elementor-widget elementor-widget-image\" data-id=\"2b1e5b8\" 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\/vi-du-ham-date-trong-excel.png\" title=\"vi-du-ham-date-trong-excel\" alt=\"V\u00ed d\u1ee5 h\u00e0m DATE l\u1ea5y ng\u00e0y th\u00e1ng n\u0103m trong Excel\" \/>\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-5cde4fb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5cde4fb\" 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-8614f2b\" data-id=\"8614f2b\" 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-67206b7 elementor-widget elementor-widget-text-editor\" data-id=\"67206b7\" 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;\">\u00a0<\/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;\">T\u01b0\u01a1ng t\u1ef1, \u0111\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 kh\u00f4ng th\u1ec3 nh\u1eadp tr\u1ef1c ti\u1ebfp c\u00f4ng th\u1ee9c =1\/1\/2020 \u2013 8\/3\/2019 nh\u01b0 \u0111\u00e3 n\u00eau \u1edf tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m DATE:<\/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;\">=DATE(2020,1,1) &#8211; DATE(2019,3,8)<\/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-55506f6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"55506f6\" 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-1950225\" data-id=\"1950225\" 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-4d8ed80 elementor-widget elementor-widget-image\" data-id=\"4d8ed80\" 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\/vi-du-ham-date-phep-tru-ngay-trong-excel.png\" title=\"vi-du-ham-date-phep-tru-ngay-trong-excel\" alt=\"s\u1eed d\u1ee5ng h\u00e0m DATE nh\u1eadp ng\u00e0y th\u00e1ng trong ph\u00e9p tr\u1eeb trong Excel\" \/>\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-5b8e82d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5b8e82d\" 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-c78c81a\" data-id=\"c78c81a\" 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-ca72e4a elementor-widget elementor-widget-heading\" data-id=\"ca72e4a\" 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-cd98e328-7fff-4cac-b2ee-cf3a937824ee\"><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, L\u01b0u \u00dd C\u00e1ch D\u00f9ng H\u00e0m DATE<\/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-f50177f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f50177f\" 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-f290a99\" data-id=\"f290a99\" 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-22fcde4 elementor-widget elementor-widget-heading\" data-id=\"22fcde4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-42afa49f-7fff-6ec7-2d24-214ad10b7224\"><span style=\"font-size: 16pt; 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.1, \u0110\u1ed1i s\u1ed1 \u201cYear\u201d \u0110\u1ec3 X\u00e1c \u0110\u1ecbnh N\u0103m<\/span><\/span><\/h3>\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-d31f11f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d31f11f\" 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-1873842\" data-id=\"1873842\" 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-bd8fc0e elementor-widget elementor-widget-text-editor\" data-id=\"bd8fc0e\" 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;\">Khi d\u00f9ng h\u00e0m DATE \u0111\u1ec3 l\u1ea5y ng\u00e0y trong Excel, c\u1ea7n l\u01b0u \u00fd Excel s\u1eed d\u1ee5ng n\u0103m theo h\u1ec7 th\u1ed1ng ng\u00e0y th\u00e1ng 1900 \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp tr\u00ean m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n.<\/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-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Trong h\u1ec7 th\u1ed1ng ng\u00e0y th\u00e1ng n\u00e0y:<\/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-e3c1e9e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e3c1e9e\" 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-0a2e040\" data-id=\"0a2e040\" 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-b2c105d elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"b2c105d\" 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-5770fc00-7fff-25d4-0709-be3906c67671\"><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;\">Ng\u00e0y \u0111\u1ea7u ti\u00ean l\u00e0 ng\u00e0y 01\/01\/1900.<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\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-da0a4979-7fff-4bb7-bebd-32c7e9f4039b\"><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;\">N\u1ebfu \u0111\u1ed1i s\u1ed1 <\/span><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;\">year <\/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;\">c\u1ee7a <\/span><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;\">h\u00e0m DATE <\/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;\">t\u1eeb 1900 \u0111\u1ebfn 9999, gi\u00e1 tr\u1ecb c\u1ee7a year \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng tr\u1ef1c ti\u1ebfp \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh n\u0103m. V\u00ed d\u1ee5: DATE(2020,11,20) tr\u1ea3 v\u1ec1 ng\u00e0y 20 th\u00e1ng 11 n\u0103m 2020.<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\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-396a23df-7fff-2433-99b3-b8818a6b0e75\"><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;\">N\u1ebfu <\/span><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;\">year <\/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;\">t\u1eeb 0 \u0111\u1ebfn 1899, Excel s\u1ebd c\u1ed9ng th\u00eam 1900 \u0111\u1ec3 t\u00ednh n\u0103m. V\u00ed d\u1ee5: DATE(5,1,1) tr\u1ea3 v\u1ec1 ng\u00e0y 1 th\u00e1ng 1 n\u0103m 1905 (k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p c\u1ed9ng 1900+5).<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\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-12945111-7fff-3da3-9d4d-e27029be533a\"><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;\">N\u1ebfu <\/span><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;\">year<\/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;\"> nh\u1ecf h\u01a1n 0 ho\u1eb7c l\u1edbn h\u01a1n 9999, h\u00e0m DATE s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #NUM!.<\/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-b536678 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b536678\" 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-ba50a65\" data-id=\"ba50a65\" 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-1016d50 elementor-widget elementor-widget-image\" data-id=\"1016d50\" 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\/luu-y-su-dung-ham-date-trong-excel-year.png\" title=\"luu-y-su-dung-ham-date-trong-excel-year\" alt=\"L\u01b0u \u00dd C\u00e1ch D\u00f9ng H\u00e0m Date C\u00e1ch L\u1ea5y N\u0103m Trong Excel V\u1edbi \u0110\u1ed1i S\u1ed1 Year\" \/>\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-e15cf4c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e15cf4c\" 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-3b1fdbc\" data-id=\"3b1fdbc\" 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-3e0387c elementor-widget elementor-widget-heading\" data-id=\"3e0387c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-2dda100f-7fff-7228-1b5b-5f83ff2bbc9d\"><span style=\"font-size: 16pt; 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.2<\/span><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">, <\/span><span style=\"font-size: 16pt; 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;\">\u0110\u1ed1i s\u1ed1 \u201cMonth\u201d \u0110\u1ec3 X\u00e1c \u0110\u1ecbnh Th\u00e1ng<\/span><\/span><\/h3>\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-152a673 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"152a673\" 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-560b83e\" data-id=\"560b83e\" 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-2647a8c elementor-widget elementor-widget-text-editor\" data-id=\"2647a8c\" 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;\">Th\u00e1ng th\u00f4ng th\u01b0\u1eddng ch\u1ec9 c\u00f3 gi\u00e1 tr\u1ecb t\u1eeb 1 \u0111\u1ebfn 12.<\/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;\">Tuy nhi\u00ean, v\u1edbi h\u00e0m DATE, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp gi\u00e1 tr\u1ecb th\u00e1ng l\u00e0 1 s\u1ed1 nguy\u00ean b\u1ea5t k\u1ef3.<\/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>\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-4ecc6c9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4ecc6c9\" 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-bbc0a39\" data-id=\"bbc0a39\" 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-6d39893 elementor-widget elementor-widget-text-editor\" data-id=\"6d39893\" 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;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 v\u00ed d\u1ee5 c\u00e1ch c\u00e1ch gh\u00e9p ng\u00e0y th\u00e1ng n\u0103m trong Excel b\u1eb1ng h\u00e0m DATE khi \u0111\u1ed1i s\u1ed1 <\/span><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;\">month<\/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;\"> kh\u00f4ng ph\u1ea3i l\u00e0 t\u1eeb 1 \u0111\u1ebfn 12:<\/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: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">N\u1ebfu <\/span><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;\">month &gt; 12<\/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;\">, h\u00e0m DATE t\u0103ng s\u1ed1 n\u0103m t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 th\u00e1ng v\u01b0\u1ee3t qu\u00e1 12 nh\u01b0 sau: DATE(2020,20,15) tra\u0309 v\u1ec1 k\u1ebft qu\u1ea3 ng\u00e0y 15 th\u00e1ng 8 n\u0103m 2021 (do 20 th\u00e1ng t\u01b0\u01a1ng \u1ee9ng 1 n\u0103m 8 th\u00e1ng n\u00ean s\u1ed1 n\u0103m = 2020+1).<\/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-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">N\u1ebfu <\/span><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;\">month &lt; 1<\/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;\">, h\u00e0m DATE gi\u1ea3m s\u1ed1 n\u0103m t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 th\u00e1ng \u00e2m nh\u01b0 sau: DATE(2020,-2,15) tra\u0309 v\u1ec1 k\u1ebft qu\u1ea3 ng\u00e0y 15 th\u00e1ng 10 n\u0103m 2019 (do s\u1ed1 th\u00e1ng \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng -2+12 th\u00e1ng \u0111\u1ed3ng th\u1eddi s\u1ed1 n\u0103m gi\u1ea3m \u0111i 1 n\u0103m).<\/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-9ab4310 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9ab4310\" 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-419c074\" data-id=\"419c074\" 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-d565a01 elementor-widget elementor-widget-image\" data-id=\"d565a01\" 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\/luu-y-su-dung-ham-date-trong-excel-doi-so-month-thang.png\" title=\"luu-y-su-dung-ham-date-trong-excel-doi-so-month-thang\" alt=\"L\u01b0u \u00dd C\u00e1ch D\u00f9ng H\u00e0m Date L\u1ea5y Th\u00e1ng Trong Excel V\u1edbi \u0110\u1ed1i S\u1ed1 Month\" \/>\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-85ee91b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"85ee91b\" 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-9cf8ca6\" data-id=\"9cf8ca6\" 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-206cbc7 elementor-widget elementor-widget-heading\" data-id=\"206cbc7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-d5a67e6e-7fff-328a-fbea-0de99cc3ebaa\"><span style=\"font-size: 16pt; 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.3, \u0110\u1ed1i s\u1ed1 \u201cDay\u201d \u0110\u1ec3 X\u00e1c \u0110\u1ecbnh Ng\u00e0y<\/span><\/span><\/h3>\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-1898994 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1898994\" 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-d8aba1c\" data-id=\"d8aba1c\" 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-a2416cc elementor-widget elementor-widget-text-editor\" data-id=\"a2416cc\" 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-78a60b2e-7fff-73db-d166-c568a1824617\"><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;\">Ng\u00e0y th\u00f4ng th\u01b0\u1eddng ch\u1ec9 c\u00f3 gi\u00e1 tr\u1ecb t\u1eeb 1 \u0111\u1ebfn 31 v\u00e0 c\u00f2n t\u00f9y thu\u1ed9c v\u00e0o th\u00e1ng (th\u00e1ng c\u00f3 28, 29, 30 hay 31 ng\u00e0y).<\/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-dece274 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dece274\" 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-dbd0ad4\" data-id=\"dbd0ad4\" 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-b76bfd6 elementor-widget elementor-widget-text-editor\" data-id=\"b76bfd6\" 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;\">Tuy nhi\u00ean, v\u1edbi h\u00e0m DATE, t\u01b0\u01a1ng t\u1ef1 nh\u01b0 \u0111\u1ed1i s\u1ed1 <\/span><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;\">month,<\/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;\"> b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp gi\u00e1 tr\u1ecb <\/span><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;\">day<\/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;\"> &#8211; ng\u00e0y l\u00e0 1 s\u1ed1 nguy\u00ean b\u1ea5t k\u1ef3, v\u00e0 Excel t\u00ednh gi\u00e1 tr\u1ecb c\u1ee7a ng\u00e0y, th\u00e1ng, n\u0103m d\u1ef1a tr\u00ean c\u00e1c nguy\u00ean t\u1eafc t\u01b0\u01a1ng t\u1ef1 \u1edf m\u1ee5c 2.2.<\/span><\/p>\n<ul style=\"margin-top: 0; margin-bottom: 0;\">\n<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: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">N\u1ebfu <\/span><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;\">day <\/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;\">l\u1edbn h\u01a1n s\u1ed1 ng\u00e0y m\u1eb7c \u0111\u1ecbnh trong th\u00e1ng, Excel s\u1ebd c\u1ed9ng s\u1ed1 ng\u00e0y \u0111\u00f3 v\u00e0o ng\u00e0y \u0111\u1ea7u ti\u00ean c\u1ee7a th\u00e1ng. V\u00ed d\u1ee5: DATE(2020,5,45) tra\u0309 v\u1ec1 k\u1ebft qu\u1ea3 ng\u00e0y 14 th\u00e1ng 6 n\u0103m 2020, do th\u00e1ng 5 \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh 31 ng\u00e0y n\u00ean ng\u00e0y =45-31 v\u00e0 th\u00e1ng t\u01b0\u01a1ng \u1ee9ng t\u0103ng 1 th\u00e1ng.<\/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=\"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;\">N\u1ebfu <\/span><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;\">day <\/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;\">nh\u1ecf h\u01a1n 1, Excel s\u1ebd tr\u1eeb s\u1ed1 ng\u00e0y \u0111\u00f3 k\u1ec3 t\u01b0\u0300 cu\u1ed1i c\u00f9ng cu\u0309a th\u00e1ng ngay tr\u01b0\u1edbc th\u00e1ng \u1edf \u0111\u1ed1i s\u1ed1 <\/span><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;\">month<\/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;\">. V\u00ed d\u1ee5: DATE(2020,3,-5) tra\u0309 v\u1ec1 k\u1ebft qu\u1ea3 ng\u00e0y 24 th\u00e1ng 2 n\u0103m 2020, do th\u00e1ng 2 c\u00f3 29 ng\u00e0y (n\u0103m nhu\u1eadn) n\u00ean ng\u00e0y =29-5 v\u00e0 th\u00e1ng t\u01b0\u01a1ng \u1ee9ng gi\u1ea3m 1 th\u00e1ng.<\/span><\/p><\/li>\n<\/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-64a1621 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"64a1621\" 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-6fe2897\" data-id=\"6fe2897\" 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-65fe30d elementor-widget elementor-widget-image\" data-id=\"65fe30d\" 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\/luu-y-su-dung-ham-date-trong-excel-doi-so-day-ngay.png\" title=\"luu-y-su-dung-ham-date-trong-excel-doi-so-day-ngay\" alt=\"L\u01b0u \u00dd C\u00e1ch D\u00f9ng H\u00e0m Date L\u1ea5y Ng\u00e0y Trong Excel V\u1edbi \u0110\u1ed1i s\u1ed1 Day \u0110\u1ec3 X\u00e1c \u0110\u1ecbnh Ng\u00e0y\" \/>\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-f227099 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f227099\" 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-4e4f313\" data-id=\"4e4f313\" 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-06c1ed7 elementor-widget elementor-widget-text-editor\" data-id=\"06c1ed7\" 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-27db4c37-7fff-fb2a-89f3-d29ff3dee1d1\"><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;\">Ngo\u00e0i h\u00e0m DATE, \u0111\u1ec3 h\u00e0m l\u1ea5y ng\u00e0y hi\u1ec7n t\u1ea1i, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m l\u1ea5y ng\u00e0y th\u00e1ng n\u0103m hi\u1ec7n t\u1ea1i trong Excel: <\/span><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;\">=TODAY()<\/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;\">.<\/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-b16477f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b16477f\" 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-7640558\" data-id=\"7640558\" 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-1102afa elementor-widget elementor-widget-heading\" data-id=\"1102afa\" 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-8fbb21e4-7fff-255d-2752-f695334d6e43\"><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, S\u1eed D\u1ee5ng H\u00e0m DATE L\u00e0m H\u00e0m T\u00ednh Ng\u00e0y Trong Excel<\/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-588fc47 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"588fc47\" 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-36c614f\" data-id=\"36c614f\" 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-f826992 elementor-widget elementor-widget-text-editor\" data-id=\"f826992\" 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 DATE l\u00e0 h\u00e0m ng\u00e0y th\u00e1ng trong Excel c\u00f3 r\u1ea5t nhi\u1ec1u \u1ee9ng d\u1ee5ng trong vi\u1ec7c t\u00ednh ng\u00e0y b\u1eb1ng c\u00e1ch c\u1ed9ng th\u00eam ho\u1eb7c tr\u1eeb b\u01a1\u0301t m\u1ed9t s\u1ed1 ng\u00e0y t\u01b0\u0300 m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3.<\/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;\">Hoctin.vn \u0111\u00e3 c\u00f3 b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn chi ti\u1ebft s\u1eed d\u1ee5ng h\u00e0m DATE v\u00e0 c\u00e1c h\u00e0m ng\u00e0y th\u00e1ng kh\u00e1c \u0111\u1ec3 t\u00ednh to\u00e1n v\u1edbi gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng n\u0103m trong Excel m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/span><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; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"><i><b>Xem th\u00eam:<\/b><\/i> <\/span><a style=\"background-color: #ffffff;\" href=\"https:\/\/hoctin.vn\/cach-tinh-so-ngay-trong-excel\/\" target=\"_blank\" rel=\"noopener\"><b><i>C\u00e1c c\u00e1ch t\u00ednh ng\u00e0y trong Excel<\/i><\/b><\/a><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\">\u00a0<\/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-4ca29e2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4ca29e2\" 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-90dec1e\" data-id=\"90dec1e\" 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-f6e0e85 elementor-widget elementor-widget-text-editor\" data-id=\"f6e0e85\" 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;\">V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y \u1ee9ng d\u1ee5ng h\u00e0m DATE \u0111\u1ec3 t\u00ednh ng\u00e0y, k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m YEAR, MONTH, DAY \u0111\u1ec3 l\u1ea5y n\u0103m, th\u00e1ng, ng\u00e0y trong Excel v\u00e0 t\u00f9y ch\u1ec9nh c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00f3 b\u1eb1ng bi\u1ec3u th\u1ee9c c\u1ed9ng, tr\u1eeb &#8211; t<\/span><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00ecm ng\u00e0y \u0111\u1ea7u th\u00e1ng, ng\u00e0y \u0111\u1ea7u n\u0103m, hay tr\u1eeb m\u1ed9t ng\u00e0y cho tr\u01b0\u1edbc v\u1edbi 1 s\u1ed1 n\u0103m v\u00e0 ng\u00e0y th\u00e1ng nh\u1ea5t \u0111\u1ecbnh:<\/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-0dd5c4d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0dd5c4d\" 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-be58e88\" data-id=\"be58e88\" 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-8a60e27 elementor-widget elementor-widget-image\" data-id=\"8a60e27\" 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\/tang-hoac-giam-ngay-theo-1-so-ngay-nhat-dinh-su-dung-ham-date-trong-excel.png\" title=\"tang-hoac-giam-ngay-theo-1-so-ngay-nhat-dinh-su-dung-ham-date-trong-excel\" alt=\"S\u1eed D\u1ee5ng H\u00e0m DATE L\u00e0m H\u00e0m T\u00ednh Ng\u00e0y Trong Excel\" \/>\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-d3d3457 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d3d3457\" 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-8a12c0f\" data-id=\"8a12c0f\" 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-4d17942 elementor-widget elementor-widget-heading\" data-id=\"4d17942\" 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-cc06dace-7fff-cf13-3329-bc11db68fed8\"><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;\">4, H\u00e0m DATE \u0110\u1ec3 \u0110\u1ecbnh D\u1ea1ng, S\u1eeda L\u1ed7i D\u1eef Li\u1ec7u Ng\u00e0y Th\u00e1ng Trong Excel<\/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-45989f0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"45989f0\" 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-99a0d72\" data-id=\"99a0d72\" 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-0dfa4ba elementor-widget elementor-widget-text-editor\" data-id=\"0dfa4ba\" 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-bed5cb8d-7fff-0645-40ac-bac61137ebf2\"><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 DATE c\u00f2n hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 s\u1eeda l\u1ed7i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng, chuy\u1ec3n \u0111\u1ed5i c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n (text) th\u00e0nh ng\u00e0y.<\/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-730901c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"730901c\" 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-82bbedf\" data-id=\"82bbedf\" 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-7b43151 elementor-widget elementor-widget-text-editor\" data-id=\"7b43151\" 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-71392626-7fff-24bf-8ef9-9b7d9b9ada8d\"><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;\">\u0110\u00f4i khi b\u1ea1n copy d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng t\u1eeb m\u1ed9t t\u1ec7p kh\u00e1c m\u00e0 Excel kh\u00f4ng nh\u1eadn di\u1ec7n ch\u00fang l\u00e0 ng\u00e0y th\u00e1ng do \u0111\u1ecbnh d\u1ea1ng d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n ho\u1eb7c nh\u1ea7m l\u1eabn th\u00f4ng tin gi\u1eefa ng\u00e0y v\u00e0 th\u00e1ng 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-c6353c7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c6353c7\" 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-461451f\" data-id=\"461451f\" 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-61ce1bc elementor-widget elementor-widget-image\" data-id=\"61ce1bc\" 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\/du-lieu-ngay-thang-trong-excel-bi-loi.png\" title=\"du-lieu-ngay-thang-trong-excel-bi-loi\" alt=\"\u0110\u00f4i khi b\u1ea1n copy d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng t\u1eeb m\u1ed9t t\u1ec7p kh\u00e1c m\u00e0 Excel kh\u00f4ng nh\u1eadn di\u1ec7n ch\u00fang l\u00e0 ng\u00e0y th\u00e1ng do \u0111\u1ecbnh d\u1ea1ng d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n ho\u1eb7c nh\u1ea7m l\u1eabn th\u00f4ng tin gi\u1eefa ng\u00e0y v\u00e0 th\u00e1ng d\u1eabn \u0111\u1ebfn l\u1ed7i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng trong Excel\" \/>\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-cc0c02a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cc0c02a\" 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-9f1c4ce\" data-id=\"9f1c4ce\" 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-4fe4d23 elementor-widget elementor-widget-text-editor\" data-id=\"4fe4d23\" 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;\"><i><b>\u00a0<\/b><\/i><\/span><\/p><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;\"><i><b>B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm \u0111\u1ecdc b\u00e0i vi\u1ebft<\/b><\/i> <\/span><a href=\"https:\/\/hoctin.vn\/dinh-dang-ngay-thang-trong-excel\/\" target=\"_blank\" rel=\"noopener\"><b><i>\u0110\u1ecbnh D\u1ea1ng Ng\u00e0y Th\u00e1ng Trong Excel<\/i><\/b><\/a><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;\"> <i><b>\u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1c c\u00e1ch s\u1eeda l\u1ed7i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng.<\/b><\/i><\/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-dfb5cc1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dfb5cc1\" 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-f15d6ec\" data-id=\"f15d6ec\" 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-b29b3f3 elementor-widget elementor-widget-text-editor\" data-id=\"b29b3f3\" 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-c86af215-7fff-1480-f328-093012558b0b\"><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 khu\u00f4n kh\u1ed5 b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd gi\u1edbi thi\u1ec7u v\u1edbi b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m DATE \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i c\u00e1c d\u1eef li\u1ec7u b\u1ecb l\u1ed7i n\u00e0y th\u00e0nh ng\u00e0y.<\/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-2dec28d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2dec28d\" 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-96be1a1\" data-id=\"96be1a1\" 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-8767a67 elementor-widget elementor-widget-text-editor\" data-id=\"8767a67\" 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, \u00f4 A1 ch\u1ee9a ng\u00e0y th\u00e1ng \u1edf \u0111\u1ecbnh d\u1ea1ng MMDDYYYY (th\u00e1ng\/ ng\u00e0y\/ n\u0103m) nh\u01b0ng ng\u00e0y th\u00e1ng m\u1eb7c \u0111\u1ecbnh c\u1ee7a h\u1ec7 th\u1ed1ng l\u00e0 DDMMYYYY (ng\u00e0y\/ th\u00e1ng\/ n\u0103m).<\/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;\">Ch\u00ednh v\u00ec v\u1eady, gi\u00e1 tr\u1ecb 07\/18\/2020 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n v\u00ec Excel kh\u00f4ng ghi nh\u1eadn th\u00e1ng 18.<\/span><\/p><p>\u00a0<\/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;\">N\u1ebfu b\u1ea1n thay \u0111\u1ed5i thi\u1ebft l\u1eadp ng\u00e0y m\u1eb7c \u0111\u1ecbnh trong m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n (chi ti\u1ebft tr\u01b0\u1eddng h\u1ee3p n\u00ean \u00e1p d\u1ee5ng \u0111\u00e3 \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn trong b\u00e0i vi\u1ebft \u0110\u1ecbnh D\u1ea1ng Ng\u00e0y Th\u00e1ng), c\u00e1c file Excel c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c l\u01b0u tr\u01b0\u1edbc \u0111\u00f3 c\u00f3 th\u1ec3 b\u1ecb thay \u0111\u1ed5i theo.<\/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;\">\u00a0<\/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\u00e2y l\u00e0 \u0111i\u1ec1u ch\u1eafc h\u1eb3n b\u1ea1n kh\u00f4ng mu\u1ed1n x\u1ea3y ra v\u00ec d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng c\u1ee7a c\u00e1c trang t\u00ednh c\u0169 s\u1ebd b\u1ecb x\u00e1o tr\u1ed9n gi\u1eefa ng\u00e0y v\u00e0 th\u00e1ng, v\u00e0 c\u0169ng s\u1ebd d\u1eabn \u0111\u1ebfn l\u1ed7i t\u01b0\u01a1ng t\u1ef1 nh\u01b0 tr\u00ean.<\/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;\">\u00a0<\/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-5efd28b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5efd28b\" 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-313ed62\" data-id=\"313ed62\" 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-d2db0b7 elementor-widget elementor-widget-text-editor\" data-id=\"d2db0b7\" 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-727b034e-7fff-d441-510e-79b157e7dd74\"><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;\">L\u00fac n\u00e0y, s\u1eed d\u1ee5ng h\u00e0m DATE k\u1ebft h\u1ee3p v\u1edbi c\u00e1c <\/span><a href=\"https:\/\/hoctin.vn\/ham-lay-ky-tu-bat-ky-trong-excel\/\" target=\"_blank\"><i><b>h\u00e0m LEFT, MID v\u00e0 RIGHT<\/b><\/i><\/a><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;\"> \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u d\u1ea1ng v\u0103n b\u1ea3n<\/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;\">th\u00e0nh ng\u00e0y th\u00e1ng l\u00e0 c\u00e1ch t\u1ed1i \u01b0u v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n nh\u1ea5t:<\/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-9e380fc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9e380fc\" 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-ae080f5\" data-id=\"ae080f5\" 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-a2b1a92 elementor-widget elementor-widget-image\" data-id=\"a2b1a92\" 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-date-xu-ly-du-lieu-ngay-thang-trong-excel-bi-loi.png\" title=\"su-dung-ham-date-xu-ly-du-lieu-ngay-thang-trong-excel-bi-loi\" alt=\"s\u1eed d\u1ee5ng h\u00e0m DATE \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m LEFT, MID v\u00e0 RIGHT \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u d\u1ea1ng v\u0103n b\u1ea3n th\u00e0nh ng\u00e0y th\u00e1ng trong Excel\" \/>\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-a4627e3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a4627e3\" 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-a757fb6\" data-id=\"a757fb6\" 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-8425ff0 elementor-widget elementor-widget-text-editor\" data-id=\"8425ff0\" 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;\">\u00a0<\/span><\/p><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;\">\u0110\u1ec3 \u00e1p d\u1ee5ng h\u00e0m l\u1ea5y ng\u00e0y, l\u1ea5y th\u00e1ng v\u00e0 n\u0103m trong Excel, s\u1eed d\u1ee5ng c\u00e1c h\u00e0m l\u1ea5y k\u00fd t\u1ef1 \u0111\u1ec3 t\u00e1ch ch\u00fang:<\/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-f1f601a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f1f601a\" 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-5c27345\" data-id=\"5c27345\" 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-7c18e3a elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"7c18e3a\" 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-37eb811c-7fff-7f21-1ab7-d3b30c0d0e1a\"><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;\">RIGHT(A5,4) l\u1ea5y 4 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean t\u00ednh t\u1eeb b\u00ean ph\u1ea3i, k\u1ebft qu\u1ea3 \u201c2020\u201d l\u00e0 n\u0103m c\u1ee7a ng\u00e0y \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i \u1edf \u00f4 E5.<\/span><\/span><br><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\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><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;\">RIGHT(LEFT(A5,5),2) ho\u1eb7c MID(A5,4,2) l\u1ea5y 2 k\u00fd t\u1ef1 t\u1eeb tr\u00e1i sang v\u00e0 b\u1eaft \u0111\u1ea7u l\u1ea5y t\u1eeb k\u00fd t\u1ef1 th\u1ee9 4. K\u1ebft qu\u1ea3 \u201c18\u201d l\u00e0 ng\u00e0y \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i \u1edf \u00f4 E5.<\/span><\/span><br><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;\">Tr\u01b0\u1edbc \u0111\u00f3, Excel hi\u1ec3u v\u1ecb tr\u00ed c\u1ee7a s\u1ed1 18 n\u00e0y l\u00e0 v\u1ecb tr\u00ed c\u1ee7a th\u00e1ng n\u1ebfu d\u1eef li\u1ec7u l\u00e0 ng\u00e0y th\u00e1ng n\u0103m, v\u00ec th\u1ebf Excel nh\u1eadn di\u1ec7n \u0111\u00e2y l\u00e0 ki\u1ec3u d\u1eef li\u1ec7u v\u0103n b\u1ea3n.<\/span><\/span><br><span id=\"docs-internal-guid-913d5db7-7fff-c9a7-b9c2-90d1fb880e6f\"><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;\">\u0110\u1ec3 chuy\u1ec3n v\u1ec1 ng\u00e0y th\u00e1ng n\u0103m, sau khi t\u00e1ch ri\u00eang c\u00e1c b\u1ed9 ph\u1eadn c\u1ee7a ng\u00e0y, s\u1eed d\u1ee5ng h\u00e0m DATE \u0111\u1ec3 gh\u00e9p ch\u00fang l\u1ea1i th\u00e0nh 1 ng\u00e0y ho\u00e0n ch\u1ec9nh.<\/span><\/span><br><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\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><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;\">LEFT(A5,2) l\u1ea5y 2 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean t\u1eeb tr\u00e1i sang, k\u1ebft qu\u1ea3 \u201c07\u201d l\u00e0 th\u00e1ng c\u1ee7a ng\u00e0y \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i \u1edf \u00f4 E5.<\/span><\/span><br><\/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-f13e438 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f13e438\" 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-9e9bddf\" data-id=\"9e9bddf\" 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-527af67 elementor-widget elementor-widget-text-editor\" data-id=\"527af67\" 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-0bc58a9b-7fff-dce0-c65d-037c7e661ebd\"><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;\">Cu\u1ed1i c\u00f9ng, gh\u00e9p c\u00e1c gi\u00e1 tr\u1ecb n\u0103m, th\u00e1ng, ng\u00e0y theo th\u1ee9 t\u1ef1 b\u1eb1ng c\u00f4ng th\u1ee9c h\u00e0m DATE, ng\u00e0y th\u00e1ng sau khi s\u1eeda s\u1ebd l\u00e0 ng\u00e0y 18\/07\/2020. Ng\u00e0y n\u00e0y \u0111\u00e3 \u0111\u01b0\u1ee3c Excel \u0111\u1ecbnh d\u1ea1ng l\u00e0 ki\u1ec3u d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m, c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh c\u1ed9ng, tr\u1eeb ng\u00e0y th\u00e1ng (nh\u01b0 ph\u00e9p tr\u1eeb ng\u00e0y th\u00e1ng \u1edf \u00f4 G5).<\/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-99b2bba elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"99b2bba\" 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-13ebf44\" data-id=\"13ebf44\" 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-0a9ea50 elementor-widget elementor-widget-text-editor\" data-id=\"0a9ea50\" 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-ed937fff-7fff-d149-dbda-d185183430dc\"><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;\">Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m DATE trong Excel. 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><\/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-2572447 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2572447\" 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-dfe5e9e\" data-id=\"dfe5e9e\" 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-e00ed23 elementor-widget elementor-widget-text-editor\" data-id=\"e00ed23\" 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: 2.592; text-align: justify; background-color: #ffffff; 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;\">Ngo\u00e0i ra, \u0111\u1ec3 vi\u1ec7c x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng (<\/span><span style=\"color: #000000; font-family: Arial; font-size: 16px; white-space: pre-wrap;\">v\u00ed d\u1ee5 vi\u1ec7c l\u1ecdc\/ s\u1eafp x\u1ebfp ng\u00e0y th\u00e1ng, c\u1ed9ng tr\u1eeb ng\u00e0y th\u00e1ng trong Excel)<\/span><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\"> \u0111\u01a1n gi\u1ea3n h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 2.592; text-align: justify; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\"><a style=\"background-color: #ffffff;\" 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\/ham-datedif-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m DATEDIF T\u00ednh Ch\u00eanh L\u1ec7ch Kho\u1ea3ng Th\u1eddi Gian<\/a><\/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\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 DATE L\u00e0 G\u00ec? T\u1ea1i Sao Ph\u1ea3i S\u1eed D\u1ee5ng H\u00e0m DATE? Khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh Excel, ch\u1eafc h\u1eb3n b\u1ea1n \u0111\u00e3 t\u1eebng l\u00e0m vi\u1ec7c v\u1edbi ki\u1ec3u d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng. C\u00e1ch hi\u1ec3n th\u1ecb\/ \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng c\u00f3 th\u1ec3 kh\u00e1c nhau, nh\u01b0ng khi x\u1eed l\u00fd d\u1eef li\u1ec7u t\u00ednh ng\u00e0y th\u00e1ng th\u00ec Excel th\u1ef1c hi\u1ec7n &#8230; <a title=\"C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m DATE &#8211; H\u00e0m Ng\u00e0y Th\u00e1ng N\u0103m Trong Excel\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/ham-date-trong-excel\/\">Read more <span class=\"screen-reader-text\">C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m DATE &#8211; H\u00e0m Ng\u00e0y Th\u00e1ng N\u0103m Trong Excel<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":1657,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[65,56],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1628"}],"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=1628"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1628\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/1657"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=1628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=1628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=1628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}