{"id":9036,"date":"2024-12-31T15:40:42","date_gmt":"2024-12-31T15:40:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/31\/huong-dan-cach-tinh-thoi-gian-lam-viec-giua-hai-thoi-diem-cu-the-theo-ngay-thang-nam\/"},"modified":"2024-12-31T15:40:42","modified_gmt":"2024-12-31T15:40:42","slug":"huong-dan-cach-tinh-thoi-gian-lam-viec-giua-hai-thoi-diem-cu-the-theo-ngay-thang-nam","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/31\/huong-dan-cach-tinh-thoi-gian-lam-viec-giua-hai-thoi-diem-cu-the-theo-ngay-thang-nam\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ednh th\u1eddi gian l\u00e0m vi\u1ec7c gi\u1eefa hai th\u1eddi \u0111i\u1ec3m c\u1ee5 th\u1ec3 theo ng\u00e0y th\u00e1ng n\u0103m"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong m\u1ed9t s\u1ed1 n\u01a1i c\u00f3 quy\u00a0\u0111\u1ecbnh t\u00ednh th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c c\u1ee5 th\u1ec3 ra bao nhi\u00eau n\u0103m, bao nhi\u00eau th\u00e1ng v\u00e0 bao nhi\u00eau ng\u00e0y t\u00ednh t\u1eeb th\u1eddi\u00a0\u0111i\u1ec3m ng\u00e0y v\u00e0o l\u00e0m\u00a0\u0111\u1ebfn 1 m\u1ed1c c\u1ee5 th\u1ec3. V\u1eady\u00a0c\u00f4ng th\u1ee9c n\u00e0o gi\u00fap ch\u00fang ta l\u00e0m\u00a0\u0111\u01b0\u1ee3c vi\u1ec7c n\u00e0y? H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u\u00a0c\u00e1ch t\u00ednh th\u1eddi gian l\u00e0m vi\u1ec7c gi\u1eefa hai th\u1eddi \u0111i\u1ec3m c\u1ee5 th\u1ec3 theo ng\u00e0y th\u00e1ng n\u0103m trong\u00a0Excel nh\u00e9.<\/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-6774107a18d3b\" 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\/huong-dan-cach-tinh-thoi-gian-lam-viec-giua-hai-thoi-diem-cu-the-theo-ngay-thang-nam.html#Yeu_cau_tinh_tham_nien_lam_viec_theo_cu_the_ngay_thang_nam\" title=\"Y\u00eau c\u1ea7u t\u00ednh th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c theo c\u1ee5 th\u1ec3 ng\u00e0y th\u00e1ng n\u0103m\">Y\u00eau c\u1ea7u t\u00ednh th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c theo c\u1ee5 th\u1ec3 ng\u00e0y th\u00e1ng n\u0103m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tinh-thoi-gian-lam-viec-giua-hai-thoi-diem-cu-the-theo-ngay-thang-nam.html#Nguyen_tac_tinh_khoang_thoi_gian_tham_nien\" title=\"Nguy\u00ean t\u1eafc t\u00ednh kho\u1ea3ng th\u1eddi gian th\u00e2m ni\u00ean\">Nguy\u00ean t\u1eafc t\u00ednh kho\u1ea3ng th\u1eddi gian th\u00e2m ni\u00ean<\/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\/huong-dan-cach-tinh-thoi-gian-lam-viec-giua-hai-thoi-diem-cu-the-theo-ngay-thang-nam.html#Cong_thuc_tinh_tham_nien_lam_viec_theo_so_nam\" title=\"C\u00f4ng th\u1ee9c t\u00ednh th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c\u00a0theo s\u1ed1 n\u0103m\">C\u00f4ng th\u1ee9c t\u00ednh th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c\u00a0theo s\u1ed1 n\u0103m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tinh-thoi-gian-lam-viec-giua-hai-thoi-diem-cu-the-theo-ngay-thang-nam.html#Cong_thuc_tinh_tham_nien_lam_viec_theo_so_thang\" title=\"C\u00f4ng th\u1ee9c t\u00ednh th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c theo s\u1ed1\u00a0th\u00e1ng\">C\u00f4ng th\u1ee9c t\u00ednh th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c theo s\u1ed1\u00a0th\u00e1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tinh-thoi-gian-lam-viec-giua-hai-thoi-diem-cu-the-theo-ngay-thang-nam.html#Cong_thuc_tinh_tham_nien_lam_viec_theo_so_ngay\" title=\"C\u00f4ng th\u1ee9c t\u00ednh th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c theo s\u1ed1 ng\u00e0y\">C\u00f4ng th\u1ee9c t\u00ednh th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c theo s\u1ed1 ng\u00e0y<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Yeu_cau_tinh_tham_nien_lam_viec_theo_cu_the_ngay_thang_nam\"><\/span>Y\u00eau c\u1ea7u t\u00ednh th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c theo c\u1ee5 th\u1ec3 ng\u00e0y th\u00e1ng n\u0103m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ed d\u1ee5 trong 1\u00a0\u0111\u01a1n v\u1ecb c\u00f3 th\u00f4ng tin nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25959\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/yeu-cau-tinh-tham-nien-theo-thang-va-nam.png\" width=\"522\" height=\"248\" title=\"yeu-cau-tinh-tham-nien-theo-thang-va-nam\"><\/p>\n<p>T\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi m\u1ed7i nh\u00e2n vi\u00ean\u00a0\u0111\u1ec1u c\u00f3 Ng\u00e0y v\u00e0o l\u00e0m c\u1ee5 th\u1ec3. T\u00ednh t\u1edbi ng\u00e0y 31\/12\/2018 (ng\u00e0y l\u00e0m m\u1ed1c) th\u00ec m\u1ed7i ng\u01b0\u1eddi\u00a0\u0111\u00e3 c\u00f3 th\u00e2m ni\u00ean l\u00e0 bao nhi\u00eau n\u0103m, th\u00e1ng, ng\u00e0y?<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nguyen_tac_tinh_khoang_thoi_gian_tham_nien\"><\/span>Nguy\u00ean t\u1eafc t\u00ednh kho\u1ea3ng th\u1eddi gian th\u00e2m ni\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 t\u00ednh kho\u1ea3ng th\u1eddi gian gi\u1eefa 2 th\u1eddi\u00a0\u0111i\u1ec3m, ch\u00fang ta\u00a0\u00e1p d\u1ee5ng theo c\u00e1c nguy\u00ean t\u1eafc sau:<\/p>\n<ul>\n<li>H\u00e0m s\u1eed d\u1ee5ng: <a href=\"http:\/\/blog.ezworkapp.com\/tinh-khoang-thoi-gian-giua-2-thoi-diem-ham-datedif-trong-excel.html\">DATEDIF<\/a><\/li>\n<li>H\u1ec7 s\u1ed1 quy\u00a0\u0111\u1ed5i: 1 n\u0103m = 12 th\u00e1ng<\/li>\n<li>Th\u1eddi\u00a0\u0111i\u1ec3m x\u00e9t th\u00e2m ni\u00ean: Ng\u00e0y l\u00e0m m\u1ed1c (trong\u00a0\u00f4 B2) lu\u00f4n l\u1ea5y ng\u00e0y cu\u1ed1i th\u00e1ng ho\u1eb7c ng\u00e0y cu\u1ed1i n\u0103m.<\/li>\n<\/ul>\n<p>Khi x\u00e9t v\u1edbi ng\u00e0y cu\u1ed1i th\u00e1ng ho\u1eb7c ng\u00e0y cu\u1ed1i n\u0103m l\u00e0m m\u1ed1c, ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3\u00a0\u0111\u01a1n gi\u1ea3n h\u00f3a logic t\u00ednh to\u00e1n r\u1ea5t nhi\u1ec1u cho\u00a0\u0111\u01a1n v\u1ecb Ng\u00e0y. V\u00e0 th\u1ef1c t\u1ebf c\u00f4ng vi\u1ec7c t\u00ednh th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c c\u0169ng th\u01b0\u1eddng x\u00e9t tr\u00ean c\u00e1c th\u1eddi\u00a0\u0111i\u1ec3m\u00a0\u0111\u00f3 ch\u1ee9 kh\u00f4ng ph\u1ea3i l\u00e0 1 ng\u00e0y b\u1ea5t k\u1ef3.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_tham_nien_lam_viec_theo_so_nam\"><\/span>C\u00f4ng th\u1ee9c t\u00ednh th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c\u00a0theo s\u1ed1 n\u0103m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u00c1p d\u1ee5ng h\u00e0m DATEDIF\u00a0\u0111\u1ec3 t\u00ednh s\u1ed1 n\u0103m gi\u1eefa 2 kho\u1ea3ng th\u1eddi gian:<\/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-851.gif\" title=\"ex101_92019-nho-851\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"padding-left: 30px\">=DATEDIF(<span style=\"color: #ff0000\">Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u<\/span>, <span style=\"color: #0000ff\">Ng\u00e0y k\u1ebft th\u00fac<\/span>, <span style=\"color: #993366\">\u201cy\u201d<\/span>)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u: t\u00ednh t\u1eeb\u00a0\u00f4 B4<\/li>\n<li>Ng\u00e0y k\u1ebft th\u00fac: t\u1ea1i\u00a0\u00f4 B2<\/li>\n<li>L\u01b0u\u00a0\u00fd tr\u01b0\u1eddng h\u1ee3p ng\u00e0y v\u00e0o l\u00e0m sau ng\u00e0y x\u00e9t l\u00e0m m\u1ed1c s\u1ebd ra k\u1ebft qu\u1ea3 l\u1ed7i cho h\u00e0m DATEDIF (Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u &gt; Ng\u00e0y k\u1ebft th\u00fac).<\/li>\n<\/ul>\n<p>D\u00f9ng h\u00e0m\u00a0IF\u00a0\u0111\u1ec3 bi\u1ec7n lu\u1eadn tr\u01b0\u1edbc cho tr\u01b0\u1eddng h\u1ee3p n\u00e0y. N\u1ebfu Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u &gt; Ng\u00e0y k\u1ebft th\u00fac th\u00ec tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 = 0<\/p>\n<p>C\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p>\u00a0<\/p>\n<p>C4=IF(B4&gt;$B$2,0,DATEDIF($B4,$B$2,\u201dy\u201d))<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25968\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-tinh-tham-nien-theo-so-nam-01.png\" width=\"649\" height=\"289\" title=\"cong-thuc-tinh-tham-nien-theo-so-nam-01\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_tham_nien_lam_viec_theo_so_thang\"><\/span>C\u00f4ng th\u1ee9c t\u00ednh th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c theo s\u1ed1\u00a0th\u00e1ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u00c1p d\u1ee5ng h\u00e0m DATEDIF\u00a0\u0111\u1ec3 t\u00ednh s\u1ed1\u00a0th\u00e1ng\u00a0gi\u1eefa 2 kho\u1ea3ng th\u1eddi gian:<\/p>\n<p style=\"padding-left: 30px\">=DATEDIF(<span style=\"color: #ff0000\">Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u<\/span>,\u00a0<span style=\"color: #0000ff\">Ng\u00e0y k\u1ebft th\u00fac<\/span>,\u00a0<span style=\"color: #993366\">\u201cm\u201d<\/span>)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u: t\u00ednh t\u1eeb\u00a0\u00f4 B4<\/li>\n<li>Ng\u00e0y k\u1ebft th\u00fac: t\u1ea1i\u00a0\u00f4 B2<\/li>\n<\/ul>\n<p>C\u00e1c tr\u01b0\u1eddng h\u1ee3p c\u1ea7n l\u01b0u\u00a0\u00fd:<\/p>\n<ul>\n<li>Bi\u1ec7n lu\u1eadn b\u1eb1ng h\u00e0m\u00a0IF cho tr\u01b0\u1eddng h\u1ee3p Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u &gt; Ng\u00e0y k\u1ebft th\u00fac th\u00ec tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 0<\/li>\n<li>K\u1ebft qu\u1ea3 h\u00e0m DATEDIF tr\u1ea3 v\u1ec1 t\u1ed5ng s\u1ed1 th\u00e1ng.\u00a0\u0110\u1ec3 t\u00ednh ra s\u1ed1 th\u00e1ng c\u00f2n l\u1ea1i trong n\u0103m th\u00ec s\u1ebd tr\u1eeb\u00a0\u0111i S\u1ed1 n\u0103m * 12 (s\u1ed1 n\u0103m\u00a0\u0111\u00e3 t\u00ednh\u00a0\u1edf tr\u00ean\u00a0\u0111\u01b0\u1ee3c quy\u00a0\u0111\u1ed5i v\u1ec1 th\u00e1ng)<\/li>\n<\/ul>\n<p>C\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p>\u00a0<\/p>\n<p>D4=IF(B4&gt;$B$2,0,DATEDIF($B4,$B$2,\u201dm\u201d)-C4*12)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25969\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-tinh-tham-nien-theo-so-thang-01.png\" width=\"705\" height=\"286\" title=\"cong-thuc-tinh-tham-nien-theo-so-thang-01\"><\/p>\n<p>Ho\u1eb7c\u00a0\u0111\u1ec3\u00a0\u0111\u01a1n gi\u1ea3n h\u01a1n, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c DATEDIF v\u1edbi tham s\u1ed1 cu\u1ed1i l\u00e0 \u201cym\u201d\u00a0\u0111\u1ec3 t\u00ednh s\u1ed1 th\u00e1ng c\u00f2n l\u1ea1i khi\u00a0\u0111\u00e3 bi\u1ebft s\u1ed1 n\u0103m:<\/p>\n<p style=\"padding-left: 30px\">=DATEDIF(<span style=\"color: #ff0000\">Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u<\/span>,\u00a0<span style=\"color: #0000ff\">Ng\u00e0y k\u1ebft th\u00fac<\/span>,\u00a0<span style=\"color: #993366\">\u201cym\u201d<\/span>)<\/p>\n<p>\u00c1p d\u1ee5ng v\u00e0o c\u00e1ch t\u00ednh c\u1ee5 th\u1ec3 ta c\u00f3:<\/p>\n<p>D4=IF(B4&gt;$B$2,0,DATEDIF($B4,$B$2,\u201dym\u201d))<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25973\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-tinh-tham-nien-theo-so-thang-03.png\" width=\"665\" height=\"288\" title=\"cong-thuc-tinh-tham-nien-theo-so-thang-03\"><\/p>\n<p>\u00a0<\/p>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a 2 c\u00e1ch vi\u1ebft l\u00e0 nh\u01b0 nhau. C\u00e1ch vi\u1ebft \u201cym\u201d ng\u1eafn h\u01a1n v\u00e0 logic\u00a0\u0111\u01a1n gi\u1ea3n h\u01a1n.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_tham_nien_lam_viec_theo_so_ngay\"><\/span>C\u00f4ng th\u1ee9c t\u00ednh th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c theo s\u1ed1 ng\u00e0y<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u01b0\u1eddng h\u1ee3p n\u00e0y t\u00ednh s\u1ed1 ng\u00e0y ch\u00ednh l\u00e0 s\u1ed1 ng\u00e0y c\u1ee7a Ng\u00e0y v\u00e0o l\u00e0m.<\/p>\n<p>Ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m DAY\u00a0\u0111\u1ec3 t\u00e1ch ph\u1ea7n s\u1ed1 ng\u00e0y n\u00e0y.<\/p>\n<p>L\u01b0u\u00a0\u00fd bi\u1ec7n lu\u1eadn th\u00eam tr\u01b0\u1eddng h\u1ee3p Ng\u00e0y v\u00e0o l\u00e0m &gt; Ng\u00e0y m\u1ed1c th\u00ec ph\u1ea3i tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 0 ng\u00e0y.<\/p>\n<p>C\u00f4ng th\u1ee9c c\u1ee5 th\u1ec3 l\u00e0:<\/p>\n<p>E4=IF(B4&gt;B2,0,DAY(B4))<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25975\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-tinh-tham-nien-theo-so-ngay.png\" width=\"524\" height=\"291\" title=\"cong-thuc-tinh-tham-nien-theo-so-ngay\"><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 file m\u1eabu trong b\u00e0i vi\u1ebft t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2H5kSTC\">http:\/\/bit.ly\/2H5kSTC<\/a><\/p>\n<p>\u00a0<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft v\u1ec1 h\u00e0m\u00a0Excel l\u00e0m vi\u1ec7c v\u1edbi Ng\u00e0y th\u00e1ng, th\u1eddi gian:<\/p>\n<p style=\"padding-left: 30px\"><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 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><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tim-ngay-dau-tien-cua-thang-voi-ham-day.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ecm ng\u00e0y \u0111\u1ea7u ti\u00ean c\u1ee7a th\u00e1ng v\u1edbi h\u00e0m DAY<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-tim-ngay-cuoi-cung-trong-thang-eomonth-trong-excel.html\">H\u00e0m t\u00ecm ng\u00e0y cu\u1ed1i c\u00f9ng trong th\u00e1ng EOMONTH trong Excel<\/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-851.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9037,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9036","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\/9036","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=9036"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9036\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9037"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}