{"id":4673,"date":"2024-12-08T06:12:04","date_gmt":"2024-12-08T06:12:04","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-dung-ham-month-trong-excel-de-tim-so-thang\/"},"modified":"2024-12-08T06:12:04","modified_gmt":"2024-12-08T06:12:04","slug":"huong-dan-cach-dung-ham-month-trong-excel-de-tim-so-thang","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-dung-ham-month-trong-excel-de-tim-so-thang\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m MONTH trong Excel \u0111\u1ec3 t\u00ecm s\u1ed1 th\u00e1ng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng th\u1eddi gian nh\u01b0\u00a0Ng\u00e0y, Th\u00e1ng, N\u0103m trong\u00a0Excel th\u00ec ch\u00fang ta c\u1ea7n ph\u1ea3i c\u00f3 nh\u1eefng h\u00e0m x\u1eed l\u00fd ri\u00eang. Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta c\u00f9ng nhau t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m MONTH. M\u1ed9t trong nh\u1eefng h\u00e0m ti\u00eau bi\u1ec3u khi l\u00e0m vi\u1ec7c v\u1edbi gi\u00e1 tr\u1ecb Th\u00e1ng. Hay n\u00f3i c\u00e1ch kh\u00e1c, ch\u00fang ta s\u1ebd d\u00f9ng h\u00e0m MONTH\u00a0\u0111\u1ec3 t\u00ecm s\u1ed1 th\u00e1ng trong 1 gi\u00e1 tr\u1ecb th\u1eddi gian.<\/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-675538b3c32c5\" 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-dung-ham-month-trong-excel-de-tim-so-thang.html#Cau_truc_ham_MONTH\" title=\"C\u1ea5u tr\u00fac h\u00e0m MONTH\">C\u1ea5u tr\u00fac h\u00e0m MONTH<\/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-dung-ham-month-trong-excel-de-tim-so-thang.html#Ung_dung_ham_MONTH_trong_lap_bao_cao_theo_thang\" title=\"\u1ee8ng d\u1ee5ng h\u00e0m MONTH trong l\u1eadp b\u00e1o c\u00e1o theo th\u00e1ng\">\u1ee8ng d\u1ee5ng h\u00e0m MONTH trong l\u1eadp b\u00e1o c\u00e1o theo th\u00e1ng<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cau_truc_ham_MONTH\"><\/span>C\u1ea5u tr\u00fac h\u00e0m MONTH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m kh\u00e1\u00a0\u0111\u01a1n gi\u1ea3n:<\/p>\n<blockquote>\n<p>=MONTH(serial_number)<\/p>\n<\/blockquote>\n<p>Trong\u00a0\u0111\u00f3 serial_number l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb th\u1eddi gian.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p>Mu\u1ed1n bi\u1ebft th\u00e1ng hi\u1ec7n t\u1ea1i l\u00e0 th\u00e1ng m\u1ea5y, ch\u00fang ta d\u00f9ng h\u00e0m:<\/p>\n<p style=\"padding-left: 30px\">=MONTH(TODAY())<\/p>\n<ul>\n<li>H\u00e0m TODAY() s\u1ebd tr\u1ea3 v\u1ec1 ng\u00e0y-th\u00e1ng-n\u0103m hi\u1ec7n t\u1ea1i<\/li>\n<li>H\u00e0m MONTH(TODAY()) s\u1ebd l\u1ea5y ra gi\u00e1 tr\u1ecb s\u1ed1 th\u00e1ng trong k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m TODAY()<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Ung_dung_ham_MONTH_trong_lap_bao_cao_theo_thang\"><\/span>\u1ee8ng d\u1ee5ng h\u00e0m MONTH trong l\u1eadp b\u00e1o c\u00e1o theo th\u00e1ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n t\u00e1c d\u1ee5ng c\u1ee7a h\u00e0m MONTH, ch\u00fang ta h\u00e3y tham kh\u1ea3o v\u00ed d\u1ee5 d\u01b0\u1edbi\u00a0\u0111\u00e2y:<\/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-379.gif\" title=\"ex101_92019-nho-379\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25275\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dung-ham-month-lap-bao-cao-theo-thang.png\" width=\"824\" height=\"333\" title=\"dung-ham-month-lap-bao-cao-theo-thang\"><\/p>\n<p>Trong b\u1ea3ng A1:C10, ch\u00fang ta c\u00f3 d\u1eef li\u1ec7u ch\u1ec9 c\u00f3 c\u00e1c c\u1ed9t Ng\u00e0y, S\u1ea3n ph\u1ea9m v\u00e0 S\u1ed1 ti\u1ec1n. Trong khi\u00a0\u0111\u00f3 y\u00eau c\u1ea7u t\u00ednh s\u1ed1 ti\u1ec1n b\u00e1n\u00a0\u0111\u01b0\u1ee3c trong th\u00e1ng 6. V\u1eady l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh s\u1ea3n ph\u1ea9m n\u00e0o b\u00e1n\u00a0\u0111\u01b0\u1ee3c trong th\u00e1ng 6?<\/p>\n<p><strong>C\u00e1ch 1: D\u00f9ng c\u1ed9t ph\u1ee5 x\u00e1c\u00a0\u0111\u1ecbnh s\u1ed1 th\u00e1ng b\u1eb1ng h\u00e0m MONTH v\u00e0 k\u1ebft h\u1ee3p h\u00e0m SUMIF<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25276\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-month-xac-dinh-so-thang-tu-du-lieu-ngay-01.png\" width=\"462\" height=\"376\" title=\"ham-month-xac-dinh-so-thang-tu-du-lieu-ngay-01\"><\/p>\n<p>T\u1ea1i c\u1ed9t D, ch\u00fang ta s\u1ebd d\u00f9ng h\u00e0m MONTH\u00a0\u0111\u1ec3 x\u00e9t s\u1ed1 th\u00e1ng trong d\u1eef li\u1ec7u Ng\u00e0y\u00a0\u1edf c\u1ed9t A, b\u1eaft\u00a0\u0111\u1ea7u t\u1eeb\u00a0\u00f4 A2<\/p>\n<ul>\n<li>D2=MONTH(A2)<\/li>\n<li>T\u1eeb D2 ch\u00fang ta <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-toan-tap-ve-cach-keo-cong-thuc-trong-excel.html\">filldown c\u00f4ng th\u1ee9c xu\u1ed1ng<\/a> D10<\/li>\n<\/ul>\n<p>D\u1ef1a v\u00e0o k\u1ebft qu\u1ea3\u00a0\u1edf c\u1ed9t D, ch\u00fang ta s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\"><strong>h\u00e0m SUMIF<\/strong><\/a>\u00a0\u0111\u1ec3 t\u00ednh nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=SUMIF(D2:D10,G2,C2:C10)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25277\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-sumif-tinh-so-tien-ban-theo-thang.png\" width=\"892\" height=\"331\" title=\"ham-sumif-tinh-so-tien-ban-theo-thang\"><\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>D2:D10 l\u00e0 v\u00f9ng ch\u1ee9a gi\u00e1 tr\u1ecb c\u00e1c th\u00e1ng, ch\u00ednh l\u00e0 n\u01a1i\u00a0\u0111\u1ec3 x\u00e9t gi\u00e1 tr\u1ecb n\u00e0o th\u1ecfa m\u00e3n\u00a0\u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>G2 l\u00e0 gi\u00e1 tr\u1ecb th\u00e1ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn l\u00e0m\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u0111\u1ec3 t\u00ednh<\/li>\n<li>C2:C10 l\u00e0 v\u00f9ng ch\u1ee9a k\u1ebft qu\u1ea3 c\u1ea7n t\u00ednh (s\u1ed1 ti\u1ec1n)<\/li>\n<\/ul>\n<p>H\u00e0m SUMIF cho ra k\u1ebft qu\u1ea3 l\u00e0 168.<\/p>\n<p>Khi s\u1eed d\u1ee5ng h\u00e0m SUMIF, ch\u00fang ta kh\u00f4ng th\u1ec3 t\u00ednh tr\u1ef1c ti\u1ebfp b\u1eb1ng c\u00e1ch so s\u00e1nh gi\u00e1 tr\u1ecb\u00a0\u1edf\u00a0\u00f4 G2 v\u1edbi v\u00f9ng A2:A10 b\u1edfi v\u00ec b\u1ea3n ch\u1ea5t d\u1eef li\u1ec7u l\u00e0 kh\u00e1c nhau. Mu\u1ed1n so s\u00e1nh gi\u00e1 tr\u1ecb s\u1ed1 th\u00e1ng, ch\u00fang ta ph\u1ea3i g\u1ecdi ra\u00a0\u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb Th\u00e1ng trong chu\u1ed7i Ng\u00e0y\/th\u00e1ng\/n\u0103m.<\/p>\n<p><strong>C\u00e1ch 2: S\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT k\u1ebft h\u1ee3p h\u00e0m MONTH<\/strong><\/p>\n<p>C\u00f3 1 c\u00e1ch l\u00e0m kh\u00e1c kh\u00f4ng c\u1ea7n s\u1eed d\u1ee5ng c\u1ed9t ph\u1ee5 (c\u1ed9t D),\u00a0\u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT. C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=SUMPRODUCT((MONTH(A2:A10)=G2)*C2:C10)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25278\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-sumproduct-ket-hop-ham-month.png\" width=\"832\" height=\"374\" title=\"ham-sumproduct-ket-hop-ham-month\"><\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>H\u00e0m MONTH(A2:A10) t\u1ea1o ra 1 m\u1ea3ng l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1 th\u00e1ng c\u1ee7a m\u1ed7i\u00a0\u00f4 trong v\u00f9ng A2:A10,\u00a0\u0111i\u1ec1u n\u00e0y gi\u1ed1ng v\u1edbi vi\u1ec7c t\u1ea1o c\u1ed9t ph\u1ee5 x\u00e9t th\u00e1ng<\/li>\n<li>V\u1edbi c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 th\u00e1ng th\u1ecfa m\u00e3n\u00a0\u0111i\u1ec1u ki\u1ec7n b\u1eb1ng\u00a0\u00f4 G2, s\u1ebd l\u1ea5y t\u01b0\u01a1ng\u00a0\u1ee9ng theo gi\u00e1 tr\u1ecb\u00a0\u1edf c\u1ed9t C theo d\u00f2ng.<\/li>\n<\/ul>\n<p>L\u01b0u\u00a0\u00fd: Ch\u1ec9 l\u00e0m\u00a0\u0111\u01b0\u1ee3c c\u00e1ch n\u00e0y khi s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT.<\/p>\n<p>Nh\u01b0 v\u1eady khi\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ea7n t\u00ednh kh\u00f4ng c\u00f3 s\u1eb5n, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m nh\u01b0 h\u00e0m MONTH\u00a0\u0111\u1ec3 g\u1ecdi ra c\u00e1c gi\u00e1 tr\u1ecb\u00a0\u0111\u00f3. Sau\u00a0\u0111\u00f3 ch\u1ec9 c\u1ea7n k\u1ebft h\u1ee3p trong c\u00e1c h\u00e0m t\u00ednh to\u00e1n theo\u00a0\u0111i\u1ec1u ki\u1ec7n nh\u01b0 SUMIF, COUNTIF, SUMPRODUCT l\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3\u00a0t\u00ednh ra\u00a0\u0111\u00fang k\u1ebft qu\u1ea3 theo y\u00eau c\u1ea7u.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft sau\u00a0\u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m SUMIF, COUNTIF, SUMPRODUCT:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-sumproduct-nang-cao-trong-excel.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT n\u00e2ng cao trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-lap-bao-cao-tong-hop-theo-tung-thang-voi-ham-sumifs.html\">C\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p theo t\u1eebng th\u00e1ng v\u1edbi h\u00e0m SUMIFS<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-sumproduct-de-dem-theo-nhieu-dieu-kien.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m SUMPRODUCT \u0111\u1ec3 \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-sumif-ket-hop-ham-vlookup-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif k\u1ebft h\u1ee3p h\u00e0m vlookup trong 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-379.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4674,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4673","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\/4673","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=4673"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4673\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4674"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}