{"id":268384,"date":"2023-10-06T13:04:12","date_gmt":"2023-10-06T06:04:12","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=268384"},"modified":"2023-10-06T13:04:12","modified_gmt":"2023-10-06T06:04:12","slug":"tinh-tuoi-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/","title":{"rendered":"Minh h\u1ecda 8 c\u00e1ch t\u00ednh tu\u1ed5i trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n, ch\u00ednh x\u00e1c"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Excel l\u00e0 m\u1ed9t trong nh\u1eefng \u1ee9ng d\u1ee5ng tin h\u1ecdc v\u0103n ph\u00f2ng c\u1ef1c k\u1ef3 h\u1eefu \u00edch trong c\u00f4ng vi\u1ec7c v\u00e0 cu\u1ed9c s\u1ed1ng. V\u1edbi ph\u1ea7n m\u1ec1m n\u00e0y, b\u1ea1n s\u1ebd ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u th\u1eddi gian nh\u1edd nh\u1eefng t\u00ednh n\u0103ng c\u1ee7a c\u00f4ng c\u1ee5 n\u00e0y. Trong \u0111\u00f3 qu\u00e1 tr\u00ecnh h\u1ecdc t\u1eadp, l\u00e0m vi\u1ec7c, nhi\u1ec1u y\u00eau c\u1ea7u \u0111\u00f2i h\u1ecfi c\u1ea7n ph\u1ea3i t\u00ednh tu\u1ed5i c\u1ee7a m\u1ed9t ho\u1eb7c h\u00e0ng lo\u1ea1t ng\u01b0\u1eddi. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 <\/span><b>t\u00ednh tu\u1ed5i trong Excel <\/b><span style=\"font-weight: 400;\">nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n?\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u00e0i vi\u1ebft h\u00f4m nay, <strong>Ho\u00e0ng H\u00e0 Mobile<\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 8 c\u00e1ch \u0111\u1ec3 t\u00ednh to\u00e1n \u0111\u1ed9 tu\u1ed5i nhanh, ch\u00ednh x\u00e1c m\u00e0 ai c\u0169ng c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c ngay tr\u00ean c\u00f4ng c\u1ee5 Microsoft Excel. H\u00e3y c\u00f9ng theo d\u00f5i v\u00e0 l\u01b0u l\u1ea1i th\u1ee7 thu\u1eadt h\u1eefu \u00edch d\u01b0\u1edbi \u0111\u00e2y ngay nh\u00e9!<\/span><\/p>\n<h2><strong>T\u00ednh tu\u1ed5i trong Excel b\u1eb1ng nh\u1eefng c\u00e1ch n\u00e0o?<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">Tu\u1ed5i c\u1ee7a b\u1ea5t k\u1ef3 ai \u0111\u01b0\u1ee3c t\u00ednh t\u1eeb ng\u00e0y ng\u01b0\u1eddi \u0111\u00f3 \u0111\u01b0\u1ee3c sinh ra v\u00e0 \u0111\u01b0\u1ee3c khai b\u00e1o trong s\u01a1 y\u1ebfu l\u00fd l\u1ecbch, gi\u1ea5y khai sinh v\u00e0 c\u00e1c lo\u1ea1i gi\u1ea5y t\u1edd t\u00f9y th\u00e2n kh\u00e1c. C\u00e1ch \u0111\u1ec3 t\u00ednh tu\u1ed5i c\u1ee7a m\u1ed9t ng\u01b0\u1eddi c\u0169ng c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n, ch\u1ec9 v\u1edbi c\u00e1c ph\u00e9p tr\u1eeb m\u00e0 ai c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c. Tuy nhi\u00ean, v\u1edbi s\u1ed1 l\u01b0\u1ee3ng danh s\u00e1ch ng\u01b0\u1eddi c\u1ea7n t\u00ednh tu\u1ed5i l\u1edbn th\u00ec vi\u1ec7c t\u00ednh nh\u1ea9m, s\u1eed d\u1ee5ng m\u00e1y t\u00ednh c\u1ea7m tay \u0111\u1ec3 t\u00ednh s\u1ebd m\u1ea5t r\u1ea5t nhi\u1ec1u th\u1eddi gian.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Do \u0111\u00f3, \u0111\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 \u0111\u1ed3ng b\u1ed9 h\u01a1n, nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Microsoft Excel \u0111\u1ec3 t\u00ednh to\u00e1n b\u1eb1ng nh\u1eefng c\u00e2u l\u1ec7nh c\u1ee7a c\u00f4ng c\u1ee5 n\u00e0y. T\u00ednh tu\u1ed5i trong ph\u1ea7n m\u1ec1m Excel l\u00e0 c\u01a1 s\u1edf \u0111\u1ec3 th\u1ed1ng k\u00ea, khai b\u00e1o, c\u1eadp nh\u1eadt th\u00f4ng tin c\u1ee7a m\u1ed9t ng\u01b0\u1eddi ho\u1eb7c m\u1ed9t nh\u00f3m \u0111\u1ed1i t\u01b0\u1ee3ng. B\u00ean c\u1ea1nh \u0111\u00f3, \u0111\u00e2y c\u0169ng l\u00e0 c\u00e2u h\u1ecfi, b\u00e0i t\u1eadp th\u1ef1c h\u00e0nh th\u01b0\u1eddng th\u1ea5y trong c\u00e1c l\u1edbp tin h\u1ecdc v\u0103n ph\u00f2ng hay l\u1edbp \u00f4n luy\u1ec7n ch\u1ee9ng ch\u1ec9.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-1-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-1-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-268448 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-1.jpg\" alt=\"tinh-tuoi-trong-excel-1\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-1-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-1-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 8 c\u00e1ch t\u00ednh tu\u1ed5i m\u00e0 Ho\u00e0ng H\u00e0 Mobile s\u1ebd chia s\u1ebb v\u1edbi b\u1ea1n trong b\u00e0i vi\u1ebft h\u00f4m nay:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m YEAR<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m YEARFRAC<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m DATEDIF<\/span><\/li>\n<li>S\u1eed d\u1ee5ng h\u00e0m TODAY<\/li>\n<li>T\u00ednh tu\u1ed5i chu\u1ea9n x\u00e1c s\u1ed1 ng\u00e0y, th\u00e1ng, n\u0103m<\/li>\n<li>T\u00ednh tu\u1ed5i trong tr\u01b0\u1eddng h\u1ee3p th\u1eddi gian kh\u00f4ng c\u1ee5 th\u1ec3<\/li>\n<li>T\u00ecm ng\u00e0y \u0111\u1ec3 m\u1ed9t ng\u01b0\u1eddi \u0111\u1ea1t \u0111\u01b0\u1ee3c m\u1ed9t \u0111\u1ed9 tu\u1ed5i nh\u1ea5t \u0111\u1ecbnh<\/li>\n<li>T\u00ednh tu\u1ed5i khi c\u00f3 ng\u00e0y, th\u00e1ng, n\u0103m sinh \u1edf nh\u1eefng \u00f4 kh\u00e1c nhau<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">V\u1edbi nh\u1eefng h\u00e0m t\u00ednh tu\u1ed5i trong ph\u1ea7n m\u1ec1m v\u0103n ph\u00f2ng Excel h\u1eefu \u00edch tr\u00ean \u0111\u00e2y ch\u1eafc ch\u1eafn s\u1ebd h\u1ed7 tr\u1ee3 r\u1ea5t nhi\u1ec1u cho c\u00f4ng vi\u1ec7c, h\u1ecdc t\u1eadp c\u1ee7a b\u1ea1n.<\/span><\/p>\n<h2><strong>8 c\u00e1ch t\u00ednh tu\u1ed5i trong Excel nhanh ch\u00f3ng, ch\u00ednh x\u00e1c<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 8 c\u00e1ch c\u0169ng nh\u01b0 minh h\u1ecda c\u00e1c b\u01b0\u1edbc chi ti\u1ebft m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c h\u00e0nh thao t\u00e1c theo \u0111\u1ec3 t\u00ednh tu\u1ed5i trong ph\u1ea7n m\u1ec1m Excel v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n, nhanh g\u1ecdn v\u00e0 chu\u1ea9n x\u00e1c:<\/span><\/p>\n<h3><strong>T\u00ednh tu\u1ed5i trong Excel v\u1edbi h\u00e0m YEAR<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 t\u00ednh tu\u1ed5i b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Year v\u1edbi c\u00f4ng th\u1ee9c sau \u0111\u00e2y: <strong>=YEAR(NOW())-YEAR(B2)).<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u1edbi:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">YEAR(NOW()): n\u0103m \u1edf th\u1eddi \u0111i\u1ec3m hi\u1ec7n t\u1ea1i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">YEAR(B2): n\u0103m \u1edf \u00f4 c\u00f3 ch\u1ee9a ng\u00e0y, th\u00e1ng, n\u0103m sinh c\u1ee7a ng\u01b0\u1eddi m\u00e0 b\u1ea1n \u0111ang ch\u1ecdn.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">C\u00e1c b\u01b0\u1edbc thao t\u00e1c v\u1edbi h\u00e0m YEAR \u0111\u1ec3 t\u00ednh tu\u1ed5i:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Nh\u1eadp \u0111\u1ea7y \u0111\u1ee7, chu\u1ea9n x\u00e1c c\u00f4ng th\u1ee9c v\u00e0o \u00f4 mu\u1ed1n t\u00ednh tu\u1ed5i.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-2-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-2-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter wp-image-268449 size-full webpexpress-processed\" title=\"S\u1eed d\u1ee5ng h\u00e0m YEAR \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-2.jpg\" alt=\"tinh-tuoi-trong-excel-2\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-2-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-2-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n n\u00fat Enter v\u00e0 ki\u1ec3m tra l\u1ea1i xem k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p t\u00ednh \u0111\u00e3 nh\u1eadp.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-3-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-3-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter wp-image-268450 size-full webpexpress-processed\" title=\"S\u1eed d\u1ee5ng h\u00e0m YEAR \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-3.jpg\" alt=\"tinh-tuoi-trong-excel-3\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-3-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-3-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Sau khi thao t\u00e1c xong nh\u01b0 2 b\u01b0\u1edbc \u1edf tr\u00ean nh\u01b0ng k\u1ebft qu\u1ea3 nh\u1eadn v\u1ec1 kh\u00f4ng ph\u1ea3i s\u1ed1 nguy\u00ean m\u00e0 \u1edf \u0111\u1ecbnh d\u1ea1ng ki\u1ec3u Date nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y th\u00ec b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh l\u1ea1i v\u1ec1 d\u1ea1ng s\u1ed1ng nguy\u00ean v\u1edbi ki\u1ec3u Number.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 \u0111\u1ecbnh d\u1ea1ng, b\u1ea1n b\u00f4i \u0111en \u00f4 c\u00f3 k\u1ebft qu\u1ea3 -&gt; sau \u0111\u00f3 click chu\u1ed9t ph\u1ea3i -&gt; nh\u1ea5n ch\u1ecdn Format Cells. Sau \u0111\u00f3, h\u1ed9p tho\u1ea1i m\u1edbi xu\u1ea5t hi\u1ec7n, b\u1ea1n nh\u1ea5n ch\u1ecdn Number -&gt; \u1edf Decimal places, b\u1ea1n nh\u1eadp v\u00e0o s\u1ed1 0 -&gt; Nh\u1ea5n ch\u1ecdn OK \u0111\u1ec3 ho\u00e0n t\u1ea5t \u0111\u1ecbnh d\u1ea1ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Khi b\u1ea1n mu\u1ed1n sao ch\u00e9p h\u00e0m \u0111\u1ec3 t\u00ednh cho nh\u1eefng \u00f4 c\u00f2n l\u1ea1i th\u00ec c\u00f3 th\u1ec3 \u0111\u1eb7t con tr\u1ecf chu\u1ed9t \u1edf g\u00f3c d\u01b0\u1edbi \u00f4 c\u00f3 k\u1ebft qu\u1ea3 \u0111\u00e3 cho \u0111\u1ebfn khi xu\u1ea5t hi\u1ec7n bi\u1ec3u t\u01b0\u1ee3ng h\u00ecnh d\u1ea5u c\u1ed9ng \u201c+\u201d r\u1ed3i gi\u1eef chu\u1ed9t k\u00e9o xu\u1ed1ng cho \u0111\u1ebfn h\u1ebft \u00f4 cu\u1ed1i c\u00f9ng c\u1ea7n t\u00ednh l\u00e0 xong.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-4-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-4-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-268451 size-full webpexpress-processed\" title=\"S\u1eed d\u1ee5ng h\u00e0m YEAR \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-4.jpg\" alt=\"tinh-tuoi-trong-excel-4\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-4-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-4-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">V\u1edbi h\u00e0m YEAR, \u01b0u \u0111i\u1ec3m c\u1ee7a c\u00e1ch t\u00ednh tu\u1ed5i n\u00e0y \u0111\u00f3 nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n v\u00e0 chu\u1ea9n x\u00e1c. Tuy v\u1eady, m\u1ed9t nh\u01b0\u1ee3c \u0111i\u1ec3m m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y \u0111\u00f3 l\u00e0 kh\u00f4ng th\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c theo ng\u00e0y, th\u00e1ng.<\/span><\/p>\n<h3><strong>T\u00ednh tu\u1ed5i trong Excel v\u1edbi<\/strong><strong> h\u00e0m YEARFRAC<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m YEARFRAC l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho vi\u1ec7c t\u00ednh tu\u1ed5i. \u01afu \u0111i\u1ec3m c\u1ee7a c\u00e1ch t\u00ednh tu\u1ed5i b\u1eb1ng h\u00e0m n\u00e0y l\u00e0 \u0111\u1ed9 tin c\u1eady v\u00e0 chu\u1ea9n x\u00e1c cao. Tuy v\u1eady, d\u01b0\u1eddng nh\u01b0 kh\u00f4ng c\u00f3 qu\u00e1 nhi\u1ec1u ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn h\u00e0m n\u00e0y n\u00ean \u0111\u1ed9 ph\u1ed5 bi\u1ebfn c\u0169ng kh\u00f4ng qu\u00e1 cao.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c h\u00e0m <strong>YEARFRAC: =YEARFRAC(start_date,end_date,[basic])<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u1edbi:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">start_date: ng\u00e0y b\u1eaft \u0111\u1ea7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">end_date: ng\u00e0y k\u1ebft th\u00fac.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">basic: con s\u1ed1 s\u1eed d\u1ee5ng \u0111\u1ec3 quy \u0111\u1ecbnh ki\u1ec3u t\u00ednh, th\u01b0\u1eddng d\u00f9ng s\u1ed1 1 d\u00f9ng \u0111\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y th\u1ef1c t\u1ebf theo n\u0103m v\u00e0 th\u00e1ng.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n \u0111ang mu\u1ed1n th\u1eed t\u00ednh tu\u1ed5i v\u1edbi h\u00e0m n\u00e0y, d\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn, minh h\u1ecda chi ti\u1ebft c\u00e1c b\u01b0\u1edbc m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Nh\u1eadp h\u00e0m v\u00e0o \u00f4 mu\u1ed1n t\u00ednh.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-5-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-5-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-268452 size-full webpexpress-processed\" title=\"S\u1eed d\u1ee5ng h\u00e0m YEARFRAC \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-5.jpg\" alt=\"tinh-tuoi-trong-excel-5\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-5-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-5-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n n\u00fat Enter v\u00e0 ki\u1ec3m tra l\u1ea1i xem k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 \u0111\u00e3 chu\u1ea9n x\u00e1c hay ch\u01b0a.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-6-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-6-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-268453 size-full webpexpress-processed\" title=\"S\u1eed d\u1ee5ng h\u00e0m YEARFRAC \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-6.jpg\" alt=\"tinh-tuoi-trong-excel-6\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-6-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-6-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Tr\u01b0\u1eddng h\u1ee3p c\u1ea7n t\u00ednh cho nh\u1eefng \u00f4 c\u00f2n l\u1ea1i, b\u1ea1n \u0111\u1eb7t con tr\u1ecf chu\u1ed9t \u1edf g\u00f3c d\u01b0\u1edbi c\u1ee7a \u00f4 v\u1eeba nh\u1eadn k\u1ebft qu\u1ea3 \u1edf tr\u00ean \u0111\u1ebfn khi xu\u1ea5t hi\u1ec7n bi\u1ec3u t\u01b0\u1ee3ng \u0111\u1ea5u \u201c+\u201d r\u1ed3i k\u00e9o xu\u1ed1ng cho \u0111\u1ebfn h\u1ebft c\u00e1c \u00f4 v\u00e0 th\u1ea3 ra l\u00e0 ho\u00e0n t\u1ea5t.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-7-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-7-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-268454 size-full webpexpress-processed\" title=\"S\u1eed d\u1ee5ng h\u00e0m YEARFRAC \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-7.jpg\" alt=\"tinh-tuoi-trong-excel-7\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-7-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-7-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><strong>T\u00ednh tu\u1ed5i trong Excel v\u1edbi<\/strong><strong> h\u00e0m DATEDIF<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh 2 h\u00e0m \u1edf tr\u00ean, DATEDIF c\u0169ng l\u00e0 h\u00e0m Excel gi\u00fap b\u1ea1n t\u00ednh tu\u1ed5i c\u1ee7a m\u1ed9t ho\u1eb7c nhi\u1ec1u ng\u01b0\u1eddi ch\u00ednh x\u00e1c. Tuy nhi\u00ean, nh\u00ecn chung, h\u00e0m DATEDIF c\u00f3 c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p h\u01a1n m\u1ed9t ch\u00fat so v\u1edbi hai h\u00e0m \u1edf tr\u00ean.<\/span><\/p>\n<p>V\u1edbi h\u00e0m t\u00ednh tu\u1ed5i n\u00e0y, t\u00f9y thu\u1ed9c v\u00e0o \u0111\u01a1n v\u1ecb t\u00ednh Unit, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 nh\u1eefng s\u1ed1 li\u1ec7u kh\u00e1c nhau. C\u1ee5 th\u1ec3:<\/p>\n<table style=\"height: 405px;\" width=\"800\">\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">STT<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u0110\u01a1n v\u1ecb t\u00ednh<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u00dd ngh\u0129a c\u1ee7a \u0111\u01a1n v\u1ecb<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1<\/span><\/td>\n<td><span style=\"font-weight: 400;\">D<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Th\u1eddi gian \u0111\u01b0\u1ee3c t\u00ednh theo ng\u00e0y tr\u00f2n gi\u1eefa 2 ng\u00e0y<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">M<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Th\u1eddi gian \u0111\u01b0\u1ee3c t\u00ednh theo th\u00e1ng tr\u00f2n gi\u1eefa 2 ng\u00e0y<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">3<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Y<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Th\u1eddi gian \u0111\u01b0\u1ee3c t\u00ednh theo n\u0103m tr\u00f2n gi\u1eefa 2 ng\u00e0y<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">4<\/span><\/td>\n<td><span style=\"font-weight: 400;\">YD<\/span><\/td>\n<td><span style=\"font-weight: 400;\">S\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch, b\u1ecf qua n\u0103m<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">5<\/span><\/td>\n<td><span style=\"font-weight: 400;\">MD<\/span><\/td>\n<td><span style=\"font-weight: 400;\">S\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch, b\u1ecf qua th\u00e1ng v\u00e0 n\u0103m<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">6<\/span><\/td>\n<td><span style=\"font-weight: 400;\">YM<\/span><\/td>\n<td><span style=\"font-weight: 400;\">S\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch, b\u1ecf qua ng\u00e0y v\u00e0 n\u0103m<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c h\u00e0m <strong>DATEDIF: =DATEDIF(B2,NOW(),&#8221;Y&#8221;)<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u1edbi:\u00a0<\/span><\/p>\n<ul>\n<li>B2: L\u00e0 \u00f4 c\u00f3 ch\u1ee9a th\u00f4ng tin ng\u00e0y, th\u00e1ng, n\u0103m sinh.<\/li>\n<li>NOW(): L\u00e0 n\u0103m \u1edf th\u1eddi \u0111i\u1ec3m hi\u1ec7n t\u1ea1i.<\/li>\n<li>&#8220;Y&#8221;: V\u1edbi y\u00eau c\u1ea7u t\u00ednh tu\u1ed5i n\u00ean unit \u1edf \u0111\u00e2y ch\u00fang ta s\u1ebd ch\u1ecdn &#8220;Y&#8221;, k\u1ebft qu\u1ea3 ch\u1ec9 t\u00ednh n\u0103m trong kho\u1ea3ng ch\u00eanh l\u1ec7ch \u0111\u01b0\u1ee3c l\u1ea5y b\u1edfi 2 \u00f4 tr\u00ean.<\/li>\n<\/ul>\n<p>Sau \u0111\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc thao t\u00e1c \u0111\u1ec3 t\u00ednh tu\u1ed5i chu\u1ea9n x\u00e1c nh\u1ea5t b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m DATEDIF:<\/p>\n<p>B\u01b0\u1edbc 1: Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 m\u00e0 b\u1ea1n c\u1ea7n t\u00ednh tu\u1ed5i.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-8-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-8-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-268456 size-full webpexpress-processed\" title=\"S\u1eed d\u1ee5ng h\u00e0m DATEDIF \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-8.jpg\" alt=\"tinh-tuoi-trong-excel-8\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-8-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-8-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>B\u01b0\u1edbc 2: Nh\u1ea5n n\u00fat Enter r\u1ed3i ki\u1ec3m tra l\u1ea1i m\u1ed9t l\u1ea7n n\u1eefa k\u1ebft qu\u1ea3 v\u1eeba tr\u1ea3 v\u1ec1.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-9-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-9-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-268457 size-full webpexpress-processed\" title=\"S\u1eed d\u1ee5ng h\u00e0m DATEDIF \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-9.jpg\" alt=\"tinh-tuoi-trong-excel-9\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-9-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-9-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>Cu\u1ed1i c\u00f9ng, \u0111\u1ec3 t\u00ednh tu\u1ed5i cho nh\u1eefng \u00f4 c\u00f2n l\u1ea1i, b\u1ea1n \u0111\u1eb7t con tr\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi c\u00f9ng c\u1ee7a \u00f4 v\u1eeba t\u00ednh \u0111\u1ebfn khi xu\u1ea5t hi\u1ec7n h\u00ecnh d\u1ea5u &#8220;+&#8221; r\u1ed3i k\u00e9o \u0111\u1ebfn h\u1ebft nh\u1eefng \u00f4 c\u00f2n l\u1ea1i l\u00e0 xong.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-10-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-10-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-268458 size-full webpexpress-processed\" title=\"S\u1eed d\u1ee5ng h\u00e0m DATEDIF \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-10.jpg\" alt=\"tinh-tuoi-trong-excel-10\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-10-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-10-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3>C\u00e1ch t\u00ednh tu\u1ed5i g\u1ea7n \u0111\u00fang v\u1edbi h\u00e0m TODAY<\/h3>\n<p>V\u1edbi h\u00e0m TODAY, k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb c\u00f3 d\u1ea1ng \u1edf s\u1ed1 th\u1eadp ph\u00e2n. B\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel v\u00f4 c\u00f9ng ti\u1ec7n l\u1ee3i, \u0111\u00e1p \u1ee9ng nhu c\u1ea7u h\u1ecdc t\u1eadp, l\u00e0m vi\u1ec7c c\u1ee7a b\u1ea1n.<\/p>\n<p>C\u00f4ng th\u1ee9c h\u00e0m<strong> TODAY: =(TODAY()-C2)\/365<\/strong><\/p>\n<p>V\u1edbi:<\/p>\n<ul>\n<li>TODAY()-C2: Ph\u00e9p t\u00ednh n\u00e0y tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ng\u00e0y hi\u1ec7n t\u1ea1i tr\u1eeb cho ng\u00e0y sinh \u1edf \u00f4 C2 c\u1ee7a b\u1ea3ng t\u00ednh.<\/li>\n<li>(TODAY()-C2)\/365: Ph\u00e9p t\u00ednh n\u00e0y tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 n\u0103m t\u00ednh t\u1eeb ng\u00e0y sinh \u1edf \u00f4 C2 cho \u0111\u1ebfn th\u1eddi \u0111i\u1ec3m hi\u1ec7n t\u1ea1i.<\/li>\n<\/ul>\n<p>B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c b\u01b0\u1edbc thao t\u00e1c d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p>B\u01b0\u1edbc 1: Nh\u1eadp chu\u1ea9n x\u00e1c c\u00f4ng th\u1ee9c h\u00e0m TODAY v\u00e0o \u00f4 mu\u1ed1n t\u00ednh.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-11-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-11-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-268459 size-full webpexpress-processed\" title=\"C\u00e1ch t\u00ednh tu\u1ed5i g\u1ea7n \u0111\u00fang v\u1edbi h\u00e0m TODAY\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-11.jpg\" alt=\"tinh-tuoi-trong-excel-11\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-11-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-11-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>B\u01b0\u1edbc 2: Nh\u1ea5t n\u00fat Enter \u0111\u1ec3 nh\u1eadn v\u1ec1 k\u1ebft qu\u1ea3 v\u00e0 ki\u1ec3m tra t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a k\u1ebft qu\u1ea3.<\/p>\n<h3>C\u00e1ch t\u00ednh tu\u1ed5i ra ng\u00e0y, th\u00e1ng, n\u0103m chu\u1ea9n x\u00e1c<\/h3>\n<p>Sau \u0111\u00e2y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd chia s\u1ebb cho b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m DATEDIF v\u1edbi nh\u1eefng \u0111\u01a1n v\u1ecb t\u00ednh &#8211; Unit kh\u00e1c \u0111\u1ec3 t\u00ednh tu\u1ed5i ra s\u1ed1 ng\u00e0y, th\u00e1ng, n\u0103m chu\u1ea9n x\u00e1c:<\/p>\n<p>B\u01b0\u1edbc 1: C\u00e1c h\u00e0m s\u1ebd ph\u1ea3i nh\u1eadp v\u00e0o \u00f4 c\u1ea7n t\u00ednh bao g\u1ed3m:<\/p>\n<ul>\n<li>T\u00ednh s\u1ed1 n\u0103m v\u1edbi h\u00e0m: DATEDIF(B2,TODAY(),&#8221;Y&#8221;)<\/li>\n<li>T\u00ednh s\u1ed1 th\u00e1ng v\u1edbi h\u00e0m: DATEDIF(B2,TODAY(),&#8221;YM&#8221;)<\/li>\n<li>T\u00ednh s\u1ed1 ng\u00e0y v\u1edbi h\u00e0m: DATEDIF(B2,TODAY(),&#8221;MD&#8221;)<\/li>\n<\/ul>\n<p>C\u00fa ph\u00e1p k\u1ebft h\u1ee3p \u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ng\u00e0y, th\u00e1ng, n\u0103m nh\u1eadp v\u00e0o \u00f4 mu\u1ed1n t\u00ednh l\u00e0: <strong>=DATEDIF(B2,TODAY(),&#8221;MD&#8221;)&amp;DATEDIF(B2,TODAY(),&#8221;YM&#8221;)&amp;DATEDIF(B2,TODAY(),&#8221;Y&#8221;)<\/strong>.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-12-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-12-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-268460 size-full webpexpress-processed\" title=\"C\u00e1ch t\u00ednh tu\u1ed5i ra ng\u00e0y, th\u00e1ng, n\u0103m chu\u1ea9n x\u00e1c\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-12.jpg\" alt=\"tinh-tuoi-trong-excel-12\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-12-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-12-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>B\u01b0\u1edbc 2: Nh\u1ea5n n\u00fat Enter v\u00e0 ki\u1ec3m tra k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 t\u1eeb ph\u00e9p t\u00ednh. L\u00fac n\u00e0y, b\u1ea1n s\u1ebd nh\u1eadn v\u1ec1 m\u1ed9t d\u00e3y s\u1ed1 d\u00ednh nhau v\u00e0 r\u1ea5t kh\u00f3 \u0111\u1ec3 ph\u00e2n bi\u1ec7t. Do \u0111\u00f3 c\u1ea7n th\u00eam \u0111\u01a1n v\u1ecb v\u00e0o c\u00f4ng th\u1ee9c.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-13-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-13-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-268461 size-full webpexpress-processed\" title=\"C\u00e1ch t\u00ednh tu\u1ed5i ra ng\u00e0y, th\u00e1ng, n\u0103m chu\u1ea9n x\u00e1c\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-13.jpg\" alt=\"tinh-tuoi-trong-excel-13\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-13-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-13-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>B\u01b0\u1edbc 3: \u0110\u1ec3 th\u00eam, b\u1ea1n nh\u1eadp v\u00e0o \u00f4 c\u1ea7n t\u00ednh h\u00e0m \u0111\u1ea7y \u0111\u1ee7 sau \u0111\u00e2y: <strong>=DATEDIF(B2,TODAY(),&#8221;MD&#8221;)&amp;&#8221;Ng\u00e0y,&#8221;&amp;DATEDIF(B2,TODAY(),&#8221;YM&#8221;)&amp;&#8221;Th\u00e1ng,&#8221;&amp;DATEDIF(B2,TODAY(),&#8221;Y&#8221;)&amp;&#8221;N\u0103m&#8221;\u00a0<\/strong>v\u00e0 nh\u1ea5n Enter l\u00e0 ho\u00e0n t\u1ea5t.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-14-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-14-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-268462 size-full webpexpress-processed\" title=\"C\u00e1ch t\u00ednh tu\u1ed5i ra ng\u00e0y, th\u00e1ng, n\u0103m chu\u1ea9n x\u00e1c\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-14.jpg\" alt=\"tinh-tuoi-trong-excel-14\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-14-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-14-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-15-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-15-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-268463 size-full webpexpress-processed\" title=\"C\u00e1ch t\u00ednh tu\u1ed5i ra ng\u00e0y, th\u00e1ng, n\u0103m chu\u1ea9n x\u00e1c\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-15.jpg\" alt=\"tinh-tuoi-trong-excel-15\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-15-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-15-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3>C\u00e1ch t\u00ednh tu\u1ed5i trong tr\u01b0\u1eddng h\u1ee3p th\u1eddi gian t\u00ednh kh\u00f4ng c\u1ee5 th\u1ec3<\/h3>\n<p>C\u00f3 m\u1ed9t s\u1ed1 y\u00eau c\u1ea7u c\u1ea7n t\u00ednh tu\u1ed5i khi bi\u1ebft th\u1eddi gian k\u1ebft th\u00fac theo n\u0103m m\u00e0 kh\u00f4ng c\u00f3 ng\u00e0y, th\u00e1ng c\u1ee5 th\u1ec3. D\u01b0\u1edbi \u0111\u00e2y s\u1ebd l\u00e0 m\u1ed9t tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3 v\u00e0 minh h\u1ecda h\u01b0\u1edbng d\u1eabn c\u00e1c b\u01b0\u1edbc v\u00e0 h\u00e0m s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o:<\/p>\n<p>B\u01b0\u1edbc 1: Nh\u1eadp h\u00e0m <strong>=DATEDIF(B3;DATE(C3;1;1);&#8221;Y&#8221;)<\/strong> v\u00e0o \u00f4 c\u1ea7n t\u00ednh tu\u1ed5i.<\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li>B3: L\u00e0 \u00f4 c\u00f3 ch\u1ee9a ng\u00e0y sinh c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n ph\u1ea3i t\u00ednh.<\/li>\n<li>DATE(C3;1;1): l\u00e0 ng\u00e0y t\u1ea1o ng\u1eabu nhi\u00ean cho th\u1eddi gian \u1edf \u00f4 C3 \u0111\u00e3 c\u00f3 s\u1eb5n n\u0103m.<\/li>\n<li>&#8220;Y&#8221;: k\u1ebft qu\u1ea3 ch\u1ec9 t\u00ednh n\u0103m trong kho\u1ea3ng ch\u00eanh l\u1ec7ch \u0111\u01b0\u1ee3c l\u1ea5y b\u1edfi 2 \u00f4 tr\u00ean.<\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-16-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-16-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-268464 size-full aligncenter webpexpress-processed\" title=\"C\u00e1ch t\u00ednh tu\u1ed5i trong tr\u01b0\u1eddng h\u1ee3p th\u1eddi gian t\u00ednh kh\u00f4ng c\u1ee5 th\u1ec3\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-16.jpg\" alt=\"tinh-tuoi-trong-excel-16\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-16-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-16-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>B\u01b0\u1edbc 2: Nh\u1ea5n ch\u1ecdn n\u00fat Enter \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3 v\u00e0 ki\u1ec3m tra. \u0110\u1ec3 thao t\u00e1c cho nh\u1eefng \u00f4 c\u00f2n l\u1ea1i, b\u1ea1n \u0111\u1eb7t con tr\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi c\u00f9ng c\u1ee7a \u00f4 v\u1eeba t\u00ednh, khi xu\u1ea5t hi\u1ec7n l\u00ean d\u1ea5u &#8220;+&#8221;, b\u1ea1n gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o xu\u1ed1ng l\u00e0 ho\u00e0n t\u1ea5t.<\/p>\n<h3>C\u00e1ch t\u00ecm ng\u00e0y \u0111\u1ec3 m\u1ed9t ng\u01b0\u1eddi \u0111\u1ea1t \u0111\u01b0\u1ee3c m\u1ed9t \u0111\u1ed9 tu\u1ed5i nh\u1ea5t \u0111\u1ecbnh<\/h3>\n<p>B\u00ean c\u1ea1nh nh\u1eefng h\u00e0m t\u00ednh tu\u1ed5i \u1edf tr\u00ean, Ho\u00e0ng H\u00e0 Mobile s\u1ebb ch\u1ec9 b\u1ea1n c\u00e1ch l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ecm th\u1eddi \u0111i\u1ec3m c\u1ee5 th\u1ec3 \u0111\u1ec3 m\u1ed9t ng\u01b0\u1eddi \u0111\u1ea1t m\u1ed9t \u0111\u1ed9 tu\u1ed5i x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc. \u0110\u00e2y s\u1ebd l\u00e0 c\u00e2u tr\u1ea3 l\u1eddi cho c\u00e2u h\u1ecfi m\u1ed9t ng\u01b0\u1eddi sinh v\u00e0o 15\/5\/1075 th\u00ec khi ng\u01b0\u1eddi \u0111\u00f3 60 tu\u1ed5i s\u1ebd r\u01a1i tr\u00fang v\u00e0o ng\u00e0y n\u00e0o.<\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y s\u1ebd l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ednh v\u1edbi m\u1ed9t tr\u01b0\u1eddng h\u1ee3p gi\u1ea3 \u0111\u1ecbnh, c\u00f3 s\u1eb5n, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o v\u00e0 thao t\u00e1c tr\u00ean Excel c\u1ee7a b\u1ea1n:<\/p>\n<p>B\u01b0\u1edbc 1: Nh\u1eadp v\u00e0o \u00f4 c\u1ea7n t\u00ednh h\u00e0m sau \u0111\u00e2y: <strong>=DATE(YEAR(B2) + 60; MONTH(B2); DAY(B2))<\/strong>.<\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li>YEAR(B2) + 60: L\u00e0 n\u0103m sinh c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ed9ng th\u00eam \u0111\u1ec3 60 \u0111\u1ec3 \u0111\u1ea1t 60 tu\u1ed5i.<\/li>\n<li>MONTH(B2): L\u00e0 th\u00e1ng sinh c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng.<\/li>\n<li>DAY(B2): L\u00e0 ng\u00e0y sinh c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng.<\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-17-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-17-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-268465 size-full webpexpress-processed\" title=\"C\u00e1ch t\u00ecm ng\u00e0y \u0111\u1ec3 m\u1ed9t ng\u01b0\u1eddi \u0111\u1ea1t \u0111\u01b0\u1ee3c m\u1ed9t \u0111\u1ed9 tu\u1ed5i nh\u1ea5t \u0111\u1ecbnh\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-17.jpg\" alt=\"tinh-tuoi-trong-excel-17\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-17-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-17-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>B\u01b0\u1edbc 2: Nh\u1ea5n n\u00fat Enter v\u00e0 ki\u1ec3m tra l\u1ea1i k\u1ebft qu\u1ea3.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-18-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-18-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-268466 size-full webpexpress-processed\" title=\"C\u00e1ch t\u00ecm ng\u00e0y \u0111\u1ec3 m\u1ed9t ng\u01b0\u1eddi \u0111\u1ea1t \u0111\u01b0\u1ee3c m\u1ed9t \u0111\u1ed9 tu\u1ed5i nh\u1ea5t \u0111\u1ecbnh\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-18.jpg\" alt=\"tinh-tuoi-trong-excel-18\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-18-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-18-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3>C\u00e1ch t\u00ednh tu\u1ed5i khi c\u00f3 ng\u00e0y, th\u00e1ng, n\u0103m sinh \u1edf nh\u1eefng \u00f4 kh\u00e1c nhau<\/h3>\n<p>\u1ede tr\u01b0\u1eddng h\u1ee3p n\u00e0y, khi nh\u1eadp v\u00e0o b\u1ea3ng t\u00ednh Excel, c\u00e1c gi\u00e1 tr\u1ecb ng\u00e0y, th\u00e1ng, n\u0103m sinh c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o t\u1eebng \u00f4 kh\u00e1c nhau ri\u00eang bi\u1ec7t. Do \u0111\u00f3, \u0111\u1ec3 t\u00ednh tu\u1ed5i, c\u1ea7n ph\u1ea3i k\u1ebft h\u1ee3p s\u1eed d\u1ee5ng c\u1ea3 hai h\u00e0m <strong>DATEVALUE<\/strong> v\u00e0 <strong>DATE.<\/strong><\/p>\n<p>B\u01b0\u1edbc 1: Nh\u1eadp v\u00e0o \u00f4 c\u1ea7n t\u00ecm c\u00e1c h\u00e0m \u0111\u1ec3 t\u00ednh ng\u00e0y, th\u00e1ng, n\u0103m d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<ul>\n<li>H\u00e0m t\u00ednh ng\u00e0y: =DATEDIF(DATE(B2;MONTH(DATEVALUE(C2&amp;\u201d1\u2033));D2);TODAY();\u201dMD\u201d) &amp; &#8220;Day; \u201c<\/li>\n<li>H\u00e0m t\u00ednh th\u00e1ng: =DATEDIF(DATE(B2;MONTH(DATEVALUE(C2&amp;\u201d1\u2033));D2);TODAY();\u201dYM\u201d) &amp; \u201cMonth, \u201c<\/li>\n<li>H\u00e0m t\u00ednh n\u0103m: =DATEDIF(DATE(B2;MONTH(DATEVALUE(C2&amp;\u201d1\u2033));D2);TODAY();\u201dY\u201d) &amp; \u201cYear.&#8221;<\/li>\n<\/ul>\n<p>B\u01b0\u1edbc 2: \u0110\u1ec3 k\u1ebft h\u1ee3p c\u00e1c h\u00e0m \u1edf tr\u00ean, s\u1eed d\u1ee5ng d\u1ea5u &#8220;&amp;&#8221; s\u1ebd t\u1ea1o th\u00e0nh m\u1ed9t c\u00f4ng th\u1ee9c tr\u1ecdn v\u1eb9n.<\/p>\n<p>B\u01b0\u1edbc 3: Nh\u1ea5n Enter \u0111\u1ec3 nh\u1eadn v\u1ec1 k\u1ebft qu\u1ea3 v\u00e0 ki\u1ec3m tra.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-19-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/tinh-tuoi-trong-excel-19-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-268467 size-full webpexpress-processed\" title=\"C\u00e1ch t\u00ednh tu\u1ed5i khi c\u00f3 ng\u00e0y, th\u00e1ng, n\u0103m sinh \u1edf nh\u1eefng \u00f4 kh\u00e1c nhau\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-19.jpg\" alt=\"tinh-tuoi-trong-excel-19\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-19-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel-19-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><strong>T\u1ed5ng k\u1ebft<\/strong><\/h2>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 t\u1ed5ng h\u1ee3p 8 c\u00e1ch c\u00f9ng h\u01b0\u1edbng d\u1eabn minh h\u1ecda l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 <strong>t\u00ednh tu\u1ed5i trong Excel<\/strong> c\u1ef1c nhanh ch\u00f3ng, chu\u1ea9n x\u00e1c v\u00e0 \u0111\u01a1n gi\u1ea3n. Hy v\u1ecdng, v\u1edbi th\u1ee7 thu\u1eadt m\u00e0 Ho\u00e0ng H\u00e0 Mobile chia s\u1ebb tr\u00ean \u0111\u00e2y, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 thao t\u00e1c cho nh\u1eefng y\u00eau c\u1ea7u trong c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp c\u1ee7a b\u1ea1n. N\u1ebfu b\u1ea1n th\u1ea5y b\u00e0i vi\u1ebft hay, \u0111\u1eebng ng\u1ea7n ng\u1ea1i theo d\u00f5i <a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/\" target=\"_blank\" rel=\"noopener\"><strong>Trang Tin T\u1ee9c &#8211; Ho\u00e0ng H\u00e0 Mobile<\/strong><\/a> \u0111\u1ec3 c\u1eadp nh\u1eadt nhanh nh\u1ea5t nh\u1eefng b\u00e0i vi\u1ebft th\u00fa v\u1ecb, h\u1ea5p d\u1eabn \u0111\u1ebfn t\u1eeb Ho\u00e0ng H\u00e0 Mobile nh\u00e9!<\/p>\n<p><em>M\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u1ebfn t\u1eeb Ho\u00e0ng H\u00e0 Mobile m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o:<\/em><\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/doi-so-thanh-chu\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch \u0111\u1ed5i s\u1ed1 th\u00e0nh ch\u1eef trong Excel c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/chuyen-file-excel-sang-word\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch chuy\u1ec3n file Excel sang Word \u0111\u01a1n gi\u1ea3n, d\u1ec5 hi\u1ec3u<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lap-lai-tieu-de-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch l\u1eb7p l\u1ea1i ti\u00eau \u0111\u1ec1 trong Excel ti\u1ec7n l\u1ee3i ai c\u0169ng n\u00ean bi\u1ebft<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Excel l\u00e0 m\u1ed9t trong nh\u1eefng \u1ee9ng d\u1ee5ng tin h\u1ecdc v\u0103n ph\u00f2ng c\u1ef1c k\u1ef3 h\u1eefu \u00edch trong c\u00f4ng vi\u1ec7c v\u00e0 cu\u1ed9c s\u1ed1ng. V\u1edbi ph\u1ea7n m\u1ec1m n\u00e0y, b\u1ea1n s\u1ebd ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u th\u1eddi gian nh\u1edd nh\u1eefng t\u00ednh n\u0103ng c\u1ee7a c\u00f4ng c\u1ee5 n\u00e0y. Trong \u0111\u00f3 qu\u00e1 tr\u00ecnh h\u1ecdc t\u1eadp, l\u00e0m vi\u1ec7c, nhi\u1ec1u y\u00eau c\u1ea7u \u0111\u00f2i h\u1ecfi [&hellip;]<\/p>\n","protected":false},"author":72,"featured_media":268447,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-268384","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Minh h\u1ecda 8 c\u00e1ch t\u00ednh tu\u1ed5i trong Excel nhanh ch\u00f3ng, ch\u00ednh x\u00e1c<\/title>\n<meta name=\"description\" content=\"Trong \u0111\u00f3 h\u1ecdc t\u1eadp, l\u00e0m vi\u1ec7c, nhi\u1ec1u l\u00fac c\u1ea7n ph\u1ea3i t\u00ednh tu\u1ed5i c\u1ee7a m\u1ed9t ho\u1eb7c m\u1ed9t nh\u00f3m ng\u01b0\u1eddi. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Minh h\u1ecda 8 c\u00e1ch t\u00ednh tu\u1ed5i trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n, ch\u00ednh x\u00e1c\" \/>\n<meta property=\"og:description\" content=\"Trong \u0111\u00f3 h\u1ecdc t\u1eadp, l\u00e0m vi\u1ec7c, nhi\u1ec1u l\u00fac c\u1ea7n ph\u1ea3i t\u00ednh tu\u1ed5i c\u1ee7a m\u1ed9t ho\u1eb7c m\u1ed9t nh\u00f3m ng\u01b0\u1eddi. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-06T06:04:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Viet Cuong\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Viet Cuong\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/\"},\"author\":{\"name\":\"Viet Cuong\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/193f117c86913fb9ff22647e2a512291\"},\"headline\":\"Minh h\u1ecda 8 c\u00e1ch t\u00ednh tu\u1ed5i trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n, ch\u00ednh x\u00e1c\",\"datePublished\":\"2023-10-06T06:04:12+00:00\",\"dateModified\":\"2023-10-06T06:04:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/\"},\"wordCount\":3315,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/\",\"name\":\"Minh h\u1ecda 8 c\u00e1ch t\u00ednh tu\u1ed5i trong Excel nhanh ch\u00f3ng, ch\u00ednh x\u00e1c\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel.jpg\",\"datePublished\":\"2023-10-06T06:04:12+00:00\",\"dateModified\":\"2023-10-06T06:04:12+00:00\",\"description\":\"Trong \u0111\u00f3 h\u1ecdc t\u1eadp, l\u00e0m vi\u1ec7c, nhi\u1ec1u l\u00fac c\u1ea7n ph\u1ea3i t\u00ednh tu\u1ed5i c\u1ee7a m\u1ed9t ho\u1eb7c m\u1ed9t nh\u00f3m ng\u01b0\u1eddi. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel?\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"tinh-tuoi-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Minh h\u1ecda 8 c\u00e1ch t\u00ednh tu\u1ed5i trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n, ch\u00ednh x\u00e1c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/193f117c86913fb9ff22647e2a512291\",\"name\":\"Viet Cuong\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/07bcf1249c15161e59a7fb9d39237905?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/07bcf1249c15161e59a7fb9d39237905?s=96&d=mm&r=g\",\"caption\":\"Viet Cuong\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/viet-cuong\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Minh h\u1ecda 8 c\u00e1ch t\u00ednh tu\u1ed5i trong Excel nhanh ch\u00f3ng, ch\u00ednh x\u00e1c","description":"Trong \u0111\u00f3 h\u1ecdc t\u1eadp, l\u00e0m vi\u1ec7c, nhi\u1ec1u l\u00fac c\u1ea7n ph\u1ea3i t\u00ednh tu\u1ed5i c\u1ee7a m\u1ed9t ho\u1eb7c m\u1ed9t nh\u00f3m ng\u01b0\u1eddi. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"Minh h\u1ecda 8 c\u00e1ch t\u00ednh tu\u1ed5i trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n, ch\u00ednh x\u00e1c","og_description":"Trong \u0111\u00f3 h\u1ecdc t\u1eadp, l\u00e0m vi\u1ec7c, nhi\u1ec1u l\u00fac c\u1ea7n ph\u1ea3i t\u00ednh tu\u1ed5i c\u1ee7a m\u1ed9t ho\u1eb7c m\u1ed9t nh\u00f3m ng\u01b0\u1eddi. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel?","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-10-06T06:04:12+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel.jpg","type":"image\/jpeg"}],"author":"Viet Cuong","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Viet Cuong","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"16 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/"},"author":{"name":"Viet Cuong","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/193f117c86913fb9ff22647e2a512291"},"headline":"Minh h\u1ecda 8 c\u00e1ch t\u00ednh tu\u1ed5i trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n, ch\u00ednh x\u00e1c","datePublished":"2023-10-06T06:04:12+00:00","dateModified":"2023-10-06T06:04:12+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/"},"wordCount":3315,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/","name":"Minh h\u1ecda 8 c\u00e1ch t\u00ednh tu\u1ed5i trong Excel nhanh ch\u00f3ng, ch\u00ednh x\u00e1c","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel.jpg","datePublished":"2023-10-06T06:04:12+00:00","dateModified":"2023-10-06T06:04:12+00:00","description":"Trong \u0111\u00f3 h\u1ecdc t\u1eadp, l\u00e0m vi\u1ec7c, nhi\u1ec1u l\u00fac c\u1ea7n ph\u1ea3i t\u00ednh tu\u1ed5i c\u1ee7a m\u1ed9t ho\u1eb7c m\u1ed9t nh\u00f3m ng\u01b0\u1eddi. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh tu\u1ed5i trong Excel?","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/tinh-tuoi-trong-excel.jpg","width":1200,"height":628,"caption":"tinh-tuoi-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-tuoi-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"Minh h\u1ecda 8 c\u00e1ch t\u00ednh tu\u1ed5i trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n, ch\u00ednh x\u00e1c"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/193f117c86913fb9ff22647e2a512291","name":"Viet Cuong","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/07bcf1249c15161e59a7fb9d39237905?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/07bcf1249c15161e59a7fb9d39237905?s=96&d=mm&r=g","caption":"Viet Cuong"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/viet-cuong\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/268384","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/72"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=268384"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/268384\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/268447"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=268384"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=268384"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=268384"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}