{"id":11187,"date":"2022-11-10T02:19:27","date_gmt":"2022-11-09T19:19:27","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11187"},"modified":"2022-12-06T11:58:47","modified_gmt":"2022-12-06T04:58:47","slug":"cach-cong-ngay-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/","title":{"rendered":"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u d\u00e0nh cho b\u1ea1n"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;11187&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u d\u00e0nh cho b\u1ea1n&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><i>C\u00e1c \u00f4 d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m r\u1ea5t ph\u1ed5 bi\u1ebfn trong nh\u1eadp li\u1ec7u v\u00e0 data Excel. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o ch\u00fang c\u0169ng s\u1ebd c\u1ed1 \u0111\u1ecbnh nh\u01b0 th\u1ebf. S\u1ebd c\u00f3 nhi\u1ec1u b\u1ed1i c\u1ea3nh khi\u1ebfn cho d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m tr\u00ean b\u1ea3ng t\u00ednh Excel c\u1ea7n c\u00f3 s\u1ef1 thay \u0111\u1ed5i v\u00e0 \u0111i\u1ec1u ch\u1ec9nh. Do \u0111\u00f3, c\u00e1c thu\u1eadt c\u1ed9ng tr\u1eeb ng\u00e0y gi\u1edd tr\u00ean Excel \u0111\u00e3 ra \u0111\u1eddi. V\u00e0 <\/i><b><i>c\u00e1ch c\u1ed9ng ng\u00e0y trong Excel <\/i><\/b><i>th\u1eadt s\u1ef1 kh\u00f4ng h\u1ec1 ph\u1ee9c t\u1ea1p nh\u01b0 c\u00e1c b\u1ea1n h\u00ecnh dung. Ch\u00fang ho\u00e0n to\u00e0n d\u1ec5 hi\u1ec3u v\u00e0 c\u00f3 th\u1ec3 thao t\u00e1c v\u1edbi c\u00e1c ph\u00e9p t\u00ednh v\u00e0 h\u00e0m \u0111\u01a1n gi\u1ea3n. Tham kh\u1ea3o ngay sau \u0111\u00e2y!\u00a0<\/i><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#Tinh_khoang_cach_giua_cac_ngay_cu_the_trong_Excel\" >T\u00ednh kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c ng\u00e0y c\u1ee5 th\u1ec3 trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#Cach_cong_ngay_trong_Excel_Hoac_tru_%E2%80%93_cong_so_am\" >C\u00e1ch c\u00f4ng ng\u00e0y trong Excel (Ho\u1eb7c tr\u1eeb &#8211; c\u1ed9ng s\u1ed1 \u00e2m)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#Cach_cong_tuan_trong_Excel_Hoac_tru\" >C\u00e1ch c\u1ed9ng tu\u1ea7n trong Excel ( Ho\u1eb7c tr\u1eeb)\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#Cach_cong_tru_thang_trong_Excel\" >C\u00e1ch c\u1ed9ng tr\u1eeb th\u00e1ng trong Excel\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#Cach_cong_hoac_tru_nam_trong_Excel\" >C\u00e1ch c\u1ed9ng ho\u1eb7c tr\u1eeb n\u0103m trong Excel\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#Cach_cong_thoi_gian_trong_Excel_Hoac_tru\" >C\u00e1ch c\u1ed9ng th\u1eddi gian trong Excel (Ho\u1eb7c tr\u1eeb)<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tinh_khoang_cach_giua_cac_ngay_cu_the_trong_Excel\"><\/span><b>T\u00ednh kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c ng\u00e0y c\u1ee5 th\u1ec3 trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u00ednh kho\u1ea3ng c\u00e1ch ng\u00e0y trong Excel th\u01b0\u1eddng ph\u1ee5c v\u1ee5 cho c\u00e1c m\u1ee5c \u0111\u00edch nh\u1ea5t \u0111\u1ecbnh. Do \u0111\u00f3, nghe c\u00f3 v\u1ebb \u0111\u01a1n gi\u1ea3n nh\u01b0ng \u0111\u00f4i khi nhi\u1ec1u ng\u01b0\u1eddi l\u1ea1i kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c ph\u00e9p t\u00ednh kho\u1ea3ng c\u00e1ch n\u00e0y. C\u00f3 4 c\u00e1ch \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c ng\u00e0y c\u1ee5 th\u1ec3 trong Excel.<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"C\u1ed9ng ho\u1eb7c tr\u1eeb ng\u00e0y th\u00e1ng n\u0103m t\u1eeb m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3 trong Excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/sdlnDux7XkM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"> Bao g\u1ed3m:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh kho\u1ea3ng c\u00e1ch b\u1eb1ng ph\u00e9p tr\u1eeb tr\u1ef1c tr\u1ef1c ti\u1ebfp. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh kho\u1ea3ng c\u00e1ch gi\u1eefa hai ng\u00e0y n\u1eb1m trong \u00f4 A2 v\u00e0 B2. B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng ph\u00e9p tr\u1eeb t\u1eeb \u00f4 \u0111\u1ea1i di\u1ec7n (B2-A2) \u0111\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c s\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch n\u00e0y.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m DATEDIF. V\u1edbi h\u00e0m n\u00e0y, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u00ednh ch\u00eanh l\u1ec7ch s\u1ed1 ng\u00e0y b\u1eb1ng c\u00e1ch nh\u1eadp h\u00e0m = DATEDIF (A2, B2, \u201cd\/m\/y\u201d) cho v\u00ed d\u1ee5 tr\u00ean. Tuy nhi\u00ean, h\u00e0m n\u00e0y kh\u00f4ng cho ph\u00e9p ng\u00e0y b\u1eaft \u0111\u1ea7u l\u1edbn h\u01a1n ng\u00e0y k\u1ebft th\u00fac. Khi b\u1ecb l\u1ed7i n\u00e0y, h\u00e0m s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m TODAY v\u00e0 ph\u00e9p tr\u1eeb. N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecnh ng\u00e0y ch\u00eanh l\u1ec7ch v\u1edbi ng\u00e0y h\u00f4m nay, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m TODAY (). V\u00ed d\u1ee5 \u0111\u00f3 l\u00e0 = TODAY () \u2013 A2 ho\u1eb7c l\u00e0 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m DATEDIF c\u00f3 c\u00fa ph\u00e1p h\u00e0m nh\u01b0 sau: = DATEDIF (A2, TODAY (), \u201cd\u201d).\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00e1c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m DATE cho nhu c\u1ea7u t\u00ednh ng\u00e0y ch\u00eanh l\u1ec7ch.\u00a0<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_11193\" aria-describedby=\"caption-attachment-11193\" style=\"width: 824px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11193 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-1.jpg\" alt=\"C\u00f3 4 c\u00e1ch \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c ng\u00e0y c\u1ee5 th\u1ec3 trong Excel\" width=\"824\" height=\"526\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-1.jpg 824w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-1-400x255.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-1-768x490.jpg 768w\" sizes=\"auto, (max-width: 824px) 100vw, 824px\" \/><figcaption id=\"caption-attachment-11193\" class=\"wp-caption-text\"><em>C\u00f3 4 c\u00e1ch \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c ng\u00e0y c\u1ee5 th\u1ec3 trong Excel<\/em><\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_cong_ngay_trong_Excel_Hoac_tru_%E2%80%93_cong_so_am\"><\/span><b>C\u00e1ch c\u00f4ng ng\u00e0y trong Excel (Ho\u1eb7c tr\u1eeb &#8211; c\u1ed9ng s\u1ed1 \u00e2m)<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n. C\u00e1c b\u1ea1n ch\u1ec9 c\u1ea7n c\u1ed9ng th\u00eam s\u1ed1 ng\u00e0y mu\u1ed1n c\u00f4ng v\u00e0o \u00f4 tham chi\u1ebfu ch\u1ee9a d\u1eef li\u1ec7u ng\u00e0y. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 c\u00f4ng gi\u1ea3n \u0111\u01a1n ho\u1eb7c b\u1eb1ng h\u00e0m. N\u1ebfu t\u00ednh t\u1eeb ng\u00e0y h\u00f4m nay th\u00ec c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m TODAY (). V\u00e0 n\u00f3 t\u01b0\u01a1ng t\u1ef1 v\u1edbi ph\u00e9p tr\u1eeb ngay. C\u1ee5 th\u1ec3 nh\u01b0 sau:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u1ed9ng th\u00eam 10 ng\u00e0y v\u00e0o \u00f4 ng\u00e0y A2: A2 + 10<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u1ed9ng th\u00eam 10 ng\u00e0y v\u1edbi\u00a0 DATE (n\u0103m, th\u00e1ng, ng\u00e0y): = DATE (2015, 5, 6) + 10<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u1ed9ng th\u00eam 10 ng\u00e0y k\u1ec3 t\u1eeb h\u00f4m nay, s\u1eed d\u1ee5ng h\u00e0m TODAY (): = TODAY () + 10<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_11192\" aria-describedby=\"caption-attachment-11192\" style=\"width: 750px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11192 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-2.jpg\" alt=\"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n\" width=\"750\" height=\"313\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-2.jpg 750w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-2-400x167.jpg 400w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><figcaption id=\"caption-attachment-11192\" class=\"wp-caption-text\"><em>C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n<\/em><\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_cong_tuan_trong_Excel_Hoac_tru\"><\/span><b>C\u00e1ch c\u1ed9ng tu\u1ea7n trong Excel ( Ho\u1eb7c tr\u1eeb)\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 c\u1ed9ng tr\u1eeb tu\u1ea7n cho d\u1eef li\u1ec7u ng\u00e0y trong Excel \u0111\u00f3 l\u00e0 b\u1ed9i s\u1ed1 c\u1ee7a 7. M\u1ed9t tu\u1ea7n c\u00f3 7 ng\u00e0y, do \u0111\u00f3 khi mu\u1ed1n th\u00eam v\u00e0o ho\u1eb7c tr\u1eeb \u0111i bao nhi\u00eau tu\u1ea7n th\u00ec ch\u1ec9 c\u1ea7n t\u00ednh theo c\u00fa ph\u00e1p c\u1ee7a ng\u00e0y, nh\u01b0ng l\u1ea5y s\u1ed1 tu\u1ea7n nh\u00e2n th\u00eam 7.\u00a0\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, b\u1ea1n mu\u1ed1n c\u00f4ng th\u00eam v\u00e0o ng\u00e0y \u1edf \u00f4 A2 N tu\u1ea7n, c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00fa ph\u00e1p sau:\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">= A2 + N tu\u1ea7n * 7 (N\u00f3 t\u01b0\u01a1ng t\u1ef1 v\u1edbi tr\u1eeb)\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, b\u1ea1n mu\u1ed1n t\u00ednh s\u1ed1 tu\u1ea7n t\u1eeb m\u1ed1c h\u00f4m nay, c\u00fa ph\u00e1p c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng \u0111\u00f3 l\u00e0: = TODAY () + (-)\u00a0 2 * 7.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_cong_tru_thang_trong_Excel\"><\/span><b>C\u00e1ch c\u1ed9ng tr\u1eeb th\u00e1ng trong Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 c\u1ed9ng tr\u1eeb th\u00e1ng trong Excel, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ch\u1ee9c n\u0103ng DATE ho\u1eb7c EDATE. V\u1edbi h\u00e0m date, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00fa ph\u00e1p nh\u01b0 sau. V\u00ed d\u1ee5, b\u1ea1n mu\u1ed1n th\u00eam 2 th\u00e1ng cho ng\u00e0y trong \u00f4 A2. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp s\u1ed1 th\u00e1ng mu\u1ed1n c\u1ed9ng v\u00e0o m\u1ed9t c\u1ed9t kh\u00e1c, ch\u1eb3ng h\u1ea1n C. N\u1ebfu l\u00e0 tr\u1eeb \u0111i s\u1ed1 th\u00e1ng th\u00ec c\u00f3 th\u1ec3 thay s\u1ed1 \u1edf c\u1ed9t C l\u00e0 s\u1ed1 \u00e2m, ho\u1eb7c thay d\u1ea5u tr\u1eeb cho c\u00f4ng th\u1ee9c. Sau \u0111\u00f3, c\u00fa ph\u00e1p h\u00e0m s\u1ebd nh\u01b0 sau:\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><b>= DATE (YEAR (A2), MONTH (A2) + $ C $ 2, DAY (A2))<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1c b\u1ea1n c\u0169ng c\u00f3 th\u1ebb s\u1eed d\u1ee5ng h\u00e0m EDATE (start_date, months) \u0111\u1ec3 c\u00f4ng tr\u1eeb s\u00f3 th\u00e1ng.\u00a0 C\u00fa ph\u00e1p h\u00e0m \u0111\u00f2i h\u1ecfi hai \u0111\u1ed1i s\u1ed1 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Start_date \u2013 ng\u00e0y b\u1eaft \u0111\u1ea7u \u0111\u1ebfm s\u1ed1 th\u00e1ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Months \u2013 s\u1ed1 th\u00e1ng \u0111\u1ec3 c\u1ed9ng (m\u1ed9t gi\u00e1 tr\u1ecb d\u01b0\u01a1ng) ho\u1eb7c tr\u1eeb (m\u1ed9t gi\u00e1 tr\u1ecb \u00e2m).<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_11191\" aria-describedby=\"caption-attachment-11191\" style=\"width: 805px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11191 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-3.jpg\" alt=\"C\u00e1ch c\u1ed9ng th\u00e1ng trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n\" width=\"805\" height=\"340\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-3.jpg 805w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-3-400x169.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-3-768x324.jpg 768w\" sizes=\"auto, (max-width: 805px) 100vw, 805px\" \/><figcaption id=\"caption-attachment-11191\" class=\"wp-caption-text\"><em>C\u00e1ch c\u1ed9ng th\u00e1ng trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n<\/em><\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c sau \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng tr\u00ean c\u1ed9t th\u1eddi gian cho k\u1ebft qu\u1ea3 gi\u1ed1ng h\u1ec7t nh\u01b0 h\u00e0m DATE trong v\u00ed d\u1ee5 tr\u01b0\u1edbc:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ho\u1eb7c c\u00e1c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m EDATE v\u00c0 DATE, EDATE v\u00e0 TODAY trong Excel. V\u00ed d\u1ee5, khi mu\u1ed1n c\u1ed9ng th\u00eam 10 th\u00e1ng k\u1ec3 t\u1eeb ng\u00e0y 9 th\u00e1ng 3 n\u0103m 2022 ta c\u00f3 h\u00e0m sau: = EDATE (DATE (2022, 3 , 9), 10). Ho\u1eb7c tr\u1eeb \u0111i 10 th\u00e1ng k\u1ec3 t\u1eeb h\u00f4m nay = EDATE (TODAY (), -10). L\u01b0u \u00fd l\u00e0, h\u00e0m EDATE tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 \u0111\u1ea1i di\u1ec7n cho ng\u00e0y. \u0110\u1ec3 bu\u1ed9c Excel hi\u1ec3n th\u1ecb n\u00f3 nh\u01b0 m\u1ed9t ng\u00e0y, b\u1ea1n n\u00ean \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng Ng\u00e0y cho c\u00e1c \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c.<\/span><\/p>\n<figure id=\"attachment_11190\" aria-describedby=\"caption-attachment-11190\" style=\"width: 629px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11190 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-4.jpg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m EDATE \" width=\"629\" height=\"332\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-4.jpg 629w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-4-400x211.jpg 400w\" sizes=\"auto, (max-width: 629px) 100vw, 629px\" \/><figcaption id=\"caption-attachment-11190\" class=\"wp-caption-text\"><em>S\u1eed d\u1ee5ng h\u00e0m EDATE<\/em><\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_cong_hoac_tru_nam_trong_Excel\"><\/span><b>C\u00e1ch c\u1ed9ng ho\u1eb7c tr\u1eeb n\u0103m trong Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m DATE cho thao t\u00e1c c\u1ed9ng ho\u1eb7c tr\u1eeb s\u1ed1 n\u0103m. C\u1ee5 th\u1ec3, c\u1ee5 ph\u00e1p s\u1ebd nh\u01b0 sau: \u00a0 <\/span><b>= DATE (YEAR (ng\u00e0y) + N n\u0103m, MONTH (ng\u00e0y), DAY (ng\u00e0y))<\/b><span style=\"font-weight: 400;\">. V\u00e0 t\u1eeb \u0111\u00f3, ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t d\u00e0nh cho c\u00e1ch c\u1ed9ng ng\u00e0y th\u00e1ng n\u0103m trong\u00a0 Excel nh\u01b0 sau:\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 th\u00eam n\u0103m, th\u00e1ng, ng\u00e0y:<\/span><\/p>\n<p style=\"text-align: justify;\"><b>= DATE (YEAR (ng\u00e0y) + X n\u0103m, MONTH (ng\u00e0y) + Y th\u00e1ng, DAY (ng\u00e0y) + Z ng\u00e0y)<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 tr\u1eeb n\u0103m, th\u00e1ng, ng\u00e0y:<\/span><\/p>\n<p style=\"text-align: justify;\"><b>= DATE (YEAR (ng\u00e0y) \u2013 X n\u0103m, MONTH (ng\u00e0y) \u2013 Y th\u00e1ng, DAY (ng\u00e0y) \u2013 Z ng\u00e0y)<\/b><\/p>\n<figure id=\"attachment_11189\" aria-describedby=\"caption-attachment-11189\" style=\"width: 738px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11189 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-5.jpg\" alt=\"C\u00e1ch c\u1ed9ng ho\u1eb7c tr\u1eeb n\u0103m trong Excel \" width=\"738\" height=\"524\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-5.jpg 738w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-5-400x284.jpg 400w\" sizes=\"auto, (max-width: 738px) 100vw, 738px\" \/><figcaption id=\"caption-attachment-11189\" class=\"wp-caption-text\"><em>C\u00e1ch c\u1ed9ng ho\u1eb7c tr\u1eeb n\u0103m trong Excel<\/em><\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_cong_thoi_gian_trong_Excel_Hoac_tru\"><\/span><b>C\u00e1ch c\u1ed9ng th\u1eddi gian trong Excel (Ho\u1eb7c tr\u1eeb)<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m TIME \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c \u0111i\u1ec1u ch\u00ednh li\u00ean quan \u0111\u1ebfn gi\u1edd trong Excel. H\u00e0m n\u00e0y cho ph\u00e9p c\u00e1c \u0111i\u1ec1u ch\u1ec9nh li\u00ean quan \u0111\u1ebfn th\u1eddi gian \u1edf \u0111\u01a1n v\u1ecb (gi\u1edd, ph\u00fat v\u00e0 gi\u00e2y) ch\u00ednh x\u00e1c. H\u00e0m TIME g\u1ea7n gi\u1ed1ng v\u1edbi h\u00e0m DATE \u1edf c\u00e1ch c\u1ed9ng ng\u00e0y trong Excel.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 th\u00eam ho\u1eb7c b\u1edbt th\u1eddi gian trong Excel, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3:<\/span><\/p>\n<p style=\"text-align: justify;\"><b>= A2 + (-) TIME (gi\u1edd, ph\u00fat, gi\u00e2y)<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u00d4 A2 l\u00e0 \u00f4 tham chi\u1ebfu c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb d\u1ea1ng gi\u1edd m\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i.\u00a0 Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp th\u1eddi gian b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i trong m\u1ed9t s\u1ed1 \u00f4, v\u00e0 tham chi\u1ebfu nh\u1eefng \u00f4 \u0111\u00f3 trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n:<\/span><\/p>\n<p style=\"text-align: justify;\"><b>= A2 + TIME ($ C $ 2, $ D $ 2, $ E $ 2)<\/b><\/p>\n<figure id=\"attachment_11188\" aria-describedby=\"caption-attachment-11188\" style=\"width: 786px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11188 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-6.jpg\" alt=\"C\u00e1ch c\u1ed9ng th\u1eddi gian trong Excel (Ho\u1eb7c tr\u1eeb)\" width=\"786\" height=\"323\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-6.jpg 786w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-6-400x164.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-6-768x316.jpg 768w\" sizes=\"auto, (max-width: 786px) 100vw, 786px\" \/><figcaption id=\"caption-attachment-11188\" class=\"wp-caption-text\"><em>C\u00e1ch c\u1ed9ng th\u1eddi gian trong Excel (Ho\u1eb7c tr\u1eeb)<\/em><\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><i><span style=\"font-weight: 400;\">V\u00e0 nh\u01b0 v\u1eady, tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng <\/span><\/i><b><i>c\u00e1ch c\u1ed9ng ng\u00e0y trong Excel <\/i><\/b><i><span style=\"font-weight: 400;\">m\u1ed9t c\u00e1ch chi ti\u1ebft v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t. Hy v\u1ecdng r\u1eb1ng nh\u1eefng th\u00f4ng tin tr\u00ean \u0111\u00e2y s\u1ebd gi\u00fap \u00edch cho c\u00e1c b\u1ea1n trong vi\u1ec7c \u0111i\u1ec1u ch\u1ec9nh d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh m\u00f4t c\u00e1ch thu\u1eadn ti\u1ec7n nh\u1ea5t. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 h\u1ecdc th\u00eam nhi\u1ec1u ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 Excel nh\u1ea5t<a href=\"https:\/\/teky.edu.vn\/\"> t\u1ea1i \u0111\u00e2y!\u00a0<\/a><\/span><\/i><\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/dinh-dang-ngay-thang-nam-trong-excel\/\" target=\"_blank\" rel=\"noopener\">\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m trong Excel b\u1eb1ng 03 c\u00e1ch \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-ngay-thang-nam-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e9 l\u1ed9 h\u00e0m ng\u00e0y th\u00e1ng n\u0103m trong Excel v\u00e0 nh\u1eefng \u0111i\u1ec1u n\u00ean bi\u1ebft<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-them-cot-trong-excel\/\" target=\"_blank\" rel=\"noopener\">3 C\u00e1ch th\u00eam c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>C\u00e1c \u00f4 d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m r\u1ea5t ph\u1ed5 bi\u1ebfn trong nh\u1eadp li\u1ec7u v\u00e0 data Excel. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o ch\u00fang c\u0169ng s\u1ebd c\u1ed1 \u0111\u1ecbnh nh\u01b0 th\u1ebf. S\u1ebd c\u00f3 nhi\u1ec1u b\u1ed1i c\u1ea3nh khi\u1ebfn cho d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m tr\u00ean b\u1ea3ng t\u00ednh Excel c\u1ea7n c\u00f3 s\u1ef1 thay \u0111\u1ed5i v\u00e0 \u0111i\u1ec1u ch\u1ec9nh. Do \u0111\u00f3, &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11193,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11187","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u d\u00e0nh cho b\u1ea1n<\/title>\n<meta name=\"description\" content=\"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel kh\u00f4ng h\u1ec1 ph\u1ee9c t\u1ea1p nh\u01b0 c\u00e1c b\u1ea1n h\u00ecnh dung. Ch\u00fang r\u1ea5t d\u1ec5 thao t\u00e1c v\u1edbi c\u00e1c ph\u00e9p t\u00ednh v\u00e0 h\u00e0m c\u01a1 b\u1ea3n.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u d\u00e0nh cho b\u1ea1n\" \/>\n<meta property=\"og:description\" content=\"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel kh\u00f4ng h\u1ec1 ph\u1ee9c t\u1ea1p nh\u01b0 c\u00e1c b\u1ea1n h\u00ecnh dung. Ch\u00fang r\u1ea5t d\u1ec5 thao t\u00e1c v\u1edbi c\u00e1c ph\u00e9p t\u00ednh v\u00e0 h\u00e0m c\u01a1 b\u1ea3n.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-09T19:19:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-06T04:58:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"824\" \/>\n\t<meta property=\"og:image:height\" content=\"526\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u d\u00e0nh cho b\u1ea1n\",\"datePublished\":\"2022-11-09T19:19:27+00:00\",\"dateModified\":\"2022-12-06T04:58:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/\"},\"wordCount\":1822,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-1.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/\",\"name\":\"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u d\u00e0nh cho b\u1ea1n\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-1.jpg\",\"datePublished\":\"2022-11-09T19:19:27+00:00\",\"dateModified\":\"2022-12-06T04:58:47+00:00\",\"description\":\"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel kh\u00f4ng h\u1ec1 ph\u1ee9c t\u1ea1p nh\u01b0 c\u00e1c b\u1ea1n h\u00ecnh dung. Ch\u00fang r\u1ea5t d\u1ec5 thao t\u00e1c v\u1edbi c\u00e1c ph\u00e9p t\u00ednh v\u00e0 h\u00e0m c\u01a1 b\u1ea3n.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-1.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-1.jpg\",\"width\":824,\"height\":526,\"caption\":\"C\u00f3 4 c\u00e1ch \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c ng\u00e0y c\u1ee5 th\u1ec3 trong Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u d\u00e0nh cho b\u1ea1n\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u d\u00e0nh cho b\u1ea1n","description":"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel kh\u00f4ng h\u1ec1 ph\u1ee9c t\u1ea1p nh\u01b0 c\u00e1c b\u1ea1n h\u00ecnh dung. Ch\u00fang r\u1ea5t d\u1ec5 thao t\u00e1c v\u1edbi c\u00e1c ph\u00e9p t\u00ednh v\u00e0 h\u00e0m c\u01a1 b\u1ea3n.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u d\u00e0nh cho b\u1ea1n","og_description":"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel kh\u00f4ng h\u1ec1 ph\u1ee9c t\u1ea1p nh\u01b0 c\u00e1c b\u1ea1n h\u00ecnh dung. Ch\u00fang r\u1ea5t d\u1ec5 thao t\u00e1c v\u1edbi c\u00e1c ph\u00e9p t\u00ednh v\u00e0 h\u00e0m c\u01a1 b\u1ea3n.","og_url":"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-09T19:19:27+00:00","article_modified_time":"2022-12-06T04:58:47+00:00","og_image":[{"width":824,"height":526,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-1.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u d\u00e0nh cho b\u1ea1n","datePublished":"2022-11-09T19:19:27+00:00","dateModified":"2022-12-06T04:58:47+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/"},"wordCount":1822,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-1.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/","name":"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u d\u00e0nh cho b\u1ea1n","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-1.jpg","datePublished":"2022-11-09T19:19:27+00:00","dateModified":"2022-12-06T04:58:47+00:00","description":"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel kh\u00f4ng h\u1ec1 ph\u1ee9c t\u1ea1p nh\u01b0 c\u00e1c b\u1ea1n h\u00ecnh dung. Ch\u00fang r\u1ea5t d\u1ec5 thao t\u00e1c v\u1edbi c\u00e1c ph\u00e9p t\u00ednh v\u00e0 h\u00e0m c\u01a1 b\u1ea3n.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-1.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-cong-ngay-trong-excel-1.jpg","width":824,"height":526,"caption":"C\u00f3 4 c\u00e1ch \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c ng\u00e0y c\u1ee5 th\u1ec3 trong Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-cong-ngay-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch c\u1ed9ng ng\u00e0y trong Excel \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u d\u00e0nh cho b\u1ea1n"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11187"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11187\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11193"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}