{"id":3127,"date":"2024-12-02T19:49:38","date_gmt":"2024-12-02T19:49:38","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/mot-so-thong-ke-thu-vi-ve-ngay-sinh-cua-ban\/"},"modified":"2024-12-02T19:49:38","modified_gmt":"2024-12-02T19:49:38","slug":"mot-so-thong-ke-thu-vi-ve-ngay-sinh-cua-ban","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/mot-so-thong-ke-thu-vi-ve-ngay-sinh-cua-ban\/","title":{"rendered":"M\u1ed9t s\u1ed1 th\u1ed1ng k\u00ea th\u00fa v\u1ecb v\u1ec1 ng\u00e0y sinh c\u1ee7a b\u1ea1n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n \u0111\u1ec3 <strong><a href=\"http:\/\/blog.ezworkapp.com\/mot-thong-ke-thu-vi-ve-ngay-sinh-cua-ban.html\">th\u1ed1ng k\u00ea m\u1ed9t s\u1ed1 \u0111i\u1ec3m th\u00fa v\u1ecb v\u1ec1 ng\u00e0y th\u00e1ng n\u0103m sinh c\u1ee7a b\u1ea1n<\/a>.<\/strong><\/em><\/p>\n<p>Ng\u00e0y sinh c\u1ee7a m\u00ecnh th\u00ec ch\u1eafc h\u1eb3n ai ai c\u0169ng nh\u1edb. B\u1ea1n \u0111\u00e3 bao gi\u1edd th\u1eed t\u00f2 m\u00f2 xem ng\u00e0y sinh c\u1ee7a b\u1ea1n c\u00f3 g\u00ec th\u00fa v\u1ecb ko???. B\u1eb1ng vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m Excel ta s\u1ebd c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 th\u00f4ng tin v\u1ec1 ng\u00e0y sinh c\u1ee7a b\u1ea1n nh\u01b0 sau<\/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-674e0f5120590\" 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\/mot-thong-ke-thu-vi-ve-ngay-sinh-cua-ban.html#Mot_so_thong_ke_co_ban\" title=\"M\u1ed9t s\u1ed1 th\u1ed1ng k\u00ea c\u01a1 b\u1ea3n\">M\u1ed9t s\u1ed1 th\u1ed1ng k\u00ea c\u01a1 b\u1ea3n<\/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\/mot-thong-ke-thu-vi-ve-ngay-sinh-cua-ban.html#Ban_sinh_vao_thu_may_trong_tuan\" title=\"B\u1ea1n sinh v\u00e0o th\u1ee9 m\u1ea5y trong tu\u1ea7n?\">B\u1ea1n sinh v\u00e0o th\u1ee9 m\u1ea5y trong tu\u1ea7n?<\/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\/mot-thong-ke-thu-vi-ve-ngay-sinh-cua-ban.html#Ban_sinh_vao_tuan_thu_may_trong_nam\" title=\"B\u1ea1n sinh v\u00e0o tu\u1ea7n th\u1ee9 m\u1ea5y trong n\u0103m?\">B\u1ea1n sinh v\u00e0o tu\u1ea7n th\u1ee9 m\u1ea5y trong n\u0103m?<\/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\/mot-thong-ke-thu-vi-ve-ngay-sinh-cua-ban.html#Tong_so_nam_ban_da_song_tuoi_cua_ban\" title=\"T\u1ed5ng s\u1ed1 n\u0103m b\u1ea1n \u0111\u00e3 s\u1ed1ng (tu\u1ed5i c\u1ee7a b\u1ea1n)\">T\u1ed5ng s\u1ed1 n\u0103m b\u1ea1n \u0111\u00e3 s\u1ed1ng (tu\u1ed5i c\u1ee7a b\u1ea1n)<\/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\/mot-thong-ke-thu-vi-ve-ngay-sinh-cua-ban.html#Tong_so_thang_ban_da_song\" title=\"T\u1ed5ng s\u1ed1 th\u00e1ng b\u1ea1n \u0111\u00e3 s\u1ed1ng\">T\u1ed5ng s\u1ed1 th\u00e1ng b\u1ea1n \u0111\u00e3 s\u1ed1ng<\/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\/mot-thong-ke-thu-vi-ve-ngay-sinh-cua-ban.html#Tong_so_ngay_ban_da_song\" title=\"T\u1ed5ng s\u1ed1 ng\u00e0y b\u1ea1n \u0111\u00e3 s\u1ed1ng\">T\u1ed5ng s\u1ed1 ng\u00e0y b\u1ea1n \u0111\u00e3 s\u1ed1ng<\/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\/mot-thong-ke-thu-vi-ve-ngay-sinh-cua-ban.html#Tong_so_gio_phut_giay_ban_da_song\" title=\"T\u1ed5ng s\u1ed1 gi\u1edd, ph\u00fat, gi\u00e2y b\u1ea1n \u0111\u00e3 s\u1ed1ng\">T\u1ed5ng s\u1ed1 gi\u1edd, ph\u00fat, gi\u00e2y b\u1ea1n \u0111\u00e3 s\u1ed1ng<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/mot-thong-ke-thu-vi-ve-ngay-sinh-cua-ban.html#Mot_vai_thong_ke_khac\" title=\"M\u1ed9t v\u00e0i th\u1ed1ng k\u00ea kh\u00e1c\">M\u1ed9t v\u00e0i th\u1ed1ng k\u00ea kh\u00e1c<\/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-9\" href=\"https:\/\/blog.hocexcel.online\/mot-thong-ke-thu-vi-ve-ngay-sinh-cua-ban.html#Tong_so_ngay_Thu_7_ban_da_trai_qua_trong_doi\" title=\"T\u1ed5ng s\u1ed1 ng\u00e0y Th\u1ee9 7 b\u1ea1n \u0111\u00e3 tr\u1ea3i qua trong \u0111\u1eddi\">T\u1ed5ng s\u1ed1 ng\u00e0y Th\u1ee9 7 b\u1ea1n \u0111\u00e3 tr\u1ea3i qua trong \u0111\u1eddi<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/mot-thong-ke-thu-vi-ve-ngay-sinh-cua-ban.html#Tong_so_ngay_Chu_nhat_ban_da_trai_qua_trong_doi\" title=\"T\u1ed5ng s\u1ed1 ng\u00e0y\u00a0Ch\u1ee7 nh\u1eadt\u00a0b\u1ea1n \u0111\u00e3 tr\u1ea3i qua trong \u0111\u1eddi\">T\u1ed5ng s\u1ed1 ng\u00e0y\u00a0Ch\u1ee7 nh\u1eadt\u00a0b\u1ea1n \u0111\u00e3 tr\u1ea3i qua trong \u0111\u1eddi<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/mot-thong-ke-thu-vi-ve-ngay-sinh-cua-ban.html#Tong_so_ngay_cuoi_tuan_ban_da_trai_qua_trong_doi\" title=\"T\u1ed5ng s\u1ed1 ng\u00e0y cu\u1ed1i tu\u1ea7n b\u1ea1n \u0111\u00e3 tr\u1ea3i qua trong \u0111\u1eddi\">T\u1ed5ng s\u1ed1 ng\u00e0y cu\u1ed1i tu\u1ea7n b\u1ea1n \u0111\u00e3 tr\u1ea3i qua trong \u0111\u1eddi<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/mot-thong-ke-thu-vi-ve-ngay-sinh-cua-ban.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Mot_so_thong_ke_co_ban\"><\/span>M\u1ed9t s\u1ed1 th\u1ed1ng k\u00ea c\u01a1 b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Ban_sinh_vao_thu_may_trong_tuan\"><\/span>B\u1ea1n sinh v\u00e0o th\u1ee9 m\u1ea5y trong tu\u1ea7n?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea1n \u0111\u00e3 bao gi\u1edd t\u00f2 m\u00f2 l\u00e0 b\u1ea1n sinh v\u00e0o ng\u00e0y th\u1ee9 m\u1ea5y trong tu\u1ea7n ch\u01b0a???<\/p>\n<p>H\u00e0m WEEKDAY s\u1ebd gi\u00fap b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3<\/p>\n<blockquote>\n<p>=WEEKDAY(&lt;ng\u00e0y sinh c\u1ee7a b\u1ea1n&gt;)<\/p>\n<\/blockquote>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-weekday-trong-excel.html\">C\u00e1ch d\u00f9ng h\u00e0m weekday trong Excel<\/a><\/strong><\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ban_sinh_vao_tuan_thu_may_trong_nam\"><\/span>B\u1ea1n sinh v\u00e0o tu\u1ea7n th\u1ee9 m\u1ea5y trong n\u0103m?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c ng\u00e0y b\u1ea1n ra \u0111\u1eddi l\u00e0 tu\u1ea7n th\u1ee9 bao nhi\u00eau trong n\u0103m v\u1edbi h\u00e0m WEEKNUM<\/p>\n<blockquote>\n<p>=WEEKNUM(&lt;ng\u00e0y sinh c\u1ee7a b\u1ea1n&gt;)<\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Tong_so_nam_ban_da_song_tuoi_cua_ban\"><\/span>T\u1ed5ng s\u1ed1 n\u0103m b\u1ea1n \u0111\u00e3 s\u1ed1ng (tu\u1ed5i c\u1ee7a b\u1ea1n)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong Excel b\u1ea1n c\u00f3 th\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3 kh\u00e1 d\u1ec5 d\u00e0ng v\u1edbi nhi\u1ec1u c\u00e1ch kh\u00e1c nhau, trong b\u00e0i vi\u1ebft n\u00e0y H\u1ecdc Excel Online s\u1eed d\u1ee5ng h\u00e0m DATEDIF<\/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\/2024\/12\/vba101_92019-nho-100.gif\" title=\"vba101_92019-nho-100\"><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\/2024\/12\/ex101_92019-nho-236.gif\" title=\"ex101_92019-nho-236\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p>=DATEDIF(&lt;ng\u00e0y sinh c\u1ee7a b\u1ea1n&gt;, &lt;ng\u00e0y hi\u1ec7n t\u1ea1i&gt;,\u201dy\u201d)<\/p>\n<\/blockquote>\n<p>H\u01b0\u1edbng d\u1eabn v\u1ec1 h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/tinh-khoang-thoi-gian-giua-2-thoi-diem-ham-datedif-trong-excel.html\">DATEDIF r\u1ea5t c\u1ee5 th\u1ec3 v\u00e0 chi ti\u1ebft ngay \u0111\u00e2y<\/a><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/tinh-khoang-thoi-gian-giua-2-thoi-diem-ham-datedif-trong-excel.html\">H\u00e0m DATEDIF, t\u00ednh kho\u1ea3ng th\u1eddi gian gi\u1eefa 2 th\u1eddi \u0111i\u1ec3m trong Excel<\/a><\/strong><\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tong_so_thang_ban_da_song\"><\/span>T\u1ed5ng s\u1ed1 th\u00e1ng b\u1ea1n \u0111\u00e3 s\u1ed1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi h\u00e0m DATEDIF tr\u00ean b\u1ea1n c\u0169ng ho\u00e0n to\u00e0n x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y<\/p>\n<blockquote>\n<p>=DATEDIF(&lt;ng\u00e0y sinh c\u1ee7a b\u1ea1n&gt;, &lt;ng\u00e0y hi\u1ec7n t\u1ea1i&gt;,\u201dm\u201d)<\/p>\n<\/blockquote>\n<p>Thay v\u00ec \u201cy\u201d \u1edf \u0111\u1ed1i s\u1ed1 th\u1ee9 3 c\u1ee7a h\u00e0m\u00a0DATEDIF\u00a0\u0111\u1ec3 x\u00e1c \u0111\u1ecbnh n\u0103m (year) th\u00ec b\u1ea1n thay n\u00f3 th\u00e0nh \u201cm\u201d \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh th\u00e1ng (month)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tong_so_ngay_ban_da_song\"><\/span>T\u1ed5ng s\u1ed1 ng\u00e0y b\u1ea1n \u0111\u00e3 s\u1ed1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u0169ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady, v\u1edbi h\u00e0m\u00a0DATEDIF\u00a0b\u1ea1n c\u0169ng x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c b\u1ea1n \u0111\u00e3 s\u1ed1ng \u0111\u01b0\u1ee3c bao nhi\u00eau ng\u00e0y k\u1ec3 t\u1eeb l\u00fac sinh ra t\u1edbi hi\u1ec7n t\u1ea1i<\/p>\n<blockquote>\n<p>=DATEDIF(&lt;ng\u00e0y sinh c\u1ee7a b\u1ea1n&gt;, &lt;ng\u00e0y hi\u1ec7n t\u1ea1i&gt;,\u201dd\u201d)<\/p>\n<\/blockquote>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-datediff-trong-vba-excel.html\"><em><strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m DATEDIF trong vba Excel <\/strong><\/em><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tong_so_gio_phut_giay_ban_da_song\"><\/span>T\u1ed5ng s\u1ed1 gi\u1edd, ph\u00fat, gi\u00e2y b\u1ea1n \u0111\u00e3 s\u1ed1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li><strong>T\u1ed5ng s\u1ed1 gi\u1edd:<\/strong> \u0110\u01a1n gi\u1ea3n l\u00e0 b\u1ea1n ch\u1ec9 c\u1ea7n l\u1ea5y s\u1ed1 ng\u00e0y v\u00e0 nh\u00e2n v\u1edbi 24 (do 1 ng\u00e0y c\u00f3 24h)<\/li>\n<li><strong>T\u1ed5ng s\u1ed1 ph\u00fat:<\/strong> Sau khi \u0111\u00e3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c t\u1ed5ng s\u1ed1 gi\u1edd, b\u1ea1n l\u1ea5y t\u1ed5ng gi\u1edd nh\u00e2n v\u1edbi 60 \u0111\u1ec3 ra t\u1ed5ng s\u1ed1 ph\u00fat (do 1 gi\u1edd c\u00f3 60 ph\u00fat)<\/li>\n<li><strong>T\u1ed5ng s\u1ed1 gi\u00e2y: <\/strong>B\u1ea1n ti\u1ebfp t\u1ee5c nh\u00e2n s\u1ed1 ph\u00fat v\u1edbi 60 \u0111\u1ec3 xem t\u1ed5ng s\u1ed1 gi\u00e2y m\u00e0 b\u1ea1n \u0111\u00e3 s\u1ed1ng tr\u00ean th\u1ebf gian n\u00e0y (ch\u1eafc h\u1eb3n l\u00e0 1 con s\u1ed1kh\u1ee7ng khi\u1ebfp l\u1eafm )<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/mot-thong-ke-thu-vi-ve-ngay-sinh-cua-ban.html\/2019-10-31_101709\" rel=\"attachment wp-att-30836\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30836 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2019-10-31_101709-1024x394-1.png\" alt=\"mot-so-thong-ke-thu-vi-ve-ngay-sinh-cua-ban-1\" width=\"1024\" height=\"394\" title=\"2019-10-31_101709-1024x394-1\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mot_vai_thong_ke_khac\"><\/span>M\u1ed9t v\u00e0i th\u1ed1ng k\u00ea kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Tong_so_ngay_Thu_7_ban_da_trai_qua_trong_doi\"><\/span>T\u1ed5ng s\u1ed1 ng\u00e0y Th\u1ee9 7 b\u1ea1n \u0111\u00e3 tr\u1ea3i qua trong \u0111\u1eddi<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3 b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m\u00a0NETWORKDAYS.INTL<\/p>\n<p>C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=NETWORKDAYS.INTL(&lt;ng\u00e0y sinh c\u1ee7a b\u1ea1n&gt;, &lt;ng\u00e0y hi\u1ec7n t\u1ea1i&gt;,\u201d1111101\u2033)<\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Tong_so_ngay_Chu_nhat_ban_da_trai_qua_trong_doi\"><\/span>T\u1ed5ng s\u1ed1 ng\u00e0y\u00a0Ch\u1ee7 nh\u1eadt\u00a0b\u1ea1n \u0111\u00e3 tr\u1ea3i qua trong \u0111\u1eddi<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<blockquote>\n<p>=NETWORKDAYS.INTL(&lt;ng\u00e0y sinh c\u1ee7a b\u1ea1n&gt;, &lt;ng\u00e0y hi\u1ec7n t\u1ea1i&gt;,\u201d1111110\u2033)<\/p>\n<\/blockquote>\n<p>\u0110\u1ec3 hi\u1ec3u h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m NETWORKDAYS.INTL, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam b\u00e0i vi\u1ebft sau:<\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xac-dinh-nhung-ngay-chu-nhat-trong-khoang-thoi-gian-bat-ky.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u00e1c \u0111\u1ecbnh nh\u1eefng ng\u00e0y Ch\u1ee7 nh\u1eadt trong kho\u1ea3ng th\u1eddi gian b\u1ea5t k\u1ef3<\/a><\/strong><\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tong_so_ngay_cuoi_tuan_ban_da_trai_qua_trong_doi\"><\/span>T\u1ed5ng s\u1ed1 ng\u00e0y cu\u1ed1i tu\u1ea7n b\u1ea1n \u0111\u00e3 tr\u1ea3i qua trong \u0111\u1eddi<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ng\u00e0y cu\u1ed1i tu\u1ea7n l\u00e0 Th\u1ee9 7 v\u00e0 Ch\u1ee7 nh\u1eadt, \u0111\u01a1n gi\u1ea3n nh\u1ea5t l\u00e0 b\u1ea1n ch\u1ec9 c\u1ea7n c\u1ed9ng 2 ch\u1ec9 ti\u00eau v\u1eeba t\u00ednh \u1edf tr\u00ean l\u1ea1i ho\u1eb7c c\u00f3 c\u00e1ch kh\u00e1c, c\u0169ng v\u1edbi h\u00e0m\u00a0NETWORKDAYS.INTL<\/p>\n<blockquote>\n<p>=NETWORKDAYS.INTL(&lt;ng\u00e0y sinh c\u1ee7a b\u1ea1n&gt;, &lt;ng\u00e0y hi\u1ec7n t\u1ea1i&gt;,\u201d1111100\u2033)<\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Hy v\u1ecdng qua b\u00e0i vi\u1ebft ng\u1eafn n\u00e0y c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong> b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 th\u1ed1ng k\u00ea \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 \u0111i\u1ec3m th\u00fa v\u1ecb v\u1ec1 ng\u00e0y th\u00e1ng n\u0103m sinh c\u1ee7a m\u00ecnh, B\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng v\u1ea5n \u0111\u1ec1 h\u01a1n n\u1eefa nh\u01b0 th\u1eed th\u1ed1ng k\u00ea xem b\u1ea1n \u0111\u00e3 tr\u1ea3i qua bao nhi\u00eau ng\u00e0y l\u1ec5 VD nh\u01b0 30\/04, 01\/05 b\u1eb1ng vi\u1ec7c v\u1eadn d\u1ee5ng c\u00e1c h\u00e0m Excel<\/p>\n<p><span style=\"font-size: 14pt\">Tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c li\u00ean quan ngay d\u01b0\u1edbi \u0111\u00e2y<\/span><\/p>\n<hr>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lap-cong-thuc-tinh-so-ngay-thu-viec-trong-thang-cua-nhan-su.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp c\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 ng\u00e0y th\u1eed vi\u1ec7c trong th\u00e1ng c\u1ee7a nh\u00e2n s\u1ef1<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-trong-excel-va-cac-vi-du-minh-hoa.html\">C\u00e1c h\u00e0m trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-weekday-trong-excel.html\">C\u00e1ch d\u00f9ng h\u00e0m weekday trong Excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/dem-ngay-lam-khong-tinh-ngay-nghi-tuan-va-ngay-le.html\">\u0110\u1ebfm s\u1ed1 ng\u00e0y l\u00e0m kh\u00f4ng t\u00ednh ng\u00e0y ngh\u1ec9 tu\u1ea7n v\u00e0 ng\u00e0y l\u1ec5<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-datediff-trong-vba-excel.html\"><em><strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m DATEDIF trong vba Excel<\/strong><\/em><\/a><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dem-so-ngay-thu-bay-chu-nhat-trong-mot-khoang-thoi-gian.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ebfm s\u1ed1 ng\u00e0y th\u1ee9 b\u1ea3y, ch\u1ee7 nh\u1eadt trong m\u1ed9t kho\u1ea3ng th\u1eddi gian<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xac-dinh-nhung-ngay-chu-nhat-trong-khoang-thoi-gian-bat-ky.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u00e1c \u0111\u1ecbnh nh\u1eefng ng\u00e0y Ch\u1ee7 nh\u1eadt trong kho\u1ea3ng th\u1eddi gian b\u1ea5t k\u1ef3<\/a><\/strong><\/em><\/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\/2024\/12\/vba101_92019-nho-100.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3128,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3127","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3127","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=3127"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3127\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3128"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}