{"id":11460,"date":"2022-11-13T16:10:57","date_gmt":"2022-11-13T09:10:57","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11460"},"modified":"2022-12-19T10:47:09","modified_gmt":"2022-12-19T03:47:09","slug":"huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Month trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;11460&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;4&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (4 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Month trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (4 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng Excel th\u00ec ch\u1eafc ch\u1eafn b\u1ea1n s\u1ebd nhi\u1ec1u l\u1ea7n s\u1eed d\u1ee5ng \u0111\u1ec3 g\u00f5 c\u00e1c ng\u00e0y th\u00e1ng n\u0103m. Tuy v\u1eady, nhi\u1ec1u ng\u01b0\u1eddi b\u1ea1n v\u1eabn ch\u01b0a bi\u1ebft c\u00e1ch d\u00f9ng h\u00e0m n\u00e0y. <\/span><span style=\"font-weight: 400;\">Trong b\u00e0i n\u00e0y, Teky.edu.vn s\u1ebd h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t. H\u00e3y c\u00f9ng theo d\u00f5i n\u1ed9i dung b\u00ean d\u01b0\u1edbi nh\u00e9.\u00a0<\/span><\/em><\/p>\n<p style=\"text-align: justify;\"><!--more--><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 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\" style=\"cursor:inherit\">N\u1ed9i dung <\/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\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" 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><\/span><\/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:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Ham_month_trong_Excel_la_gi\" >H\u00e0m month trong Excel l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Cach_de_su_dung_ham_month_trong_Excel_cu_the_chi_tiet\" >C\u00e1ch \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m month trong Excel c\u1ee5 th\u1ec3 chi ti\u1ebft<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Cu_phap_cua_ham_month\" >C\u00fa ph\u00e1p c\u1ee7a h\u00e0m month<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Mot_so_luu_y_trong_cu_phap_nay\" >M\u1ed9t s\u1ed1 l\u01b0u \u00fd trong c\u00fa ph\u00e1p n\u00e0y<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Cach_su_dung_cu_the_chi_tiet_cua_ham_month_khi_dung_Excel\" >C\u00e1ch s\u1eed d\u1ee5ng c\u1ee5 th\u1ec3 chi ti\u1ebft c\u1ee7a h\u00e0m month khi d\u00f9ng Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Huong_dan_su_dung_ham_month\" >H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Buoc_1\" >B\u01b0\u1edbc 1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Buoc_2\" >B\u01b0\u1edbc 2<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Cac_loi_thuong_xay_ra_khi_su_dung_ham_month_trong_Excel\" >C\u00e1c l\u1ed7i th\u01b0\u1eddng x\u1ea3y ra khi s\u1eed d\u1ee5ng h\u00e0m month trong Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Loi_VALUE\" >L\u1ed7i #VALUE?<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Nguyen_nhan\" >Nguy\u00ean nh\u00e2n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Cach_de_khac_phuc\" >C\u00e1ch \u0111\u1ec3 kh\u1eafc ph\u1ee5c<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Loi_NAME\" >L\u1ed7i #NAME?<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Nguyen_nhan-2\" >Nguy\u00ean nh\u00e2n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Cach_de_khac_phuc-2\" >C\u00e1ch \u0111\u1ec3 kh\u1eafc ph\u1ee5c<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Loi_gia_tri_thang_giong_nhu_la_mot_ngay\" >L\u1ed7i gi\u00e1 tr\u1ecb th\u00e1ng gi\u1ed1ng nh\u01b0 l\u00e0 m\u1ed9t ng\u00e0y<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Nguyen_nhan-3\" >Nguy\u00ean nh\u00e2n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#Cach_de_khac_phuc-3\" >C\u00e1ch \u0111\u1ec3 kh\u1eafc ph\u1ee5c<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_month_trong_Excel_la_gi\"><\/span><strong>H\u00e0m month trong Excel l\u00e0 g\u00ec?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m month trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m quen thu\u1ed9c v\u00e0 ch\u1eafc h\u1eb3n nh\u1eefng ai th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel s\u1ebd s\u1eed d\u1ee5ng r\u1ea5t nhi\u1ec1u. Lo\u1ea1i h\u00e0m n\u00e0y s\u1ebd c\u00f3 ch\u1ee9c n\u0103ng t\u00e1ch gi\u00e1 tr\u1ecb th\u00e1ng trong m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3. Th\u00e1ng s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 d\u01b0\u1edbi d\u1ea1ng s\u1ed1 nguy\u00ean v\u00e0 c\u00f3 gi\u00e1 tr\u1ecb t\u1eeb 1 \u0111\u1ebfn 12. <\/span><span style=\"font-weight: 400;\">H\u00e0m month l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng r\u1ea5t nhi\u1ec1u. Lo\u1ea1i h\u00e0m n\u00e0y s\u1ebd gi\u00fap:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gi\u00fap x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c s\u1ed1 th\u00e1ng c\u1ee5 th\u1ec3 trong b\u1ea3ng t\u00ednh.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gi\u00fap k\u1ebft h\u1ee3p v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c \u0111\u1ec3 thu\u1eadn ti\u1ec7n h\u01a1n trong c\u00f4ng vi\u1ec7c<\/span><\/li>\n<\/ul>\n<p><iframe loading=\"lazy\" title=\"Gi\u1edbi thi\u1ec7u h\u00e0m DAY, MONTH, YEAR v\u00e0 h\u00e0m WEEKDAY\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/7uWDAhN20ck?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_de_su_dung_ham_month_trong_Excel_cu_the_chi_tiet\"><\/span><span style=\"font-weight: 400;\">C\u00e1ch \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m month trong Excel c\u1ee5 th\u1ec3 chi ti\u1ebft<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1eb7c d\u00f9 h\u00e0m month trong excel l\u00e0 h\u00e0m ph\u1ed5 bi\u1ebfn v\u00e0 th\u00f4ng d\u1ee5ng. Nh\u01b0ng nhi\u1ec1u ng\u01b0\u1eddi \u0111\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng ng\u01b0\u1eddi m\u1edbi s\u1eed d\u1ee5ng Excel \u00edt nhi\u1ec1u s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c. V\u1eady h\u00e3y theo d\u00f5i ngay c\u00e1c th\u00f4ng tin d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 bi\u1ebft c\u00e1c d\u00f9ng h\u00e0m month n\u00e0y ngay nh\u00e9.\u00a0<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_month\"><\/span><strong>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m month<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 s\u1eed d\u1ee5ng lo\u1ea1i h\u00e0m n\u00e0y th\u00ec trong b\u1ea3ng t\u00ednh c\u1ee7a Excel. B\u1ea1n h\u00e3y nh\u1eadp l\u1ec7nh theo c\u00fa ph\u00e1p <strong>=MONTH(serial_number)<\/strong> v\u00e0o \u00f4 d\u1eef li\u1ec7u b\u1ea1n c\u1ea7n v\u00e0 nh\u1ea5n Enter.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Trong \u0111\u00f3:<\/strong> \u0110\u1ed1i s\u1ed1 serial number l\u00e0 \u00f4 d\u1eef li\u1ec7u ng\u00e0y m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 th\u00e1ng.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Mot_so_luu_y_trong_cu_phap_nay\"><\/span><strong>M\u1ed9t s\u1ed1 l\u01b0u \u00fd trong c\u00fa ph\u00e1p n\u00e0y<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u1ea1n n\u00ean cung c\u1ea5p ng\u00e0y cho h\u00e0m MONTH theo c\u00e1c s\u1ed1 seri. Ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn c\u00e1c \u00f4 ch\u1ee9a ng\u00e0y ho\u1eb7c l\u00e0 gi\u00e1 tr\u1ecb ng\u00e0y \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 t\u1eeb c\u00f4ng th\u1ee9c Excel kh\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n c\u1ed1 g\u1eafng nh\u1eadp ng\u00e0y d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n th\u00ec Excel s\u1ebd hi\u1ec3u sai do c\u00e1c h\u1ec7 th\u1ed1ng ng\u00e0y kh\u00e1c nhau ho\u1eb7c c\u00e0i \u0111\u1eb7t hi\u1ec3n th\u1ecb ng\u00e0y tr\u00ean m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_cu_the_chi_tiet_cua_ham_month_khi_dung_Excel\"><\/span><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng c\u1ee5 th\u1ec3 chi ti\u1ebft c\u1ee7a h\u00e0m month khi d\u00f9ng Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m month trong Excel c\u0169ng v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n. \u0110\u1ec3 m\u1ecdi ng\u01b0\u1eddi d\u1ec5 hi\u1ec3u th\u00ec m\u00ecnh s\u1ebd c\u00f3 2 v\u00ed d\u1ee5 minh h\u1ecda c\u1ee5 th\u1ec3. M\u1ecdi ng\u01b0\u1eddi c\u00f9ng theo d\u00f5i \u0111\u1ec3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng ngay nh\u00e9.\u00a0<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Huong_dan_su_dung_ham_month\"><\/span>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 \u0111\u1ea7u ti\u00ean: B\u1ea1n h\u00e3y s\u1eed d\u1ee5ng h\u00e0m MONTH trong <a href=\"https:\/\/www.microsoft.com\/vi-vn\/microsoft-365\/excel\" rel=\"nofollow noreferrer\">Excel<\/a> \u0111\u1ec3 l\u1ea5y ra th\u00e1ng \u1edf \u00f4 A1.<\/span><\/p>\n<h4 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Buoc_1\"><\/span><span style=\"font-weight: 400;\"><strong>B\u01b0\u1edbc 1<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ea7u ti\u00ean b\u1ea1n c\u1ea7n b\u1eadt Excel, \u0111\u1ee3i trong gi\u00e2y l\u00e1t th\u00ec s\u1ebd kh\u1edfi \u0111\u1ed9ng xong. Trong b\u1ea3ng t\u00ednh hi\u1ec7n ra b\u1ea1n nh\u1eadp v\u00e0o \u00f4 A1 theo c\u00fa ph\u00e1p MONTH(A1) v\u00e0o \u00f4 b\u1ea1n mu\u1ed1n tr\u1ea3 k\u1ebft qu\u1ea3.\u00a0<\/span><\/p>\n<figure id=\"attachment_11464\" aria-describedby=\"caption-attachment-11464\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11464 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h4-2.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h4-2.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h4-2-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/h4-2-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11464\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><strong>M\u1ed9t s\u1ed1 l\u01b0u \u00fd<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">M\u00ecnh h\u01b0\u1edbng d\u1eabn \u1edf \u00f4 A1 n\u00ean nh\u1eadp A1 ch\u00ednh v\u00ec th\u1ebf m\u00e0 m\u1ecdi ng\u01b0\u1eddi c\u00f3 th\u1ec3 thay \u0111\u1ed5i s\u1ed1 seri n\u00e0y nha.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00f9y theo \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng tr\u00ean m\u00e1y c\u1ee7a b\u1ea1n m\u00e0 th\u00e1ng s\u1ebd hi\u1ec3n th\u1ecb tr\u01b0\u1edbc ho\u1eb7c sau ng\u00e0y. Nh\u01b0 c\u1ee7a m\u00ecnh l\u00e0 th\u00e1ng hi\u1ec3n th\u1ecb tr\u01b0\u1edbc ng\u00e0y. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1ch \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng T\u1ea1i \u0111\u00e2y!<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1eadp h\u00e0m =MONTH(A1) v\u00e0o \u00f4 m\u00e0 m\u1ecdi ng\u01b0\u1eddi c\u1ea7n tr\u00ean b\u1ea3ng t\u00ednh.<\/span><\/li>\n<\/ul>\n<h4 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Buoc_2\"><\/span><span style=\"font-weight: 400;\"><strong>B\u01b0\u1edbc 2<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau khi \u0111\u00e3 nh\u1eadp xong th\u00ec m\u1ecdi ng\u01b0\u1eddi ch\u1ec9 c\u1ea7n \u1ea5n ph\u00edm Enter v\u00e0 ki\u1ec3m tra l\u1ea1i k\u1ebft qu\u1ea3 \u0111\u00e3 hi\u1ec3n th\u1ecb.<\/span><\/p>\n<figure id=\"attachment_11461\" aria-describedby=\"caption-attachment-11461\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11461 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-2.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-2.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-2-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-2-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11461\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 ti\u1ebfp theo: B\u1ea1n h\u00e3y s\u1eed d\u1ee5ng h\u00e0m MONTH \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb th\u00e1ng c\u1ee7a 15\/03\/2021, 30\/04\/1945 v\u00e0 02\/09\/1945.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>B\u01b0\u1edbc 1:<\/strong> \u0110\u1ea7u ti\u00ean c\u0169ng gi\u1ed1ng nh\u01b0 \u1edf v\u00ed d\u1ee5 1 th\u00ec b\u1ea1n m\u1edf Excel. T\u1ea1i b\u1ea3ng t\u00ednh th\u00ec b\u1ea1n s\u1ebd nh\u1eadp v\u00e0o \u00f4 A1 v\u1edbi c\u00fa ph\u00e1p =MONTH(A1) v\u00e0o \u00f4 b\u1ea1n mu\u1ed1n tr\u1ea3 k\u1ebft qu\u1ea3.\u00a0<\/span><\/p>\n<figure id=\"attachment_11462\" aria-describedby=\"caption-attachment-11462\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11462 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11462\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t l\u01b0u \u00fd nho nh\u1ecf l\u00e0 M\u00ecnh \u0111ang h\u01b0\u1edbng d\u1eabn trong b\u1ea3ng t\u00ednh \u1edf \u00f4 A1 n\u00ean s\u1ebd nh\u1eadp c\u00e1c gi\u00e1 tr\u1ecb v\u00e0o \u00f4 A1. C\u00f2n n\u1ebfu b\u1ea1n mong mu\u1ed1n nh\u1eadp gi\u00e1 tr\u1ecb, d\u1eef li\u1ec7u kh\u00e1c khi l\u00e0m vi\u1ec7c th\u00ec b\u1ea1n s\u1ebd nh\u1eadp v\u00e0o \u00f4 m\u00e0 m\u00ecnh l\u1ef1a ch\u1ecdn. <\/span><span style=\"font-weight: 400;\">Nh\u1eadp h\u00e0m =MONTH(A1) v\u00e0o \u00f4 m\u00e0 b\u1ea1n c\u1ea7n tr\u00ean b\u1ea3ng t\u00ednh.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>B\u01b0\u1edbc 2:<\/strong> Sau khi \u0111\u00e3 nh\u1eadp xong nh\u01b0 tr\u00ean th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n \u1ea5n ph\u00edm Enter v\u00e0 ki\u1ec3m tra k\u1ebft qu\u1ea3.<\/span><\/p>\n<figure id=\"attachment_11465\" aria-describedby=\"caption-attachment-11465\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11465 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-1.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11465\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>B\u01b0\u1edbc 3:<\/strong> \u1ede g\u00f3c ph\u1ea3i b\u00ean d\u01b0\u1edbi c\u1ee7a \u00f4 k\u1ebft qu\u1ea3. B\u1ea1n h\u00e3y nh\u1ea5n v\u00e0 gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o xu\u1ed1ng d\u01b0\u1edbi. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi b\u1ea1n th\u1ef1c hi\u1ec7n thao t\u00e1c n\u00e0y th\u00ec excel s\u1ebd t\u1ef1 \u0111\u1ed9ng tr\u1ea3 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb b\u1ea1n c\u1ea7n v\u00e0 th\u1ea3 chu\u1ed9t ra khi ho\u00e0n th\u00e0nh. \u1ede \u0111\u00e2y c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y l\u00e0 c\u00f3 3 gi\u00e1 tr\u1ecb c\u1ea7n xu\u1ea5t k\u1ebft qu\u1ea3 n\u00ean k\u00e9o xu\u1ed1ng 3 \u00f4 t\u01b0\u01a1ng \u1ee9ng.<\/span><\/p>\n<figure id=\"attachment_11466\" aria-describedby=\"caption-attachment-11466\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11466 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-2.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-2.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-2-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-2-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11466\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cac_loi_thuong_xay_ra_khi_su_dung_ham_month_trong_Excel\"><\/span><span style=\"font-weight: 400;\">C\u00e1c l\u1ed7i th\u01b0\u1eddng x\u1ea3y ra khi s\u1eed d\u1ee5ng h\u00e0m month trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Loi_VALUE\"><\/span><span style=\"font-weight: 400;\">L\u1ed7i #VALUE?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i ph\u1ed5 bi\u1ebfn. L\u1ed7i n\u00e0y hay c\u00f2n g\u1ecdi l\u00e0 nh\u1eadp kh\u00f4ng ch\u00ednh x\u00e1c y\u00eau c\u1ea7u d\u1eabn \u0111\u1ebfn t\u00ecnh tr\u1ea1ng nh\u01b0 tr\u00ean.<\/span><\/p>\n<figure id=\"attachment_11467\" aria-describedby=\"caption-attachment-11467\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11467 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-1.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11467\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t<\/figcaption><\/figure>\n<h4 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Nguyen_nhan\"><\/span><span style=\"font-weight: 400;\"><strong>Nguy\u00ean nh\u00e2n<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u1ed7i n\u00e0y x\u1ea3y ra khi serial_number trong h\u00e0m MONTH kh\u00f4ng ph\u1ea3i l\u00e0 gi\u00e1 tr\u1ecb GENERAL, NUMBER, DATE m\u00e0 l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb \u1edf d\u01b0\u1edbi d\u1ea1ng TEXT (Ch\u1eef), K\u00fd t\u1ef1. L\u1ed7i n\u00e0y g\u1ecdi l\u00e0 l\u1ed7i nh\u1eadp sai h\u00e0m<\/span><\/p>\n<h4 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_de_khac_phuc\"><\/span><strong>C\u00e1ch \u0111\u1ec3 kh\u1eafc ph\u1ee5c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i v\u00f9ng d\u1eef li\u1ec7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1eb7c bi\u1ec7t c\u1ea7n nh\u1eadp ch\u00ednh x\u00e1c y\u00eau c\u1ea7u c\u1ee7a h\u00e0m v\u1ec1 ng\u00e0y, th\u00e1ng, n\u0103m l\u00e0 b\u1eb1ng s\u1ed1.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Loi_NAME\"><\/span><span style=\"font-weight: 400;\">L\u1ed7i #NAME?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u1ed7i n\u00e0y c\u0169ng l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i ph\u1ed5 bi\u1ebfn v\u00e0 th\u01b0\u1eddng xuy\u00ean xu\u1ea5t hi\u1ec7n.<\/span><\/p>\n<figure id=\"attachment_11468\" aria-describedby=\"caption-attachment-11468\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11468 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11468\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t<\/figcaption><\/figure>\n<h4 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Nguyen_nhan-2\"><\/span><span style=\"font-weight: 400;\"><strong>Nguy\u00ean nh\u00e2n <\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong h\u00e0m t\u00ednh v\u00e0 b\u1ea1n \u0111\u00e3 nh\u1eadp b\u1ecb l\u1ed7i gi\u00e1 tr\u1ecb l\u00e0 ch\u1eef ho\u1eb7c k\u00fd t\u1ef1. V\u00ed d\u1ee5: MONTH(BB), MONTH(B@), \u2026<\/span><\/p>\n<h4 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_de_khac_phuc-2\"><\/span><span style=\"font-weight: 400;\"><strong>C\u00e1ch \u0111\u1ec3 kh\u1eafc ph\u1ee5c<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u00a0B\u1ea1n c\u1ea7n ki\u1ec3m tra v\u00e0 ch\u1ec9nh s\u1eeda l\u1ea1i h\u00e0m t\u00ednh.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Loi_gia_tri_thang_giong_nhu_la_mot_ngay\"><\/span><span style=\"font-weight: 400;\">L\u1ed7i gi\u00e1 tr\u1ecb th\u00e1ng gi\u1ed1ng nh\u01b0 l\u00e0 m\u1ed9t ng\u00e0y<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Nguyen_nhan-3\"><\/span><span style=\"font-weight: 400;\"><strong>Nguy\u00ean nh\u00e2n <\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u1ed7i n\u00e0y c\u00f3 th\u1ec3 l\u00e0 do \u0111\u1ecbnh d\u1ea1ng \u1edf \u00f4 ho\u1eb7c c\u1ed9t d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng d\u01b0\u1edbi d\u1ea1ng &#8220;Date&#8221;. Ch\u00ednh v\u00ec th\u1ebf m\u00e0 k\u1ebft qu\u1ea3 xu\u1ea5t ra s\u1ebd hi\u1ec3n th\u1ecb nh\u01b0 m\u1ed9t ng\u00e0y. \u1ede \u0111\u00e2y k\u1ebft qu\u1ea3 c\u1ee7a m\u00ecnh xu\u1ea5t ra l\u00e0 ng\u00e0y 01\/01\/1900.<\/span><\/p>\n<figure id=\"attachment_11469\" aria-describedby=\"caption-attachment-11469\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11469 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11469\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t<\/figcaption><\/figure>\n<h4 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_de_khac_phuc-3\"><\/span><span style=\"font-weight: 400;\"><strong>C\u00e1ch \u0111\u1ec3 kh\u1eafc ph\u1ee5c<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi l\u1ed7i n\u00e0y th\u00ec b\u1ea1n s\u1ebd th\u1ef1c hi\u1ec7n ch\u1ecdn t\u00f9y ch\u1ecdn General t\u1eeb menu \u0111\u1ecbnh d\u1ea1ng c\u1ee7a b\u1ea3ng t\u00ednh Excel.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1eeba r\u1ed3i l\u00e0 nh\u1eefng h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t. H\u00e0m n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ednh th\u00e1ng ng\u00e0y v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n. Hy v\u1ecdng v\u1edbi nh\u1eefng chia s\u1ebb Teky.edu.vn c\u1ee5 th\u1ec3 v\u00e0 c\u00f3 v\u00ed d\u1ee5 tr\u00ean \u0111\u00e3 gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n d\u1ec5 d\u00e0ng h\u00e0m month. V\u00e0 n\u1ebfu c\u00f2n b\u1ea5t k\u1ef3 th\u1eafc m\u1eafc hay g\u00f3p \u00fd cho b\u00e0i vi\u1ebft. B\u1ea1n c\u00f3 th\u1ec3 b\u00ecnh lu\u1eadn ho\u1eb7c li\u00ean h\u1ec7 v\u1edbi ch\u00fang t\u00f4i \u0111\u1ec3 \u0111\u01b0\u1ee3c gi\u1ea3i \u0111\u00e1p nh\u00e9.<\/span><\/p>\n<p style=\"text-align: justify;\"><strong>Tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft sau<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/cach-hien-sheet-trong-excel-thuc-hien-nhu-the-nao-xem-ngay\/\">C\u00e1ch hi\u1ec7n sheet trong excel th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o- [Xem ngay]<\/a><\/li>\n<li style=\"text-align: justify;\">\n<p class=\"c-detail-head__title\"><a href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-cac-phim-tat-chuyen-sheet-trong-excel-don-gian-nhat\/\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng c\u00e1c ph\u00edm t\u1eaft chuy\u1ec3n sheet trong excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/p>\n<\/li>\n<li>\n<p class=\"c-detail-head__title\" style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/\">H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng nh\u1ea5t<\/a><\/p>\n<\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/\" target=\"_blank\" rel=\"noopener\">Nh\u1eefng \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong Excel.\u00a0<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh nh\u1ea5t<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Khi s\u1eed d\u1ee5ng Excel th\u00ec ch\u1eafc ch\u1eafn b\u1ea1n s\u1ebd nhi\u1ec1u l\u1ea7n s\u1eed d\u1ee5ng \u0111\u1ec3 g\u00f5 c\u00e1c ng\u00e0y th\u00e1ng n\u0103m. Tuy v\u1eady, nhi\u1ec1u ng\u01b0\u1eddi b\u1ea1n v\u1eabn ch\u01b0a bi\u1ebft c\u00e1ch d\u00f9ng h\u00e0m n\u00e0y. Trong b\u00e0i n\u00e0y, Teky.edu.vn s\u1ebd h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t. H\u00e3y c\u00f9ng theo d\u00f5i n\u1ed9i &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11470,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"show_on_app":false,"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11460","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"acf":{"show_on_app":false},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"H\u00e0m month d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n th\u00e1ng trong excel. Th\u1ef1c hi\u1ec7n c\u00e1c b\u00e1o c\u00e1o d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn th\u00e1ng gi\u00fap b\u1ea1n l\u00e0m ch\u00ednh x\u00e1c h\u01a1n.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m month d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n th\u00e1ng trong excel. Th\u1ef1c hi\u1ec7n c\u00e1c b\u00e1o c\u00e1o d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn th\u00e1ng gi\u00fap b\u1ea1n l\u00e0m ch\u00ednh x\u00e1c h\u01a1n.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-13T09:10:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-19T03:47:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/huong-dan-su-dung-ham-month-trong-Excel-don-gian-va-de-hieu-nhat.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Month trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\",\"datePublished\":\"2022-11-13T09:10:57+00:00\",\"dateModified\":\"2022-12-19T03:47:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/\"},\"wordCount\":2035,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/huong-dan-su-dung-ham-month-trong-Excel-don-gian-va-de-hieu-nhat.png\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/huong-dan-su-dung-ham-month-trong-Excel-don-gian-va-de-hieu-nhat.png\",\"datePublished\":\"2022-11-13T09:10:57+00:00\",\"dateModified\":\"2022-12-19T03:47:09+00:00\",\"description\":\"H\u00e0m month d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n th\u00e1ng trong excel. Th\u1ef1c hi\u1ec7n c\u00e1c b\u00e1o c\u00e1o d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn th\u00e1ng gi\u00fap b\u1ea1n l\u00e0m ch\u00ednh x\u00e1c h\u01a1n.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/huong-dan-su-dung-ham-month-trong-Excel-don-gian-va-de-hieu-nhat.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/huong-dan-su-dung-ham-month-trong-Excel-don-gian-va-de-hieu-nhat.png\",\"width\":600,\"height\":400,\"caption\":\"h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Month trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t","description":"H\u00e0m month d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n th\u00e1ng trong excel. Th\u1ef1c hi\u1ec7n c\u00e1c b\u00e1o c\u00e1o d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn th\u00e1ng gi\u00fap b\u1ea1n l\u00e0m ch\u00ednh x\u00e1c h\u01a1n.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t","og_description":"H\u00e0m month d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n th\u00e1ng trong excel. Th\u1ef1c hi\u1ec7n c\u00e1c b\u00e1o c\u00e1o d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn th\u00e1ng gi\u00fap b\u1ea1n l\u00e0m ch\u00ednh x\u00e1c h\u01a1n.","og_url":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-13T09:10:57+00:00","article_modified_time":"2022-12-19T03:47:09+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/huong-dan-su-dung-ham-month-trong-Excel-don-gian-va-de-hieu-nhat.png","type":"image\/png"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Month trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","datePublished":"2022-11-13T09:10:57+00:00","dateModified":"2022-12-19T03:47:09+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/"},"wordCount":2035,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/huong-dan-su-dung-ham-month-trong-Excel-don-gian-va-de-hieu-nhat.png","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/","url":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/","name":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/huong-dan-su-dung-ham-month-trong-Excel-don-gian-va-de-hieu-nhat.png","datePublished":"2022-11-13T09:10:57+00:00","dateModified":"2022-12-19T03:47:09+00:00","description":"H\u00e0m month d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n th\u00e1ng trong excel. Th\u1ef1c hi\u1ec7n c\u00e1c b\u00e1o c\u00e1o d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn th\u00e1ng gi\u00fap b\u1ea1n l\u00e0m ch\u00ednh x\u00e1c h\u01a1n.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/huong-dan-su-dung-ham-month-trong-Excel-don-gian-va-de-hieu-nhat.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/huong-dan-su-dung-ham-month-trong-Excel-don-gian-va-de-hieu-nhat.png","width":600,"height":400,"caption":"h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Month trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"thumbnail":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/huong-dan-su-dung-ham-month-trong-Excel-don-gian-va-de-hieu-nhat-400x267.png","_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11460","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11460"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11460\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11470"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}