{"id":24337,"date":"2021-05-10T17:29:52","date_gmt":"2021-05-10T10:29:52","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24337"},"modified":"2021-11-23T17:03:08","modified_gmt":"2021-11-23T10:03:08","slug":"ham-day-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-day-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Day trong Excel qua v\u00ed d\u1ee5 b\u00e0i t\u1eadp"},"content":{"rendered":"<p><strong>H\u00e0m Day trong Excel<\/strong> \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 h\u00e0m ng\u00e0y \/ gi\u1edd. Trong ph\u00e2n t\u00edch t\u00e0i ch\u00ednh, ch\u00fang ta th\u01b0\u1eddng s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 ph\u00e2n t\u00edch chu\u1ed7i d\u1eef li\u1ec7u th\u1eddi gian, ng\u00e0y gi\u1edd. \u0110\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m Day trong Excel<\/strong> nh\u01b0 th\u1ebf n\u00e0o, c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m, b\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ben Computer.<\/p>\n<h2><strong>C\u00fa ph\u00e1p h\u00e0m Day trong Excel<\/strong><\/h2>\n<p><span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-day-trong-excel\/\"><strong>H\u00e0m Day trong Excel<\/strong><\/a><\/span> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1, l\u1ea5y gi\u00e1 tr\u1ecb ng\u00e0y trong ng\u00e0y \/ th\u00e1ng \/ n\u0103m trong b\u1ea3ng t\u00ednh Excel. H\u00e0m Excel c\u00f3 c\u00fa ph\u00e1p, c\u00f4ng th\u1ee9c c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<blockquote><p><strong>=DAY(Serial_number)<\/strong><\/p><\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li><strong>Serial_number<\/strong>\u00a0(l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c): l\u00e0 ng\u00e0y m\u00e0 ch\u00fang ta \u0111ang mu\u1ed1n l\u1ea5y, t\u00ecm ki\u1ebfm.<\/li>\n<li><strong>Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1:<\/strong> gi\u00e1 tr\u1ecb h\u00e0m Day tr\u1ea3 v\u1ec1 l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1 trong kho\u1ea3ng t\u1eeb 1 \u0111\u1ebfn 31.<\/li>\n<\/ul>\n<p><strong>L\u01b0u \u00fd:<\/strong><\/p>\n<p>H\u00e0m Day c\u0169ng ho\u1ea1t \u0111\u1ed9ng v\u1edbi gi\u00e1 tr\u1ecb ng\u00e0y \u0111\u01b0\u1ee3c nh\u1eadp d\u01b0\u1edbi d\u1ea1ng:<\/p>\n<ul>\n<li>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a m\u1ed9t s\u1ed1 h\u00e0m Excel kh\u00e1c.<\/li>\n<li>Ng\u00e0y \u0111\u01b0\u1ee3c nh\u1eadp d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p.<\/li>\n<li>Ng\u00e0y \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n trong m\u1ed9t \u00f4.<\/li>\n<li>Excel ch\u1ec9 c\u00f3 th\u1ec3 x\u1eed l\u00fd c\u00e1c ng\u00e0y b\u1eaft \u0111\u1ea7u t\u1eeb ng\u00e0y 1\/1\/1900 (tr\u00ean Excel cho Windows) v\u00e0 1904 (tr\u00ean Excel cho Mac).<\/li>\n<\/ul>\n<h2><strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Day trong Excel<\/strong><\/h2>\n<p>T\u01b0\u01a1ng t\u1ef1 c\u00e1c h\u00e0m Excel kh\u00e1c, \u0111\u1ec3 h\u00ecnh dung c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Day nh\u01b0 th\u1ebf n\u00e0o, ch\u00fang ta s\u1ebd xem qua m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<h3><strong>1. V\u00ed d\u1ee5 1<\/strong><\/h3>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y, ch\u00fang ta s\u1ebd xem c\u00e1ch h\u00e0m Day tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 nh\u01b0 th\u1ebf n\u00e0o:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"355\" class=\"aligncenter wp-image-16592 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-4.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-4-300x169.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-4.jpg 632w\" alt=\"1 4 - H\u00e0m Day trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng - Ben Computer\" \/><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean:<\/p>\n<ul>\n<li>C\u00e1c gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c cung c\u1ea5p d\u01b0\u1edbi d\u1ea1ng c\u00e1c tham chi\u1ebfu \u0111\u1ebfn c\u00e1c \u00f4 ch\u1ee9a ng\u00e0y th\u00e1ng ho\u1eb7c d\u01b0\u1edbi d\u1ea1ng gi\u00e1 tr\u1ecb ng\u00e0y \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 t\u1eeb h\u00e0m Excel kh\u00e1c (trong \u00f4 A2).<\/li>\n<li>Th\u00f4ng th\u01b0\u1eddng k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 d\u1ea1ng nh\u01b0 1\/1\/2022 ch\u1ee9 kh\u00f4ng ph\u1ea3i gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1 nguy\u00ean. \u0110i\u1ec1u n\u00e0y l\u00e0 do trong c\u00e1c \u00f4, c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng l\u00e0 \u201cng\u00e0y th\u00e1ng\u201d.<\/li>\n<\/ul>\n<p>\u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, trong menu Format tr\u00ean thanh Ribbon, ch\u00fang ta ch\u1ecdn t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng l\u00e0\u00a0<strong>General.<\/strong>\u00a0<strong>Menu Format<\/strong>\u00a0n\u1eb1m trong\u00a0<strong>group Number<\/strong>\u00a0trong\u00a0<strong>tab Home<\/strong>\u00a0tr\u00ean thanh Ribbon nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"186\" class=\"aligncenter wp-image-16593 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-4.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-4-300x88.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-4.jpg 632w\" alt=\"2 4 - H\u00e0m Day trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng - Ben Computer\" \/><\/p>\n<h3><strong>2.V\u00ed d\u1ee5 2<\/strong><\/h3>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y. Trong v\u00ed d\u1ee5 n\u00e0y, gi\u1ea3 s\u1eed ch\u00fang ta c\u1ea7n th\u00eam s\u1ed1 n\u0103m c\u1ee5 th\u1ec3 v\u00e0o ng\u00e0y th\u00e1ng.<\/p>\n<p>C\u00f4ng th\u1ee9c h\u00e0m Day \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"353\" class=\"aligncenter wp-image-16594 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-3.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-3-300x168.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-3.jpg 632w\" alt=\"3 3 - H\u00e0m Day trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng - Ben Computer\" \/><\/p>\n<p>Ch\u00fang ta s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p>Trong c\u00f4ng th\u1ee9c Excel tr\u00ean, c\u00e1c h\u00e0m YEAR, MONTH v\u00e0 h\u00e0m DAY \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u00edch xu\u1ea5t c\u00e1c th\u00e0nh ph\u1ea7n ng\u00e0y t\u01b0\u01a1ng \u1ee9ng. Trong \u00f4 A2:<\/p>\n<p>= Year 2016<\/p>\n<p>= Month 2 (Feb)<\/p>\n<p>= Date 29th<\/p>\n<p>H\u00e0m Date \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 k\u1ebft h\u1ee3p c\u00e1c gi\u00e1 tr\u1ecb, t\u1ea1o th\u00e0nh m\u1ed9t ng\u00e0y h\u1ee3p l\u1ec7 trong Excel. \u0110\u1ec3 th\u00eam n\u0103m ho\u1eb7c tr\u1eeb n\u0103m t\u1eeb ng\u00e0y \u0111\u00e3 cho, ch\u00fang ta ch\u1ec9 c\u1ea7n th\u00eam gi\u00e1 tr\u1ecb trong \u00f4 B2 v\u00e0o th\u00e0nh ph\u1ea7n n\u0103m, c\u00f4ng th\u1ee9c Excel c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><strong>=DATE(YEAR(A2)+B2,MONTH(A2),DAY(A2)).<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"255\" class=\"aligncenter wp-image-16595 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-2.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-2-300x121.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-2.jpg 632w\" alt=\"4 2 - H\u00e0m Day trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng - Ben Computer\" \/><\/p>\n<h2><strong>M\u1ed9t s\u1ed1 l\u1ed7i h\u00e0m Day trong Excel th\u01b0\u1eddng g\u1eb7p<\/strong><\/h2>\n<p>Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p s\u1eed d\u1ee5ng h\u00e0m Day \u0111\u1ec3 tr\u1ea3 v\u1ec1 ng\u00e0y trong chu\u1ed7i ng\u00e0y \/ th\u00e1ng \/ n\u0103m, b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd g\u1eb7p ph\u1ea3i m\u1ed9t s\u1ed1 l\u1ed7i kh\u00e1c nhau, \u0111i\u1ec3n h\u00ecnh l\u00e0 l\u1ed7i Value v\u00e0 l\u1ed7i Num.<\/p>\n<p>\u2013 L\u1ed7i\u00a0<strong>#NUM!<\/strong>: L\u1ed7i n\u00e0y x\u1ea3y ra trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu tham s\u1ed1 h\u00e0m Day \u0111\u01b0\u1ee3c cung c\u1ea5p l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1 nh\u01b0ng kh\u00f4ng \u0111\u01b0\u1ee3c c\u00f4ng nh\u1eadn l\u00e0 ng\u00e0y h\u1ee3p l\u1ec7.<\/p>\n<p>\u2013 L\u1ed7i\u00a0<strong>#VALUE!<\/strong>: L\u1ed7i n\u00e0y x\u1ea3y ra n\u1ebfu tham s\u1ed1, \u0111\u1ed1i s\u1ed1 h\u00e0m Day \u0111\u01b0\u1ee3c cung c\u1ea5p l\u00e0 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n v\u00e0 kh\u00f4ng \u0111\u01b0\u1ee3c coi l\u00e0 ng\u00e0y h\u1ee3p l\u1ec7.<\/p>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 t\u1ea5t t\u1ea7n t\u1eadt c\u00fa ph\u00e1p, c\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m Day trong Exce<\/strong>l. Ngo\u00e0i n\u1ebfu c\u00f2n c\u00e2u h\u1ecfi n\u00e0o c\u1ea7n gi\u1ea3i \u0111\u00e1p th\u00eam, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 chia s\u1ebb \u00fd ki\u1ebfn c\u1ee7a m\u00ecnh trong ph\u1ea7n b\u00ecn lu\u1eadn b\u00ean d\u01b0\u1edbi b\u00e0i vi\u1ebft nh\u00e9.<\/p>\n<p>B\u00ean c\u1ea1nh \u0111\u00f3, n\u1ebfu ch\u01b0a bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c <a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-sumif-trong-excel\/\">h\u00e0m Sumif<\/a> v\u00e0 <a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-nhan-trong-excel\/\">h\u00e0m nh\u00e2n trong Excel<\/a> nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean Ben Computer \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00eam nh\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Day trong Excel \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 h\u00e0m ng\u00e0y \/ gi\u1edd. Trong ph\u00e2n t\u00edch t\u00e0i ch\u00ednh, ch\u00fang ta th\u01b0\u1eddng s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 ph\u00e2n t\u00edch chu\u1ed7i d\u1eef li\u1ec7u th\u1eddi gian, ng\u00e0y gi\u1edd. \u0110\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Day trong Excel nh\u01b0 th\u1ebf n\u00e0o, c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m, b\u1ea1n \u0111\u1ecdc [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":24338,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24337","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\/24337","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=24337"}],"version-history":[{"count":1,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24337\/revisions"}],"predecessor-version":[{"id":44448,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24337\/revisions\/44448"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24338"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}