{"id":8627,"date":"2024-12-23T04:02:47","date_gmt":"2024-12-23T04:02:47","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/23\/huong-dan-cach-tinh-khoang-cach-giua-hai-ngay-trong-excel\/"},"modified":"2024-12-23T04:02:47","modified_gmt":"2024-12-23T04:02:47","slug":"huong-dan-cach-tinh-khoang-cach-giua-hai-ngay-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/23\/huong-dan-cach-tinh-khoang-cach-giua-hai-ngay-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ednh kho\u1ea3ng c\u00e1ch gi\u1eefa hai ng\u00e0y 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> v\u00e0 b\u1ea1n s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u nh\u1eefng c\u00e1ch t\u00ednh kho\u1ea3ng c\u00e1ch gi\u1eefa hai ng\u00e0y trong Excel. Y\u00eau c\u1ea7u n\u00e0y th\u01b0\u1eddng th\u1ea5y trong c\u00e1c c\u00f4ng vi\u1ec7c li\u00ean quan t\u1edbi t\u00ednh ng\u00e0y th\u1ef1c hi\u1ec7n h\u1ee3p \u0111\u1ed3ng, th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c\u2026 H\u00e0m s\u1eed d\u1ee5ng ch\u1ee7 y\u1ebfu l\u00e0 h\u00e0m DATEDIF.<\/em><\/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-6768e0e622110\" 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-khoang-cach-giua-hai-ngay-trong-excel.html#Tinh_so_ngay_tu_ngay_bat_dau_toi_ngay_ket_thuc\" title=\"T\u00ednh s\u1ed1 ng\u00e0y t\u1eeb ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u t\u1edbi ng\u00e0y k\u1ebft th\u00fac\">T\u00ednh s\u1ed1 ng\u00e0y t\u1eeb ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u t\u1edbi ng\u00e0y k\u1ebft th\u00fac<\/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-khoang-cach-giua-hai-ngay-trong-excel.html#Tinh_so_tuan_giua_hai_ngay\" title=\"T\u00ednh s\u1ed1 tu\u1ea7n gi\u1eefa hai ng\u00e0y\">T\u00ednh s\u1ed1 tu\u1ea7n gi\u1eefa hai ng\u00e0y<\/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-khoang-cach-giua-hai-ngay-trong-excel.html#Tinh_so_thang_giua_hai_ngay\" title=\"T\u00ednh s\u1ed1 th\u00e1ng gi\u1eefa hai ng\u00e0y\">T\u00ednh s\u1ed1 th\u00e1ng gi\u1eefa hai ng\u00e0y<\/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-khoang-cach-giua-hai-ngay-trong-excel.html#Tinh_so_nam_giua_hai_ngay\" title=\"T\u00ednh s\u1ed1 n\u0103m\u00a0gi\u1eefa hai ng\u00e0y\">T\u00ednh s\u1ed1 n\u0103m\u00a0gi\u1eefa hai ng\u00e0y<\/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-khoang-cach-giua-hai-ngay-trong-excel.html#Tinh_so_thang_le_ngoai_cac_nam_tron\" title=\"T\u00ednh s\u1ed1 th\u00e1ng l\u1ebb ngo\u00e0i c\u00e1c n\u0103m tr\u00f2n\">T\u00ednh s\u1ed1 th\u00e1ng l\u1ebb ngo\u00e0i c\u00e1c n\u0103m tr\u00f2n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tinh_so_ngay_tu_ngay_bat_dau_toi_ngay_ket_thuc\"><\/span>T\u00ednh s\u1ed1 ng\u00e0y t\u1eeb ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u t\u1edbi ng\u00e0y k\u1ebft th\u00fac<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 t\u00ednh kho\u1ea3ng c\u00e1ch ng\u00e0y gi\u1eefa 2 th\u1eddi\u00a0\u0111i\u1ec3m: t\u1eeb ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u t\u1edbi ng\u00e0y k\u1ebft th\u00fac, ch\u00fang ta c\u00f3 2 c\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27394\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/datedif-theo-so-ngay-1.png\" width=\"703\" height=\"122\" title=\"datedif-theo-so-ngay-1\"><\/p>\n<p><strong>C\u00e1ch 1<\/strong>: D\u00f9ng ph\u00e9p tr\u1eeb tr\u1ef1c ti\u1ebfp gi\u1eefa 2 m\u1ed1c ng\u00e0y: Ng\u00e0y k\u1ebft th\u00fac \u2013 Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u<\/p>\n<p>K\u1ebft qu\u1ea3 gi\u1ed1ng nh\u01b0 t\u1ea1i\u00a0\u00f4 C2 trong h\u00ecnh tr\u00ean.<\/p>\n<p><strong>C\u00e1ch 2<\/strong>: S\u1eed d\u1ee5ng h\u00e0m DATEDIF theo\u00a0\u0111\u01a1n v\u1ecb t\u00ednh l\u00e0 s\u1ed1 ng\u00e0y<\/p>\n<p>C\u1ea5u tr\u00fac: DATEDIF(Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u, Ng\u00e0y k\u1ebft th\u00fac, \u201cd\u201d)<\/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-798.gif\" title=\"ex101_92019-nho-798\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>K\u00fd hi\u1ec7u \u201cd\u201d\u00a0\u0111\u1ea1i di\u1ec7n cho Ng\u00e0y (Day)<\/p>\n<p>Ta th\u1ea5y k\u1ebft qu\u1ea3 c\u1ee7a c\u1ea3 2 c\u00e1ch t\u00ednh\u00a0\u0111\u1ec1u b\u1eb1ng nhau.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tinh_so_tuan_giua_hai_ngay\"><\/span>T\u00ednh s\u1ed1 tu\u1ea7n gi\u1eefa hai ng\u00e0y<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea3n th\u00e2n h\u00e0m DATEDIF kh\u00f4ng c\u00f3\u00a0\u0111\u01a1n v\u1ecb t\u00ednh l\u00e0 Tu\u1ea7n, nh\u01b0ng d\u1ef1a v\u00e0o\u00a0\u0111\u1eb7c\u00a0\u0111i\u1ec3m: 1 tu\u1ea7n lu\u00f4n c\u00f3 7 ng\u00e0y, do\u00a0\u0111\u00f3 ta c\u00f3 th\u1ec3 l\u00e0m nh\u01b0 sau:<\/p>\n<p>L\u1ea5y k\u1ebft qu\u1ea3 h\u00e0m DATEDIF theo ng\u00e0y chia cho s\u1ed1 7<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27395\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/datedif-theo-so-tuan-1.png\" width=\"702\" height=\"122\" title=\"datedif-theo-so-tuan-1\"><\/p>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 D2 cho ch\u00fang ta k\u1ebft qu\u1ea3 t\u00ednh theo s\u1ed1 tu\u1ea7n gi\u1eefa hai ng\u00e0y: T\u1eeb ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u t\u1edbi Ng\u00e0y k\u1ebft th\u00fac:<\/p>\n<p style=\"padding-left: 30px\">=DATEDIF(A2,B2,\u201dd\u201d)\/7<\/p>\n<p>\u0110\u1ec3 t\u00ednh theo tr\u00f2n s\u1ed1 tu\u1ea7n (\u0111\u1ee7 tu\u1ea7n), ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m lo\u1ea1i b\u1ecf ph\u1ea7n th\u1eadp ph\u00e2n l\u00e0 h\u00e0m TRUNC ho\u1eb7c <a href=\"http:\/\/blog.ezworkapp.com\/ham-int-ham-lay-phan-nguyen-trong-excel.html\"><strong>h\u00e0m INT<\/strong><\/a><\/p>\n<p style=\"padding-left: 30px\">=TRUNC(DATEDIF(A2,B2,\u201dd\u201d)\/7, 0)<\/p>\n<p style=\"padding-left: 30px\">=INT(DATEDIF(A2,B2,\u201dd\u201d)\/7)<\/p>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cach-tim-phan-nguyen-cua-phep-chia-voi-ham-quotient-va-ham-int.html\">C\u00e1ch t\u00ecm ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia v\u1edbi h\u00e0m QUOTIENT v\u00e0 h\u00e0m INT<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tinh_so_thang_giua_hai_ngay\"><\/span>T\u00ednh s\u1ed1 th\u00e1ng gi\u1eefa hai ng\u00e0y<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 t\u00ednh s\u1ed1 th\u00e1ng, ch\u00fang ta s\u1eed d\u1ee5ng tham s\u1ed1 \u201cm\u201d trong h\u00e0m DATEDIF nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27402\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/datedif-theo-so-thang-1.png\" width=\"873\" height=\"117\" title=\"datedif-theo-so-thang-1\"><\/p>\n<p style=\"padding-left: 30px\">=DATEDIF(Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u, Ng\u00e0y k\u1ebft th\u00fac, \u201cm\u201d)<\/p>\n<p>S\u1ed1 th\u00e1ng\u00a0\u0111\u01b0\u1ee3c t\u00ednh trong h\u00e0m DATEDIF\u00a0tr\u00ean nguy\u00ean t\u1eafc tr\u00f2n ng\u00e0y,\u00a0\u0111\u1ee7 ng\u00e0y ch\u1ee9 kh\u00f4ng\u00a0\u0111\u01a1n thu\u1ea7n ch\u1ec9 x\u00e9t ch\u00eanh l\u1ec7ch s\u1ed1 th\u00e1ng.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tinh_so_nam_giua_hai_ngay\"><\/span>T\u00ednh s\u1ed1 n\u0103m\u00a0gi\u1eefa hai ng\u00e0y<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 t\u00ednh s\u1ed1 th\u00e1ng, ch\u00fang ta s\u1eed d\u1ee5ng tham s\u1ed1 \u201cy\u201d trong h\u00e0m DATEDIF nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-27416\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/datedif-theo-so-nam-01-1024x113-2.png\" width=\"1024\" height=\"113\" title=\"datedif-theo-so-nam-01-1024x113-2\"><\/p>\n<p>T\u1ea1i\u00a0\u00f4 F2 d\u00f9ng c\u00f4ng th\u1ee9c x\u00e1c\u00a0\u0111\u1ecbnh s\u1ed1 n\u0103m:<\/p>\n<p style=\"padding-left: 30px\">=DATEDIF(Ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u, Ng\u00e0y k\u1ebft th\u00fac, \u201cy\u201d)<\/p>\n<p>S\u1ed1 n\u0103m\u00a0\u0111\u01b0\u1ee3c t\u00ednh trong <strong><a href=\"http:\/\/blog.ezworkapp.com\/tinh-khoang-thoi-gian-giua-2-thoi-diem-ham-datedif-trong-excel.html\">h\u00e0m DATEDIF<\/a><\/strong>\u00a0\u0111\u01b0\u1ee3c t\u00ednh tr\u00ean nguy\u00ean t\u1eafc\u00a0\u0111\u1ee7 ng\u00e0y.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tinh_so_thang_le_ngoai_cac_nam_tron\"><\/span>T\u00ednh s\u1ed1 th\u00e1ng l\u1ebb ngo\u00e0i c\u00e1c n\u0103m tr\u00f2n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 t\u00ednh s\u1ed1 th\u00e1ng l\u1ebb ngo\u00e0i s\u1ed1 n\u0103m, ta c\u00f3 th\u1ec3 t\u00ednh theo 2 c\u00e1ch:<\/p>\n<p><strong>C\u00e1ch 1<\/strong>: T\u00ednh s\u1ed1 th\u00e1ng \u2013 (S\u1ed1 n\u0103m * 12)<\/p>\n<p><strong>C\u00e1ch 2<\/strong>: S\u1eed d\u1ee5ng h\u00e0m DATEDIF v\u1edbi tham s\u1ed1 l\u00e0 \u201cym\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27417\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/datedif-theo-so-thang-le-1.png\" width=\"877\" height=\"124\" title=\"datedif-theo-so-thang-le-1\"><\/p>\n<p>Trong\u00a0\u00f4 E2, c\u00f4ng th\u1ee9c Datedif s\u1eed d\u1ee5ng l\u00e0:<\/p>\n<p style=\"padding-left: 30px\">=DATEDIF(A2,B2,\u201dym\u201d)<\/p>\n<p>K\u1ebft qu\u1ea3: 16 th\u00e1ng = 1 n\u0103m + 4 th\u00e1ng l\u1ebb<\/p>\n<p>Nh\u01b0 v\u1eady\u00a0\u0111\u1ec3 t\u00ednh kho\u1ea3ng c\u00e1ch gi\u1eefa hai ng\u00e0y theo S\u1ed1 ng\u00e0y, S\u1ed1 tu\u1ea7n, S\u1ed1 th\u00e1ng, S\u1ed1 n\u0103m, S\u1ed1 th\u00e1ng l\u1ebb\u2026 ch\u00fang ta\u00a0\u0111\u1ec1u c\u00f3 th\u1ec3 ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m DATEDIF l\u00e0 c\u00f3 th\u1ec3 ra k\u1ebft qu\u1ea3 ngay.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1\u00a0\u1ee9ng d\u1ee5ng c\u1ee7a vi\u1ec7c t\u00ednh kho\u1ea3ng c\u00e1ch gi\u1eefa hai ng\u00e0y, hai th\u1eddi\u00a0\u0111i\u1ec3m trong\u00a0Excel:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tinh-thoi-gian-lam-viec-giua-hai-thoi-diem-cu-the-theo-ngay-thang-nam.html\">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<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-thiet-lap-tu-dong-canh-bao-hop-dong-lao-dong-sap-het-han-tren-file-excel.html\">C\u00e1ch thi\u1ebft l\u1eadp t\u1ef1 \u0111\u1ed9ng c\u1ea3nh b\u00e1o h\u1ee3p \u0111\u1ed3ng lao \u0111\u1ed9ng s\u1eafp h\u1ebft h\u1ea1n tr\u00ean file 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-798.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8628,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8627","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\/8627","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=8627"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8627\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8628"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8627"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8627"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}