{"id":4357,"date":"2024-12-04T20:54:24","date_gmt":"2024-12-04T20:54:24","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-su-dung-ham-heongaychu-de-chuyen-du-lieu-ngay-thang-ve-dang-chu\/"},"modified":"2024-12-04T20:54:24","modified_gmt":"2024-12-04T20:54:24","slug":"huong-dan-su-dung-ham-heongaychu-de-chuyen-du-lieu-ngay-thang-ve-dang-chu","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-su-dung-ham-heongaychu-de-chuyen-du-lieu-ngay-thang-ve-dang-chu\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m \u201cHeongaychu\u201d \u0111\u1ec3 chuy\u1ec3n d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng v\u1ec1 d\u1ea1ng ch\u1eef"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>B\u00e0i vi\u1ebft s\u1ebd gi\u1edbi thi\u1ec7u h\u00e0m \u201cHeongaychu\u201d trong b\u1ed9 h\u00e0m c\u1ee7a Add \u2013 ins HocExcelOnline, <strong>d\u00f9ng \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng v\u1ec1 d\u1ea1ng ch\u1eef trong Excel<\/strong> m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 thu\u1eadn ti\u1ec7n.<\/em><\/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-6750c17f9b7ed\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-heongaychu-de-doc.html#Huong_dan_su_dung_ham_%E2%80%9CHeongaychu%E2%80%9D_de_chuyen_du_lieu_ngay_thang_ve_dang_chu\" title=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m \u201cHeongaychu\u201d \u0111\u1ec3 chuy\u1ec3n d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng v\u1ec1 d\u1ea1ng ch\u1eef\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m \u201cHeongaychu\u201d \u0111\u1ec3 chuy\u1ec3n d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng v\u1ec1 d\u1ea1ng ch\u1eef<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-heongaychu-de-doc.html#Cu_phap_cua_ham_%E2%80%9CHeongaychu%E2%80%9D\" title=\"C\u00fa ph\u00e1p c\u1ee7a h\u00e0m \u201cHeongaychu\u201d\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m \u201cHeongaychu\u201d<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-heongaychu-de-doc.html#Cach_thuc_hien\" title=\"C\u00e1ch th\u1ef1c hi\u1ec7n\">C\u00e1ch th\u1ef1c hi\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-heongaychu-de-doc.html#Mot_so_diem_chu_y\" title=\"M\u1ed9t s\u1ed1 \u0111i\u1ec3m ch\u00fa \u00fd\">M\u1ed9t s\u1ed1 \u0111i\u1ec3m ch\u00fa \u00fd<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-heongaychu-de-doc.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Huong_dan_su_dung_ham_%E2%80%9CHeongaychu%E2%80%9D_de_chuyen_du_lieu_ngay_thang_ve_dang_chu\"><\/span>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m \u201cHeongaychu\u201d \u0111\u1ec3 chuy\u1ec3n d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng v\u1ec1 d\u1ea1ng ch\u1eef<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i Add \u2013 ins HocExcelOnline \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m \u201cHeongaychu\u201d:<\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\"><em><strong>Link here:\u00a0H\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t add ins hocexcelonline<\/strong><\/em><\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_%E2%80%9CHeongaychu%E2%80%9D\"><\/span>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m \u201cHeongaychu\u201d<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e0m Heongaychu trong Add \u2013 ins HocExcelOnline c\u00f3 c\u00fa ph\u00e1p \u0111\u01a1n gi\u1ea3n nh\u01b0 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29606 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-26.png\" alt=\"huong-dan-chuyen-du-lieu-ngay-thang-ve-dang-chu-1\" width=\"435\" height=\"190\" title=\"1-26\"><\/p>\n<p style=\"text-align: justify\">Tham s\u1ed1 truy\u1ec1n v\u00e0o h\u00e0m c\u00f3 th\u1ec3 l\u00e0 tham chi\u1ebfu t\u1edbi 1 \u00f4 ho\u1eb7c l\u00e0 truy\u1ec1n\u00a0 gi\u00e1 tr\u1ecb tr\u1ef1c ti\u1ebfp v\u00e0o h\u00e0m.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_thuc_hien\"><\/span>C\u00e1ch th\u1ef1c hi\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">T\u1ea1i \u00f4 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb ng\u00e0y th\u00e1ng v\u1ec1 d\u1ea1ng ch\u1eef b\u1ea1n g\u00f5 v\u00e0o c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-152.gif\" title=\"vba101_92019-nho-152\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-350.gif\" title=\"ex101_92019-nho-350\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p><strong>=Heongaychu(B3)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29607 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-26-1024x271-1.png\" alt=\"huong-dan-chuyen-du-lieu-ngay-thang-ve-dang-chu-2\" width=\"1024\" height=\"271\" title=\"2-26-1024x271-1\"><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 truy\u1ec1n gi\u00e1 tr\u1ecb tr\u1ef1c ti\u1ebfp v\u00e0o h\u00e0m.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29608 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-17.png\" alt=\"huong-dan-chuyen-du-lieu-ngay-thang-ve-dang-chu-3\" width=\"879\" height=\"342\" title=\"3-17\"><\/p>\n<p style=\"text-align: justify\">H\u00e0m s\u1ebd th\u1ef1c hi\u1ec7n \u0111\u1ecdc d\u1eef li\u1ec7u v\u00e0 chuy\u1ec3n v\u1ec1 d\u1ea1ng ch\u1eef cho b\u1ea1n m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Mot_so_diem_chu_y\"><\/span>M\u1ed9t s\u1ed1 \u0111i\u1ec3m ch\u00fa \u00fd<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify\">\n<li>V\u1edbi \u00f4 d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng nh\u01b0ng \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng General hay d\u1ea1ng Text,\u2026 th\u00ec h\u00e0m v\u1eabn hi\u1ec3u v\u00e0 t\u00ednh to\u00e1n \u0111\u1ec3 tr\u1ea3 v\u1ec1 \u0111\u00fang (\u00f4 B4 v\u00e0 B9 trong h\u00ecnh).<\/li>\n<li>v\u1edbi \u00f4 tr\u1ed1ng (kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u) th\u00ec h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 \u201cNg\u00e0y kh\u00f4ng \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng\u201d (\u00f4 B5).<\/li>\n<li>V\u1edbi \u00f4 c\u00f3 d\u1eef li\u1ec7u Text h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE! (\u00f4 B6).<\/li>\n<li>N\u1ebfu tham s\u1ed1 truy\u1ec1n v\u00e0o l\u00e0 1 v\u00f9ng th\u00ec h\u00e0m ch\u1ec9 t\u00ednh d\u1eef li\u1ec7u cho \u00f4 \u0111\u1ea7u ti\u00ean (\u00f4 B7).<\/li>\n<li>B\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p c\u00e1c h\u00e0m kh\u00e1c trong Excel v\u1edbi h\u00e0m <em><strong>Heongaychu\u00a0<\/strong><\/em>(\u00f4 B8)<i>.<\/i><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/08\/4-19.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29610 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-19-1024x396-1.png\" alt=\"huong-dan-chuyen-du-lieu-ngay-thang-ve-dang-chu-4\" width=\"1024\" height=\"396\" title=\"4-19-1024x396-1\"><\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> <\/strong>hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 n\u1eafm v\u00e0 v\u1eadn d\u1ee5ng \u0111\u01b0\u1ee3c h\u00e0m \u201cHeongaychu\u201d \u0111\u1ec3 \u0111\u1ecdc d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng v\u1ec1 d\u1ea1ng ch\u1eef 1 c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu nh\u01b0 b\u1ea1n theo d\u00f5i th\u00ec trong 1 b\u00e0i vi\u1ebf t g\u1ea7n \u0111\u00e2y, <strong>H\u1ecdc Excel Online<\/strong> c\u0169ng \u0111\u00e3 c\u00f3 b\u00e0i vi\u1ebft n\u1eefa h\u01b0\u1edbng d\u1eabn v\u1ec1 c\u00e1ch\u00a0<strong>chuy\u1ec3n d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng v\u1ec1 d\u1ea1ng ch\u1eef<\/strong> b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong Excel. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o n\u00f3 \u1edf ngay d\u01b0\u1edbi \u0111\u00e2y v\u00e0 l\u1ef1a ch\u1ecdn c\u00e1ch \u00e1p d\u1ee5ng cho ph\u00f9 h\u1ee3p \ud83d\ude0a.<\/p>\n<hr>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/chuyen-ngay-ve-dang-chu-trong-excel.html\">Chuy\u1ec3n d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng v\u1ec1 d\u1ea1ng ch\u1eef trong excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\">H\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t add ins hocexcelonline<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-heounique-loc-khong-trung.html\">H\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t add ins hocexcelonline<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-add-ins-hocexcel-online-de-tim-kiem-nhieu-dieu-kien-tu-file-dang-dong.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng add ins hocexcel online \u0111\u1ec3 t\u00ecm ki\u1ebfm nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n t\u1eeb file \u0111ang \u0111\u00f3ng<\/a><\/strong><\/em><\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-152.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4358,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4357","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4357","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=4357"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4357\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4358"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}