{"id":8223,"date":"2024-12-22T04:16:21","date_gmt":"2024-12-22T04:16:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-cach-xac-dinh-ngay-sinh-nhat-cua-nhan-vien-bang-ham-excel\/"},"modified":"2024-12-22T04:16:21","modified_gmt":"2024-12-22T04:16:21","slug":"huong-dan-cach-xac-dinh-ngay-sinh-nhat-cua-nhan-vien-bang-ham-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-cach-xac-dinh-ngay-sinh-nhat-cua-nhan-vien-bang-ham-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u00e1c \u0111\u1ecbnh ng\u00e0y sinh nh\u1eadt c\u1ee7a nh\u00e2n vi\u00ean b\u1eb1ng h\u00e0m excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong l\u0129nh v\u1ef1c h\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1 ch\u1eafc h\u1eb3n b\u1ea1n kh\u00f4ng c\u00f2n xa l\u1ea1 g\u00ec vi\u1ec7c ph\u1ea3i x\u00e1c \u0111\u1ecbnh <strong>ng\u00e0y sinh nh\u1eadt c\u1ee7a m\u1ed7i nh\u00e2n vi\u00ean.<\/strong>\u00a0M\u1ee5c\u00a0\u0111\u00edch l\u00e0\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 \u0111\u01b0a ra c\u00e1c ch\u00ednh s\u00e1ch \u0111\u00e3i ng\u1ed9 cho nh\u00e2n s\u1ef1 c\u1ee7a C\u00f4ng ty. B\u00e0i vi\u1ebft n\u00e0y <a href=\"https:\/\/hocexcel.online\/\">H\u1ecdc Excel Online<\/a> xin gi\u1edbi thi\u1ec7u t\u1edbi c\u00e1c b\u1ea1n c\u00e1ch d\u00f9ng h\u00e0m trong Excel \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ng\u00e0y sinh nh\u1eadt.<\/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-67679294b12ea\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-xac-dinh-ngay-sinh-nhat-tren-excel.html#Cach_xac_dinh_ngay_sinh_nhat_cua_nhan_vien\" title=\"C\u00e1ch x\u00e1c \u0111\u1ecbnh ng\u00e0y sinh nh\u1eadt c\u1ee7a nh\u00e2n vi\u00ean\">C\u00e1ch x\u00e1c \u0111\u1ecbnh ng\u00e0y sinh nh\u1eadt c\u1ee7a nh\u00e2n vi\u00ean<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-xac-dinh-ngay-sinh-nhat-tren-excel.html#Nguyen_tac_xac_dinh_ngay_sinh_nhat\" title=\"Nguy\u00ean t\u1eafc x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y sinh nh\u1eadt\">Nguy\u00ean t\u1eafc x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y sinh nh\u1eadt<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-xac-dinh-ngay-sinh-nhat-tren-excel.html#Cach_dung_ham_tim_ngay_sinh_nhat_cua_nhan_vien\" title=\"C\u00e1ch d\u00f9ng h\u00e0m t\u00ecm\u00a0ng\u00e0y sinh nh\u1eadt c\u1ee7a nh\u00e2n vi\u00ean\">C\u00e1ch d\u00f9ng h\u00e0m t\u00ecm\u00a0ng\u00e0y sinh nh\u1eadt c\u1ee7a nh\u00e2n vi\u00ean<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/cach-xac-dinh-ngay-sinh-nhat-tren-excel.html#Cac_ham_su_dung\" title=\"C\u00e1c h\u00e0m s\u1eed d\u1ee5ng\">C\u00e1c h\u00e0m s\u1eed d\u1ee5ng<\/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\/cach-xac-dinh-ngay-sinh-nhat-tren-excel.html#Ket_qua\" title=\"K\u1ebft qu\u1ea3\">K\u1ebft qu\u1ea3<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_xac_dinh_ngay_sinh_nhat_cua_nhan_vien\"><\/span>C\u00e1ch x\u00e1c \u0111\u1ecbnh ng\u00e0y sinh nh\u1eadt c\u1ee7a nh\u00e2n vi\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Nguyen_tac_xac_dinh_ngay_sinh_nhat\"><\/span>Nguy\u00ean t\u1eafc x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y sinh nh\u1eadt<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u2013 Ng\u00e0y sinh nh\u1eadt s\u1ebd \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1eb1ng c\u00e1ch: l\u1ea5y ng\u00e0y v\u00e0 th\u00e1ng c\u1ee7a ng\u00e0y sinh k\u1ebft h\u1ee3p v\u1edbi n\u0103m c\u1ee7a th\u1eddi \u0111i\u1ec3m c\u1ea7n x\u00e1c \u0111\u1ecbnh ng\u00e0y sinh nh\u1eadt.<\/p>\n<p style=\"text-align: justify\">\u2013 Sau \u0111\u00f3 ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m DATE \u0111\u1ec3 gh\u00e9p l\u1ea1i th\u00e0nh ng\u00e0y sinh nh\u1eadt c\u1ee7a nh\u00e2n vi\u00ean<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dung_ham_tim_ngay_sinh_nhat_cua_nhan_vien\"><\/span>C\u00e1ch d\u00f9ng h\u00e0m t\u00ecm\u00a0ng\u00e0y sinh nh\u1eadt c\u1ee7a nh\u00e2n vi\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cac_ham_su_dung\"><\/span>C\u00e1c h\u00e0m s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Th\u00f4ng th\u01b0\u1eddng ch\u00fang ta s\u1ebd c\u1ea7n t\u1edbi c\u00e1c h\u00e0m sau:<\/p>\n<ul style=\"list-style-type: disc;text-align: justify\">\n<li><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-year-trong-excel-de-lap-bao-cao-theo-nam.html\">H\u00e0m <strong>YEAR<\/strong> <\/a>\u0111\u1ec3 x\u00e1c \u0111\u1ecbnh n\u0103m c\u1ee7a ng\u00e0y hi\u1ec7n t\u1ea1i.<\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-month-trong-excel-de-tim-so-thang.html\">H\u00e0m <strong>MONTH<\/strong><\/a> \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh th\u00e1ng c\u1ee7a ng\u00e0y sinh.<\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/cach-xac-dinh-ngay-thang-nam-bang-cac-ham-thoi-gian-trong-excel-co-bai-tap.html\">H\u00e0m <strong>DAY<\/strong><\/a> \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ng\u00e0y c\u1ee7a ng\u00e0y sinh.<\/li>\n<li>H\u00e0m <strong>TODAY<\/strong> tr\u1ea3 v\u1ec1 ng\u00e0y hi\u1ec7n t\u1ea1i.<\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-date-trong-excel-cach-tinh-toan-ngay-thang.html\">H\u00e0m <strong>DATE<\/strong><\/a> \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ra ng\u00e0y sinh nh\u1eadt.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-28746 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-4-1024x521-1.png\" width=\"600\" height=\"305\" title=\"1-4-1024x521-1\"><\/p>\n<p style=\"text-align: justify\">C\u00e1c h\u00e0m n\u00e0y kh\u00e1 \u0111\u01a1n gi\u1ea3n v\u00e0 \u0111\u00e3 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y chi ti\u1ebft \u1edf b\u00e0i vi\u1ebft sau, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecdc th\u00eam.<\/p>\n<p style=\"text-align: left;padding-left: 30px\"><em><a href=\"http:\/\/blog.ezworkapp.com\/cach-xac-dinh-ngay-thang-nam-bang-cac-ham-thoi-gian-trong-excel-co-bai-tap.html\">C\u00e1ch<\/a><a href=\"http:\/\/blog.ezworkapp.com\/cach-xac-dinh-ngay-thang-nam-bang-cac-ham-thoi-gian-trong-excel-co-bai-tap.html\"> x\u00e1c \u0111\u1ecbnh ng\u00e0y th\u00e1ng n\u0103m b\u1eb1ng c\u00e1c h\u00e0m th\u1eddi gian trong excel c\u00f3 b\u00e0i t\u1eadp<\/a><\/em><\/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-745.gif\" title=\"ex101_92019-nho-745\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ket_qua\"><\/span>K\u1ebft qu\u1ea3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">M\u1eb7c d\u00f9 c\u1ea7n s\u1eed d\u1ee5ng t\u1edbi nhi\u1ec1u h\u00e0m l\u1ed3ng nhau nh\u01b0 n\u1ebfu b\u1ea1n n\u1eafm k\u1ef9 \u0111\u01b0\u1ee3c m\u1ed7i h\u00e0m \u0111\u00f3 th\u00ec b\u1ea1n s\u1ebd th\u1ea5y kh\u00f4ng h\u1ec1 kh\u00f3 ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/08\/2-6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-28974\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-6-1024x393-1.png\" width=\"1024\" height=\"393\" title=\"2-6-1024x393-1\"><\/a><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c \u1edf \u00f4 C5 c\u00f3 th\u1ec3 gi\u1ea3i th\u00edch \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/p>\n<blockquote>\n<p style=\"text-align: justify\"><strong>=DATE(YEAR(TODAY()),MONTH(B5), DAY(B5))<\/strong><\/p>\n<\/blockquote>\n<ul style=\"list-style-type: circle\">\n<li style=\"text-align: justify\"><strong>YEAR(TODAY()):\u00a0<\/strong>H\u00e0m TODAY() tr\u1ea3 v\u1ec1 ng\u00e0y th\u00e1ng n\u0103m hi\u1ec7n t\u1ea1i, sau \u0111\u00f3 h\u00e0m YEAR s\u1ebd l\u1ea5y ra n\u0103m (k\u1ebft qu\u1ea3 l\u00e0 2019).<\/li>\n<li style=\"text-align: justify\"><strong>MONTH(B5):\u00a0<\/strong>S\u1ebd tr\u1ea3 v\u1ec1 th\u00e1ng c\u1ee7a ng\u00e0y sinh trong \u00f4 B5 (k\u1ebft qu\u1ea3 l\u00e0 06).<\/li>\n<li style=\"text-align: justify\"><strong>DAY(B5):\u00a0<\/strong>S\u1ebd tr\u1ea3 v\u1ec1 ng\u00e0y c\u1ee7a ng\u00e0y sinh trong \u00f4 B5 (k\u1ebft qu\u1ea3 l\u00e0 26).<\/li>\n<li style=\"text-align: justify\">K\u1ebft qu\u1ea3 c\u1ee7a nh\u1eefng h\u00e0m tr\u00ean s\u1ebd l\u00e0 c\u00e1c \u0111\u1ed1i s\u1ed1 cho h\u00e0m DATE.<\/li>\n<li style=\"text-align: justify\"><strong>DATE(2019, 06, 26)<\/strong> v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 26\/06\/2019).<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Qua b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a>, hy v\u1ecdng b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch \u0111\u1ec3 t\u00ednh ra <strong>ng\u00e0y sinh nh\u00e2n c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean<\/strong> trong \u0111\u01a1n v\u1ecb m\u00ecnh, t\u1eeb \u0111\u00f3 gi\u00fap cho vi\u1ec7c qu\u1ea3n l\u00fd c\u00e1c th\u00f4ng tin li\u00ean quan t\u1edbi nh\u00e2n vi\u00ean \u0111\u01b0\u1ee3c d\u1ec5 d\u00e0ng h\u01a1n.<\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, \u0111\u1ec3 c\u00f3 th\u1ec3 bi\u1ebft th\u00eam \u0111\u01b0\u1ee3c c\u00e1c nh\u00f3m h\u00e0m x\u1eed l\u00fd ng\u00e0y th\u00e1ng, c\u00e1c h\u00e0m th\u01b0\u1eddng s\u1eed d\u1ee5ng trong l\u0129nh v\u1ef1c nh\u00e2n s\u1ef1, k\u1ebf to\u00e1n b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1c kho\u00e1 h\u1ecdc v\u00e0 b\u00e0i vi\u1ebft v\u1ec1 K\u1ebf to\u00e1n, nh\u00e2n s\u1ef1.<\/p>\n<hr>\n<p style=\"text-align: justify\"><a href=\"https:\/\/hocexcel.online\/search\/kwd?q=nh%C3%A2n+s%E1%BB%B1\">C\u00e1c kho\u00e1 h\u1ecdc v\u1ec1 Nh\u00e2n s\u1ef1<\/a><\/p>\n<p style=\"text-align: justify\"><a href=\"https:\/\/hocexcel.online\/search\/kwd?q=k%E1%BA%BF+to%C3%A1n\">C\u00e1c kho\u00e1 h\u1ecdc v\u1ec1 K\u1ebf to\u00e1n<\/a><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/?p=28716&amp;preview_id=28716&amp;preview_nonce=6832c71719&amp;_thumbnail_id=28826&amp;preview=true\">M\u1ed9t s\u1ed1 c\u00e1ch t\u00ednh tu\u1ed5i c\u1ee7a nh\u00e2n vi\u00ean trong nh\u00e2n s\u1ef1<\/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\/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-745.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8224,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8223","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\/8223","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=8223"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8223\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8224"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}