{"id":12128,"date":"2025-01-15T07:16:43","date_gmt":"2025-01-15T07:16:43","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-edate-huong-dan-su-dung-ham-edate-trong-excel\/"},"modified":"2025-01-15T07:16:43","modified_gmt":"2025-01-15T07:16:43","slug":"ham-edate-huong-dan-su-dung-ham-edate-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-edate-huong-dan-su-dung-ham-edate-trong-excel\/","title":{"rendered":"H\u00e0m EDATE, h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m EDATE trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<section class=\"ocpSection\"><em><strong>H\u00e0m EDATE tr\u1ea3 v\u1ec1gi\u00e1 tr\u1ecb ng\u00e0y tr\u01b0\u1edbc ho\u1eb7c sau ng\u00e0y \u0111\u00e3 bi\u1ebft \u0111\u00e3 x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc. \u00a0Trong th\u1ef1c t\u1ebf, ng\u01b0\u1eddi ta th\u01b0\u1eddng d\u00f9ng h\u00e0m EDATE \u0111\u1ec3 t\u00ednh to\u00e1n ng\u00e0y \u0111\u00e1o h\u1ea1n ho\u1eb7c ng\u00e0y \u0111\u1ebfn h\u1ea1n.\u00a0<\/strong><\/em><strong>C\u00fa ph\u00e1p =EDATE(start_date, months)<\/strong><\/section>\n<section class=\"ocpSection\"><em>Trong \u0111\u00f3:<\/em><\/p>\n<ul>\n<li><strong><em>Start_date<\/em>:\u00a0\u00a0\u00a0<\/strong>Ng\u00e0y ng\u00e0y b\u1eaft \u0111\u1ea7u.<\/li>\n<li><strong><em>Months<\/em><\/strong>: S\u1ed1 th\u00e1ng tr\u01b0\u1edbc ho\u1eb7c sau ng\u00e0y b\u1eaft \u0111\u1ea7u (start_date). Gi\u00e1 tr\u1ecb d\u01b0\u01a1ng cho \u0111\u1ed1i s\u1ed1 months t\u1ea1o ra ng\u00e0y trong t\u01b0\u01a1ng lai, gi\u00e1 tr\u1ecb \u00e2m t\u1ea1o ra ng\u00e0y trong qu\u00e1 kh\u1ee9.<\/li>\n<\/ul>\n<p>*<strong>L\u01b0u \u00fd:<\/strong><\/p>\n<ul>\n<li>N\u1ebfu <em><strong>start_date<\/strong><\/em> kh\u00f4ng ph\u1ea3i l\u00e0 ng\u00e0y h\u1ee3p l\u1ec7, h\u00e0m EDATE tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i <strong>#VALUE!<\/strong> .<\/li>\n<li>N\u1ebfu <em><strong>months<\/strong> <\/em>kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1 nguy\u00ean th\u00ec n\u00f3 b\u1ecb c\u1eaft c\u1ee5t.<\/li>\n<\/ul>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">H\u00e0m excel c\u01a1 b\u1ea3n <\/a><\/p>\n<\/blockquote>\n<h4><strong>V\u00ed d\u1ee5<\/strong><\/h4>\n<ul>\n<li>S\u1eed d\u1ee5ng h\u00e0m EDATE \u0111\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y th\u00f5a \u0111i\u1ec1u ki\u1ec7n trong b\u1ea3ng d\u1eef li\u1ec7u sau:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4180 aligncenter\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%20600%20411'%3E%3C\/svg%3E\" alt=\"\" width=\"600\" height=\"411\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-edate.png 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2017\/04\/ham-edate-300x206.png 300w\" data-lazy-sizes=\"(max-width: 600px) 100vw, 600px\" data-lazy-src=\"\/wp-content\/uploads\/2017\/04\/ham-edate.png\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4180 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-edate.png\" width=\"600\" height=\"411\" title=\"ham-edate\"><\/p>\n<ul>\n<li>D\u00f9ng c\u00f4ng th\u1ee9c:\u00a0<strong>=EDATE(B4;C4),\u00a0<\/strong>thu \u0111\u01b0\u1ee3c \u0111\u00e1p \u00e1n.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4183 aligncenter\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%20600%20412'%3E%3C\/svg%3E\" alt=\"\" width=\"600\" height=\"412\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-edate-1.png 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2017\/04\/ham-edate-1-300x206.png 300w\" data-lazy-sizes=\"(max-width: 600px) 100vw, 600px\" data-lazy-src=\"\/wp-content\/uploads\/2017\/04\/ham-edate-1.png\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4183 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-edate-1.png\" width=\"600\" height=\"412\" title=\"ham-edate-1\"><\/p>\n<p>Edate kh\u00f4ng ph\u1ea3i l\u00e0 h\u00e0m ph\u1ed5 bi\u1ebfn trong Excel, c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft h\u00e0m n\u00e0y. Th\u1ef1c t\u1ebf, trong Excel c\u00f3 r\u1ea5t nhi\u1ec1u h\u00e0m, c\u00f4ng c\u1ee5 c\u00f3 th\u1ec3 b\u1ea1n c\u0169ng ch\u01b0a bi\u1ebft, n\u00ean vi\u1ec7c \u00e1p d\u1ee5ng c\u00e1c t\u00ednh n\u0103ng n\u00e0y \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u b\u1ecb h\u1ea1n ch\u1ebf, b\u1ea1n s\u1ebd m\u1ea5t nhi\u1ec1u th\u1eddi gian, c\u00f4ng s\u1ee9c h\u01a1n \u0111\u1ec3 x\u1eed l\u00fd.<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\">HocExcel.Online<\/a>\n<\/p>\n<\/section>\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":"<p>H\u00e0m EDATE tr\u1ea3 v\u1ec1gi\u00e1 tr\u1ecb ng\u00e0y tr\u01b0\u1edbc ho\u1eb7c sau ng\u00e0y \u0111\u00e3 bi\u1ebft \u0111\u00e3 x\u00e1c \u0111\u1ecbnh..<\/p>\n","protected":false},"author":1,"featured_media":12129,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12128","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\/12128","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=12128"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12128\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12129"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}