{"id":9368,"date":"2025-01-02T02:43:13","date_gmt":"2025-01-02T02:43:13","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-su-dung-ham-date-co-ban-trong-excel\/"},"modified":"2025-01-02T02:43:13","modified_gmt":"2025-01-02T02:43:13","slug":"huong-dan-su-dung-ham-date-co-ban-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-su-dung-ham-date-co-ban-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m DATE c\u01a1 b\u1ea3n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-date-trong-excel-cach-tinh-toan-ngay-thang.html\"><strong>h\u00e0m DATE<\/strong><\/a> c\u1ee7a Excel c\u01a1 b\u1ea3n nh\u1ea5t khi b\u1ea1n c\u1ea7n l\u1ea5y ba gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t v\u00e0 k\u1ebft h\u1ee3p c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00f3 \u0111\u1ec3 t\u1ea1o th\u00e0nh m\u1ed9t ng\u00e0y.<\/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-6775fd405da4d\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-date-co-ban-trong-excel.html#Cu_phap\" title=\"C\u00fa ph\u00e1p\">C\u00fa ph\u00e1p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-date-co-ban-trong-excel.html#Su_dung_ham_DATE_ghep_3_gia_tri_lai_thanh_1\" title=\"S\u1eed d\u1ee5ng h\u00e0m DATE gh\u00e9p 3 gi\u00e1 tr\u1ecb l\u1ea1i th\u00e0nh 1\">S\u1eed d\u1ee5ng h\u00e0m DATE gh\u00e9p 3 gi\u00e1 tr\u1ecb l\u1ea1i th\u00e0nh 1<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cu_phap\"><\/span>C\u00fa ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m DATE c\u00f3 c\u00fa ph\u00e1p nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=DATE(year, month, day)<\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<p><strong>Year: <\/strong>Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb bi\u1ec3u th\u1ecb <strong>s\u1ed1<\/strong>\u00a0<strong>n\u0103m<\/strong>. Gia\u0301 tri\u0323 n\u00e0y\u00a0bao g\u00f4\u0300m t\u01b0\u0300 m\u00f4\u0323t \u0111\u00ea\u0301n b\u00f4\u0301n ch\u01b0\u0303 s\u00f4\u0301. Theo m\u1eb7c \u0111\u1ecbnh, n\u0103m \u0111\u1ea7u ti\u00ean b\u1eaft \u0111\u1ea7u t\u1eeb 1900.<\/p>\n<div class=\"ocpAlert\"><\/div>\n<ul>\n<li>N\u1ebfu\u00a0<b class=\"ocpLegacyBold\">year<\/b>\u00a0t\u01b0\u0300 0 \u0111\u1ebfn 1899,\u00a0Excel s\u1ebd th\u00eam gia\u0301 tri\u0323 \u0111o\u0301 va\u0300o 1900 \u0111\u1ec3 t\u00ednh n\u0103m. V\u00ed du\u0323: DATE(100,6,12) = 12\/06\/2000.<\/li>\n<li>N\u1ebfu\u00a0<b class=\"ocpLegacyBold\">year<\/b>\u00a0t\u01b0\u0300 1900 \u0111\u1ebfn 9999, Excel s\u1ebd d\u00f9ng gi\u00e1 tr\u1ecb \u0111\u00f3 la\u0300m n\u0103m. V\u00ed d\u1ee5: DATE(2018,3,27)\u00a0=\u00a027\/03\/2018.<\/li>\n<li>N\u00ea\u0301u\u00a0<b class=\"ocpLegacyBold\">year<\/b>\u00a0nho\u0309 h\u01a1n 0 ho\u0103\u0323c t\u01b0\u0300 10000 tr\u01a1\u0309 l\u00ean, Excel tra\u0309 v\u00ea\u0300 gia\u0301 tri\u0323 l\u00f4\u0303i #NUM!.<\/li>\n<\/ul>\n<p><b class=\"ocpRunInHead\">Month:\u00a0<\/b>Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb bi\u1ec3u th\u1ecb <strong>s\u1ed1 th\u00e1ng\u00a0<\/strong>trong kho\u1ea3ng\u00a0<strong>th\u00e1ng 1 \u2013 th\u00e1ng 12.<\/strong><\/p>\n<ul>\n<li>N\u1ebfu\u00a0<b class=\"ocpLegacyBold\">month<\/b>\u00a0l\u1edbn h\u01a1n 12, Excel\u00a0s\u1ebd c\u1ed9ng th\u00eam s\u1ed1 th\u00e1ng \u0111\u00f3 v\u00e0o n\u0103m sau. V\u00ed d\u1ee5: DATE(2018,14,2) = 02\/02\/2019.<\/li>\n<li>N\u1ebfu\u00a0<b class=\"ocpLegacyBold\">month<\/b>\u00a0nho\u0309 h\u01a1n 1, Excel\u00a0s\u1ebd tr\u1eeb \u0111i s\u1ed1 th\u00e1ng \u0111\u00f3 v\u00e0o\u00a0n\u0103m tr\u01b0\u1edbc.\u00a0V\u00ed d\u1ee5: DATE(2018,-3,2)\u00a0= 02\/09\/2017.<\/li>\n<\/ul>\n<p><b class=\"ocpRunInHead\">Day:\u00a0<\/b>Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb bi\u1ec3u th\u1ecb\u00a0<strong>s\u1ed1 ng\u00e0y<\/strong> trong kho\u1ea3ng <strong>ng\u00e0y 1<\/strong> t\u1edbi <strong>ng\u00e0y 31<\/strong>.<\/p>\n<ul>\n<li>N\u1ebfu\u00a0<b class=\"ocpLegacyBold\">day<\/b>\u00a0l\u1edbn h\u01a1n s\u1ed1 ng\u00e0y trong th\u00e1ng \u0111\u00e3 x\u00e1c \u0111\u1ecbnh, Excel\u00a0s\u1ebd c\u1ed9ng th\u00eam s\u1ed1 ng\u00e0y \u0111\u00f3 v\u00e0o th\u00e1ng sau. V\u00ed d\u1ee5: DATE(2018,1,35)\u00a0= 04\/02\/2018.<\/li>\n<li>N\u1ebfu\u00a0<b class=\"ocpLegacyBold\">day<\/b>\u00a0nh\u1ecf h\u01a1n 1, Excel\u00a0s\u1ebd tr\u1eeb \u0111i s\u1ed1 th\u00e1ng \u0111\u00f3 v\u00e0o\u00a0n\u0103m tr\u01b0\u1edbc.\u00a0V\u00ed d\u1ee5: DATE(2018,1,-15) = 16\/12\/2017.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_DATE_ghep_3_gia_tri_lai_thanh_1\"><\/span>S\u1eed d\u1ee5ng h\u00e0m DATE gh\u00e9p 3 gi\u00e1 tr\u1ecb l\u1ea1i th\u00e0nh 1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-date-trong-excel-cach-tinh-toan-ngay-thang.html\">H\u00e0m DATE<\/a> c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 gh\u00e9p 3 gi\u00e1 tr\u1ecb ng\u00e0y \u2013 th\u00e1ng \u2013 n\u0103m t\u1ea1i 3 c\u1ed9t kh\u00e1c nhau l\u1ea1i th\u00e0nh m\u1ed9t chu\u1ed7i. V\u00ed d\u1ee5 v\u1edbi b\u1ea3ng:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-44.gif\" title=\"ex101_92019-nho-44\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24786\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/huong-dan-su-dung-date-1.png\" width=\"347\" height=\"160\" title=\"huong-dan-su-dung-date-1\"><\/p>\n<p>Ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m DATE \u0111\u1ec3 gh\u00e9p 3 gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng n\u0103m l\u1ea1i v\u00e0o trong m\u1ed9t c\u1ed9t nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24788\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/huong-dan-su-dung-date-2.png\" width=\"649\" height=\"159\" title=\"huong-dan-su-dung-date-2\"><\/p>\n<p>\u00a0<\/p>\n<p>Ngo\u00e0i ra h\u00e0m DATE c\u0169ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u00e0o k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng v\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng kh\u00e1c. Tham kh\u1ea3o th\u00eam t\u1ea1i\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-date-su-dung-trong-ke-toan-tien-luong-nhan-su.html\">\u0111\u00e2y<\/a>.<\/strong><\/p>\n<p>Ho\u1eb7c tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft li\u00ean quan:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/chuyen-doi-dinh-dang-date-thanh-text-trong-excel-bang-ham-text-va-khong-su-dung-cong-thuc.html\"><strong>Chuy\u1ec3n Date th\u00e0nh Text trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/chuyen-doi-tu-text-sang-date-voi-text-columns-fixed-width.html\"><strong>Chuy\u1ec3n Text th\u00e0nh Date trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-edate-huong-dan-su-dung-ham-edate-trong-excel.html\"><strong>H\u00e0m EDate trong Excel<\/strong><\/a><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-44.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9369,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9368","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\/9368","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=9368"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9368\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9369"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}