{"id":24055,"date":"2021-05-07T09:18:47","date_gmt":"2021-05-07T02:18:47","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24055"},"modified":"2021-11-23T17:05:57","modified_gmt":"2021-11-23T10:05:57","slug":"ham-lay-thang-nam-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-lay-thang-nam-trong-excel\/","title":{"rendered":"H\u00e0m l\u1ea5y th\u00e1ng n\u0103m trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng"},"content":{"rendered":"

B\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng h\u00e0m l\u1ea5y th\u00e1ng n\u0103m trong Excel<\/strong> nh\u01b0ng ch\u01b0a bi\u1ebft c\u00e1ch th\u1ef1c hi\u1ec7n?\u00a0 \u0110\u1eebng lo l\u1eafng, trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y Ben Computer s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y trong Excel m\u1ed9t c\u00e1ch chi ti\u1ebft nh\u1ea5t c\u00f3 k\u00e8m v\u00ed d\u1ee5. C\u00f9ng theo d\u00f5i ngay nh\u00e9.<\/p>\n

C\u00e1c h\u00e0m Excel l\u1ea5y ng\u00e0y th\u00e1ng n\u0103m c\u01a1 b\u1ea3n<\/strong><\/h2>\n

Tr\u01b0\u1edbc khi t\u00ecm hi\u1ec3u h\u00e0m l\u1ea5y th\u00e1ng n\u0103m trong Excel<\/strong><\/a><\/span> th\u00ec h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u qua c\u00f3 c\u00e1c h\u00e0m l\u1ea5y th\u1eddi gian ng\u00e0y, th\u00e1ng, n\u0103m nh\u01b0 th\u1ebf n\u00e0o \u0111\u00e3 nh\u00e9.<\/p>\n

\u2013 H\u00e0m Day:<\/strong> x\u00e1c \u0111\u1ecbnh ng\u00e0y trong chu\u1ed7i ng\u00e0y \/ th\u00e1ng \/ n\u0103m.<\/p>\n

\u2013 H\u00e0m Month:<\/strong> x\u00e1c \u0111\u1ecbnh th\u00e1ng trong chu\u1ed7i ng\u00e0y \/ th\u00e1ng \/ n\u0103m.<\/p>\n

\u2013 H\u00e0m Year:<\/strong> x\u00e1c \u0111\u1ecbnh n\u0103m trong chu\u1ed7i ng\u00e0y \/ th\u00e1ng \/ n\u0103m.<\/p>\n

\u2013 H\u00e0m Date:<\/strong> x\u00e1c \u0111\u1ecbnh ng\u00e0y \/ th\u00e1ng \/ n\u0103m t\u1eeb c\u00e1c th\u00f4ng s\u1ed1 ng\u00e0y, th\u00e1ng, n\u0103m cho tr\u01b0\u1edbc.<\/p>\n

\u2013 H\u00e0m Today:<\/strong> x\u00e1c \u0111\u1ecbnh ng\u00e0y hi\u1ec7n t\u1ea1i d\u01b0\u1edbi \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m.<\/p>\n

\"H\u00e0m<\/p>\n

H\u00e0m l\u1ea5y th\u00e1ng n\u0103m trong Excel<\/strong><\/h2>\n

1. H\u00e0m Year trong Excel<\/strong><\/h3>\n

H\u00e0m Year trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh s\u1ed1 n\u0103m c\u1ee7a m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3 \u0111\u00e3 cho tr\u01b0\u1edbc. H\u00e0m Excel n\u00e0y tr\u1ea3 v\u1ec1 s\u1ed1 nguy\u00ean ch\u00ednh l\u00e0 s\u1ed1 n\u0103m, g\u1ed3m 4 ch\u1eef s\u1ed1.<\/p>\n

C\u00f4ng th\u1ee9c h\u00e0m Year trong Excel<\/strong><\/h4>\n

C\u00f4ng th\u1ee9c h\u00e0m Year trong Excel c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=YEAR(serial_number)<\/strong><\/p><\/blockquote>\n

Trong \u0111\u00f3 tham s\u1ed1\u00a0serial_number l<\/strong>\u00e0 b\u1eaft bu\u1ed9c, l\u00e0 s\u1ed1 ng\u00e0y c\u1ee5 th\u1ec3 m\u00e0 ch\u00fang ta mu\u1ed1n t\u00ecm n\u0103m. Ng\u00e0y ph\u1ea3i \u0111\u01b0\u1ee3c nh\u1eadp b\u1eb1ng h\u00e0m DATE ho\u1eb7c l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c ho\u1eb7c h\u00e0m Excel kh\u00e1c tr\u1ea3 v\u1ec1.<\/p>\n

V\u00ed d\u1ee5 v\u1ec1 h\u00e0m Year<\/strong><\/h4>\n

Gi\u1ea3 s\u1eed n\u1ebfu ch\u00fang ta mu\u1ed1n tr\u00edch xu\u1ea5t, t\u00ecm s\u1ed1 n\u0103m t\u1eeb danh s\u00e1ch s\u1ed1 ng\u00e0y c\u1ee5 th\u1ec3 cho tr\u01b0\u1edbc trong b\u1ea3ng t\u00ednh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

\"H\u00e0m<\/p>\n

Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m Year \u0111\u1ec3 tr\u00edch xu\u1ea5t n\u0103m. C\u00f4ng th\u1ee9c h\u00e0m Excel c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

\"H\u00e0m<\/p>\n

K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

\"K\u1ebft<\/p>\n

L\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m Year trong Excel<\/strong><\/h4>\n

\u2013 L\u1ed7i\u00a0#Value?:<\/strong>\u00a0l\u1ed7i n\u00e0y x\u1ea3y ra n\u1ebfu tham s\u1ed1 serial_number h\u00e0m Year kh\u00f4ng ph\u1ea3i gi\u00e1 tr\u1ecb s\u1ed1, ng\u00e0y th\u00e1ng m\u00e0 l\u00e0 gi\u00e1 tr\u1ecb k\u00fd t\u1ef1, v\u0103n b\u1ea3n.<\/p>\n

\u2013 L\u1ed7i #NAME?:<\/strong>\u00a0l\u1ed7i n\u00e0y x\u1ea3y ra n\u1ebfu c\u00fa ph\u00e1p h\u00e0m Year m\u00e0 b\u1ea1n nh\u1eadp b\u1ecb l\u1ed7i gi\u00e1 tr\u1ecb l\u00e0 ch\u1eef ho\u1eb7c k\u00fd t\u1ef1.<\/p>\n

2. H\u00e0m Month trong Excel<\/strong><\/h3>\n

H\u00e0m Month trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 th\u00e1ng cho m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3. Gi\u00e1 tr\u1ecb th\u00e1ng n\u00e0y n\u1eb1m trong kho\u1ea3ng t\u1eeb 1 \u0111\u1ebfn 12. H\u00e0m MONTH c\u00f3 s\u1eb5n trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n Excel 2000 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n m\u1edbi h\u01a1n.<\/p>\n

C\u00fa ph\u00e1p h\u00e0m Month trong Excel<\/strong><\/h4>\n

C\u00fa ph\u00e1p h\u00e0m Month trong Excel c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=MONTH(serial_number)<\/strong><\/p><\/blockquote>\n

Trong \u0111\u00f3 h\u00e0m ch\u1ec9 s\u1eed d\u1ee5ng m\u1ed9t tham s\u1ed1 duy nh\u1ea5t:<\/p>\n

\u2013 Serial_number<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): l\u00e0 gi\u00e1 tr\u1ecb ng\u00e0y c\u1ee5 th\u1ec3 m\u00e0 ch\u00fang ta mu\u1ed1n tr\u1ea3 v\u1ec1 th\u00e1ng. Tham s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 l\u00e0:<\/p>\n

Tham chi\u1ebfu \u0111\u1ebfn c\u00e1c \u00f4 ch\u1ee9a ng\u00e0y th\u00e1ng<\/p>\n

Gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 t\u1eeb c\u00f4ng th\u1ee9c, h\u00e0m Excel.<\/p>\n

V\u00ed d\u1ee5 v\u1ec1 h\u00e0m Month<\/strong><\/h4>\n

Cho b\u1ea3ng t\u00ednh ch\u1ee9a d\u1eef li\u1ec7u nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y, y\u00eau c\u1ea7u l\u00e0 s\u1eed d\u1ee5ng h\u00e0m Month \u0111\u1ec3 tr\u1ea3 v\u1ec1 th\u00e1ng c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb ng\u00e0y n\u00e0y:<\/p>\n

12\/09\/2017 9:40:00 AM<\/p>\n

05\/29\/17<\/p>\n

2015 June 7<\/p>\n

C\u00f4ng th\u1ee9c h\u00e0m Month Excel c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

\"H\u00e0m<\/p>\n

K\u1ebft qu\u1ea3 h\u00e0m tr\u1ea3 v\u1ec1 c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n

\"K\u1ebft<\/p>\n

Trong h\u00e0ng A4, v\u00ec ng\u00e0y kh\u00f4ng c\u00f3 \u0111\u1ecbnh d\u1ea1ng th\u00edch h\u1ee3p, n\u00ean ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m DATE v\u1edbi h\u00e0m MONTH.<\/p>\n

L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Month trong Excel\u00a0<\/strong><\/h4>\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u1ed7i v\u00e0 l\u01b0u \u00fd quan tr\u1ecdng khi s\u1eed d\u1ee5ng h\u00e0m Month trong Excel \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh th\u00e1ng trong chu\u1ed7i ng\u00e0y \/ th\u00e1ng \/ n\u0103m:<\/p>\n