{"id":9698,"date":"2025-01-02T13:02:00","date_gmt":"2025-01-02T13:02:00","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/add-in-chon-ngay-trong-excel-excel-date-picker\/"},"modified":"2025-01-02T13:02:00","modified_gmt":"2025-01-02T13:02:00","slug":"add-in-chon-ngay-trong-excel-excel-date-picker","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/add-in-chon-ngay-trong-excel-excel-date-picker\/","title":{"rendered":"Add-in ch\u1ecdn ng\u00e0y trong Excel (Excel Date Picker)"},"content":{"rendered":"
\n

V\u1edbi Google Sheets, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 click ch\u1ecdn ng\u00e0y t\u1ea1i m\u1ed9t \u00f4 ch\u1ee9a d\u1eef li\u1ec7u ng\u00e0y. Nh\u01b0ng trong Excel hi\u1ec7n nay v\u1eabn thi\u1ebfu t\u00ednh n\u0103ng tr\u00ean. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 th\u1ec3 d\u00f9ng DatePicker (C\u00f4ng c\u1ee5 ch\u1ecdn ng\u00e0y) th\u00f4ng minh tr\u00ean. R\u1ea5t \u0111\u01a1n gi\u1ea3n, v\u1edbi t\u1eeb kh\u00f3a: \u201cExcel DatePicker\u201d b\u1ea1n s\u1ebd g\u1eb7p r\u1ea5t nhi\u1ec1u add-in kh\u00e1c nhau gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c n\u00e0y trong Excel.<\/p>\n

Tuy nhi\u00ean m\u00ecnh th\u1ea5y c\u00f3 m\u1ed9t add-in kh\u00e1 hay v\u00e0 \u0111\u00e3 ki\u1ec3m tra b\u00ean trong kh\u00f4ng c\u00f3 g\u00ec \u201ckhuy\u1ebfn m\u00e3i\u201d qu\u1ea3ng c\u00e1o, n\u00ean mu\u1ed1n gi\u1edbi thi\u1ec7u c\u00f9ng c\u00e1c b\u1ea1n. \u0110\u00f3 l\u00e0 c\u00f4ng c\u1ee5 Excel Date Picker c\u1ee7a\u00a0SAM RADAKOVITZ (website:\u00a0samradapps.com\/datepicker\/). B\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 t\u1eeb trang \u0111\u00f3, ho\u1eb7c t\u1ea3i v\u1ec1 t\u1eeb link d\u1ef1 ph\u00f2ng: Excel Date Picker Addin<\/a>. V\u00e0 n\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft c\u00e1ch c\u00e0i \u0111\u1eb7t addin th\u1ebf n\u00e0o, th\u00ec c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft: C\u00e1ch \u0111\u1ecdc s\u1ed1 th\u00e0nh ch\u1eef trong Excel v\u1edbi addin \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n b\u1edfi HocExcel.Online<\/a><\/strong>.<\/p>\n

Nh\u01b0 v\u1eady cu\u1ed1i c\u00f9ng, b\u1ea1n c\u00f3 th\u1ec3 t\u00f9y ch\u1ecdn nhanh ng\u00e0y th\u00e1ng n\u0103m ch\u1ec9 b\u1eb1ng c\u00e1i click chu\u1ed9t. \u0110\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n

<\/a><\/p>\n

C\u00e1ch c\u00e0i \u0111\u1eb7t:<\/p>\n

Sau khi t\u1ea3i v\u1ec1 v\u00e0 gi\u1ea3i n\u00e9n, b\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p file n\u00e0y v\u00e0o th\u01b0 m\u1ee5c xlstart, n\u01a1i ch\u1ee9a c\u00e1c file s\u1ebd kh\u1edfi \u0111\u1ed9ng c\u00f9ng Excel. Th\u01b0\u1eddng \u0111\u01b0\u1eddng d\u1eabn c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t trong c\u00e1c \u0111\u01b0\u1eddng d\u1eabn sau:<\/p>\n

C:Program Files (x86)Microsoft Office [version] xlstart<\/pre>\n
ho\u1eb7c\u00a0v\u1edbi Office 365 subscription th\u01b0 m\u1ee5c xlstart s\u1ebd n\u1eb1m \u1edf:<\/p>\n
C:Program Files (x86)Microsoft OfficerootOffice16xlstart<\/pre>\n
C\u00e1ch c\u00e0i \u0111\u1eb7t kh\u00e1c: Gi\u1ed1ng v\u1edbi b\u00e0i vi\u1ebft \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u b\u00ean tr\u00ean. Sau khi gi\u1ea3i n\u00e9n, b\u1ea1n m\u1edf Excel v\u00e0 ch\u1ecdn [ File -> Options -> Add-ins -> Go ] \u0111\u1ec3 v\u00e0o ph\u1ea7n qu\u1ea3n l\u00fd Excel add-ins, sau \u0111\u00f3 ch\u1ecdn file b\u1ea1n \u0111\u00e3 t\u1ea3i v\u1ec1 v\u00e0 gi\u1ea3i n\u00e9n.<\/p>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
L\u01b0u \u00fd:<\/strong>
\nN\u1ebfu b\u1ea1n \u0111ang s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 phi\u00ean b\u1ea3n g\u1ea7n \u0111\u00e2y c\u1ee7a Excel, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n ph\u1ea3i unblock add-in sau khi t\u1ea3i v\u1ec1 b\u1edfi c\u00e1c y\u00eau c\u1ea7u b\u1ea3o m\u1eadt c\u1ee7a Office, v\u00e0 c\u00f3 th\u1ec3 b\u1ea1n c\u1ea7n sao ch\u00e9p file n\u00e0y v\u00e0o th\u01b0 m\u1ee5c tin t\u01b0\u1edfng (Trusted Folder, trong Trusted Center).<\/p>\n
Addin n\u00e0y h\u1ed7 tr\u1ee3 c\u1ea3 32 l\u1eabn 64bit, v\u00e0 Office 2007 tr\u1edf \u0111i. N\u1ebfu b\u1ea1n d\u00f9ng Office 2003, vui l\u00f2ng t\u1ea3i Excel Date Picker d\u00e0nh cho Office 2003<\/a>.<\/p>\n<\/div>\n
\n
Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n
T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n
H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n
HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n
\n
\u00a9  document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9699,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9698","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\/9698","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=9698"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9698\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9699"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9698"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9698"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}