{"id":12008,"date":"2025-01-15T06:31:17","date_gmt":"2025-01-15T06:31:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-cac-cach-tinh-tuoi-tu-ngay-sinh-trong-excel\/"},"modified":"2025-01-15T06:31:17","modified_gmt":"2025-01-15T06:31:17","slug":"huong-dan-cac-cach-tinh-tuoi-tu-ngay-sinh-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-cac-cach-tinh-tuoi-tu-ngay-sinh-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch t\u00ednh tu\u1ed5i t\u1eeb ng\u00e0y sinh trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y,<a href=\"http:\/\/blog.ezworkapp.com\/\"><strong> H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u00fap b\u1ea1n t\u00ednh tu\u1ed5i t\u1eeb ng\u00e0y sinh trong Excel. B\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u1ecdc c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh tu\u1ed5i d\u1ef1a v\u00e0o ng\u00e0y sinh c\u0169ng nh\u01b0 bi\u1ebft \u0111\u01b0\u1ee3c tu\u1ed5i ch\u00ednh x\u00e1c theo ng\u00e0y, th\u00e1ng, n\u0103m t\u00ednh \u0111\u1ebfn ng\u00e0y h\u00f4m nay ho\u1eb7c 1 ng\u00e0y kh\u00e1c giu\u0301p ba\u0323n co\u0301 th\u00ea\u0309 t\u01b0\u0323 ho\u0323c excel v\u0103n pho\u0300ng ta\u0323i nha\u0300 m\u00f4\u0323t ca\u0301ch hi\u00ea\u0323u qua\u0309 nh\u00e2\u0301t.<\/em><\/p>\n<p>Tuy kh\u00f4ng c\u00f3 1 h\u00e0m \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 t\u00ednh tu\u1ed5i, nh\u01b0ng c\u00f3 nhi\u1ec1u c\u00e1ch kh\u00e1c nhau \u0111\u1ec3 th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u. B\u00e0i vi\u1ebft s\u1ebd gi\u1ea3i th\u00edch \u01b0u, khuy\u1ebft \u0111i\u1ec3m c\u1ee7a nh\u1eefng c\u00e1ch n\u00e0y, \u0111\u1ed3ng th\u1eddi \u0111\u01b0a ra ph\u01b0\u01a1ng \u00e1n t\u1ed1t nh\u1ea5t v\u00e0 c\u00e1ch \u1ee9ng d\u1ee5ng v\u00e0o c\u00e1c c\u00f4ng vi\u1ec7c c\u1ee5 th\u1ec3.<\/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-6787563217aa1\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cac-cach-tinh-tuoi-tu-ngay-sinh-trong-excel.html#_Tinh_tuoi_trong_Excel_theo_nam_tron\" title=\"\u00a0Ti\u0301nh tu\u00f4\u0309i trong Excel (theo n\u0103m tro\u0300n)\">\u00a0Ti\u0301nh tu\u00f4\u0309i trong Excel (theo n\u0103m tro\u0300n)<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cac-cach-tinh-tuoi-tu-ngay-sinh-trong-excel.html#Cong_thuc_Excel_don_gian_de_tinh_so_nam_tuoi\" title=\"C\u00f4ng th\u01b0\u0301c Excel \u0111\u01a1n gia\u0309n \u0111\u00ea\u0309 ti\u0301nh s\u00f4\u0301 n\u0103m tu\u00f4\u0309i:\">C\u00f4ng th\u01b0\u0301c Excel \u0111\u01a1n gia\u0309n \u0111\u00ea\u0309 ti\u0301nh s\u00f4\u0301 n\u0103m tu\u00f4\u0309i:<\/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\/cac-cach-tinh-tuoi-tu-ngay-sinh-trong-excel.html#TINH_TUOI_VOI_HAM_YEARFRAC\" title=\"T\u00cdNH TU\u1ed4I V\u1edaI H\u00c0M YEARFRAC:\">T\u00cdNH TU\u1ed4I V\u1edaI H\u00c0M 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\/cac-cach-tinh-tuoi-tu-ngay-sinh-trong-excel.html#TINH_TUOI_TRONG_EXCEL_VOI_HAM_DATEIF\" title=\"T\u00cdNH TU\u1ed4I TRONG EXCEL V\u1edaI H\u00c0M DATEIF:\">T\u00cdNH TU\u1ed4I TRONG EXCEL V\u1edaI H\u00c0M DATEIF:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cac-cach-tinh-tuoi-tu-ngay-sinh-trong-excel.html#CACH_TINH_TUOI_RA_NGAY_THANG_NAM_CHINH_XAC\" title=\"C\u00c1CH T\u00cdNH TU\u1ed4I RA NG\u00c0Y TH\u00c1NG N\u0102M CH\u00cdNH X\u00c1C:\">C\u00c1CH T\u00cdNH TU\u1ed4I RA NG\u00c0Y TH\u00c1NG N\u0102M CH\u00cdNH X\u00c1C:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cac-cach-tinh-tuoi-tu-ngay-sinh-trong-excel.html#THOI_GIAN_TINH_TUOI_KHONG_CU_THE\" title=\"TH\u1edcI GIAN T\u00cdNH TU\u1ed4I KH\u00d4NG C\u1ee4 TH\u1ec2:\">TH\u1edcI GIAN T\u00cdNH TU\u1ed4I KH\u00d4NG C\u1ee4 TH\u1ec2:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cac-cach-tinh-tuoi-tu-ngay-sinh-trong-excel.html#TIM_NGAY_KHI_1_NGUOI_DAT_BAO_NHIEU_TUOI\" title=\"T\u00ccM NG\u00c0Y KHI 1 NG\u01af\u1edcI \u0110\u1ea0T BAO NHI\u00caU TU\u1ed4I:\">T\u00ccM NG\u00c0Y KHI 1 NG\u01af\u1edcI \u0110\u1ea0T BAO NHI\u00caU TU\u1ed4I:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cac-cach-tinh-tuoi-tu-ngay-sinh-trong-excel.html#TINH_TUOI_VOI_NGAY_THANG_NAM_SINH_O_CAC_O_KHAC_NHAU\" title=\"T\u00cdNH TU\u1ed4I V\u1edaI NG\u00c0Y, TH\u00c1NG, N\u0102M SINH \u1ede C\u00c1C \u00d4 KH\u00c1C NHAU:\">T\u00cdNH TU\u1ed4I V\u1edaI NG\u00c0Y, TH\u00c1NG, N\u0102M SINH \u1ede C\u00c1C \u00d4 KH\u00c1C NHAU:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cac-cach-tinh-tuoi-tu-ngay-sinh-trong-excel.html#DANH_DAU_TUOI\" title=\"\u0110\u00c1NH D\u1ea4U TU\u1ed4I :\">\u0110\u00c1NH D\u1ea4U TU\u1ed4I :<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"_Tinh_tuoi_trong_Excel_theo_nam_tron\"><\/span><strong>\u00a0Ti\u0301nh tu\u00f4\u0309i trong Excel (theo n\u0103m tro\u0300n)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong cu\u1ed9c s\u1ed1ng h\u1eb1ng ng\u00e0y, c\u00e2u h\u1ecfi \u201cB\u1ea1n bao nhi\u00eau tu\u1ed5i?\u201d \u00e1m ch\u1ec9 s\u1ed1 n\u0103m b\u1ea1n \u0111\u00e3 s\u1ed1ng tr\u00ean \u0111\u1eddi. Nh\u01b0ng v\u1edbi Excel, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh ch\u00ednh x\u00e1c s\u1ed1 tu\u1ed5i ra ng\u00e0y, th\u00e1ng, n\u0103m, th\u1eadm ch\u00ed l\u00e0 gi\u1edd, ph\u00fat. Nh\u01b0ng ch\u00fang ta s\u1ebd theo c\u00e1ch truy\u1ec1n th\u1ed1ng, t\u00ednh tu\u1ed5i ra s\u1ed1 n\u0103m tr\u01b0\u1edbc.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_Excel_don_gian_de_tinh_so_nam_tuoi\"><\/span><strong>C\u00f4ng th\u01b0\u0301c Excel \u0111\u01a1n gia\u0309n \u0111\u00ea\u0309 ti\u0301nh s\u00f4\u0301 n\u0103m tu\u00f4\u0309i:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u00ecnh th\u01b0\u1eddng, b\u1ea1n t\u00ednh s\u1ed1 tu\u1ed5i nh\u01b0 th\u1ebf n\u00e0o? \u0110\u01a1n gi\u1ea3n l\u00e0 tr\u1eeb n\u0103m hi\u1ec7n t\u1ea1i cho n\u0103m sinh. C\u00f4ng th\u1ee9c n\u00e0y c\u0169ng d\u00f9ng cho Excel.<\/p>\n<p>Gi\u1ea3 s\u1eed ng\u00e0y th\u00e1ng n\u0103m sinh \u1edf \u00f4 B2, c\u00f4ng th\u1ee9c t\u00ednh tu\u1ed5i nh\u01b0 sau:<\/p>\n<p><strong>=(TODAY()-B2)\/365<\/strong><\/p>\n<p>Ph\u1ea7n \u0111\u1ea7u c\u1ee7a c\u00f4ng th\u1ee9c <strong>(TODAY()-B2)<\/strong> tr\u1ea3 hi\u1ec7u gi\u1eefa ng\u00e0y th\u00e1ng n\u0103m hi\u1ec7n t\u1ea1i v\u00e0 ng\u00e0y th\u00e1ng n\u0103m sinh, r\u1ed3i b\u1ea1n chia con s\u1ed1 cho 365 \u0111\u1ec3 c\u00f3 s\u1ed1 n\u0103m tu\u1ed5i.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-69.gif\" title=\"vba101_92019-nho-69\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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\/2025\/01\/ex101_92019-nho-343.gif\" title=\"ex101_92019-nho-343\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>C\u00f4ng th\u1ee9c tr\u00ean r\u1ea5t r\u00f5 r\u00e0ng v\u00e0 d\u1ec5 nh\u1edb, tuy nhi\u00ean, c\u00f3 1 v\u1ea5n \u0111\u1ec1 nh\u1ecf. V\u1edbi ph\u1ea7n l\u1edbn tr\u01b0\u1eddng h\u1ee3p, n\u00f3 s\u1ebd tr\u1ea3 k\u1ebft qu\u1ea3 d\u1ea1ng th\u1eadp ph\u00e2n nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4902 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/age-calculation-formula.png\" width=\"276\" height=\"185\" title=\"age-calculation-formula\"><\/p>\n<p>\u0110\u1ec3 th\u1ec3 hi\u1ec7n k\u1ebft qu\u1ea3 ra n\u0103m tr\u00f2n, d\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-int-ham-lay-phan-nguyen-trong-excel.html\"><strong>h\u00e0m INT<\/strong> <\/a>\u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n.<\/p>\n<p><strong>=INT((TODAY()-B2)\/365)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4911 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-formula-age-years.png\" width=\"301\" height=\"181\" title=\"excel-formula-age-years\"><\/p>\n<p><strong>H\u1ea1n ch\u1ebf:<\/strong><\/p>\n<p>D\u00f9ng c\u00f4ng th\u1ee9c n\u00e0y trong Excel cho ra k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u0111\u1ed1i ch\u00ednh x\u00e1c, nh\u01b0ng kh\u00f4ng ph\u1ea3i kh\u00f4ng sai. Chia cho s\u1ed1 ng\u00e0y trung b\u00ecnh trong 1 n\u0103m \u0111\u00fang trong h\u1ea7u h\u1ebft m\u1ecdi tr\u01b0\u1eddng h\u1ee3p, nh\u01b0ng \u0111\u00f4i khi cho ra k\u1ebft qu\u1ea3 sai. V\u00ed d\u1ee5, n\u1ebfu c\u00f3 ng\u01b0\u1eddi sinh ng\u00e0y 29\/2 v\u00e0 h\u00f4m nay l\u00e0 28\/2, c\u00f4ng th\u1ee9c s\u1ebd khi\u1ebfn ng\u01b0\u1eddi \u0111\u00f3 gi\u00e0 h\u01a1n 1 tu\u1ed5i.<\/p>\n<p>Do \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 chia cho 365,25 thay v\u00ec 365 v\u00ec c\u1ee9 4 n\u0103m l\u1ea1i c\u00f3 1 n\u0103m nhu\u1eadn 366 ng\u00e0y. Tuy nhi\u00ean, c\u00e1ch n\u00e0y c\u0169ng ch\u01b0a ph\u1ea3i t\u1ed1t nh\u1ea5t. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n t\u00ednh tu\u1ed5i 1 em b\u00e9 ch\u01b0a s\u1ed1ng qua n\u0103m nhu\u1eadn, chia cho 365,25 s\u1ebd cho ra k\u1ebft qu\u1ea3 sai.<\/p>\n<blockquote>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-dien-ngay-thang-vao-excel-thong-tin-ngay-thang-hien-tai-tu-dong-dien-ngay-thang-vao-cot.html\">C\u00e1ch \u0111i\u1ec1n ng\u00e0y th\u00e1ng v\u00e0o Excel, th\u00eam th\u00f4ng tin ng\u00e0y th\u00e1ng hi\u1ec7n t\u1ea1i, t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n ng\u00e0y th\u00e1ng v\u00e0o c\u1ed9t<\/a><\/p>\n<\/blockquote>\n<p>T\u00f3m l\u1ea1i, l\u1ea5y ng\u00e0y th\u00e1ng n\u0103m sinh hi\u1ec7n t\u1ea1i tr\u1eeb \u0111i ng\u00e0y th\u00e1ng n\u0103m sinh \u0111\u00fang v\u1edbi cu\u1ed9c s\u1ed1ng b\u00ecnh th\u01b0\u1eddng, nh\u01b0ng g\u00e2y ra v\u1ea5n \u0111\u1ec1 trong Excel. \u1ede c\u00e1c ph\u1ea7n ti\u1ebfp theo, b\u1ea1n s\u1ebd h\u1ecdc c\u00e1c h\u00e0m \u0111\u1eb7c bi\u1ec7t gi\u00fap t\u00ednh tu\u1ed5i ch\u00ednh x\u00e1c v\u1edbi b\u1ea5t k\u00ec n\u0103m n\u00e0o.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"TINH_TUOI_VOI_HAM_YEARFRAC\"><\/span><strong>T\u00cdNH TU\u1ed4I V\u1edaI H\u00c0M YEARFRAC:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t c\u00e1ch t\u00ednh tu\u1ed5i \u0111\u00e1ng tin c\u1eady h\u01a1n trong Excel l\u00e0 d\u00f9ng h\u00e0m YEARFRAC.<\/p>\n<p>C\u00fa ph\u00e1p h\u00e0m YEARFRAC:<\/p>\n<p><strong>YEARFRAC(start_date, end_date, [basis])<\/strong><\/p>\n<p>Trong \u0111o\u0301:<\/p>\n<ul>\n<li>Start_date: Ng\u00e0y b\u1eaft \u0111\u1ea7u<\/li>\n<li>End_date: Ng\u00e0y k\u1ebft th\u00fac<\/li>\n<li>Basis: M\u1ed9t con s\u1ed1 quy \u0111\u1ecbnh ki\u1ec3u t\u00ednh<\/li>\n<li>\u0110\u1ec3 t\u00ednh tu\u1ed5i, th\u00eam th\u00f4ng tin sau v\u00e0o h\u00e0m:<\/li>\n<li>Start_date: Ng\u00e0y sinh<\/li>\n<li>End_date: Ng\u00e0y hi\u1ec7n t\u1ea1i<\/li>\n<li>Basis: 1 (y\u00eau c\u1ea7u Excel t\u00ednh theo s\u1ed1 ng\u00e0y th\u1ef1c t\u1ebf c\u1ee7a th\u00e1ng v\u00e0 s\u1ed1 ng\u00e0y th\u1ef1c t\u1ebf c\u1ee7a n\u0103m).<\/li>\n<\/ul>\n<p>T\u1eeb \u0111\u00f3, c\u00f3 th\u1ec3 suy ra c\u00f4ng th\u1ee9c t\u00ednh tu\u1ed5i nh\u01b0 sau:<\/p>\n<p><strong>YEARFRAC(date of birth, TODAY(), 1)<\/strong><\/p>\n<p>Gi\u1ea3 s\u1eed ng\u00e0y sinh \u1edf trong \u00f4 B2, k\u1ebft qu\u1ea3 s\u1ebd nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4912 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/calculate-age-yearfrac.png\" width=\"247\" height=\"180\" title=\"calculate-age-yearfrac\"><\/p>\n<p>Nh\u01b0 \u1edf trong v\u00ed d\u1ee5 tr\u01b0\u1edbc, k\u1ebft qu\u1ea3 h\u00e0m YEARFRAC l\u00e0 s\u1ed1 th\u1eadp ph\u00e2n. \u0110\u1ec3 chuy\u1ec3n th\u00e0nh s\u1ed1 nguy\u00ean, d\u00f9ng h\u00e0m ROUNDDOWN, th\u00eam s\u1ed1 0 v\u00e0o cu\u1ed1i c\u00f4ng th\u1ee9c tr\u00ean.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"TINH_TUOI_TRONG_EXCEL_VOI_HAM_DATEIF\"><\/span><strong>T\u00cdNH TU\u1ed4I TRONG EXCEL V\u1edaI H\u00c0M DATEIF:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 t\u00ednh tu\u1ed5i l\u00e0 d\u00f9ng h\u00e0m DATEIF:<\/p>\n<p>DATEDIF(start_date, end_date, unit)<\/p>\n<p>H\u00e0m n\u00e0y tr\u1ea3 k\u1ebft qu\u1ea3 l\u00e0 th\u1eddi gian gi\u1eefa 2 ng\u00e0y t\u00ednh theo ng\u00e0y, th\u00e1ng ho\u1eb7c n\u0103m tu\u1ef3 theo \u0111\u01a1n v\u1ecb m\u00e0 b\u1ea1n ch\u1ecdn.<\/p>\n<ul>\n<li>Y \u2013 th\u1eddi gian t\u00ednh theo n\u0103m tr\u00f2n gi\u1eefa 2 ng\u00e0y.<\/li>\n<li>M \u2013\u00a0 th\u1eddi gian t\u00ednh theo th\u00e1ng tr\u00f2n gi\u1eefa 2 ng\u00e0y.<\/li>\n<li>D \u2013 th\u1eddi gian t\u00ednh theo ng\u00e0y tr\u00f2n gi\u1eefa 2 ng\u00e0y.<\/li>\n<li>YM \u2013 s\u1ed1 th\u00e1ng ch\u00eanh l\u1ec7ch, b\u1ecf qua ng\u00e0y, n\u0103m.<\/li>\n<li>MD \u2013 S\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch, b\u1ecf qua th\u00e1ng, n\u0103m.<\/li>\n<li>YD \u2013 S\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch, b\u1ecf qua n\u0103m.<\/li>\n<\/ul>\n<p>V\u00ec ch\u00fang ta t\u00ednh tu\u1ed5i theo n\u0103m, d\u00f9ng \u201cY\u201d.<\/p>\n<p><strong>DATEDIF(date of birth, TODAY(), \u201cy\u201d)<\/strong><\/p>\n<p>V\u00ed d\u1ee5, ng\u00e0y sinh trong \u00f4 B2, k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4913 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/calculate-age-datedif.png\" width=\"246\" height=\"182\" title=\"calculate-age-datedif\"><\/p>\n<p>Kh\u00f4ng c\u1ea7n l\u00e0m tr\u00f2n v\u00ec trong h\u00e0m DATEIF, \u0111\u01a1n v\u1ecb n\u0103m t\u00ednh theo n\u0103m tr\u00f2n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4914 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/calculate-age-datedif-1.png\" width=\"246\" height=\"182\" title=\"calculate-age-datedif-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"CACH_TINH_TUOI_RA_NGAY_THANG_NAM_CHINH_XAC\"><\/span><strong>C\u00c1CH T\u00cdNH TU\u1ed4I RA NG\u00c0Y TH\u00c1NG N\u0102M CH\u00cdNH X\u00c1C:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nh\u01b0 b\u1ea1n v\u1eeba th\u1ea5y, t\u00ednh tu\u1ed5i c\u1ee7a 1 ng\u01b0\u1eddi ra n\u0103m tr\u00f2n r\u1ea5t d\u1ec5 nh\u01b0ng kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng \u0111\u1ee7. N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft ch\u00ednh x\u00e1c s\u1ed1 tu\u1ed5i, bao nhi\u00eau ng\u00e0y, th\u00e1ng, n\u0103m, h\u00e3y vi\u1ebft ra 3 h\u00e0m DATEIF kh\u00e1c nhau:<\/p>\n<ol>\n<li>\u0110\u1ec3 c\u00f3 s\u1ed1 n\u0103m: <strong>=DATEDIF(B2, TODAY(), \u201cY\u201d)<\/strong><\/li>\n<li>\u0110\u1ec3 c\u00f3 s\u1ed1 th\u00e1ng: <strong>=DATEDIF(B2, TODAY(), \u201cYM\u201d)<\/strong><\/li>\n<li>\u0110\u1ec3 c\u00f3 s\u1ed1 ng\u00e0y: <strong>=DATEDIF(B2,TODAY(),\u201dMD\u201d)<\/strong><\/li>\n<\/ol>\n<p>Trong \u0111\u00f3 B2 l\u00e0 \u00f4 c\u00f3 ch\u1ee9a ng\u00e0y th\u00e1ng n\u0103m sinh.<\/p>\n<p>V\u00e0 n\u1ed1i c\u00e1c h\u00e0m v\u00e0o trong 1 c\u00f4ng th\u1ee9c, nh\u01b0 sau:<\/p>\n<p><strong>=DATEDIF(B2,TODAY(),\u201dY\u201d) &amp; DATEDIF(B2,TODAY(),\u201dYM\u201d) &amp; DATEDIF(B2,TODAY(),\u201dMD\u201d)<\/strong><\/p>\n<p>C\u00f4ng th\u1ee9c tr\u00ean s\u1ebd \u0111\u01b0a c\u00e1c con s\u1ed1 ng\u00e0y, th\u00e1ng, n\u0103m v\u1ec1 1 chu\u1ed7i nh\u01b0 h\u00ecnh d\u01b0\u1edbi.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4915 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/age-years-months-days.png\" width=\"559\" height=\"187\" title=\"age-years-months-days\"><\/p>\n<p>\u0110\u1ec3 k\u1ebft qu\u1ea3 r\u00f5 r\u00e0ng h\u01a1n, t\u00e1ch ch\u00fang b\u1eb1ng d\u1ea5u ph\u1ea9y v\u00e0 \u0111\u1ecbnh ngh\u0129a c\u00e1c con s\u1ed1 \u0111\u00f3 l\u00e0 g\u00ec:<\/p>\n<p><strong>=DATEDIF(B2,TODAY(),\u201dY\u201d) &amp; \u201d Years, \u201d &amp; DATEDIF(B2,TODAY(),\u201dYM\u201d) &amp; \u201d Months, \u201d &amp; DATEDIF(B2,TODAY(),\u201dMD\u201d) &amp; \u201d Days\u201d<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4916 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/calculate-age-date-of-birth.png\" width=\"373\" height=\"224\" title=\"calculate-age-date-of-birth\"><\/p>\n<p>Xem th\u00eam: T\u00f4\u0309ng h\u01a1\u0323p ca\u0301c b\u00f4\u0323 ta\u0300i li\u00ea\u0323u h\u01b0\u01a1\u0301ng d\u00e2\u0303n v\u00ea\u0300 <a href=\"http:\/\/blog.ezworkapp.com\/excel-nang-cao\">Excel n\u00e2ng cao<\/a> m\u01a1\u0301i nh\u00e2\u0301t<\/p>\n<p>C\u00f4ng th\u1ee9c tr\u00ean c\u00f3 th\u1ec3 ho\u00e0n h\u1ea3o h\u01a1n n\u1ebfu c\u00e1c gi\u00e1 tr\u1ecb b\u1eb1ng 0 \u0111\u01b0\u1ee3c gi\u1ea5u \u0111i. Th\u00eam 3 m\u1ec7nh \u0111\u1ec1 IF \u0111\u1ec3 ki\u1ec3m tra cho m\u1ed7i c\u00f4ng th\u1ee9c DATEIF:<\/p>\n<p><strong>=IF(DATEDIF(B2, TODAY(),\u201dy\u201d)=0,\u201d\u201d,DATEDIF(B2, TODAY(),\u201dy\u201d)&amp;\u201d years, \u201c)&amp;<\/strong><\/p>\n<p><strong>IF(DATEDIF(B2, TODAY(),\u201dym\u201d)=0,\u201d\u201d,DATEDIF(B2, TODAY(),\u201dym\u201d)&amp;\u201d months, \u201c)&amp;<\/strong><\/p>\n<p><strong>IF(DATEDIF(B2, TODAY(),\u201dmd\u201d)=0,\u201d\u201d,DATEDIF(B2, TODAY(),\u201dmd\u201d)&amp;\u201d days\u201d)<\/strong><\/p>\n<p>H\u00ecnh d\u01b0\u1edbi minh ho\u1ea1 k\u1ebft qu\u1ea3 c\u00f4ng th\u1ee9c tr\u00ean \u2013 kh\u00f4ng c\u00f2n c\u00e1c gi\u00e1 tr\u1ecb 0.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4917 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/age-years-month-days-formula.png\" width=\"517\" height=\"224\" title=\"age-years-month-days-formula\"><\/p>\n<p>M\u1eb9o nh\u1ecf. N\u1ebfu b\u1ea1n ch\u1ec9 c\u1ea7n t\u00ednh tu\u1ed5i theo ng\u00e0y, th\u00e1ng, d\u00f9ng c\u00f4ng th\u1ee9c tr\u00ean v\u00e0 b\u1ecf m\u1ec7nh \u0111\u1ec1 IF(DATEDIF()) cu\u1ed1i c\u00f9ng.<\/p>\n<p><strong>V\u00cd D\u1ee4 T\u00cdNH TU\u1ed4I TRONG EXCEL:<\/strong><\/p>\n<p>C\u00f4ng th\u1ee9c t\u00ednh tu\u1ed5i \u1edf v\u00ed d\u1ee5 tr\u00ean \u0111\u00fang v\u1edbi h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p. Nh\u01b0ng \u0111\u00f4i khi b\u1ea1n c\u1ea7n th\u00f4ng tin r\u1ea5t c\u1ee5 th\u1ec3, tuy kh\u00f4ng ph\u1ea3i trong m\u1ecdi tr\u01b0\u1eddng h\u1ee3p. C\u00e1c v\u00ed d\u1ee5 sau s\u1ebd gi\u00fap b\u1ea1n d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c t\u00ednh tu\u1ed5i, th\u1ef1c hi\u1ec7n c\u00e1c b\u00e0i to\u00e1n t\u01b0\u01a1ng t\u1ef1.<\/p>\n<p>T\u00ednh tu\u1ed5i t\u1eeb ng\u00e0y th\u00e1ng n\u0103m sinh \u0111\u1ebfn m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3<\/p>\n<p>N\u1ebfu b\u1ea1n c\u1ea7n t\u00ednh tu\u1ed5i t\u1eeb ng\u00e0y th\u00e1ng n\u0103m sinh \u0111\u1ebfn m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3, kh\u00f4ng ph\u1ea3i \u0111\u1ebfn ng\u00e0y h\u00f4m nay, d\u00f9ng h\u00e0m DATEIF nh\u01b0 tr\u00ean, thay TODAY() b\u1eb1ng ng\u00e0y c\u1ee5 th\u1ec3.<\/p>\n<p>Gi\u1ea3 s\u1eed ng\u00e0y sinh trong \u00f4 B1, c\u1ea7n t\u00ednh tu\u1ed5i \u0111\u1ebfn ng\u00e0y 1\/1\/2000:<\/p>\n<p><strong>=DATEDIF(B1, \u201c1\/1\/2020\u2033,\u201dY\u201d) &amp; \u201d Years, \u201d &amp; DATEDIF(B1, \u201c1\/1\/2020\u2033,\u201dYM\u201d) &amp; \u201d Months, \u201d &amp; DATEDIF(B1, \u201c1\/1\/2020\u201d, \u201cMD\u201d) &amp; \u201d Days\u201d<\/strong><\/p>\n<p>\u0110\u1ec3 c\u00f4ng th\u1ee9c t\u00ednh tu\u1ed5i linh ho\u1ea1t h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp ng\u00e0y v\u00e0o 1 \u00f4 v\u00e0 th\u00eam \u00f4 \u0111\u00f3 v\u00e0o c\u00f4ng th\u1ee9c:<\/p>\n<p><strong>=DATEDIF(B1, B2,\u201dY\u201d) &amp; \u201d Years, \u201c&amp; DATEDIF(B1,B2,\u201dYM\u201d) &amp; \u201d Months, \u201c&amp;DATEDIF(B1,B2, \u201cMD\u201d) &amp; \u201d Days\u201d<\/strong><\/p>\n<p>Khi B1 ch\u1ee9a ng\u00e0y sinh, B2 ch\u1ee9a ng\u00e0y m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh tu\u1ed5i \u0111\u1ebfn:<\/p>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4918 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/age-specific-date.png\" width=\"386\" height=\"167\" title=\"age-specific-date\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"THOI_GIAN_TINH_TUOI_KHONG_CU_THE\"><\/span><strong>TH\u1edcI GIAN T\u00cdNH TU\u1ed4I KH\u00d4NG C\u1ee4 TH\u1ec2:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f4ng th\u1ee9c t\u00ednh tu\u1ed5i v\u1eabn c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng ngay c\u1ea3 khi th\u1eddi gian k\u1ebft th\u00fac ch\u1ec9 c\u00f3 n\u0103m, kh\u00f4ng r\u00f5 ng\u00e0y th\u00e1ng.<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi c\u01a1 s\u1edf d\u1eef li\u1ec7u y t\u1ebf, m\u1ee5c ti\u00eau c\u1ee7a b\u1ea1n l\u00e0 t\u00ecm ra s\u1ed1 tu\u1ed5i c\u1ee7a b\u1ec7nh nh\u00e2n v\u00e0o l\u1ea7n cu\u1ed1i h\u1ecd khi kh\u00e1m b\u1ec7nh.<\/p>\n<p>Gi\u1ea3 s\u1eed ng\u00e0y sinh c\u1ee7a h\u1ecd \u1edf c\u1ed9t B, b\u1eaft \u0111\u1ea7u t\u1eeb h\u00e0ng 3, v\u00e0 n\u0103m b\u1ec7nh nh\u00e2n kh\u00e1m l\u1ea7n cu\u1ed1i \u1edf c\u1ed9t C, c\u00f4ng th\u1ee9c t\u00ednh tu\u1ed5i nh\u01b0 sau:<\/p>\n<p><strong>=DATEDIF(B3,DATE(C3, 1, 1),\u201dy\u201d)<\/strong><\/p>\n<p>V\u00ec ng\u00e0y kh\u00e1m b\u1ec7nh l\u1ea7n cu\u1ed1i kh\u00f4ng r\u00f5, b\u1ea1n d\u00f9ng h\u00e0m DATE v\u1edbi c\u00e1ch t\u00ednh ng\u00e0y th\u00e1ng m\u1eb7c \u0111\u1ecbnh, v\u00ed d\u1ee5: DATE(C3, 1, 1).<\/p>\n<p>H\u00e0m DATE tr\u1eeb n\u0103m t\u1eeb \u00f4 B3, m\u1eb7c \u0111\u1ecbnh th\u00eam ng\u00e0y, th\u00e1ng cho n\u0103m b\u1ea1n cung c\u1ea5p (v\u00ed d\u1ee5: 1\/1) v\u00e0 \u0111\u01b0a ng\u00e0y th\u00e1ng n\u0103m c\u1ee5 th\u1ec3 v\u00e0o h\u00e0m DATEIF. K\u1ebft qu\u1ea3 l\u00e0 b\u1ea1n c\u00f3 tu\u1ed5i b\u1ec7nh nh\u00e2n t\u00ednh \u0111\u1ebfn ng\u00e0y 1\/1 c\u1ee7a n\u0103m n\u00e0o \u0111\u00f3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4919 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/calculate-age-certain-year.png\" width=\"372\" height=\"203\" title=\"calculate-age-certain-year\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"TIM_NGAY_KHI_1_NGUOI_DAT_BAO_NHIEU_TUOI\"><\/span><strong>T\u00ccM NG\u00c0Y KHI 1 NG\u01af\u1edcI \u0110\u1ea0T BAO NHI\u00caU TU\u1ed4I:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Gi\u1ea3 s\u1eed 1 ng\u01b0\u1eddi sinh n\u0103m 8\/3\/1978, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 bi\u1ebft \u0111\u1ebfn ng\u00e0y n\u00e0o anh ta 50 tu\u1ed5i? Th\u00f4ng th\u01b0\u1eddng, b\u1ea1n th\u00eam 50 n\u0103m v\u00e0o ng\u00e0y th\u00e1ng n\u0103m sinh c\u1ee7a ng\u01b0\u1eddi \u0111\u00f3. Trong Excel, b\u1ea1n d\u00f9ng h\u00e0m DATE.<\/p>\n<p><strong>=DATE(YEAR(B2) + 50, MONTH(B2), DAY(B2))<\/strong><\/p>\n<p>A2 l\u00e0 \u00f4 ch\u1ee9a ng\u00e0y sinh.<\/p>\n<p>Thay v\u00ec ph\u1ea3i nh\u1eadp n\u0103m ch\u00ednh x\u00e1c v\u00e0o c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 d\u1eabn t\u1edbi 1 \u00f4 b\u1ea5t k\u00ec c\u00f3 ch\u1ee9a ng\u00e0y th\u00e1ng n\u0103m \u0111\u00f3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4920 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/date-certain-age.png\" width=\"431\" height=\"184\" title=\"date-certain-age\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"TINH_TUOI_VOI_NGAY_THANG_NAM_SINH_O_CAC_O_KHAC_NHAU\"><\/span><strong>T\u00cdNH TU\u1ed4I V\u1edaI NG\u00c0Y, TH\u00c1NG, N\u0102M SINH \u1ede C\u00c1C \u00d4 KH\u00c1C NHAU:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi ng\u00e0y th\u00e1ng n\u0103m sinh \u1edf 3 \u00f4 kh\u00e1c nhau (v\u00ed d\u1ee5 n\u0103m \u1edf \u00f4 B3, th\u00e1ng \u1edf \u00f4 C3 v\u00e0 ng\u00e0y \u1edf D3), b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh tu\u1ed5i theo c\u00e1ch n\u00e0y:<\/p>\n<p>L\u1ea5y ng\u00e0y th\u00e1ng n\u0103m sinh b\u1eb1ng c\u00e1ch d\u00f9ng h\u00e0m DATE v\u00e0 DATEVALUE<\/p>\n<p><strong>DATE(B3,MONTH(DATEVALUE(C3&amp;\u201d1\u2033)),D3)<\/strong><\/p>\n<p>Th\u00eam c\u00f4ng th\u1ee9c tr\u00ean v\u00e0o h\u00e0m DATEIF \u0111\u1ec3 t\u00ednh tu\u1ed5i:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4921 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/age-from-years-months-days.png\" width=\"540\" height=\"242\" title=\"age-from-years-months-days\"><\/p>\n<p><strong>T\u1ea0O M\u00c1Y T\u00cdNH TU\u1ed4I TRONG EXCEL<\/strong><\/p>\n<p>Khi b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00f4ng th\u1ee9c t\u00ednh tu\u1ed5i, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u00e1y t\u00ednh tu\u1ed5i c\u1ee7a ri\u00eang m\u00ecnh nh\u01b0 sau.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4922\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/age-calculator-excel.png\" width=\"600\" height=\"240\" title=\"age-calculator-excel\"><\/p>\n<p>V\u1edbi m\u00e1y t\u00ednh n\u00e0y, ch\u00fang ta d\u00f9ng nh\u1eefng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 t\u00ednh tu\u1ed5i d\u1ef1a tr\u00ean ng\u00e0y sinh \u1edf \u00f4 A3 v\u00e0 ng\u00e0y hi\u1ec7n nay.<\/p>\n<p>C\u00f4ng th\u1ee9c \u1edf \u00f4 B5 t\u00ednh tu\u1ed5i theo ng\u00e0y, th\u00e1ng, n\u0103m:<\/p>\n<p><strong>=DATEDIF(B2,TODAY(),\u201dY\u201d) &amp; \u201d Years, \u201d &amp; DATEDIF(B2,TODAY(),\u201dYM\u201d) &amp; \u201d Months, \u201d &amp; DATEDIF(B2,TODAY(),\u201dMD\u201d) &amp; \u201d Days\u201d<\/strong><\/p>\n<p>C\u00f4ng th\u1ee9c \u1edf \u00f4 B6 t\u00ednh th\u00e1ng:<\/p>\n<p><strong>=DATEDIF($B$3,TODAY(),\u201dm\u201d)<\/strong><\/p>\n<p>C\u00f4ng th\u1ee9c \u1edf \u00f4 B7 t\u00ednh ng\u00e0y:<\/p>\n<p><strong>=DATEDIF($B$3,TODAY(),\u201dd\u201d) <\/strong><\/p>\n<p>N\u1ebfu b\u1ea1n \u0111\u00e3 l\u00e0m Excel Form, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea3i thi\u1ec7n m\u00e1y t\u00ednh tu\u1ed5i \u0111\u01a1n gi\u1ea3n n\u00e0y b\u1eb1ng c\u00e1ch cho ph\u00e9p ng\u01b0\u1eddi s\u1eed d\u1ee5ng t\u00ednh tu\u1ed5i \u0111\u1ebfn 1 ng\u00e0y c\u1ee5 th\u1ec3, nh\u01b0 h\u00ecnh d\u01b0\u1edbi:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4923 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/improved-age-calculator-excel.png\" width=\"332\" height=\"247\" title=\"improved-age-calculator-excel\"><\/p>\n<p>\u0110\u1ec3 c\u00f3 m\u00e1y t\u00ednh tu\u1ed5i th\u00f4ng minh \u1edf Excel, b\u1ea1n v\u00e0o <strong>Developer tab &gt; Insert &gt; Form controls &gt; Option Button <\/strong>v\u00e0 li\u00ean k\u1ebft t\u1edbi \u00f4. Sau \u0111\u00f3, vi\u1ebft c\u00f4ng th\u1ee9c IF\/DATEIF \u0111\u1ec3 t\u00ednh tu\u1ed5i \u0111\u1ebfn ng\u00e0y hi\u1ec7n t\u1ea1i ho\u1eb7c 1 ng\u00e0y kh\u00e1c. C\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng nh\u01b0 sau:<\/p>\n<p>N\u1ebfu h\u1ed9p Today\u2019s date \u0111\u01b0\u1ee3c ch\u1ecdn, gi\u00e1 tr\u1ecb 1 xu\u1ea5t hi\u1ec7n \u1edf \u00f4 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft (v\u00ed d\u1ee5 I5), v\u00e0 c\u00f4ng th\u1ee9c t\u00ednh tu\u1ed5i nh\u01b0 sau:<\/p>\n<p><strong>IF($I$5=1, DATEDIF($B$3,TODAY(),\u201dY\u201d) &amp; \u201d Years, \u201d &amp; DATEDIF($B$3,TODAY(),\u201dYM\u201d) &amp; \u201d Months, \u201d &amp; DATEDIF($B$3,TODAY(),\u201dMD\u201d) &amp; \u201d Days\u201d)<\/strong><\/p>\n<p>N\u1ebfu h\u1ed9p Specific date \u0111\u01b0\u1ee3c ch\u1ecdn, v\u00e0 1 ng\u00e0y c\u1ee5 th\u1ec3 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o \u00f4 B7, tu\u1ed5i \u0111\u01b0\u1ee3c t\u00ednh \u0111\u1ebfn ng\u00e0y \u0111\u00f3:<\/p>\n<p><strong>IF(ISNUMBER($B$7), DATEDIF($B$3, $B$7,\u201dY\u201d) &amp; \u201d Years, \u201d &amp; DATEDIF($B$3, $B$7,\u201dYM\u201d) &amp; \u201d Months, \u201d &amp; DATEDIF($B$3, $B$7,\u201dMD\u201d) &amp; \u201d Days\u201d, \u201c\u201d))<\/strong><\/p>\n<p>Cu\u1ed1i c\u00f9ng, b\u1ea1n l\u1ed3ng c\u00e1c h\u00e0m v\u00e0o nhau, v\u00e0 c\u00f4ng th\u1ee9c t\u00ednh tu\u1ed5i \u0111\u01b0\u1ee3c ho\u00e0n th\u00e0nh (trong \u00f4 B9):<\/p>\n<p><strong>=IF($I$5=1,DATEDIF($B$3,TODAY(),\u201dY\u201d) &amp; \u201d Years, \u201d &amp; DATEDIF($B$3,TODAY(),\u201dYM\u201d) &amp; \u201d Months, \u201d &amp; DATEDIF($B$3,TODAY(),\u201dMD\u201d) &amp; \u201d Days\u201d, IF(ISNUMBER($B$7), DATEDIF($B$3, $B$7,\u201dY\u201d) &amp; \u201d Years, \u201d &amp; DATEDIF($B$3, $B$7,\u201dYM\u201d) &amp; \u201d Months, \u201d &amp; DATEDIF($B$3, $B$7,\u201dMD\u201d) &amp; \u201d Days\u201d, \u201c\u201d))<\/strong><\/p>\n<p>C\u00f4ng th\u1ee9c \u1edf \u00f4 B10 v\u00e0 B11 c\u0169ng ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1. D\u0129 nhi\u00ean s\u1ebd \u0111\u01a1n gi\u1ea3n h\u01a1n v\u00ec h\u00e0m DATEIF ch\u1ec9 c\u1ea7n tr\u1ea3 gi\u00e1 tr\u1ecb l\u00e0 th\u00e1ng tr\u00f2n, ng\u00e0y tr\u00f2n.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"DANH_DAU_TUOI\"><\/span><strong>\u0110\u00c1NH D\u1ea4U TU\u1ed4I :<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n kh\u00f4ng ch\u1ec9 c\u1ea7n t\u00ednh tu\u1ed5i m\u00e0 c\u1ea7n \u0111\u00e1nh d\u1ea5u \u00f4 ch\u1ee9a s\u1ed1 tu\u1ed5i tr\u00ean ho\u1eb7c d\u01b0\u1edbi 1 m\u1ee9c n\u00e0o \u0111\u00f3.<\/p>\n<p>N\u1ebfu c\u00f4ng th\u1ee9c t\u00ednh tu\u1ed5i cho ra s\u1ed1 n\u0103m tu\u1ed5i tr\u00f2n, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam c\u00f4ng th\u1ee9c \u0111i\u1ec1u ki\u1ec7n nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p>\u0110\u1ec3 \u0111\u00e1nh d\u1ea5u s\u1ed1 tu\u1ed5i l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 18: <strong>=$C2&gt;=18<\/strong><\/p>\n<p>\u0110\u00e1nh d\u1ea5u s\u1ed1 tu\u1ed5i nh\u1ecf h\u01a1n 18: <strong>=$C2&lt;18<\/strong><\/p>\n<p>C2 l\u00e0 \u00f4 tr\u00ean c\u00f9ng trong c\u1ed9t Age<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4924 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/highlight-age-excel.png\" width=\"628\" height=\"475\" title=\"highlight-age-excel\"><\/p>\n<p>Nh\u01b0ng khi c\u00f4ng th\u1ee9c cho ra tu\u1ed5i \u1edf d\u1ea1ng th\u00e1ng, n\u0103m ho\u1eb7c ng\u00e0y, th\u00e1ng, n\u0103m? Trong tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3, b\u1ea1n ph\u1ea3i t\u1ea1o \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c DATEIF (\u0111\u1ec3 t\u00ednh tu\u1ed5i ra s\u1ed1 n\u0103m).<\/p>\n<p>Gi\u1ea3 s\u1eed ng\u00e0y th\u00e1ng n\u0103m sinh \u1edf c\u1ed9t B t\u1eeb h\u00e0ng 2, c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p>\u0110\u00e1nh d\u1ea5u s\u1ed1 tu\u1ed5i nh\u1ecf h\u01a1n 18 (v\u00e0ng)<\/p>\n<p><strong>=DATEDIF($B2, TODAY(),\u201dY\u201d)&lt;18<\/strong><\/p>\n<p>\u0110\u00e1nh d\u1ea5u s\u1ed1 tu\u1ed5i t\u1eeb 18 \u0111\u1ebfn 65 (xanh)<\/p>\n<p><strong>=AND(DATEDIF($B2, TODAY(),\u201dY\u201d)&gt;=18, DATEDIF($B2, TODAY(),\u201dY\u201d)&lt;=65)<\/strong><\/p>\n<p>\u0110\u00e1nh d\u1ea5u s\u1ed1 tu\u1ed5i tr\u00ean 65 (lam)<\/p>\n<p><strong>=DATEDIF($B2, TODAY(),\u201dY\u201d)&gt;65<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4925 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/highlight-age-excel2.png\" width=\"628\" height=\"518\" title=\"highlight-age-excel2\"><\/p>\n<p>\u0110\u1ec3 c\u00f3 nh\u1eefng \u0111i\u1ec1u ki\u1ec7n d\u1ef1a v\u00e0o c\u00f4ng th\u1ee9c nh\u01b0 tr\u00ean, ch\u1ecdn \u00f4 ho\u1eb7c h\u00e0ng b\u1ea1n mu\u1ed1n \u0111\u00e1nh d\u1ea5u, t\u1edbi <strong>Home tab &gt; Styles group &gt; Conditional Formatting &gt; New Rule\u2026 &gt; Use a formula to determine which cells to format.<\/strong><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2v0HPjU\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener\">HocExcel.Online<\/a><\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-69.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12009,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12008","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\/12008","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=12008"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12008\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12009"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}