{"id":20831,"date":"2021-03-20T11:08:17","date_gmt":"2021-03-20T04:08:17","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=20831"},"modified":"2021-10-15T15:28:24","modified_gmt":"2021-10-15T08:28:24","slug":"ham-tinh-so-ngay","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-tinh-so-ngay\/","title":{"rendered":"Chia s\u1ebb c\u00e1ch vi\u1ebft h\u00e0m t\u00ednh s\u1ed1 ng\u00e0y trong Excel nhanh ch\u00f3ng"},"content":{"rendered":"<p>Vi\u1ec7c t\u00ednh ng\u00e0y th\u00e1ng b\u1eb1ng ph\u01b0\u01a1ng ph\u00e1p th\u1ee7 c\u00f4ng ch\u1eafc ch\u1eafn s\u1ebd khi\u1ebfn cho b\u1ea1n c\u1ea3m th\u1ea5y v\u00f4 c\u00f9ng \u0111au \u0111\u1ea7u v\u00e0 m\u1ec7t m\u1ecfi. V\u00ec v\u1eady, nhi\u1ec1u ng\u01b0\u1eddi \u0111\u00e3 ngh\u0129 \u0111\u1ebfn gi\u1ea3i ph\u00e1p l\u00e0 t\u00ednh s\u1ed1 ng\u00e0y b\u1eb1ng c\u00f4ng c\u1ee5 excel \u0111\u1ec3 nhanh ch\u00f3ng v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian \u0111ang k\u1ec3. Tuy nhi\u00ean, c\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong excel kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft. Sau \u0111\u00e2y ch\u00fang t\u00f4i s\u1ebd chia s\u1ebb <strong>c\u00e1ch vi\u1ebft\u00a0h\u00e0m t\u00ednh s\u1ed1 ng\u00e0y\u00a0trong excel nhanh ch\u00f3ng<\/strong> cho b\u1ea1n. H\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft \u0111\u1ec3 c\u00f3 th\u00eam nh\u1eefng th\u00f4ng tin b\u1ed5 \u00edch nh\u00e9.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"303\" class=\"wp-image-24224 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/03\/ham-tinh-so-ngay-trong-excel.png\" alt=\"H\u00e0m t\u00ednh s\u1ed1 ng\u00e0y trong Excel\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/03\/ham-tinh-so-ngay-trong-excel.png 512w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/03\/ham-tinh-so-ngay-trong-excel-300x178.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/p>\n<h2><strong>L\u1ee3i \u00edch c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m t\u00ednh s\u1ed1 ng\u00e0y<\/strong><\/h2>\n<p>Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c cho vi\u1ec7c t\u00ednh to\u00e1n s\u1ed1 ng\u00e0y n\u00f3i ri\u00eang v\u00e0 vi\u1ec7c t\u00ednh to\u00e1n trong c\u00f4ng vi\u1ec7c n\u00f3i chung. Hi\u1ec7n nay, thay v\u00ec vi\u1ec7c ph\u1ea3i ng\u1ed3i \u0111au \u0111\u1ea7u nh\u1ee9c \u00f3c ngh\u0129 c\u00e1ch l\u00e0m sao \u0111\u1ec3 c\u00f3 th\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <strong>h\u00e0m t\u00ednh s\u1ed1 ng\u00e0y trong excel<\/strong> \u0111\u1ec3 h\u1ed7 tr\u1ee3. L\u1ee3i \u00edch khi s\u1eed d\u1ee5ng <strong>h\u00e0m t\u00ednh s\u1ed1 ng\u00e0y trong excel<\/strong> \u0111\u00f3 l\u00e0:<\/p>\n<ul>\n<li>C\u00f3 qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng, ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u th\u1eddi gian.<\/li>\n<li>C\u00f3 kh\u1ea3 n\u0103ng t\u00ednh to\u00e1n nhi\u1ec1u con s\u1ed1 c\u00f9ng m\u1ed9t l\u00fac m\u00e0 v\u1eabn cho k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i.<\/li>\n<li>H\u00e0m t\u00ednh s\u1ed1 ng\u00e0y kh\u00f4ng ch\u1ec9 gi\u00fap t\u00ednh s\u1ed1 ng\u00e0y hi\u1ec7u qu\u1ea3 m\u00e0 c\u00f2n gi\u00fap s\u1eafp x\u1ebfp v\u00e0 l\u1ecdc d\u1eef li\u1ec7u nhanh ch\u00f3ng.<\/li>\n<li>T\u00ednh \u0111\u01b0\u1ee3c kho\u1ea3ng c\u00e1ch s\u1ed1 ng\u00e0y tr\u00ean di\u1ec7n r\u1ed9ng, k\u1ec3 c\u1ea3 l\u00ean t\u1edbi v\u00e0i ch\u1ee5c hay v\u00e0i tr\u0103m ng\u00e0y.<\/li>\n<\/ul>\n<h2><strong>S\u1eed d\u1ee5ng h\u00e0m Datedif t\u00ednh s\u1ed1 ng\u00e0y trong excel nh\u01b0 th\u1ebf n\u00e0o?<\/strong><\/h2>\n<p>H\u1ea7u h\u1ebft m\u1ecdi ng\u01b0\u1eddi khi c\u00f3 nhu c\u1ea7u t\u00ednh s\u1ed1 ng\u00e0y th\u00ec \u0111\u1ec1u s\u1eed d\u1ee5ng h\u00e0m Datedif. H\u00e0m Datedif c\u00f3 c\u00e1ch t\u00ednh kh\u00f4ng qu\u00e1 kh\u00f3. \u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 ng\u00e0y k\u1ebft th\u00fac l\u00e0 \u0111\u01b0\u1ee3c. Sau \u0111\u00f3 h\u00e0m s\u1ebd \u0111\u01b0a ra cho b\u1ea1n k\u1ebft qu\u1ea3 bao g\u1ed3m: Kho\u1ea3ng c\u00e1ch ng\u00e0y, th\u00e1ng n\u0103m ho\u1eb7c cho \u0111\u1ed3ng th\u1eddi k\u1ebft qu\u1ea3 bao g\u1ed3m c\u1ea3 3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"318\" height=\"144\" class=\"wp-image-20835 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/03\/cach-tinh-so-ngay-trong-excel-1.jpg\" alt=\"C\u00e1c s\u1eed d\u1ee5ng h\u00e0m t\u00ednh s\u1ed1 ng\u00e0y Dateif - \u1ea2nh 1\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/03\/cach-tinh-so-ngay-trong-excel-1.jpg 318w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/03\/cach-tinh-so-ngay-trong-excel-1-300x136.jpg 300w\" sizes=\"auto, (max-width: 318px) 100vw, 318px\" \/><\/p>\n<p>H\u00e0m Datedif c\u00f3 c\u00fa ph\u00e1p c\u1ee5 th\u1ec3 nh\u01b0 sau: <strong>=DATEDIF(start_day,end_day,unit)<\/strong><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li><strong>Start_day:<\/strong> Ng\u00e0y \u0111\u1ea7u ti\u00ean ho\u1eb7c ng\u00e0y b\u1eaft \u0111\u1ea7u t\u00ednh trong kho\u1ea3ng th\u1eddi gian c\u1ea7n t\u00ednh.<\/li>\n<li><strong>End_day:<\/strong> Ng\u00e0y cu\u1ed1i c\u00f9ng ho\u1eb7c ng\u00e0y k\u1ebft th\u00fac c\u1ee7a kho\u1ea3ng th\u1eddi gian b\u1ea1n c\u1ea7n t\u00ednh \u0111\u00f3.<\/li>\n<li><strong>Unit:<\/strong> \u0111\u01a1n v\u1ecb(ng\u00e0y, th\u00e1ng, n\u0103m) m\u00e0 b\u1ea1n mu\u1ed1n h\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3.<\/li>\n<li>Unit l\u00e0 \u201cd\u201d ngh\u0129a l\u00e0 b\u1ea1n mu\u1ed1n h\u00e0m tr\u1ea3 v\u1ec1 s\u1ed1 ng\u00e0y (day) trong kho\u1ea3ng th\u1eddi gian \u0111\u00f3.<\/li>\n<li>Unit l\u00e0 \u201cm\u201d ngh\u0129a l\u00e0 b\u1ea1n mu\u1ed1n h\u00e0m tr\u1ea3 v\u1ec1 s\u1ed1 th\u00e1ng (month) ho\u00e0n t\u1ea5t trong kho\u1ea3ng tho\u00e0i gian.<\/li>\n<li>Unit l\u00e0 \u201cy\u201d ngh\u0129a l\u00e0 b\u1ea1n mu\u1ed1n h\u00e0m tr\u1ea3 v\u1ec1 ho\u00e0n t\u1ea5t s\u1ed1 n\u0103m (year) trong kho\u1ea3ng th\u1eddi gian \u0111\u00f3.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5 ng\u01b0\u1eddi ch\u01a1i c\u00f3 ng\u00e0y \u0111\u1ea7u ti\u00ean l\u00e0 \u00f4 D2 ng\u00e0y 9\/1\/20115 \u0111\u1ebfn ng\u00e0y k\u1ebft th\u00fac l\u00e0 E2 ng\u00e0y 12\/6\/2017\/ Nh\u01b0 v\u1eady, c\u00f4ng th\u1ee9c t\u00ednh s\u1ebd l\u00e0:<strong> =DATEDIF(D2,E2,\u201dy\u201d)&amp;\u201d years, &amp;DATEDIF(D2,E2,\u201dym\u201d)&amp;\u201d months, \u201c&amp;DATEDIF(D2,E2,\u201dmd\u201d)&amp;\u201d days\u201d<\/strong>. K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m n\u00e0y ra 2 n\u0103m, 5 th\u00e1ng, 7 ng\u00e0y. Con s\u1ed1 n\u00e0y ch\u00ednh l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a qu\u00e1 tr\u00ecnh d\u00f9ng h\u00e0m t\u00ednh ng\u00e0y th\u00e1ng<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"391\" height=\"188\" class=\"wp-image-20834 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/03\/cach-tinh-so-ngay-trong-excel-2.jpg\" alt=\"C\u00e1c s\u1eed d\u1ee5ng h\u00e0m t\u00ednh s\u1ed1 ng\u00e0y Dateif - \u1ea2nh 2\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/03\/cach-tinh-so-ngay-trong-excel-2.jpg 391w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/03\/cach-tinh-so-ngay-trong-excel-2-300x144.jpg 300w\" sizes=\"auto, (max-width: 391px) 100vw, 391px\" \/><\/p>\n<h2><strong>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Datedif<\/strong><\/h2>\n<p>C\u00e1c b\u1ea1n trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng <strong>h\u00e0m Datedif<\/strong> c\u1ea7n ph\u1ea3i l\u01b0u \u00fd m\u1ed9t s\u1ed1 v\u1ea5n \u0111\u1ec1 sau:<\/p>\n<ul>\n<li>Trong t\u00ednh to\u00e1n ng\u00e0y th\u00e1ng s\u1ebd \u0111\u01b0\u1ee3c l\u01b0u \u1edf d\u1ea1ng s\u1ed1 seri li\u00ean ti\u1ebfp.<\/li>\n<li>H\u00e0m Datedif th\u01b0\u1eddng th\u00edch h\u1ee3p \u0111\u1ec3 t\u00ednh to\u00e1n \u0111\u1ed9 tu\u1ed5i.<\/li>\n<li>Th\u00f4ng th\u01b0\u1eddng, m\u00e1y t\u00ednh s\u1ebd hi\u1ec3n th\u1ecb theo ch\u1ebf \u0111\u1ed9 ng\u00e0y th\u00e1ng theo th\u1ee9 t\u1ef1 th\u00e1ng\/ ng\u00e0y\/ n\u0103m. N\u00ean khi nh\u1eadp d\u1eef li\u1ec7u b\u1ea1n n\u00ean ch\u00fa \u00fd, \u0111\u1eebng \u0111\u1ec3 b\u1ecb nh\u1eadp nh\u1ea7m.<\/li>\n<li>Ng\u01b0\u1eddi d\u00f9ng h\u00e0m c\u00f3 th\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c \u0111\u1ec3 h\u00e0m v\u1ec1 \u0111\u1ed3ng th\u1eddi c\u1ea3 gi\u00e1 tr\u1ecb ng\u00e0y, th\u00e1ng, n\u0103m<\/li>\n<li>Nh\u1ea5n Alt + Enter \u0111\u1ec3 th\u00eam m\u1ed9t d\u00f2ng m\u1edbi v\u00e0 Ctrl + Shift + U \u0111\u1ec3 m\u1edf r\u1ed9ng gi\u00fap qu\u00e1 tr\u00ecnh xem to\u00e0n b\u1ed9 h\u00e0m t\u00ednh \u0111\u01b0\u1ee3c r\u00f5 h\u01a1n.<\/li>\n<\/ul>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 b\u00e0i vi\u1ebft chia s\u1ebb h\u01b0\u1edbng d\u1eabn chi ti\u1ebft <strong>c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m t\u00ednh s\u1ed1 ng\u00e0y Datedif<\/strong>. Hy v\u1ecdng b\u00e0i vi\u1ebft \u0111\u00e3 cung c\u1ea5p cho b\u1ea1n \u0111\u01b0\u1ee3c nh\u1eefng th\u00f4ng tin h\u1eefu \u00edch, gi\u00fap b\u1ea1n t\u00ednh to\u00e0n \u0111\u01b0\u1ee3c ng\u00e0y th\u00e1ng nhanh ch\u00f3ng. T\u1eeb \u0111\u00f3, ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c m\u1ed9t kho\u1ea3ng th\u1eddi gian \u0111\u00e1ng k\u1ec3 cho b\u1ea3n th\u00e2n. Ch\u00fac c\u00e1c b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng nhanh ch\u00f3ng.<\/p>\n<blockquote><p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft li\u00ean quan:<\/p>\n<p><a href=\"https:\/\/ben.com.vn\/tin-tuc\/khoa-file-excel\/\">Chia s\u1ebb 3 c\u00e1ch kh\u00f3a file excel nhanh ch\u00f3ng cho nh\u1eefng ai ch\u01b0a bi\u1ebft<\/a><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Vi\u1ec7c t\u00ednh ng\u00e0y th\u00e1ng b\u1eb1ng ph\u01b0\u01a1ng ph\u00e1p th\u1ee7 c\u00f4ng ch\u1eafc ch\u1eafn s\u1ebd khi\u1ebfn cho b\u1ea1n c\u1ea3m th\u1ea5y v\u00f4 c\u00f9ng \u0111au \u0111\u1ea7u v\u00e0 m\u1ec7t m\u1ecfi. V\u00ec v\u1eady, nhi\u1ec1u ng\u01b0\u1eddi \u0111\u00e3 ngh\u0129 \u0111\u1ebfn gi\u1ea3i ph\u00e1p l\u00e0 t\u00ednh s\u1ed1 ng\u00e0y b\u1eb1ng c\u00f4ng c\u1ee5 excel \u0111\u1ec3 nhanh ch\u00f3ng v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian \u0111ang k\u1ec3. Tuy nhi\u00ean, c\u00e1ch t\u00ednh [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":20833,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-20831","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/20831","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=20831"}],"version-history":[{"count":1,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/20831\/revisions"}],"predecessor-version":[{"id":37940,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/20831\/revisions\/37940"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/20833"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=20831"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=20831"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=20831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}