{"id":98419,"date":"2024-09-18T10:53:23","date_gmt":"2024-09-18T03:53:23","guid":{"rendered":"https:\/\/phongvu.vn\/cong-nghe\/?p=98419"},"modified":"2025-03-25T15:34:02","modified_gmt":"2025-03-25T08:34:02","slug":"cach-tinh-so-ngay-trong-excel-don-gian-nhat","status":"publish","type":"post","link":"https:\/\/phongvu.vn\/cong-nghe\/cach-tinh-so-ngay-trong-excel-don-gian-nhat\/","title":{"rendered":"B\u1ecf t\u00fai 3+ c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel d\u1ec5 hi\u1ec3u v\u00e0 chi ti\u1ebft nh\u1ea5t"},"content":{"rendered":"\n<p>Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 ti\u1ec7n \u00edch h\u1ed7 tr\u1ee3 r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n, \u0111\u1eb7c bi\u1ec7t l\u00e0 trong vi\u1ec7c t\u00ednh to\u00e1n s\u1ed1 ng\u00e0y. T\u1eeb vi\u1ec7c t\u00ednh s\u1ed1 ng\u00e0y gi\u1eefa hai ng\u00e0y, trong m\u1ed9t th\u00e1ng, m\u1ed9t n\u0103m, \u0111\u1ebfn t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c ho\u1eb7c theo \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3, Excel \u0111\u1ec1u c\u00f3 c\u00e1c h\u00e0m v\u00e0 c\u00f4ng th\u1ee9c gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u1ee7a <a href=\"https:\/\/phongvu.vn\/cong-nghe\/\" target=\"_blank\" rel=\"noreferrer noopener\">Phong V\u0169 Tech News<\/a> v\u1ec1 c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 quan t\u00e2m.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<ul>\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/mail-merge-la-gi-huong-dan-su-dung-mail-merge-trong-word-excel-co-the-ban-quan-tam\/\" target=\"_blank\" rel=\"noreferrer noopener\">Mail merge l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng mail merge trong Word, Excel c\u00f3 th\u1ec3 b\u1ea1n quan t\u00e2m&nbsp;<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/top-6-website-ho-tro-chuyen-file-pdf-sang-excel-khong-phai-ai-cung-biet\/\" target=\"_blank\" rel=\"noreferrer noopener\">Top 6 website h\u1ed7 tr\u1ee3 chuy\u1ec3n file PDF sang Excel kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-product-trong-excel-la-gi\/\" target=\"_blank\" rel=\"noreferrer noopener\">H\u00e0m Product trong Excel l\u00e0 g\u00ec \u2013 C\u00e1c l\u01b0u \u00fd v\u00e0 v\u00ed d\u1ee5 s\u1eed d\u1ee5ng h\u00e0m Product<\/a><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_55 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-6a19d722cb0d3\" ><span class=\"\"><span style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-6a19d722cb0d3\"  type=\"checkbox\" id=\"item-6a19d722cb0d3\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-tinh-so-ngay-trong-excel-don-gian-nhat\/#Tinh_so_ngay_giua_hai_ngay\" title=\"T\u00ednh s\u1ed1 ng\u00e0y gi\u1eefa hai ng\u00e0y\">T\u00ednh s\u1ed1 ng\u00e0y gi\u1eefa hai ng\u00e0y<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-tinh-so-ngay-trong-excel-don-gian-nhat\/#Tinh_so_ngay_trong_mot_thang_hoac_nam_cu_the\" title=\"T\u00ednh s\u1ed1 ng\u00e0y trong m\u1ed9t th\u00e1ng ho\u1eb7c n\u0103m c\u1ee5 th\u1ec3\">T\u00ednh s\u1ed1 ng\u00e0y trong m\u1ed9t th\u00e1ng ho\u1eb7c n\u0103m c\u1ee5 th\u1ec3<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-tinh-so-ngay-trong-excel-don-gian-nhat\/#Tinh_so_ngay_lam_viec_ngoai_tru_cuoi_tuan\" title=\"T\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c (ngo\u1ea1i tr\u1eeb cu\u1ed1i tu\u1ea7n)\">T\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c (ngo\u1ea1i tr\u1eeb cu\u1ed1i tu\u1ea7n)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-tinh-so-ngay-trong-excel-don-gian-nhat\/#Tinh_so_ngay_trong_Excel_theo_dieu_kien_cu_the\" title=\"T\u00ednh s\u1ed1 ng\u00e0y trong Excel theo \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3\">T\u00ednh s\u1ed1 ng\u00e0y trong Excel theo \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-tinh-so-ngay-trong-excel-don-gian-nhat\/#Mot_so_luu_y_khi_tinh_so_ngay_trong_Excel\" title=\"M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi t\u00ednh s\u1ed1 ng\u00e0y trong Excel\">M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi t\u00ednh s\u1ed1 ng\u00e0y trong Excel<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tinh_so_ngay_giua_hai_ngay\"><\/span><strong>T\u00ednh s\u1ed1 ng\u00e0y gi\u1eefa hai ng\u00e0y<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-2-1024x640.jpg\" alt=\"C\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 ng\u00e0y gi\u1eefa hai ng\u00e0y tr\u00ean ph\u1ea7n m\u1ec1m Excel\" class=\"wp-image-98420\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-2-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-2-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-2-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-2-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-2-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-2-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-2-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-2-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-2-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-2-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-2.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 ng\u00e0y gi\u1eefa hai ng\u00e0y tr\u00ean ph\u1ea7n m\u1ec1m Excel<\/figcaption><\/figure>\n\n\n\n<p>\u0110\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y gi\u1eefa hai ng\u00e0y trong Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m DATEDIF ho\u1eb7c th\u1ef1c hi\u1ec7n ph\u00e9p tr\u1eeb tr\u1ef1c ti\u1ebfp gi\u1eefa hai ng\u00e0y. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u v\u00e0 tham kh\u1ea3o:<\/p>\n\n\n\n<p>1. S\u1eed d\u1ee5ng ph\u00e9p tr\u1eeb tr\u1ef1c ti\u1ebfp:<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c<\/strong>: =Ng\u00e0y_k\u1ebft_th\u00fac &#8211; Ng\u00e0y_b\u1eaft_\u0111\u1ea7u<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5<\/strong>: =B2 &#8211; A2 (Trong \u0111\u00f3, B2 l\u00e0 ng\u00e0y k\u1ebft th\u00fac v\u00e0 A2 l\u00e0 ng\u00e0y b\u1eaft \u0111\u1ea7u)<\/p>\n\n\n\n<p>2. S\u1eed d\u1ee5ng h\u00e0m DATEDIF:<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c<\/strong>: =DATEDIF(Ng\u00e0y_b\u1eaft_\u0111\u1ea7u, Ng\u00e0y_k\u1ebft_th\u00fac, &#8220;d&#8221;)<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5<\/strong>: =DATEDIF(A2, B2, &#8220;d&#8221;) (Trong \u0111\u00f3, &#8220;d&#8221; \u0111\u1ea1i di\u1ec7n cho s\u1ed1 ng\u00e0y gi\u1eefa hai ng\u00e0y).<\/p>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Tinh_so_ngay_trong_mot_thang_hoac_nam_cu_the\"><\/span><strong>T\u00ednh s\u1ed1 ng\u00e0y trong m\u1ed9t th\u00e1ng ho\u1eb7c n\u0103m c\u1ee5 th\u1ec3<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-1-1024x640.jpg\" alt=\"C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong m\u1ed9t n\u0103m c\u1ee5 th\u1ec3 b\u1eb1ng c\u00f4ng th\u1ee9c DATE tr\u00ean Excel\" class=\"wp-image-98421\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-1-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-1-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-1-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-1-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-1-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-1-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-1-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-1-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-1-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-1-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-1.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong m\u1ed9t n\u0103m c\u1ee5 th\u1ec3 b\u1eb1ng c\u00f4ng th\u1ee9c DATE tr\u00ean Excel<\/figcaption><\/figure>\n\n\n\n<p>\u0110\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y trong m\u1ed9t th\u00e1ng ho\u1eb7c n\u0103m c\u1ee5 th\u1ec3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m EOMONTH ho\u1eb7c DATE trong Excel. Sau \u0111\u00f3 th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n theo c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n\n\n\n<p>1. T\u00ednh s\u1ed1 ng\u00e0y trong m\u1ed9t th\u00e1ng:<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c<\/strong>: =DAY(EOMONTH(Ng\u00e0y, 0))<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5<\/strong>: =DAY(EOMONTH(A2, 0)) (Trong \u0111\u00f3, A2 ch\u1ee9a ng\u00e0y thu\u1ed9c th\u00e1ng b\u1ea1n mu\u1ed1n t\u00ednh)<\/p>\n\n\n\n<p>2. T\u00ednh s\u1ed1 ng\u00e0y trong m\u1ed9t n\u0103m:<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c cho n\u0103m th\u01b0\u1eddng<\/strong>: =DATE(N\u0103m+1, 1, 1) &#8211; DATE(N\u0103m, 1, 1)<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5<\/strong>: =DATE(2025, 1, 1) &#8211; DATE(2024, 1, 1)<\/p>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Tinh_so_ngay_lam_viec_ngoai_tru_cuoi_tuan\"><\/span><strong>T\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c (ngo\u1ea1i tr\u1eeb cu\u1ed1i tu\u1ea7n)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-3-1024x640.jpg\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c trong th\u00e1ng tr\u1eeb cu\u1ed1i tu\u1ea7n\" class=\"wp-image-98422\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-3-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-3-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-3-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-3-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-3-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-3-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-3-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-3-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-3-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-3-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-3.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">H\u01b0\u1edbng d\u1eabn c\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c trong th\u00e1ng tr\u1eeb cu\u1ed1i tu\u1ea7n<\/figcaption><\/figure>\n\n\n\n<p>\u0110\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m NETWORKDAYS ho\u1eb7c NETWORKDAYS.INTL trong Excel. H\u00e0m n\u00e0y s\u1ebd gi\u00fap b\u1ea1n t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c gi\u1eefa hai ng\u00e0y, t\u1ef1 \u0111\u1ed9ng lo\u1ea1i tr\u1eeb c\u00e1c ng\u00e0y cu\u1ed1i tu\u1ea7n (th\u1ee9 7, ch\u1ee7 nh\u1eadt).<\/p>\n\n\n\n<p>1. T\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c chu\u1ea9n:<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c<\/strong>: =NETWORKDAYS(Ng\u00e0y_b\u1eaft_\u0111\u1ea7u, Ng\u00e0y_k\u1ebft_th\u00fac)<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5<\/strong>: =NETWORKDAYS(A2, B2)<\/p>\n\n\n\n<p>2. T\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c v\u1edbi t\u00f9y ch\u1ecdn ng\u00e0y cu\u1ed1i tu\u1ea7n:<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c<\/strong>: =NETWORKDAYS.INTL(Ng\u00e0y_b\u1eaft_\u0111\u1ea7u, Ng\u00e0y_k\u1ebft_th\u00fac, &#8220;0101010&#8221;)<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5<\/strong>: =NETWORKDAYS.INTL(A2, B2, &#8220;0101010&#8221;) (Trong \u0111\u00f3 &#8220;0101010&#8221; \u0111\u1ea1i di\u1ec7n cho tu\u1ea7n l\u00e0m vi\u1ec7c t\u1eeb th\u1ee9 2 \u0111\u1ebfn th\u1ee9 6).<\/p>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Tinh_so_ngay_trong_Excel_theo_dieu_kien_cu_the\"><\/span><strong>T\u00ednh s\u1ed1 ng\u00e0y trong Excel theo \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-4-1024x640.jpg\" alt=\"C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y theo \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3 tr\u00ean Excel\" class=\"wp-image-98423\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-4-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-4-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-4-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-4-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-4-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-4-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-4-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-4-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-4-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-4-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/tinh-so-ngay-trong-excel-4.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y theo \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3 tr\u00ean Excel<\/figcaption><\/figure>\n\n\n\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh s\u1ed1 ng\u00e0y \u0111\u00e1p \u1ee9ng m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3 n\u00e0o \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m COUNTIF ho\u1eb7c SUMPRODUCT \u0111\u1ec3 l\u1ecdc ra nh\u1eefng ng\u00e0y \u0111\u00e1p \u1ee9ng y\u00eau c\u1ea7u. C\u00e1ch s\u1eed d\u1ee5ng 2 h\u00e0m n\u00e0y \u0111\u01b0\u1ee3c Phong V\u0169 Tech News h\u01b0\u1edbng d\u1eabn \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/p>\n\n\n\n<p>1. S\u1eed d\u1ee5ng h\u00e0m COUNTIF:<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c<\/strong>: =COUNTIF(Ph\u1ea1m_vi_ng\u00e0y, &#8220;\u0110i\u1ec1u_ki\u1ec7n&#8221;)<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5<\/strong>: =COUNTIF(A2:A10, &#8220;&gt;01\/01\/2024&#8221;) (\u0110\u1ebfm s\u1ed1 ng\u00e0y sau 01\/01\/2024)<\/p>\n\n\n\n<p>2. S\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT:<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c<\/strong>: =SUMPRODUCT((Ph\u1ea1m_vi_ng\u00e0y&gt;=Ng\u00e0y_b\u1eaft_\u0111\u1ea7u)*(Ph\u1ea1m_vi_ng\u00e0y&lt;=Ng\u00e0y_k\u1ebft_th\u00fac))<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5<\/strong>: =SUMPRODUCT((A2:A10&gt;=DATE(2024,1,1))*(A2:A10&lt;=DATE(2024,12,31)))<\/p>\n\n\n\n<p>V\u1edbi c\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 ng\u00e0y trong Excel n\u00e0y, b\u1ea1n s\u1ebd d\u1ec5 d\u00e0ng t\u00ednh \u0111\u01b0\u1ee3c ng\u00e0y l\u00e0m vi\u1ec7c c\u1ee7a m\u00ecnh ch\u1ec9 v\u1edbi v\u00e0i b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n. L\u01b0u \u00fd, nh\u1eadp \u0111\u00fang s\u1ed1 ng\u00e0y \u0111\u1ec3 k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng \u0111\u01b0\u1ee3c ch\u00ednh x\u00e1c nh\u1ea5t nh\u00e9.<\/p>\n\n\n\n<div class=\"pv-products-card\"><div class=\"pv-products-title\"><div>Tham kh\u1ea3o m\u1ed9t s\u1ed1 d\u00f2ng laptop n\u1ed5i b\u1eadt, b\u00e1n ch\u1ea1y t\u1ea1i Phong V\u0169 d\u01b0\u1edbi \u0111\u00e2y:<\/div><\/div><div class=\"pv-products\" data-type=\"carousel\" data-key=\"product-area\" data-skus=\"220101409,230703418,230703419,230704076,231002798,231004204,240302749,240302752,240502377,240602773\"><\/div><\/div>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Mot_so_luu_y_khi_tinh_so_ngay_trong_Excel\"><\/span><strong>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi t\u00ednh s\u1ed1 ng\u00e0y trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Khi th\u1ef1c hi\u1ec7n t\u00ednh s\u1ed1 ng\u00e0y tr\u00ean Excel, \u0111\u1ec3 k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng \u0111\u01b0\u1ee3c ch\u00ednh x\u00e1c nh\u1ea5t ng\u01b0\u1eddi d\u00f9ng c\u1ea7n ph\u1ea3i ch\u00fa \u00fd \u0111\u1ebfn nh\u1eefng v\u1ea5n \u0111\u1ebfn nh\u01b0 sau:<\/p>\n\n\n\n<ul>\n<li><strong>\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng<\/strong>: \u0110\u1ea3m b\u1ea3o r\u1eb1ng c\u00e1c \u00f4 ch\u1ee9a ng\u00e0y th\u00e1ng trong Excel \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u00fang (theo chu\u1ea9n ng\u00e0y th\u00e1ng c\u1ee7a h\u1ec7 th\u1ed1ng) \u0111\u1ec3 tr\u00e1nh sai s\u00f3t khi t\u00ednh to\u00e1n.<\/li>\n\n\n\n<li><strong>Ki\u1ec3m tra k\u1ebft qu\u1ea3<\/strong>: Sau khi \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c, h\u00e3y ki\u1ec3m tra k\u1ebft qu\u1ea3 \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng n\u00f3 \u0111\u00fang v\u1edbi mong \u0111\u1ee3i c\u1ee7a b\u1ea1n.<\/li>\n\n\n\n<li><strong>Ng\u00e0y th\u00e1ng h\u1ee3p l\u1ec7<\/strong>: Khi nh\u1eadp ng\u00e0y th\u00e1ng v\u00e0o Excel, h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng b\u1ea1n nh\u1eadp \u0111\u00fang ng\u00e0y th\u00e1ng h\u1ee3p l\u1ec7 \u0111\u1ec3 tr\u00e1nh l\u1ed7i t\u00ednh to\u00e1n.<\/li>\n<\/ul>\n\n\n\n<p>V\u1edbi nh\u1eefng h\u01b0\u1edbng d\u1eabn tr\u00ean t\u1eeb Phong V\u0169 Tech News, hy v\u1ecdng b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u00ednh s\u1ed1 ng\u00e0y trong Excel theo nhu c\u1ea7u c\u1ee7a m\u00ecnh. C\u00e1c h\u00e0m v\u00e0 c\u00f4ng th\u1ee9c trong Excel r\u1ea5t linh ho\u1ea1t, gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n nhi\u1ec1u ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p h\u01a1n n\u1eefa. Do \u0111\u00f3, v\u1edbi m\u1ed7i tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3 h\u00e3y l\u1ef1a ch\u1ecdn c\u00f4ng th\u1ee9c ph\u00f9 h\u1ee3p \u0111\u1ec3 k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n \u0111\u01b0\u1ee3c ch\u00ednh x\u00e1c h\u01a1n nh\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 ti\u1ec7n \u00edch h\u1ed7 tr\u1ee3 r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n, \u0111\u1eb7c bi\u1ec7t l\u00e0 trong vi\u1ec7c t\u00ednh to\u00e1n s\u1ed1 ng\u00e0y. T\u1eeb vi\u1ec7c t\u00ednh s\u1ed1 ng\u00e0y gi\u1eefa hai ng\u00e0y, trong m\u1ed9t th\u00e1ng, m\u1ed9t n\u0103m, \u0111\u1ebfn t\u00ednh s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c ho\u1eb7c theo \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3, Excel \u0111\u1ec1u c\u00f3 c\u00e1c h\u00e0m [&hellip;]<\/p>\n","protected":false},"author":28,"featured_media":122201,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[24,1029],"tags":[],"_links":{"self":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/98419"}],"collection":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/comments?post=98419"}],"version-history":[{"count":5,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/98419\/revisions"}],"predecessor-version":[{"id":122202,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/98419\/revisions\/122202"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media\/122201"}],"wp:attachment":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media?parent=98419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/categories?post=98419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/tags?post=98419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}