{"id":1442,"date":"2020-10-02T14:27:56","date_gmt":"2020-10-02T07:27:56","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1442"},"modified":"2020-10-26T07:35:40","modified_gmt":"2020-10-26T00:35:40","slug":"cach-tinh-so-ngay-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/cach-tinh-so-ngay-trong-excel\/","title":{"rendered":"C\u00e1ch C\u1ed9ng Tr\u1eeb Ng\u00e0y, Th\u00e1ng, N\u0103m V\u00e0 T\u00ednh S\u1ed1 Ng\u00e0y Trong Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1442\" class=\"elementor elementor-1442\">\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-cf761c6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cf761c6\" 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-390172c\" data-id=\"390172c\" 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-e1ba102 elementor-widget elementor-widget-text-editor\" data-id=\"e1ba102\" 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;\">T\u00ednh ng\u00e0y kh\u00e1 \u0111\u01a1n gi\u1ea3n khi c\u00e1c kho\u1ea3ng th\u1eddi gian kh\u00f4ng c\u00e1ch nhau qu\u00e1 xa, tuy nhi\u00ean n\u1ebfu c\u1ea7n t\u00ednh s\u1ed1 ng\u00e0y t\u1eeb ng\u00e0y 28\/1\/2012 \u0111\u1ebfn ng\u00e0y 17\/9\/2020 th\u00ec vi\u1ec7c t\u00ednh nh\u1ea9m kh\u00f4ng h\u1ec1 nhanh v\u00e0 d\u1ec5 d\u00e0ng v\u00ec c\u00e1c th\u00e1ng c\u00f3 s\u1ed1 ng\u00e0y kh\u00f4ng \u0111\u1ec1u v\u00e0 n\u0103m nhu\u1eadn.<\/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;\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu hi\u1ec7u gi\u00fap t\u00ednh to\u00e1n v\u1edbi d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng, \u0111\u00f3 l\u00e0 b\u1ea3ng t\u00ednh Excel.<\/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;\">Trong b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel, \u1ee9ng d\u1ee5ng \u0111\u1ebfm ng\u00e0y gi\u1eefa 2 th\u1eddi \u0111i\u1ec3m, \u0111i\u1ec1u ch\u1ec9nh l\u1ecbch tr\u00ecnh b\u1eb1ng c\u00e1ch c\u1ed9ng, tr\u1eeb ng\u00e0y, tu\u1ea7n, th\u00e1ng, n\u0103m cho m\u1ed9t ng\u00e0y \u1ea5n \u0111\u1ecbnh tr\u01b0\u1edbc\u2026<\/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-0939c2f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0939c2f\" 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-aaa6c7d\" data-id=\"aaa6c7d\" 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-1bfbbd7 elementor-widget elementor-widget-heading\" data-id=\"1bfbbd7\" 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;\"><h1 dir=\"ltr\" style=\"line-height:1.7999999999999998;text-align: justify;margin-top:20pt;margin-bottom:6pt;\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1, L\u01b0u \u00dd Khi T\u00ednh Ng\u00e0y Th\u00e1ng Trong Excel<\/span><\/h1><\/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-7e0b519 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7e0b519\" 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-5c55ac7\" data-id=\"5c55ac7\" 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-cb912dd elementor-widget elementor-widget-text-editor\" data-id=\"cb912dd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m c\u00f3 nhi\u1ec1u \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau:<\/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-a7ac2eb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a7ac2eb\" 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-64dc371\" data-id=\"64dc371\" 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-93b862a elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"93b862a\" 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-check\"><\/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;\">\u0110\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n: l\u00e0 ng\u00e0y th\u00e1ng m\u1eb7c \u0111\u1ecbnh, v\u00ed d\u1ee5 01\/01\/2019.<\/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-check\"><\/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><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: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">\u0110\u1ecbnh d\u1ea1ng s\u1ed1 s\u00ea-ri: Excel m\u0103\u0323c \u0111i\u0323nh nga\u0300y 1 tha\u0301ng 1 n\u0103m 1900 co\u0301 s\u00f4\u0301 s\u00ea-ri la\u0300 1.<\/span><\/p><\/span><span><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: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Nh\u1eefng ng\u00e0y th\u00e1ng tr\u01b0\u1edbc n\u0103m 1900 kh\u00f4ng th\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u00e0nh s\u1ed1 tr\u00ean Excel.<\/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: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Ng\u00e0y 1 tha\u0301ng 1 n\u0103m 2019 co\u0301 s\u00f4\u0301 s\u00ea-ri la\u0300 43466 vi\u0300 no\u0301 la\u0300 43465 nga\u0300y sau nga\u0300y 1 tha\u0301ng 1 n\u0103m 1900.<\/span><\/p><\/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-00596e4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"00596e4\" 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-8088180\" data-id=\"8088180\" 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-a584f64 elementor-widget elementor-widget-text-editor\" data-id=\"a584f64\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\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 trong Excel th\u00ec ch\u1ec9 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 s\u00ea-ri \u0111\u01b0\u1ee3c d\u00f9ng l\u00e0m d\u1eef li\u1ec7u c\u1ed9ng, tr\u1eeb ng\u00e0y th\u00e1ng.<\/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;\">Do \u0111\u00f3, b\u1ea1n kh\u00f4ng th\u1ec3 vi\u1ebft c\u00f4ng th\u1ee9c = 1\/1\/2020 &#8211; 8\/3\/2019 \u0111\u1ec3 t\u00ednh ng\u00e0y ch\u00eanh l\u1ec7ch trong Excel, v\u00ec Excel s\u1ebd hi\u1ec3u \u0111\u00e2y l\u00e0 ph\u00e9p tr\u1eeb c\u1ee7a 2 ph\u00e9p chia:<\/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-378ffaa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"378ffaa\" 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-5895230\" data-id=\"5895230\" 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-21ba6a9 elementor-widget elementor-widget-image\" data-id=\"21ba6a9\" 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\/tinh-so-ngay-trong-excel-loi-khi-nhap-ngay-thang-bi-hieu-lam-la-phep-chia.png\" title=\"tinh-so-ngay-trong-excel-loi-khi-nhap-ngay-thang-bi-hieu-lam-la-phep-chia\" alt=\"L\u01b0u \u00dd Khi T\u00ednh to\u00e1n v\u1edbi Ng\u00e0y Th\u00e1ng Trong Excel: khi x\u1eed l\u00fd d\u1eef li\u1ec7u t\u00ednh ng\u00e0y th\u00e1ng trong Excel th\u00ec ch\u1ec9 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 s\u00ea-ri \u0111\u01b0\u1ee3c d\u00f9ng l\u00e0m d\u1eef li\u1ec7u c\u1ed9ng, tr\u1eeb ng\u00e0y th\u00e1ng\" \/>\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-db0ae4a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"db0ae4a\" 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-c853cd3\" data-id=\"c853cd3\" 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-f5cba9c elementor-widget elementor-widget-text-editor\" data-id=\"f5cba9c\" 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;\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh s\u1ed1 ng\u00e0y trong Excel, b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1n c\u00e1c ng\u00e0y v\u00e0o c\u00e1c \u00f4 r\u1ed3i tham chi\u1ebfu v\u00e0o c\u00f4ng th\u1ee9c, \u0111i\u1ec1n ng\u00e0y 1\/1\/2020 v\u00e0o \u00f4 A3, ng\u00e0y 8\/3\/2019 v\u00e0o \u00f4 A4 r\u1ed3i t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa 2 ng\u00e0y b\u1eb1ng bi\u1ec3u th\u1ee9c <\/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;\">=A3-A4.<\/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;\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m DATE \u0111\u1ec3 t\u00ednh c\u1ed9ng tr\u1eeb ng\u00e0y th\u00e1ng trong Excel:<\/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: 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; 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;\">V\u00ed d\u1ee5: DATE(2020,1,1)-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-3d1d6c8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3d1d6c8\" 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-ae08a23\" data-id=\"ae08a23\" 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-17e49b0 elementor-widget elementor-widget-image\" data-id=\"17e49b0\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/10\/cach-tru-ngay-thang-tinh-so-ngay-trong-excel-phep-tru-va-ham-date.png\" title=\"cach-tru-ngay-thang-tinh-so-ngay-trong-excel-phep-tru-va-ham-date\" alt=\"\u0110\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh s\u1ed1 ng\u00e0y trong Excel, b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1n c\u00e1c ng\u00e0y v\u00e0o c\u00e1c \u00f4 r\u1ed3i tham chi\u1ebfu v\u00e0o c\u00f4ng th\u1ee9c ho\u1eb7c s\u1eed d\u1ee5ng h\u00e0m DATE\" \/>\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-076ee16 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"076ee16\" 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-2200ea1\" data-id=\"2200ea1\" 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-62cff08 elementor-widget elementor-widget-heading\" data-id=\"62cff08\" 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-089d18cf-7fff-f498-e0ba-c9538608edfc\"><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, C\u00e1ch Tr\u1eeb Ng\u00e0y Trong Excel B\u1eb1ng H\u00e0m DATEDIF<\/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-ef88af5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ef88af5\" 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-9039e23\" data-id=\"9039e23\" 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-6b1dc62 elementor-widget elementor-widget-text-editor\" data-id=\"6b1dc62\" 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;\">Hoctin.vn \u0111\u00e3 c\u00f3 b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/hoctin.vn\/ham-datedif-trong-excel\/\"><span style=\"font-size: 12pt; font-family: Arial; color: #1155cc; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">h\u00e0m DATEDIF<\/span><\/a><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\u00ednh ch\u00eanh l\u1ec7ch kho\u1ea3ng th\u1eddi gian trong Excel.<\/span><\/p><p><b id=\"docs-internal-guid-87d5e23d-7fff-3560-6614-9984ad19eb88\" style=\"font-weight: normal;\">\u00a0<\/b><\/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;\">C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y t\u1eeb ng\u00e0y b\u1eaft \u0111\u1ea7u \u0111\u1ebfn ng\u00e0y k\u1ebft th\u00fac b\u1eb1ng h\u00e0m \u0111\u1ebfm ng\u00e0y trong Excel:<\/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: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=DATEDIF(Start_date, End_date, \u201cd\u201d)<\/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;\">Nh\u01b0\u1ee3c \u0111i\u1ec3m c\u1ee7a h\u00e0m DATEDIF so v\u1edbi 2 c\u00e1ch tr\u1eeb ng\u00e0y \u0111\u00e3 n\u00eau \u1edf m\u1ee5c 1 l\u00e0 h\u00e0m DATEDIF s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #NUM! n\u1ebfu b\u1ea1n tr\u1eeb 1 ng\u00e0y nh\u1ecf h\u01a1n (10\/9\/2020) cho 1 ng\u00e0y l\u1edbn h\u01a1n (15\/9\/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-72d52b9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"72d52b9\" 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-fbd52d7\" data-id=\"fbd52d7\" 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-60ff05d elementor-widget elementor-widget-image\" data-id=\"60ff05d\" 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\/dung-ham-datedif-tinh-so-ngay-trong-excel.png\" title=\"dung-ham-datedif-tinh-so-ngay-trong-excel\" alt=\"C\u00e1ch Tr\u1eeb Ng\u00e0y Trong Excel B\u1eb1ng H\u00e0m DATEDIF\" \/>\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-fabf009 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fabf009\" 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-905ab13\" data-id=\"905ab13\" 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-f016953 elementor-widget elementor-widget-heading\" data-id=\"f016953\" 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-675f67a5-7fff-c14a-7a34-959d8b33e122\"><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, C\u00f4ng Th\u1ee9c T\u00ednh S\u1ed1 Ng\u00e0y Trong Excel K\u1ec3 T\u1eeb Ng\u00e0y Hi\u1ec7n T\u1ea1i<\/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-7436222 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7436222\" 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-da2592b\" data-id=\"da2592b\" 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-e87f6e8 elementor-widget elementor-widget-text-editor\" data-id=\"e87f6e8\" 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-34888b75-7fff-fcb8-56e0-8bf2a0c00c24\"><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 t\u00ednh s\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch t\u1eeb 1 ng\u00e0y b\u1ea5t k\u1ef3 \u0111\u1ebfn ng\u00e0y h\u00f4m nay, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng 1 trong ba c\u00f4ng th\u1ee9c \u0111\u00e3 n\u00eau \u1edf tr\u00ean: ph\u00e9p tr\u1eeb, h\u00e0m DATE, h\u00e0m DATEDIF k\u1ebft h\u1ee3p v\u1edbi 1 trong hai h\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb ng\u00e0y\/ th\u1eddi gian hi\u1ec7n t\u1ea1i 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-fb03ef9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fb03ef9\" 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-b1fed14\" data-id=\"b1fed14\" 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-83e6f39 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"83e6f39\" 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-check\"><\/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;\">TODAY(): tr\u1ea3 v\u1ec1 s\u1ed1 s\u00ea-ri cu\u0309a nga\u0300y hi\u1ec7n ta\u0323i khi quy \u0111\u1ed5i s\u1ebd l\u00e0 d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m.<\/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-check\"><\/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-d015a8a0-7fff-6e21-2a4f-90700726d9fb\"><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;\">NOW(): tr\u1ea3 v\u1ec1 s\u1ed1 s\u00ea-ri c\u1ee7a ng\u00e0y v\u00e0 th\u1eddi gian hi\u1ec7n ta\u0323i khi quy \u0111\u1ed5i s\u1ebd l\u00e0 d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m gi\u1edd ph\u00fat gi\u00e2y.<\/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-2dbec52 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2dbec52\" 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-685645d\" data-id=\"685645d\" 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-a442a3c elementor-widget elementor-widget-text-editor\" data-id=\"a442a3c\" 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 s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c:<\/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;\">= TODAY() \u2013 A8<\/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;\">= DATEDIF(A8, TODAY(), \u201cd\u201d)<\/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;\">= INT(NOW()-A8)<\/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;\">= DATEDIF(A8, NOW(), \u201cd\u201d)<\/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;\">Nh\u01b0 \u0111\u00e3 tr\u00ecnh b\u00e0y t\u1ea1i m\u1ee5c 2, c\u00e1c c\u00f4ng th\u1ee9c DATEDIF ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng khi ng\u00e0y h\u00f4m nay l\u1edbn h\u01a1n ng\u00e0y b\u1ea1n c\u1ea7n tr\u1eeb \u0111i. Tr\u01b0\u1eddng h\u1ee3p ng\u00e0y hi\u1ec7n t\u1ea1i nh\u1ecf h\u01a1n ng\u00e0y c\u1ea7n \u0111\u01b0\u1ee3c tr\u1eeb, h\u00e0m DATEDIF s\u1ebd b\u00e1o l\u1ed7i #NUM!:<\/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-b7df48f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b7df48f\" 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-822df72\" data-id=\"822df72\" 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-fb42c59 elementor-widget elementor-widget-image\" data-id=\"fb42c59\" 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\/so-sanh-dung-ham-datedif-ket-hop-today-voi-phep-tru-ngay-thang-de-tinh-so-ngay-trong-excel.png\" title=\"so-sanh-dung-ham-datedif-ket-hop-today-voi-phep-tru-ngay-thang-de-tinh-so-ngay-trong-excel\" alt=\"C\u00f4ng Th\u1ee9c T\u00ednh S\u1ed1 Ng\u00e0y Trong Excel K\u1ec3 T\u1eeb Ng\u00e0y Hi\u1ec7n T\u1ea1i\" \/>\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-979acb1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"979acb1\" 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-414bd02\" data-id=\"414bd02\" 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-4d81f33 elementor-widget elementor-widget-text-editor\" data-id=\"4d81f33\" 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-ac28f1f7-7fff-95b4-25e4-7db7909119c8\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">B\u1ea1n c\u1ea7n c\u00e2n nh\u1eafc khi tr\u1eeb ng\u00e0y trong Excel b\u1eb1ng h\u00e0m DATEDIF \u0111\u1ec3 tr\u00e1nh l\u1ed7i trong trang t\u00ednh.<\/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-58a87cb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"58a87cb\" 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-8426f2c\" data-id=\"8426f2c\" 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-08d5d7a elementor-widget elementor-widget-heading\" data-id=\"08d5d7a\" 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-a4b9be7b-7fff-d2a6-fd64-c8b105b7ea7d\"><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, T\u00ednh Ng\u00e0y Trong Excel 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><\/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-6b22ddc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6b22ddc\" 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-0028c8c\" data-id=\"0028c8c\" 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-cfd8574 elementor-widget elementor-widget-heading\" data-id=\"cfd8574\" 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;\"><h2 dir=\"ltr\" style=\"line-height:1.7999999999999998;text-align: justify;margin-top:18pt;margin-bottom:6pt;\"><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;\">4.1, T\u0103ng Gi\u00e1 Tr\u1ecb Ng\u00e0y Trong Excel Th\u00eam 1 S\u1ed1 \u0110\u01a1n V\u1ecb<\/span><\/h2><\/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-692b274 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"692b274\" 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-fe8b76b\" data-id=\"fe8b76b\" 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-c74c7aa elementor-widget elementor-widget-text-editor\" data-id=\"c74c7aa\" 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;\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t h\u00f3a \u0111\u01a1n \u0111\u1ebfn h\u1ea1n thanh to\u00e1n trong 45 ng\u00e0y k\u1ec3 t\u1eeb ng\u00e0y h\u00f3a \u0111\u01a1n. B\u1ea1n mu\u1ed1n bi\u1ebft h\u1ea1n thanh to\u00e1n l\u00e0 ng\u00e0y n\u00e0o th\u00ec b\u1ea1n c\u1ea7n ph\u1ea3i c\u1ed9ng th\u00eam 45 ng\u00e0y v\u00e0o ng\u00e0y h\u00f3a \u0111\u01a1n.<\/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;\">Ho\u1eb7c b\u1ea1n mu\u1ed1n \u0111i\u1ec1u ch\u1ec9nh k\u1ebf ho\u1ea1ch c\u1ee7a m\u1ed9t d\u1ef1 \u00e1n b\u1eb1ng c\u00e1ch c\u1ed9ng th\u00eam ba tu\u1ea7n. \u0110\u1ec3 bi\u1ebft ng\u00e0y ho\u00e0n th\u00e0nh m\u1edbi l\u00e0 ng\u00e0y n\u00e0o, b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n ph\u00e9p c\u1ed9ng ng\u00e0y th\u00e1ng trong Excel.<\/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-2e05da2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2e05da2\" 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-520f8d7\" data-id=\"520f8d7\" 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-c557997 elementor-widget elementor-widget-text-editor\" data-id=\"c557997\" 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<h3 dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 16pt; margin-bottom: 4pt;\"><span style=\"font-size: 13.999999999999998pt; font-family: Arial; color: #1d6f42; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u1ed8NG TH\u00caM N NG\u00c0Y<\/span><\/h3>\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;\">C\u00f4ng th\u1ee9c c\u1ed9ng ng\u00e0y \u0111\u01a1n gi\u1ea3n nh\u1ea5t:<\/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: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">= Date + N ng\u00e0y<\/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;\">Trong \u0111\u00f3: Date c\u00f3 th\u1ec3 l\u00e0:<\/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;\">Tham chi\u1ebfu \u00f4 nh\u01b0 B4 khi gi\u00e1 tr\u1ecb ng\u00e0y \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o \u00f4 B4<\/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;\">H\u00e0m DATE(n\u0103m, th\u00e1ng, ng\u00e0y) nh\u01b0 DATE(2013,9,15)<\/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;\">L\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a m\u1ed9t h\u00e0m ng\u00e0y th\u00e1ng kh\u00e1c.<\/span><\/p>\n<\/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-53a5e38 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"53a5e38\" 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-a649a46\" data-id=\"a649a46\" 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-3bd72d9 elementor-widget elementor-widget-text-editor\" data-id=\"3bd72d9\" 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<h3 dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 16pt; margin-bottom: 4pt;\"><span style=\"font-size: 13.999999999999998pt; font-family: Arial; color: #1d6f42; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u1ed8NG TH\u00caM T TU\u1ea6N<\/span><\/h3><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\u1eadn d\u1ee5ng c\u00f4ng th\u1ee9c c\u1ed9ng ng\u00e0y \u1edf tr\u00ean, \u00e1p d\u1ee5ng t\u00ednh th\u00eam s\u1ed1 tu\u1ea7n v\u00e0o ng\u00e0y ban \u0111\u1ea7u:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-weight: bold; white-space: pre-wrap;\">= Date + T tu\u1ea7n * 7<\/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-e6a1a8f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e6a1a8f\" 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-0c181ba\" data-id=\"0c181ba\" 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-fd80182 elementor-widget elementor-widget-text-editor\" data-id=\"fd80182\" 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<h3 dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 16pt; margin-bottom: 4pt;\"><span style=\"font-size: 13.999999999999998pt; font-family: Arial; color: #1d6f42; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u1ed8NG TH\u00caM X TH\u00c1NG<\/span><\/h3><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: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch 1:<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> C\u00f4ng th\u1ee9c c\u1ed9ng th\u00eam 1 s\u1ed1 th\u00e1ng v\u00e0o ng\u00e0y ban \u0111\u1ea7u m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i quan t\u00e2m th\u00e1ng c\u00f3 bao nhi\u00eau ng\u00e0y (28, 29 ng\u00e0y v\u1edbi th\u00e1ng 2; 30 hay 31 ng\u00e0y v\u1edbi c\u00e1c th\u00e1ng c\u00f2n l\u1ea1i):<\/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: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">= DATE (n\u0103m, th\u00e1ng+X, ng\u00e0y)<\/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;\">V\u00ed d\u1ee5 DATE(2019, 9+2, 15) tr\u1ea3 v\u1ec1 ng\u00e0y 15\/11\/2019 l\u00e0 ng\u00e0y sau ng\u00e0y 15\/9\/2019 hai th\u00e1ng.<\/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;\">\u00d4 B4 c\u00f3 gi\u00e1 tr\u1ecb 15\/9\/2013. C\u00f4ng th\u1ee9c t\u00ednh ng\u00e0y DATE(year(B4), month(B4)+5, year(B4)) tr\u1ea3 v\u1ec1 ng\u00e0y t\u1ea1i \u00f4 B4 c\u1ed9ng th\u00eam 5 th\u00e1ng l\u00e0 ng\u00e0y 15\/2\/2014.<\/span><\/p><p><b id=\"docs-internal-guid-2a6c40ed-7fff-8270-1be0-d6213ed79fa2\" style=\"font-weight: normal;\">\u00a0<\/b><\/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: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch 2:<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> M\u1ed9t c\u00f4ng th\u1ee9c Excel kh\u00e1c \u0111\u01a1n gi\u1ea3n h\u01a1n &#8211; C\u00f4ng th\u1ee9c h\u00e0m EDATE t\u00ednh ng\u00e0y tr\u01b0\u1edbc ho\u1eb7c sau ng\u00e0y \u0111\u00e3 bi\u1ebft \u0111\u00e3 x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc:<\/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: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=EDATE (ng\u00e0y b\u1eaft \u0111\u1ea7u, s\u1ed1 th\u00e1ng c\u1ea7n c\u1ed9ng th\u00eam X)<\/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;\">V\u00ed d\u1ee5 =EDATE(B9,3) tr\u1ea3 v\u1ec1 ng\u00e0y sau ng\u00e0y t\u1ea1i \u00f4 B9 ba th\u00e1ng.<\/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-fef312f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fef312f\" 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-a804eda\" data-id=\"a804eda\" 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-a583a1e elementor-widget elementor-widget-text-editor\" data-id=\"a583a1e\" 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<h3 dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 16pt; margin-bottom: 4pt;\"><span style=\"font-size: 13.999999999999998pt; font-family: Arial; color: #1d6f42; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u1ed8NG TH\u00caM Y N\u0102M<\/span><\/h3><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\u1eadn d\u1ee5ng c\u00f4ng th\u1ee9c t\u00ednh th\u00eam 1 s\u1ed1 th\u00e1ng trong Excel \u1edf tr\u00ean, \u00e1p d\u1ee5ng cho n\u0103m (12 th\u00e1ng) nh\u01b0 sau:<\/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: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch 1:<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> C\u00f4ng th\u1ee9c c\u1ed9ng th\u00eam 1 s\u1ed1 n\u0103m v\u00e0o ng\u00e0y ban \u0111\u1ea7u m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i quan t\u00e2m n\u0103m nhu\u1eadn:<\/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: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">= DATE(n\u0103m+Y, th\u00e1ng, ng\u00e0y)<\/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;\">V\u00ed d\u1ee5 DATE(2019+1, 9, 15) tr\u1ea3 v\u1ec1 ng\u00e0y 15\/9\/2020 l\u00e0 ng\u00e0y sau ng\u00e0y 15\/9\/2019 m\u1ed9t 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;\">\u00d4 B4 c\u00f3 gi\u00e1 tr\u1ecb 15\/9\/2013. C\u00f4ng th\u1ee9c t\u00ednh ng\u00e0y DATE(year(B4)+2, month(B4), year(B4)) tr\u1ea3 v\u1ec1 ng\u00e0y t\u1ea1i \u00f4 B4 c\u1ed9ng th\u00eam 2 n\u0103m l\u00e0 ng\u00e0y 15\/9\/2021.<\/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: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch 2:<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> C\u00f4ng th\u1ee9c h\u00e0m EDATE t\u00ednh ng\u00e0y tr\u01b0\u1edbc ho\u1eb7c sau ng\u00e0y \u0111\u00e3 bi\u1ebft \u0111\u00e3 x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc:<\/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: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=EDATE(ng\u00e0y b\u1eaft \u0111\u1ea7u, Y*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;\">V\u00ed d\u1ee5: \u0110\u1ec3 c\u1ed9ng th\u00eam 3 n\u0103m t\u1eeb ng\u00e0y \u1edf \u00f4 A1: vi\u1ebft c\u00f4ng th\u1ee9c EDATE(A1,3*12).<\/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-6bd156c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6bd156c\" 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-50ca953\" data-id=\"50ca953\" 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-f7528f9 elementor-widget elementor-widget-text-editor\" data-id=\"f7528f9\" 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<h3 dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 16pt; margin-bottom: 4pt;\"><span style=\"font-size: 13.999999999999998pt; font-family: Arial; color: #1d6f42; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">T\u1ed4NG H\u1ee2P C\u00d4NG TH\u1ee8C<\/span><\/h3><p><span id=\"docs-internal-guid-775e5182-7fff-99c5-b0eb-12e82a94996e\"><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;\">Nh\u01b0 v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 c\u1ed9ng th\u00eam m\u1ed9t s\u1ed1 ng\u00e0y, m\u1ed9t s\u1ed1 tu\u1ea7n, m\u1ed9t s\u1ed1 th\u00e1ng, m\u1ed9t s\u1ed1 n\u0103m t\u01b0\u0300 m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng ph\u00e9p c\u1ed9ng, h\u00e0m DATE, EDATE nh\u01b0<\/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;\"> b\u1ea3ng t\u1ed5ng h\u1ee3p sau<\/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-1461d96 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1461d96\" 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-5848c57\" data-id=\"5848c57\" 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-70a6147 elementor-widget elementor-widget-image\" data-id=\"70a6147\" 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\/cong-ngay-thang-tinh-so-ngay-trong-excel.png\" title=\"cong-ngay-thang-tinh-so-ngay-trong-excel\" alt=\"T\u00ednh S\u1ed1 Ng\u00e0y Trong Excel 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\" \/>\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-e5d8a7d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e5d8a7d\" 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-b46085c\" data-id=\"b46085c\" 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-a0916de elementor-widget elementor-widget-heading\" data-id=\"a0916de\" 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-5cfea5e2-7fff-9d9b-83d8-cdf492b53a36\"><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;\">4.2, Tr\u1eeb Ng\u00e0y Trong Excel \u0110\u1ec3 T\u00ednh Ng\u00e0y \u0110\u1ebfn H\u1ea1n<\/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-9e201d1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9e201d1\" 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-0199167\" data-id=\"0199167\" 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-08504d2 elementor-widget elementor-widget-text-editor\" data-id=\"08504d2\" 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;\">Gi\u1ea3 s\u1eed m\u1ed9t h\u00f3a \u0111\u01a1n c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o \u0111\u00e3 h\u1ebft h\u1ea1n thanh to\u00e1n v\u00e0o ng\u00e0y h\u00f4m nay. H\u1ea1n thanh to\u00e1n l\u00e0 90 ng\u00e0y t\u1eeb ng\u00e0y nh\u1eadn h\u00f3a \u0111\u01a1n.<\/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;\">B\u1ea1n nh\u1edb l\u00e0 m\u00ecnh \u0111\u00e3 thanh to\u00e1n h\u00f3a \u0111\u01a1n ngay v\u00e0o ng\u00e0y nh\u1eadn \u0111\u01b0\u1ee3c nh\u01b0ng b\u1ea1n kh\u00f4ng nh\u1edb c\u1ee5 th\u1ec3 l\u00e0 ng\u00e0y n\u00e0o. B\u1ea1n c\u1ea7n ki\u1ec3m tra Bank Statement (sao k\u00ea ng\u00e2n h\u00e0ng) v\u00e0o 1 ng\u00e0y c\u1ee5 th\u1ec3 l\u00e0 ng\u00e0y b\u1ea1n \u0111\u00e3 thanh to\u00e1n.<\/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;\">B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm ng\u00e0y thanh to\u00e1n b\u1eb1ng c\u00e1ch l\u1ea5y ng\u00e0y h\u00f4m nay tr\u1eeb \u0111i 60 ng\u00e0y.<\/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;\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch th\u00eam 1 s\u1ed1 ng\u00e0y v\u00e0o m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3, c\u00e1ch tr\u1eeb ng\u00e0y \u0111\u1ec3 t\u00ecm ng\u00e0y th\u00e1ng n\u0103m c\u0169ng s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1, thay s\u1ed1 ng\u00e0y c\u1ea7n th\u00eam t\u1eeb <b>s\u1ed1 d\u01b0\u01a1ng th\u00e0nh s\u1ed1 \u00e2m <\/b>\u0111\u1ec3 tr\u1eeb ng\u00e0y trong Excel.<b> <\/b><\/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-4e01324 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4e01324\" 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-3a6392f\" data-id=\"3a6392f\" 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-b6c8c38 elementor-widget elementor-widget-text-editor\" data-id=\"b6c8c38\" 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: 13.999999999999998pt; font-family: Arial; color: #1d6f42; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">TR\u1eea \u0110I N NG\u00c0Y<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-weight: bold; white-space: pre-wrap;\">= Date &#8211; N ng\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-f594e21 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f594e21\" 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-8e26f88\" data-id=\"8e26f88\" 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-50e3fc5 elementor-widget elementor-widget-text-editor\" data-id=\"50e3fc5\" 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: 13.999999999999998pt; font-family: Arial; color: #1d6f42; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">TR\u1eea \u0110I T TU\u1ea6N<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-weight: bold; white-space: pre-wrap;\">= Date &#8211; T tu\u1ea7n * 7<\/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-f537085 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f537085\" 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-e2b04a8\" data-id=\"e2b04a8\" 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-ba22475 elementor-widget elementor-widget-text-editor\" data-id=\"ba22475\" 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: 13.999999999999998pt; font-family: Arial; color: #1d6f42; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">TR\u1eea X TH\u00c1NG<\/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: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch 1: DATE (n\u0103m, th\u00e1ng-X, ng\u00e0y)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-weight: bold; white-space: pre-wrap;\">C\u00e1ch 2: EDATE (ng\u00e0y b\u1eaft \u0111\u1ea7u, X)<\/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-a7a527f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a7a527f\" 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-b01e515\" data-id=\"b01e515\" 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-98cd9b1 elementor-widget elementor-widget-text-editor\" data-id=\"98cd9b1\" 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: 13.999999999999998pt; font-family: Arial; color: #1d6f42; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">TR\u1eea Y N\u0102M<\/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: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch 1: DATE(n\u0103m-Y, th\u00e1ng, ng\u00e0y)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-weight: bold; white-space: pre-wrap;\">C\u00e1ch 2: EDATE(ng\u00e0y b\u1eaft \u0111\u1ea7u, -Y*12)<\/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-330d2fd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"330d2fd\" 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-80bc85c\" data-id=\"80bc85c\" 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-d83958d elementor-widget elementor-widget-image\" data-id=\"d83958d\" 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\/tru-ngay-thang-tinh-so-ngay-trong-excel.png\" title=\"tru-ngay-thang-tinh-so-ngay-trong-excel\" alt=\"C\u00e1ch T\u00ednh S\u1ed1 Ng\u00e0y Trong Excel B\u1eb1ng C\u00e1ch Tr\u1eeb B\u01a1\u0301t M\u1ed9t S\u1ed1 Ng\u00e0y T\u01b0\u0300 M\u1ed9t Ng\u00e0y C\u1ee5 Th\u1ec3\" \/>\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-742953c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"742953c\" 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-ceef7eb\" data-id=\"ceef7eb\" 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-cb1476e elementor-widget elementor-widget-text-editor\" data-id=\"cb1476e\" 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.16;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;white-space:pre-wrap;\">Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1c c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y 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><\/p>\n<p dir=\"ltr\" style=\"line-height:2.16;text-align: justify;background-color:#ffffff;margin-top:0pt;margin-bottom:0pt;\"><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; white-space: pre-wrap;\"><br><\/span><\/p><p dir=\"ltr\" style=\"line-height:2.16;text-align: justify;background-color:#ffffff;margin-top:0pt;margin-bottom:0pt;\"><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">Ngo\u00e0i ra, \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng, v\u00ed d\u1ee5 l\u1ecdc\/ s\u1eafp x\u1ebfp ng\u00e0y th\u00e1ng, \u0111\u1ecbnh d\u1ea1ng&nbsp;ng\u00e0y th\u00e1ng trong Excel, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft:<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height:3.1104;text-align: justify;background-color:#ffffff;margin-top:0pt;margin-bottom:0pt;\"><a href=\"https:\/\/hoctin.vn\/cach-loc-du-lieu-trong-excel\/\" target=\"_blank\">C\u00e1ch l\u1ecdc v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong Excel<\/a><br><\/p>\n<p dir=\"ltr\" style=\"line-height:3.1104;text-align: justify;background-color:#ffffff;margin-top:0pt;margin-bottom:0pt;\"><a href=\"https:\/\/hoctin.vn\/dinh-dang-ngay-thang-trong-excel\/\" target=\"_blank\">\u0110\u1ecbnh D\u1ea1ng Ng\u00e0y Th\u00e1ng Trong Excel<\/a><br><\/p>\n<p dir=\"ltr\" style=\"line-height:3.1104;text-align: justify;background-color:#ffffff;margin-top:0pt;margin-bottom:0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-datedif-trong-excel\/\" target=\"_blank\">H\u00e0m DATEDIF<\/a><br><\/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>T\u00ednh ng\u00e0y kh\u00e1 \u0111\u01a1n gi\u1ea3n khi c\u00e1c kho\u1ea3ng th\u1eddi gian kh\u00f4ng c\u00e1ch nhau qu\u00e1 xa, tuy nhi\u00ean n\u1ebfu c\u1ea7n t\u00ednh s\u1ed1 ng\u00e0y t\u1eeb ng\u00e0y 28\/1\/2012 \u0111\u1ebfn ng\u00e0y 17\/9\/2020 th\u00ec vi\u1ec7c t\u00ednh nh\u1ea9m kh\u00f4ng h\u1ec1 nhanh v\u00e0 d\u1ec5 d\u00e0ng v\u00ec c\u00e1c th\u00e1ng c\u00f3 s\u1ed1 ng\u00e0y kh\u00f4ng \u0111\u1ec1u v\u00e0 n\u0103m nhu\u1eadn. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t &#8230; <a title=\"C\u00e1ch C\u1ed9ng Tr\u1eeb Ng\u00e0y, Th\u00e1ng, N\u0103m V\u00e0 T\u00ednh S\u1ed1 Ng\u00e0y Trong Excel\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/cach-tinh-so-ngay-trong-excel\/\">Read more <span class=\"screen-reader-text\">C\u00e1ch C\u1ed9ng Tr\u1eeb Ng\u00e0y, Th\u00e1ng, N\u0103m V\u00e0 T\u00ednh S\u1ed1 Ng\u00e0y Trong Excel<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":1443,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25,30],"tags":[65,55,56,7],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1442"}],"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=1442"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1442\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/1443"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=1442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=1442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=1442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}