{"id":11914,"date":"2025-01-15T06:01:18","date_gmt":"2025-01-15T06:01:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-dien-ngay-thang-vao-excel-them-thong-tin-ngay-thang-hien-tai-tu-dong-dien-ngay-thang-vao-cot\/"},"modified":"2025-01-15T06:01:18","modified_gmt":"2025-01-15T06:01:18","slug":"cach-dien-ngay-thang-vao-excel-them-thong-tin-ngay-thang-hien-tai-tu-dong-dien-ngay-thang-vao-cot","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-dien-ngay-thang-vao-excel-them-thong-tin-ngay-thang-hien-tai-tu-dong-dien-ngay-thang-vao-cot\/","title":{"rendered":"C\u00e1ch \u0111i\u1ec1n ng\u00e0y th\u00e1ng v\u00e0o Excel, th\u00eam th\u00f4ng tin ng\u00e0y th\u00e1ng hi\u1ec7n t\u1ea1i, t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n ng\u00e0y th\u00e1ng v\u00e0o c\u1ed9t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">V\u1edbi b\u00e0i vi\u1ebft n\u00e0y, Blog H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n nh\u1eefng c\u00e1ch th\u1ee9c kh\u00e1c nhau \u0111\u1ec3 \u0111i\u1ec1n ng\u00e0y th\u00e1ng v\u00e0o Excel, c\u00e1ch \u0111i\u1ec1n th\u00f4ng tin ng\u00e0y, th\u00e1ng, gi\u1edd hi\u1ec7n t\u1ea1i nh\u01b0 l\u00e0 gi\u00e1 tr\u1ecb t\u0129nh ho\u1eb7c \u0111\u1ed9ng, c\u0169ng nh\u01b0 c\u00e1ch l\u1ea5p \u0111\u1ea7y m\u1ed9t c\u1ed9t ho\u1eb7c d\u00f2ng v\u1edbi th\u00f4ng tin ng\u00e0y th\u00e1ng, ho\u1eb7c t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n m\u1ed9t ng\u00e0y ng\u1eabu nhi\u00ean n\u00e0o \u0111\u00f3 v\u00e0o Excel.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\">K<span data-sheets-value='{\"1\":2,\"2\":\"kh\u00f3a h\u1ecdc word excel \"}' data-sheets-userformat='{\"2\":2561,\"3\":[null,0],\"12\":0,\"14\":[null,2,16711680]}'>h\u00f3a h\u1ecdc word excel <\/span><\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">C\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch \u0111\u1ec3 th\u00eam ng\u00e0y th\u00e1ng v\u00e0o Excel t\u00f9y thu\u1ed9c v\u00e0o m\u1ee5c \u0111\u00edch c\u1ee7a b\u1ea1n l\u00e0 g\u00ec. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 mu\u1ed1n \u0111i\u1ec1n th\u00f4ng tin ng\u00e0y th\u00e1ng v\u00e0o b\u00e1o c\u00e1o hay h\u00f3a \u0111\u01a1n kh\u00f4ng? Hay b\u1ea1n mu\u1ed1n \u0111i\u1ec1n v\u00e0o Excel ng\u00e0y th\u00e1ng t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt v\u00e0 lu\u00f4n hi\u1ec3n th\u1ecb ng\u00e0y, th\u00e1ng, gi\u1edd hi\u1ec7n t\u1ea1i? Hay b\u1ea1n mu\u1ed1n t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n c\u00e1c ng\u00e0y trong tu\u1ea7n ho\u1eb7c \u0111i\u1ec1n m\u1ed9t ng\u00e0y ng\u1eabu nhi\u00ean v\u00e0o trong trang t\u00ednh c\u1ee7a m\u00ecnh?<\/p>\n<p style=\"text-align: justify\">B\u1ea1n s\u1ebd bi\u1ebft \u0111\u01b0\u1ee3c c\u00e1ch th\u1ee9c \u0111\u1ec3 th\u1ef1c hi\u1ec7n t\u1ea5t c\u1ea3 c\u00e1c m\u1ee5c ti\u00eau \u0111\u00f3 \u0111\u00f3 th\u00f4ng qua b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y. N\u1ebfu b\u1ea1n c\u00f2n t\u00f2 m\u00f2 v\u1ec1 c\u00e1ch Excel l\u01b0u th\u00f4ng tin ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian\u00a0nh\u01b0 th\u1ebf n\u00e0o, h\u00e3y t\u00ecm hi\u1ec3u b\u00e0i vi\u1ebft <a href=\"http:\/\/blog.ezworkapp.com\/cach-chinh-dung-dinh-dang-ngay-thang-nam-trong-excel.html\" target=\"_blank\" rel=\"noopener\"><em>\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng tr\u00ean Excel<\/em> <\/a>nh\u00e9.<\/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-67874f29d08fd\" 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\/cach-dien-ngay-thang-vao-excel-thong-tin-ngay-thang-hien-tai-tu-dong-dien-ngay-thang-vao-cot.html#Cach_dien_ngay_thang_tren_Excel\" title=\"C\u00e1ch \u0111i\u1ec1n ng\u00e0y th\u00e1ng tr\u00ean Excel:\">C\u00e1ch \u0111i\u1ec1n ng\u00e0y th\u00e1ng tr\u00ean Excel:<\/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\/cach-dien-ngay-thang-vao-excel-thong-tin-ngay-thang-hien-tai-tu-dong-dien-ngay-thang-vao-cot.html#Cach_dien_ngay_thang_gio_hien_tai_tren_Excel\" title=\"C\u00e1ch \u0111i\u1ec1n ng\u00e0y, th\u00e1ng, gi\u1edd hi\u1ec7n t\u1ea1i\u00a0tr\u00ean Excel:\">C\u00e1ch \u0111i\u1ec1n ng\u00e0y, th\u00e1ng, gi\u1edd hi\u1ec7n t\u1ea1i\u00a0tr\u00ean Excel:<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-dien-ngay-thang-vao-excel-thong-tin-ngay-thang-hien-tai-tu-dong-dien-ngay-thang-vao-cot.html#Cac_phim_tat_de_dien_ngay_thang_nam_hien_tai_vao_Excel_nhu_mot_timestamp\" title=\"C\u00e1c ph\u00edm t\u1eaft\u00a0\u0111\u1ec3 \u0111i\u1ec1n ng\u00e0y th\u00e1ng n\u0103m hi\u1ec7n t\u1ea1i v\u00e0o Excel (nh\u01b0 m\u1ed9t timestamp)\">C\u00e1c ph\u00edm t\u1eaft\u00a0\u0111\u1ec3 \u0111i\u1ec1n ng\u00e0y th\u00e1ng n\u0103m hi\u1ec7n t\u1ea1i v\u00e0o Excel (nh\u01b0 m\u1ed9t timestamp)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-dien-ngay-thang-vao-excel-thong-tin-ngay-thang-hien-tai-tu-dong-dien-ngay-thang-vao-cot.html#Cach_dien_ngay_thang_va_gio_hien_tai_ma_co_the_tu_dong_cap_nhat\" title=\"C\u00e1ch \u0111i\u1ec1n ng\u00e0y th\u00e1ng v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i m\u00e0 c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt\">C\u00e1ch \u0111i\u1ec1n ng\u00e0y th\u00e1ng v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i m\u00e0 c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-dien-ngay-thang-vao-excel-thong-tin-ngay-thang-hien-tai-tu-dong-dien-ngay-thang-vao-cot.html#Cach_dien_ngay_thang_va_gio_hien_tai_nhu_mot_timestamp_khong_doi\" title=\"C\u00e1ch \u0111i\u1ec1n ng\u00e0y, th\u00e1ng v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i nh\u01b0 m\u1ed9t timestamp kh\u00f4ng \u0111\u1ed5i:\">C\u00e1ch \u0111i\u1ec1n ng\u00e0y, th\u00e1ng v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i nh\u01b0 m\u1ed9t timestamp kh\u00f4ng \u0111\u1ed5i:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-dien-ngay-thang-vao-excel-thong-tin-ngay-thang-hien-tai-tu-dong-dien-ngay-thang-vao-cot.html#Cach_tu_dong_lap_day_thong_tin_ngay_thang_vao_cot_trong_Excel\" title=\"C\u00e1ch t\u1ef1 \u0111\u1ed9ng l\u1ea5p \u0111\u1ea7y th\u00f4ng tin ng\u00e0y th\u00e1ng v\u00e0o c\u1ed9t trong Excel:\">C\u00e1ch t\u1ef1 \u0111\u1ed9ng l\u1ea5p \u0111\u1ea7y th\u00f4ng tin ng\u00e0y th\u00e1ng v\u00e0o c\u1ed9t trong Excel:<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-dien-ngay-thang-vao-excel-thong-tin-ngay-thang-hien-tai-tu-dong-dien-ngay-thang-vao-cot.html#Cach_dien_mot_day_ngay_thang_theo_thu_tu_tang_dan_theo_ngay\" title=\"C\u00e1ch \u0111i\u1ec1n m\u1ed9t d\u00e3y ng\u00e0y th\u00e1ng theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n theo ng\u00e0y:\">C\u00e1ch \u0111i\u1ec1n m\u1ed9t d\u00e3y ng\u00e0y th\u00e1ng theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n theo ng\u00e0y:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-dien-ngay-thang-vao-excel-thong-tin-ngay-thang-hien-tai-tu-dong-dien-ngay-thang-vao-cot.html#Tu_dong_dien_cac_ngay_cac_thang_hoac_cac_nam\" title=\"T\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n c\u00e1c ng\u00e0y, c\u00e1c th\u00e1ng ho\u1eb7c c\u00e1c n\u0103m:\">T\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n c\u00e1c ng\u00e0y, c\u00e1c th\u00e1ng ho\u1eb7c c\u00e1c n\u0103m:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-dien-ngay-thang-vao-excel-thong-tin-ngay-thang-hien-tai-tu-dong-dien-ngay-thang-vao-cot.html#Tu_dong_dien_ngay_thang_theo_khoang_cach_nhat_dinh\" title=\"T\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n ng\u00e0y th\u00e1ng theo kho\u1ea3ng c\u00e1ch nh\u1ea5t \u0111\u1ecbnh:\">T\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n ng\u00e0y th\u00e1ng theo kho\u1ea3ng c\u00e1ch nh\u1ea5t \u0111\u1ecbnh:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-dien-ngay-thang-vao-excel-thong-tin-ngay-thang-hien-tai-tu-dong-dien-ngay-thang-vao-cot.html#Cach_dien_ngay_thang_mot_cach_ngau_nhien_trong_Excel\" title=\"C\u00e1ch \u0111i\u1ec1n ng\u00e0y th\u00e1ng m\u1ed9t c\u00e1ch ng\u1eabu nhi\u00ean trong Excel:\">C\u00e1ch \u0111i\u1ec1n ng\u00e0y th\u00e1ng m\u1ed9t c\u00e1ch ng\u1eabu nhi\u00ean trong Excel:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dien_ngay_thang_tren_Excel\"><\/span>C\u00e1ch \u0111i\u1ec1n ng\u00e0y th\u00e1ng tr\u00ean Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1n th\u00f4ng tin ng\u00e0y th\u00e1ng v\u00e0o m\u1ed9t \u00f4 tr\u00ean Excel b\u1eb1ng r\u1ea5t nhi\u1ec1u c\u00e1ch, v\u00ed d\u1ee5 nh\u01b0 1\/1\/2015 hay 1-Jan-2015, ho\u1eb7c 1-Jan, January 1, 2015. Khi b\u1ea1n \u0111i\u1ec1n th\u00f4ng tin nh\u01b0 v\u1eady v\u00e0o m\u1ed9t \u00f4 tr\u00ean Excel, Excel s\u1ebd bi\u1ebft r\u1eb1ng b\u1ea1n \u0111ang \u0111i\u1ec1n th\u00f4ng tin ng\u00e0y th\u00e1ng v\u00e0 t\u1ef1 \u0111\u1ed9ng \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng cho th\u00f4ng tin b\u1ea1n v\u1eeba \u0111i\u1ec1n. Th\u00f4ng th\u01b0\u1eddng, Excel s\u1ebd \u0111\u1ecbnh d\u1ea1ng th\u00f4ng tin \u0111\u00f3 d\u1ef1a tr\u00ean \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng m\u1eb7c \u0111\u1ecbnh tr\u00ean Windows, nh\u01b0ng \u0111\u00f4i khi n\u00f3 s\u1ebd gi\u1ed1ng y h\u1ec7t nh\u1eefng g\u00ec b\u1ea1n m\u1edbi \u0111i\u1ec1n v\u00e0o.<\/p>\n<p style=\"text-align: justify\">Khi b\u1ea1n \u0111i\u1ec1n th\u00f4ng tin ng\u00e0y, th\u00e1ng, gi\u1edd, Excel s\u1ebd nh\u1eadn bi\u1ebft v\u00e0 t\u1ef1 \u0111\u1ed9ng c\u0103n l\u1ec1 ph\u1ea3i cho c\u00e1c th\u00f4ng tin, tr\u00e1i ng\u01b0\u1ee3c v\u1edbi vi\u1ec7c c\u0103n l\u1ec1 tr\u00e1i khi b\u1ea1n nh\u1eadp th\u00f4ng tin d\u01b0\u1edbi d\u1ea1ng ch\u1eef.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5626 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/entering-dates-excel.png\" width=\"169\" height=\"166\" title=\"entering-dates-excel\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu Excel kh\u00f4ng nh\u1eadn bi\u1ebft \u0111\u01b0\u1ee3c th\u00f4ng tin b\u1ea1n m\u1edbi \u0111i\u1ec1n l\u00e0 ng\u00e0y th\u00e1ng ( l\u00fac \u1ea5y th\u00f4ng tin s\u1ebd \u0111\u01b0\u1ee3c c\u0103n l\u1ec1 tr\u00e1i), h\u00e3y th\u1eed \u0111i\u1ec1n ng\u00e0y th\u00e1ng b\u1eb1ng nh\u1eefng \u0111\u1ecbnh d\u1ea1ng kh\u00e1c g\u1ea7n gi\u1ed1ng v\u1edbi \u0111\u1ecbnh d\u1ea1ng m\u1eb7c \u0111\u1ecbnh c\u1ee7a Windows. \u0110\u1ecbnh d\u1ea1ng m\u1eb7c \u0111\u1ecbnh s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u hoa th\u1ecb (*) \u1edf c\u1eeda s\u1ed5 <em>Format Cell<\/em>. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 v\u00e0o tab <em>Home &gt; nh\u00f3m Number<\/em> tr\u00ean thanh Ribbon \u0111\u1ec3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng \u1edf d\u1ea1ng d\u00e0i ho\u1eb7c d\u1ea1ng ng\u1eafn.<\/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\/2025\/01\/vba101_92019-nho-66.gif\" title=\"vba101_92019-nho-66\"><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\/2025\/01\/ex101_92019-nho-335.gif\" title=\"ex101_92019-nho-335\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-5631 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-default-date-time-formats-153x300-1.png\" width=\"153\" height=\"300\" title=\"excel-default-date-time-formats-153x300-1\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng b\u1eb1ng h\u1ed9p tho\u1ea1i Format Cells, m\u1edf b\u1eb1ng ph\u00edm t\u1eaft <em>Ctrl + 1<\/em>. H\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft <em>C\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng tr\u00ean Excel<\/em> \u0111\u1ec3 bi\u1ebft c\u00e1ch l\u00e0m chi ti\u1ebft nh\u00e9.<\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd.<\/strong> N\u1ebfu ng\u00e0y th\u00e1ng b\u1ea1n nh\u1eadp hi\u1ec3n th\u1ecb th\u00e0nh m\u1ed9t d\u00e3y c\u00e1c d\u1ea5u th\u0103ng (#####), kh\u1ea3 n\u0103ng cao l\u00e0 v\u00ec \u00f4 kh\u00f4ng \u0111\u1ee7 r\u1ed9ng \u0111\u1ec3 ch\u1ee9a v\u1eeba th\u00f4ng tin. \u0110\u1ec3 kh\u1eafc ph\u1ee5c, b\u1ea1n c\u00f3 th\u1ec3 click chu\u1ed9t \u0111\u00f4i v\u00e0o c\u1ea1nh b\u00ean ph\u1ea3i c\u1ee7a \u00f4 \u0111\u1ec3 Excel t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh, ho\u1eb7c d\u00f9ng chu\u1ed9t k\u00e9o c\u1ea1nh b\u00ean ph\u1ea3i \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng theo \u00fd mu\u1ed1n. N\u1ebfu c\u00e1ch n\u00e0y kh\u00f4ng hi\u1ec7u qu\u1ea3, b\u1ea1n h\u00e3y t\u00ecm hi\u1ec3u c\u00e1c c\u00e1ch kh\u00e1c trong b\u00e0i <em>M\u1eb9o \u0111\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng tr\u00ean Excel<\/em>.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dien_ngay_thang_gio_hien_tai_tren_Excel\"><\/span>C\u00e1ch \u0111i\u1ec1n ng\u00e0y, th\u00e1ng, gi\u1edd hi\u1ec7n t\u1ea1i\u00a0tr\u00ean Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">T\u1ea1i Excel, b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1n th\u00f4ng tin ng\u00e0y, th\u00e1ng, gi\u1edd hi\u1ec7n t\u1ea1i d\u01b0\u1edbi d\u1ea1ng gi\u00e1 tr\u1ecb t\u0129nh ho\u1eb7c gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html\">\u0110\u1ecbnh d\u1ea1ng th\u1eddi gian trong Excel &amp; c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m NOW v\u00e0 TIME \u0111\u1ec3 ch\u00e8n th\u1eddi gian<\/a><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cac_phim_tat_de_dien_ngay_thang_nam_hien_tai_vao_Excel_nhu_mot_timestamp\"><\/span>C\u00e1c ph\u00edm t\u1eaft\u00a0\u0111\u1ec3 \u0111i\u1ec1n ng\u00e0y th\u00e1ng n\u0103m hi\u1ec7n t\u1ea1i v\u00e0o Excel (nh\u01b0 m\u1ed9t timestamp)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Tr\u01b0\u1edbc h\u1ebft, h\u00e3y t\u00ecm hi\u1ec3u xem timestamp l\u00e0 g\u00ec nh\u00e9. Timestamp ch\u00ednh l\u00e0 \u0111i\u1ec1n m\u1ed9t \u201cng\u00e0y th\u00e1ng t\u0129nh\u201d v\u00e0o Excel, th\u00f4ng tin n\u00e0y s\u1ebd kh\u00f4ng thay \u0111\u1ed5i m\u1ed7i l\u1ea7n b\u1ea1n m\u1edf Excel hay th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n tr\u00ean trang t\u00ednh.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady, n\u1ebfu m\u1ee5c \u0111\u00edch c\u1ee7a b\u1ea1n l\u00e0 l\u00e0 \u0111i\u1ec1n ng\u00e0y, th\u00e1ng, gi\u1edd hi\u1ec7n t\u1ea1i nh\u01b0 m\u1ed9t gi\u00e1 tr\u1ecb t\u0129nh m\u00e0 kh\u00f4ng t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt v\u00e0o nh\u1eefng ng\u00e0y ti\u1ebfp theo, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u1eefng ph\u00edm t\u1eaft sau \u0111\u00e2y:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong><em>Ctrl + ;<\/em><\/strong>\u00a0ph\u00edm t\u1eaft \u0111\u1ec3 \u0111i\u1ec1n ng\u00e0y th\u00e1ng hi\u1ec7n t\u1ea1i v\u00e0o trong \u00f4<\/li>\n<li><strong><em>Ctrl + Shift + ;<\/em><\/strong> ph\u00edm t\u1eaft \u0111\u1ec3 \u0111i\u1ec1n th\u1eddi gian hi\u1ec7n t\u1ea1i v\u00e0o \u00f4<\/li>\n<li>\u0110\u1ec3 \u0111i\u1ec1n c\u1ea3 hai th\u00f4ng tin th\u1eddi gian v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i v\u00e0o c\u00f9ng m\u1ed9t \u00f4, nh\u1ea5n ph\u00edm <em><strong>Ctrl + ;<\/strong><\/em> v\u00e0 nh\u1ea5n ph\u00edm c\u00e1ch, sau \u0111\u00f3 nh\u1ea5n <em><strong>Ctrl + Shift + ;<\/strong><\/em><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-5625 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/enter-current-excel-date-300x91-1.png\" width=\"300\" height=\"91\" title=\"enter-current-excel-date-300x91-1\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dien_ngay_thang_va_gio_hien_tai_ma_co_the_tu_dong_cap_nhat\"><\/span>C\u00e1ch \u0111i\u1ec1n ng\u00e0y th\u00e1ng v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i m\u00e0 c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n \u0111i\u1ec1n th\u00f4ng tin ng\u00e0y th\u00e1ng hi\u1ec7n t\u1ea1i v\u00e0o Excel m\u00e0 c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng m\u1ed9t trong hai ch\u1ee9c n\u0103ng sau c\u1ee7a Excel:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>=TODAY()<\/strong> \u2013 \u0111i\u1ec1n th\u00f4ng tin ng\u00e0y th\u00e1ng v\u00e0o \u00f4<\/li>\n<li><strong>=NOW()<\/strong> \u2013 \u0111i\u1ec1n th\u00f4ng tin ng\u00e0y, th\u00e1ng v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i v\u00e0o \u00f4<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5633 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/today-now-functions.png\" width=\"194\" height=\"61\" title=\"today-now-functions\"><\/p>\n<p style=\"text-align: justify\">Kh\u00f4ng gi\u1ed1ng nh\u01b0 nh\u1eefng c\u00e1ch l\u00e0m t\u1eaft, hai ch\u1ee9c n\u0103ng TODAY v\u00e0 NOW s\u1ebd lu\u00f4n lu\u00f4n c\u1eadp nh\u1eadt ng\u00e0y, th\u00e1ng v\u00e0 gi\u1edd m\u1edbi nh\u1ea5t trong file Excel c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">Khi s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng TODAY v\u00e0 NOW c\u1ee7a Excel, h\u00e3y lu\u00f4n l\u01b0u \u00fd r\u1eb1ng:<\/p>\n<ul style=\"text-align: justify\">\n<li>Th\u00f4ng tin ng\u00e0y, th\u00e1ng v\u00e0 gi\u1edd s\u1ebd kh\u00f4ng c\u1eadp nh\u1eadt li\u00ean t\u1ee5c m\u00e0 ch\u1ec9 c\u1eadp nh\u1eadt khi file t\u1eaft \u0111i v\u00e0\u00a0m\u1edf l\u1ea1i, ho\u1eb7c khi c\u00f3 m\u1ed9t l\u1ec7nh ch\u1ee9a ch\u1ee9c n\u0103ng \u0111\u00f3 ho\u1ea1t \u0111\u1ed9ng.<\/li>\n<li>Ch\u1ee9c n\u0103ng n\u00e0y s\u1ebd l\u1ea5y th\u00f4ng tin ng\u00e0y, th\u00e1ng, gi\u1edd hi\u1ec7n t\u1ea1i d\u1ef1a tr\u00ean h\u1ec7 th\u1ed1ng \u0111\u1ed3ng h\u1ed3 tr\u00ean m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n.<\/li>\n<\/ul>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dien_ngay_thang_va_gio_hien_tai_nhu_mot_timestamp_khong_doi\"><\/span>C\u00e1ch \u0111i\u1ec1n ng\u00e0y, th\u00e1ng v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i nh\u01b0 m\u1ed9t timestamp kh\u00f4ng \u0111\u1ed5i:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Blog h\u1ecdc Excel Online \u0111\u00e3 nhi\u1ec1u l\u1ea7n nh\u1eadn \u0111\u01b0\u1ee3c c\u00e2u h\u1ecfi \u2013 \u201cT\u00f4i c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c n\u00e0o \u0111\u1ec3 \u0111i\u1ec1n timestamp v\u00e0o Excel m\u00e0 n\u00f3 kh\u00f4ng thay \u0111\u1ed5i m\u1ed7i khi trang t\u00ednh \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n l\u1ea1i ho\u1eb7c \u0111\u01b0\u1ee3c m\u1edf l\u1ea1i?\u201d<\/p>\n<p style=\"text-align: justify\">V\u1edbi nh\u1eefng ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u, HocExcelOnline mu\u1ed1n l\u01b0u \u00fd v\u1edbi c\u00e1c b\u1ea1n r\u1eb1ng c\u00e1ch l\u00e0m s\u1ebd c\u1ea7n s\u1eed d\u1ee5ng \u0111\u1ebfn tham chi\u1ebfu v\u00f2ng v\u00e0 c\u1ea7n th\u1ef1c hi\u1ec7n m\u1ed9t c\u00e1ch c\u1ea9n th\u1eadn, k\u1ef9 l\u01b0\u1ee1ng. B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u c\u00f4ng th\u1ee9c ngay d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch nh\u1eefng m\u00f3n h\u00e0ng v\u00e0o c\u1ed9t A (Item), v\u00e0 c\u1ee9 khi n\u00e0o m\u1ed9t m\u00f3n \u0111\u1ed3 \u1edf c\u1ed9t A \u0111\u01b0\u1ee3c giao \u0111\u1ebfn kh\u00e1ch h\u00e0ng th\u00e0nh c\u00f4ng, b\u1ea1n s\u1ebd \u0111i\u1ec1n \u201cYes\u201d v\u00e0o c\u1ed9t B (Delivery). B\u1ea5t c\u1ee9 khi n\u00e0o c\u00f3 Yes \u0111\u01b0\u1ee3c \u0111i\u1ec1n v\u00e0o c\u1ed9t B, b\u1ea1n mu\u1ed1n th\u1eddi gian v\u00e0 ng\u00e0y th\u00e1ng s\u1ebd \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n v\u00e0o c\u00f9ng h\u00e0ng t\u1ea1i c\u1ed9t C nh\u01b0 m\u1ed9t timestamp t\u0129nh kh\u00f4ng thay \u0111\u1ed5i.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c vi\u1ec7c n\u00e0y, c\u00fang ta s\u1ebd d\u00f9ng c\u00f4ng th\u1ee9c IF v\u1edbi tham chi\u1ebfu v\u00f2ng:<br \/>\n<strong>=IF(B2=\u201dyes\u201d, IF(C2=\u201d\u201d ,NOW(), C2), \u201c\u201d)<\/strong><br \/>\nTrong c\u00f4ng th\u1ee9c n\u00e0y, c\u1ed9t B l\u00e0 c\u1ed9t Delivery, c\u00f2n C2 l\u00e0 \u00f4 m\u00e0 b\u1ea1n \u0111i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0 l\u00e0 \u00f4 s\u1ebd ch\u1ee9a timestamp.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-5630 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-circula-formula-timestamp-300x170-1.png\" width=\"300\" height=\"170\" title=\"excel-circula-formula-timestamp-300x170-1\"><\/p>\n<p style=\"text-align: justify\">\u1ede trong c\u00f4ng th\u1ee9c tr\u00ean, c\u00f4ng th\u1ee9c IF \u0111\u1ea7u ti\u00ean s\u1ebd x\u00e1c nh\u1eadn t\u1ea1i \u00f4 B2 c\u00f3 t\u1eeb \u201cYes\u201d (hay b\u1ea5t c\u1ee9 m\u1ed9t t\u1eeb n\u00e0o kh\u00e1c m\u00e0 b\u1ea1n \u0111\u1ecbnh s\u1eed d\u1ee5ng), v\u00e0 khi t\u1eeb \u0111\u00f3 xu\u1ea5t hi\u1ec7n, n\u00f3 s\u1ebd k\u00edch ho\u1ea1t c\u00f4ng th\u1ee9c IF th\u1ee9 2, ho\u1eb7c tr\u1ea3 l\u1ea1i m\u1ed9t d\u00e3y tr\u1ed1ng. C\u00f4ng th\u1ee9c IF th\u1ee9 2 l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c v\u00f2ng khi\u1ebfn cho NOW s\u1ebd tr\u1ea3 l\u1ea1i th\u00f4ng tin ng\u00e0y th\u00e1ng hi\u1ec7n t\u1ea1i n\u1ebfu C2 ch\u01b0a c\u00f3 gi\u00e1 tr\u1ecb n\u00e0o \u0111\u01b0\u1ee3c \u0111i\u1ec1n v\u00e0o trong \u0111\u00f3, ch\u00ednh v\u00ec v\u1eady s\u1ebd b\u1ea3o to\u00e0n t\u1ea5t c\u1ea3 nh\u1eefng timestamp \u0111\u00e3 t\u1ed3n t\u1ea1i.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n timestamp xu\u1ea5t hi\u1ec7n kh\u00f4ng ph\u1ee5 thu\u1ed9c l\u00e0 b\u1ea1n s\u1ebd \u0111i\u1ec1n g\u00ec v\u00e0o B2\u00a0(ch\u1eef, s\u1ed1 hay k\u00fd hi\u1ec7u), h\u00e3y thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c IF \u0111\u1ea7u ti\u00ean \u0111\u1ec3 n\u00f3 x\u00e1c nh\u1eadn nh\u1eefng \u00f4 c\u00f3 d\u1eef li\u1ec7u:<br \/>\n<strong>=IF(B2&lt;&gt;\u201d\u201d, IF(C2=\u201d\u201d ,NOW(), C2), \u201c\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\"><em><strong>L\u01b0u \u00fd.<\/strong> \u0110\u1ec3 c\u00f4ng th\u1ee9c v\u00f2ng Excel n\u00e0y hi\u1ec7u qu\u1ea3, b\u1ea1n n\u00ean c\u00e0i \u0111\u1eb7t \u0111\u1ec3 Excel cho ph\u00e9p t\u00ednh to\u00e1n l\u1eb7p l\u1ea1i, ngh\u0129a l\u00e0 cho ph\u00e9p trang t\u00ednh l\u1eb7p l\u1ea1i vi\u1ec7c t\u00ednh to\u00e1n li\u00ean t\u1ee5c cho \u0111\u1ebfn khi m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3 v\u1ec1 s\u1ed1 \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng. V\u00e0 th\u1ef1c t\u1ebf th\u00ec c\u00f3 r\u1ea5t nhi\u1ec1u l\u00fd do \u0111\u1ec3 kh\u00f4ng s\u1eed d\u1ee5ng tham chi\u1ebfu v\u00f2ng trong Excel v\u00e0 n\u1ebfu b\u1ea1n quy\u1ebft \u0111\u1ecbnh s\u1eed d\u1ee5ng ph\u01b0\u01a1ng \u00e1n n\u00e0y, b\u1ea1n s\u1ebd ph\u1ea3i ch\u1ea5p nh\u1eadn r\u1ee7i ro.<\/em><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tu_dong_lap_day_thong_tin_ngay_thang_vao_cot_trong_Excel\"><\/span>C\u00e1ch t\u1ef1 \u0111\u1ed9ng l\u1ea5p \u0111\u1ea7y th\u00f4ng tin ng\u00e0y th\u00e1ng v\u00e0o c\u1ed9t trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n \u0111i\u1ec1n ng\u00e0y th\u00e1ng v\u00e0o m\u1ed9t d\u00e3y c\u00e1c \u00f4 trong h\u00e0ng ho\u1eb7c c\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng c\u1ee7a Excel mang t\u00ean AutoFill.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dien_mot_day_ngay_thang_theo_thu_tu_tang_dan_theo_ngay\"><\/span>C\u00e1ch \u0111i\u1ec1n m\u1ed9t d\u00e3y ng\u00e0y th\u00e1ng theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n theo ng\u00e0y:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111i\u1ec1n ng\u00e0y th\u00e1ng v\u00e0o trong m\u1ed9t c\u1ed9t ho\u1eb7c m\u1ed9t h\u00e0ng v\u00e0 nh\u1eefng th\u00f4ng tin \u0111\u00f3 \u0111\u01b0\u1ee3c x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n theo ng\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110i\u1ec1n ng\u00e0y \u0111\u1ea7u ti\u00ean v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean tr\u00ean Excel.<\/li>\n<li>Click v\u00e0o \u00f4 ch\u1ee9a ng\u00e0y \u0111\u1ea7u ti\u00ean \u0111\u1ec3 ch\u1ecdn, sau \u0111\u00f3 k\u00e9o Fill Handle sang b\u00ean ph\u1ea3i ho\u1eb7c xu\u1ed1ng d\u01b0\u1edbi t\u1ea5t c\u1ea3 c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u0111i\u1ec1n ng\u00e0y th\u00e1ng. Fill Handle ch\u00ednh l\u00e0 m\u1ed9t \u00f4 vu\u00f4ng nh\u1ecf n\u1eb1m \u1edf g\u00f3c b\u00ean ph\u1ea3i d\u01b0\u1edbi c\u00f9ng \u1edf \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn, nh\u01b0 trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5624 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/auto-fill-dates-excel.png\" width=\"235\" height=\"208\" title=\"auto-fill-dates-excel\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tu_dong_dien_cac_ngay_cac_thang_hoac_cac_nam\"><\/span>T\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n c\u00e1c ng\u00e0y, c\u00e1c th\u00e1ng ho\u1eb7c c\u00e1c n\u0103m:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">C\u00f3 hai c\u00e1ch m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1n t\u1ef1 \u0111\u1ed9ng ng\u00e0y, th\u00e1ng, n\u0103m v\u00e0o m\u1ed9t c\u1ed9t.<br \/>\n<strong>1.<\/strong> B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng Auto Fill nh\u01b0 h\u01b0\u1edbng d\u1eabn b\u00ean tr\u00ean. Khi c\u00e1c \u00f4 trong c\u1ed9t \u0111\u00e3 c\u00f3 \u0111\u1ea7y \u0111\u1ee7 c\u00e1c th\u00f4ng tin ng\u00e0y th\u00e1ng n\u0103m theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n, h\u00e3y click v\u00e0o c\u00e1c l\u1ef1a ch\u1ecdn AutoFill v\u00e0 l\u1ef1a ch\u1ecdn Fill Weekdays, Fill Months ho\u1eb7c Fill Years\u00a0theo \u00fd mu\u1ed1n nh\u00e9.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-5628 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-autofill-weekdays-198x300-1.png\" width=\"198\" height=\"300\" title=\"excel-autofill-weekdays-198x300-1\"><\/p>\n<p style=\"text-align: justify\"><strong>2.<\/strong> M\u1ed9t c\u00e1ch l\u00e0m n\u1eefa l\u00e0 \u0111i\u1ec1n ng\u00e0y \u0111\u1ea7u ti\u00ean v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean, ch\u1ecdn \u00f4 \u0111\u00f3, click chu\u1ed9t ph\u1ea3i v\u00e0 k\u00e9o Fill Handle xu\u1ed1ng cho \u0111\u1ebfn \u00f4 cu\u1ed1i c\u00f9ng b\u1ea1n mu\u1ed1n \u0111i\u1ec1n ng\u00e0y th\u00e1ng, sau \u0111\u00f3 th\u1ea3 chu\u1ed9t. Khi \u0111\u00f3 Excel s\u1ebd hi\u1ec7n ra menu v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 click v\u00e0o l\u1ef1a ch\u1ecdn ph\u00f9 h\u1ee3p cho m\u00ecnh.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-5629 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-autofill-weekdays2-206x300-1.png\" width=\"206\" height=\"300\" title=\"excel-autofill-weekdays2-206x300-1\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tu_dong_dien_ngay_thang_theo_khoang_cach_nhat_dinh\"><\/span>T\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n ng\u00e0y th\u00e1ng theo kho\u1ea3ng c\u00e1ch nh\u1ea5t \u0111\u1ecbnh:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng c\u00e1ch th\u1ee9 2 \u0111\u01b0\u1ee3c n\u00eau \u1edf tr\u00ean, b\u1ea1n s\u1ebd nh\u1eadn th\u1ea5y l\u00e0 Excel c\u00f3 r\u1ea5t nhi\u1ec1u l\u1ef1a ch\u1ecdn \u0111i\u1ec1n ng\u00e0y th\u00e1ng cho b\u1ea1n. M\u1ed9t trong nh\u1eefng l\u1ef1a ch\u1ecdn \u0111\u00f3 l\u00e0 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n ng\u00e0y th\u00e1ng theo kho\u1ea3ng c\u00e1ch nh\u1ea5t \u0111\u1ecbnh, v\u00ed d\u1ee5 ng\u00e0y tr\u01b0\u1edbc c\u00e1ch ng\u00e0y sau 3 ng\u00e0y, 3 th\u00e1ng ho\u1eb7c 3 n\u0103m ch\u1eb3ng h\u1ea1n. H\u00e3y th\u1eed xem c\u00e1c b\u01b0\u1edbc l\u00e0m d\u01b0\u1edbi \u0111\u00e2y nh\u00e9:<\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110i\u1ec1n ng\u00e0y \u0111\u1ea7u ti\u00ean v\u00e0o m\u1ed9t \u00f4 b\u1ea5t k\u1ef3.<\/li>\n<li>Ch\u1ecdn \u00f4 \u0111\u00f3, click chu\u1ed9t ph\u1ea3i v\u00e0o fill handle, k\u00e9o xu\u1ed1ng \u0111\u1ebfn \u00f4 cu\u1ed1i c\u00f9ng m\u00e0 b\u1ea1n mu\u1ed1n \u0111i\u1ec1n ng\u00e0y th\u00e1ng v\u00e0 th\u1ea3 chu\u1ed9t.<\/li>\n<li>Trong b\u1ea3ng menu, ch\u1ecdn <strong>Series<\/strong>.<\/li>\n<li>Trong h\u1ed9p tho\u1ea1i <strong>Series<\/strong>, ch\u1ecdn Date unit theo nh\u01b0 b\u1ea1n mu\u1ed1n v\u00e0 \u0111i\u1ec1n s\u1ed1 th\u00edch h\u1ee3p v\u00e0o Step Value. N\u1ebfu b\u1ea1n \u0111i\u1ec1n th\u00f4ng s\u1ed1 nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, v\u1edbi ng\u00e0y \u0111\u1ea7u ti\u00ean l\u00e0 3-Jan-15, th\u00ec ng\u00e0y ti\u1ebfp theo li\u1ec1n k\u1ec1 sau \u0111\u00f3 s\u1ebd l\u00e0 5-Jan-15.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5627 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-auto-date-series.png\" width=\"292\" height=\"235\" title=\"excel-auto-date-series\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dien_ngay_thang_mot_cach_ngau_nhien_trong_Excel\"><\/span>C\u00e1ch \u0111i\u1ec1n ng\u00e0y th\u00e1ng m\u1ed9t c\u00e1ch ng\u1eabu nhi\u00ean trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Ti\u1ebfc l\u00e0 trong th\u1eddi \u0111i\u1ec3m hi\u1ec7n t\u1ea1i, Excel kh\u00f4ng cung c\u1ea5p c\u00f4ng c\u1ee5 \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n ng\u00e0y th\u00e1ng ng\u1eabu nhi\u00ean v\u00e0o Excel. Tuy nhi\u00ean, H\u1ecdc Excel Online \u2013 anh Nguy\u1ec5n \u0110\u1ee9c Thanh c\u00f3 1 video \u0111\u1ec3 gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c v\u1ea5n \u0111\u1ec1 n\u00e0y, b\u1ea1n h\u00e3y theo d\u00f5i c\u00e1ch l\u00e0m trong video sau \u0111\u00e2y:<\/p>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/Q4NTw1kC15g\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 nh\u1eefng c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u1ec3 \u0111i\u1ec1n ng\u00e0y th\u00e1ng v\u00e0o Excel. Hy v\u1ecdng b\u00e0i vi\u1ebft n\u00e0y \u0111\u00e3 cung c\u1ea5p \u00a0nh\u1eefng c\u00f4ng c\u1ee5, ph\u00edm t\u1eaft, c\u00f4ng th\u1ee9c c\u1ea7n thi\u1ebft v\u00e0 h\u1eefu d\u1ee5ng cho b\u1ea1n. H\u1eb9n g\u1eb7p l\u1ea1i c\u00e1c b\u1ea1n trong c\u00e1c b\u00e0i vi\u1ebft ti\u1ebfp theo.<\/p>\n<p style=\"text-align: left\">C\u00e1c b\u00e0i vi\u1ebft kh\u00e1c v\u1ec1 ng\u00e0y th\u00e1ng trong Excel:<\/p>\n<ul>\n<li style=\"text-align: left\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-date-trong-excel-cach-tinh-toan-ngay-thang.html\" target=\"_blank\" rel=\"noopener\">C\u00e1ch d\u00f9ng h\u00e0m DATE trong Excel<\/a><\/li>\n<li style=\"text-align: left\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-cong-tru-ngay-thang-nam-trong-excel.html\" target=\"_blank\" rel=\"noopener\">C\u00e1ch c\u1ed9ng tr\u1eeb ng\u00e0y, th\u00e1ng, n\u0103m trong Excel<\/a><\/li>\n<li style=\"text-align: left\"><a href=\"http:\/\/blog.ezworkapp.com\/cac-cach-tinh-tuoi-tu-ngay-sinh-trong-excel.html\" target=\"_blank\" rel=\"noopener\">C\u00e1ch t\u00ednh tu\u1ed5i theo ng\u00e0y sinh trong Excel<\/a><\/li>\n<\/ul>\n<p>Hi\u00ea\u0323n ta\u0323i, blog.hocexcel.online \u0111a\u0303 chia se\u0309 r\u00e2\u0301t nhi\u00ea\u0300u vi\u0301 du\u0323 cu\u0303ng nh\u01b0 nh\u01b0\u0303ng gia\u0301o tri\u0300nh v\u00ea\u0300 ho\u0323c <a href=\"http:\/\/blog.ezworkapp.com\/excel-nang-cao\">Excel n\u00e2ng cao<\/a> m\u00f4\u0323t ca\u0301ch chi ti\u00ea\u0301t nh\u00e2\u0301t giu\u0301p cho ca\u0301c ba\u0323n co\u0301 th\u00ea\u0309 ho\u0323c va\u0300 a\u0301p du\u0323ng va\u0300o trong c\u00f4ng vi\u00ea\u0323c m\u00f4\u0323t ca\u0301ch hi\u00ea\u0323u qua\u0309\u00a0 nh\u00e2\u0301t.<\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra \u0111\u1ec3 n\u00e2ng cao h\u01a1n ki\u1ebfn th\u1ee9c v\u1ec1 Excel, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham gia kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2n425gg\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Trong kh\u00f3a h\u1ecdc n\u00e0y c\u00e1c b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ecm hi\u1ec3u nh\u1eefng ki\u1ebfn th\u1ee9c \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, vi\u1ec7c \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m, c\u00f4ng c\u1ee5 \u0111\u00f3 v\u00e0o trong c\u00f4ng vi\u1ec7c. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng c\u00f3 r\u1ea5t nhi\u1ec1u \u01b0u \u0111\u00e3i cho b\u1ea1n khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: justify\">\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\/2025\/01\/vba101_92019-nho-66.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11915,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11914","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\/11914","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=11914"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11914\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11915"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11914"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11914"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}