{"id":8696,"date":"2024-12-25T01:44:07","date_gmt":"2024-12-25T01:44:07","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/25\/huong-dan-chuyen-doi-ngay-sinh-thanh-tuoi-trong-excel\/"},"modified":"2024-12-25T01:44:07","modified_gmt":"2024-12-25T01:44:07","slug":"huong-dan-chuyen-doi-ngay-sinh-thanh-tuoi-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/25\/huong-dan-chuyen-doi-ngay-sinh-thanh-tuoi-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn chuy\u1ec3n \u0111\u1ed5i ng\u00e0y sinh th\u00e0nh tu\u1ed5i trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh to\u00e1n tu\u1ed5i c\u1ee7a m\u1ed9t ng\u01b0\u1eddi khi bi\u1ebft \u0111\u01b0\u1ee3c ng\u00e0y th\u00e1ng n\u0103m sinh c\u1ee7a h\u1ecd? Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1ch chuy\u1ec3n \u0111\u1ed5i ng\u00e0y sinh th\u00e0nh tu\u1ed5i trong Excel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27225\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chuyen-ngay-thang-nam-thanh-tuoi-1.png\" width=\"331\" height=\"203\" title=\"chuyen-ngay-thang-nam-thanh-tuoi-1\"><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-676b63669d6ed\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/chuyen-doi-ngay-sinh-thanh-tuoi-trong-excel.html#Su_dung_DATEDIF_tinh_chenh_lech_giua_2_ngay\" title=\"S\u1eed d\u1ee5ng DATEDIF t\u00ednh ch\u00eanh l\u1ec7ch\u00a0gi\u1eefa 2 ng\u00e0y\">S\u1eed d\u1ee5ng DATEDIF t\u00ednh ch\u00eanh l\u1ec7ch\u00a0gi\u1eefa 2 ng\u00e0y<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/chuyen-doi-ngay-sinh-thanh-tuoi-trong-excel.html#Su_dung_phep_tru\" title=\"S\u1eed d\u1ee5ng ph\u00e9p tr\u1eeb\">S\u1eed d\u1ee5ng ph\u00e9p tr\u1eeb<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/chuyen-doi-ngay-sinh-thanh-tuoi-trong-excel.html#Ket_hop_ROUNDDOWN_va_YEARFRAC\" title=\"K\u1ebft h\u1ee3p ROUNDDOWN v\u00e0 YEARFRAC\">K\u1ebft h\u1ee3p ROUNDDOWN v\u00e0 YEARFRAC<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/chuyen-doi-ngay-sinh-thanh-tuoi-trong-excel.html#Su_dung_DATEDIF_chuyen_doi_ngay_sinh_thanh_tuoi_chinh_xac\" title=\"S\u1eed d\u1ee5ng DATEDIF chuy\u1ec3n \u0111\u1ed5i ng\u00e0y sinh th\u00e0nh tu\u1ed5i ch\u00ednh x\u00e1c\">S\u1eed d\u1ee5ng DATEDIF chuy\u1ec3n \u0111\u1ed5i ng\u00e0y sinh th\u00e0nh tu\u1ed5i ch\u00ednh x\u00e1c<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_DATEDIF_tinh_chenh_lech_giua_2_ngay\"><\/span>S\u1eed d\u1ee5ng DATEDIF t\u00ednh ch\u00eanh l\u1ec7ch\u00a0gi\u1eefa 2 ng\u00e0y<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m DATEDIF c\u00f3 c\u00fa ph\u00e1p nh\u01b0 sau:<\/p>\n<p><strong>=DATEDIF(ng\u00e0y b\u1eaft \u0111\u1ea7u, ng\u00e0y k\u1ebft th\u00fac, \u0111\u01a1n v\u1ecb)<\/strong><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<p><strong>ng\u00e0y b\u1eaft \u0111\u1ea7u:\u00a0<\/strong>ng\u00e0y b\u1eaft \u0111\u1ea7u c\u1ea7n t\u00ednh to\u00e1n<\/p>\n<p><strong>ng\u00e0y k\u1ebft th\u00fac:<\/strong> ng\u00e0y k\u1ebft th\u00fac vi\u1ec7c t\u00ednh to\u00e1n, c\u1ea7n l\u1edbn h\u01a1n ng\u00e0y b\u1eaft \u0111\u1ea7u<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-809.gif\" title=\"ex101_92019-nho-809\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>\u0111\u01a1n v\u1ecb:<\/strong>lo\u1ea1i k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a vi\u1ec7c t\u00ednh to\u00e1n (vi\u1ebft trong d\u1ea5u ngo\u1eb7c k\u00e9p \u201c\u201d)<\/p>\n<p>C\u00e1c \u0111\u01a1n v\u1ecb c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng:<\/p>\n<p><strong>y:<\/strong> tr\u1ea3 v\u1ec1 s\u1ed1 n\u0103m ch\u00eanh l\u1ec7ch<\/p>\n<p><strong>m:<\/strong> tr\u1ea3 v\u1ec1 s\u1ed1 th\u00e1ng ch\u00eanh l\u1ec7ch<\/p>\n<p><strong>d:<\/strong> tr\u1ea3 v\u1ec1 s\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch<\/p>\n<p><strong>md:<\/strong>\u00a0tr\u1ea3 v\u1ec1 s\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch kh\u00f4ng t\u00ednh n\u0103m &amp; th\u00e1ng<\/p>\n<p><strong>ym:<\/strong> tr\u1ea3 v\u1ec1 s\u1ed1 th\u00e1ng ch\u00eanh l\u1ec7ch kh\u00f4ng t\u00ednh n\u0103m &amp; ng\u00e0y<\/p>\n<p><strong>yd:\u00a0<\/strong>tr\u1ea3 v\u1ec1 s\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch kh\u00f4ng t\u00ednh n\u0103m<\/p>\n<p>Ta s\u1ebd s\u1eed d\u1ee5ng DATEDIF \u0111\u1ec3 t\u00ednh tu\u1ed5i nh\u01b0 sau:<\/p>\n<p><strong>=DATEDIF(B3,NOW(),\u201dy\u201d)<\/strong><\/p>\n<p>Sau \u0111\u00f3 s\u1eed d\u1ee5ng AutoFill cho nh\u1eefng \u00f4 c\u00f2n l\u1ea1i. Ta \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27226\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chuyen-ngay-thang-nam-thanh-tuoi-2.png\" width=\"433\" height=\"253\" title=\"chuyen-ngay-thang-nam-thanh-tuoi-2\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_phep_tru\"><\/span>S\u1eed d\u1ee5ng ph\u00e9p tr\u1eeb<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng, ta c\u00f3 th\u1ec3 t\u00ednh tu\u1ed5i b\u1eb1ng c\u00e1ch l\u1ea5y hi\u1ec7n t\u1ea1i tr\u1eeb \u0111i ng\u00e0y sinh, sau \u0111\u00f3 chia cho 365. S\u1eed d\u1ee5ng h\u00e0m QUOTIENT l\u1ea5y ra ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia:<\/p>\n<p><strong>=QUOTIENT(NOW()-B3,365)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27228\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chuyen-ngay-thang-nam-thanh-tuoi-3.png\" width=\"433\" height=\"252\" title=\"chuyen-ngay-thang-nam-thanh-tuoi-3\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ket_hop_ROUNDDOWN_va_YEARFRAC\"><\/span>K\u1ebft h\u1ee3p ROUNDDOWN v\u00e0 YEARFRAC<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m\u00a0<strong>YEARFRAC<\/strong> s\u1ebd hi\u1ec3n th\u1ecb ch\u00ednh x\u00e1c s\u1ed1 ng\u00e0y gi\u1eefa 2 d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m, h\u00e0m\u00a0<strong>ROUNDDOWN\u00a0<\/strong>s\u1ebd l\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 ti\u1ebfn v\u1ec1 0.<\/p>\n<p>C\u00f4ng th\u1ee9c ta \u00e1p d\u1ee5ng c\u1ee5 th\u1ec3 trong b\u00e0i:<\/p>\n<p><strong>=ROUNDDOWN(YEARFRAC(B3,NOW(),1),0)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27229\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chuyen-ngay-thang-nam-thanh-tuoi-4.png\" width=\"534\" height=\"251\" title=\"chuyen-ngay-thang-nam-thanh-tuoi-4\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_DATEDIF_chuyen_doi_ngay_sinh_thanh_tuoi_chinh_xac\"><\/span>S\u1eed d\u1ee5ng DATEDIF chuy\u1ec3n \u0111\u1ed5i ng\u00e0y sinh th\u00e0nh tu\u1ed5i ch\u00ednh x\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u1ede ph\u1ea7n \u0111\u1ea7u ti\u00ean, ch\u00fang ta \u0111\u00e3 s\u1eed d\u1ee5ng\u00a0<strong>DATEDIF<\/strong> \u0111\u1ec3 t\u00ednh tu\u1ed5i. Ti\u1ebfp t\u1ee5c, v\u1edbi DATEDIF ta c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb ch\u00ednh x\u00e1c s\u1ed1 ng\u00e0y, th\u00e1ng, n\u0103m c\u1ee7a m\u1ed9t ng\u01b0\u1eddi v\u1edbi c\u00f4ng th\u1ee9c sau:<\/p>\n<p><strong>=DATEDIF(B3,TODAY(),\u201dY\u201d) &amp; \u201d N\u0103m, \u201d &amp; DATEDIF(B3,TODAY(),\u201dYM\u201d) &amp; \u201d Th\u00e1ng, \u201d &amp; DATEDIF(B3,TODAY(),\u201dMD\u201d) &amp; \u201d Ng\u00e0y\u201d<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-27230\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chuyen-ngay-thang-nam-thanh-tuoi-5-1024x270-1.png\" width=\"1024\" height=\"270\" title=\"chuyen-ngay-thang-nam-thanh-tuoi-5-1024x270-1\"><\/p>\n<hr>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft kh\u00e1c c\u00f9ng ch\u1ee7 \u0111\u1ec1 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tinh-khoang-thoi-gian-giua-2-thoi-diem-ham-datedif-trong-excel.html\"><strong>S\u1eed d\u1ee5ng DATEDIF c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tinh-nam-bang-ham-yearfrac.html\"><strong>T\u00ednh s\u1ed1 n\u0103m b\u1eb1ng h\u00e0m YEARFRAC<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-tim-phan-nguyen-cua-phep-chia-voi-ham-quotient-va-ham-int.html\"><strong>T\u00ecm ph\u1ea7n nguy\u00ean ph\u00e9p chia b\u1eb1ng QUOTIENT v\u00e0 INT<\/strong><\/a><\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-809.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8697,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8696","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8696","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=8696"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8696\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8697"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}