\u56e0\u70ba\u539f\u59cb\u7db2\u7ad9\u6700\u5f8c\u7684\u516c\u5f0f\u986f\u793a\u6709\u554f\u984c\uff0c\u5c07\u539f\u6559\u5b78\u518d\u6b21\u5be6\u4f5c\u5982\u4e0b\uff1a<\/p>\n\n\n\n \u3010\u516c\u5f0f\u8a2d\u8a08\u8207\u89e3\u6790\u3011<\/strong><\/p>\n\n\n\n (1) 2023\/2\/25\u2192112\/2\/15<\/p>\n\n\n\n \u5132\u5b58\u683cC2\uff1a=TEXT(B2,”[-zh-TW]e\/m\/d;@”)<\/span><\/p>\n\n\n\n \u5728\u00a0TEXT<\/strong>\u00a0\u51fd\u6578\u4e2d\u5229\u7528\u300c,”[$-zh-TW]e\/m\/d;@\u300d\u53c3\u6578\uff0c\u5c07\u65e5\u671f\u4ee5\u6c11\u570b\u5e74\u986f\u793a\u3002<\/p>\n\n\n\n (2) 2023\/2\/15\u2192\u661f\u671f\u4e09<\/p>\n\n\n\n \u5132\u5b58\u683cD2\uff1a=TEXT(B2,”[$-404]aaaa;@”)<\/p>\n\n\n\n \u5728\u00a0TEXT\u00a0\u51fd\u6578\u4e2d\u5229\u7528\u300c[$-404]aaaa;@\u300d\u53c3\u6578\uff0c\u5c07\u65e5\u671f\u4ee5\u661f\u671f\uff2e\u986f\u793a\u3002<\/p>\n\n\n\n (3) 2023\/2\/15\u2192112\/2\/15<\/p>\n\n\n\n \u539f\u516c\u5f0f\u5728\u7db2\u9801\u6703\u9020\u6210\u986f\u793a\u932f\u8aa4\uff1a<\/p>\n\n\n TEXT(B2,”[$-zh-TW]e\/m\/d;@”)&”(“&RIGHT(TEXT(B2,”[$-404]aaaa;@”),1)&”)”<\/p>\n\n\n\n \u53c3\u8003\u7db2\u7ad9\uff1a \u5b78\u4e0d\u5b8c\uff0e\u6559\u4e0d\u505c\uff0e\u7528\u4e0d\u76e1 \u56e0\u70ba\u539f\u59cb\u7db2\u7ad9\u6700\u5f8c\u7684\u516c\u5f0f\u986f\u793a\u6709\u554f\u984c\uff0c\u5c07\u539f\u6559\u5b78\u518d\u6b21\u5be6\u4f5c\u5982\u4e0b\uff1a \u3010\u516c\u5f0f\u8a2d\u8a08\u8207\u89e3\u6790 […]<\/p>\n","protected":false},"author":1,"featured_media":724,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}}},"categories":[5],"tags":[177,373,374,372,371,370],"author_meta":{"display_name":"mackuo","author_link":"https:\/\/kuo.us.to\/wordpress\/author\/mackuo\/"},"featured_img":"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/02\/wpnoqo2plfa-300x200.jpg","coauthors":[],"tax_additional":{"categories":{"linked":["\u6578\u4f4d<\/a>"],"unlinked":["\u6578\u4f4d<\/span>"]},"tags":{"linked":["excel<\/a>","TEXT<\/a>","TEXT\u51fd\u6578<\/a>","\u661f\u671f<\/a>","\u6c11\u570b\u65e5\u671f<\/a>","\u897f\u5143\u65e5\u671f<\/a>"],"unlinked":["excel<\/span>","TEXT<\/span>","TEXT\u51fd\u6578<\/span>","\u661f\u671f<\/span>","\u6c11\u570b\u65e5\u671f<\/span>","\u897f\u5143\u65e5\u671f<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 3 \u5e74 ago","modified":"Updated 3 \u5e74 ago"},"absolute_dates":{"created":"Posted on 2023 \u5e74 2 \u6708 21 \u65e5","modified":"Updated on 2023 \u5e74 2 \u6708 21 \u65e5"},"absolute_dates_time":{"created":"Posted on 2023 \u5e74 2 \u6708 21 \u65e5 \u4e0a\u5348 10:06","modified":"Updated on 2023 \u5e74 2 \u6708 21 \u65e5 \u4e0a\u5348 10:06"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/716"}],"collection":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/comments?post=716"}],"version-history":[{"count":6,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/716\/revisions"}],"predecessor-version":[{"id":723,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/716\/revisions\/723"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/724"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-095040.jpg\")
<\/figure>\n\n\n\n\u5132\u5b58\u683cE2\uff1a=TEXT(B2,\"[$-zh-TW]e\/m\/d;@\")&\"(\"&RIGHT(TEXT(B2,\"[$-404]aaaa;@\"),1)&\")\"<\/pre>\n\n\n\n
\u5728\u00a0TEXT\u00a0\u51fd\u6578\u4e2d\u5229\u7528\u300cTEXT(B2,\"[$-zh-TW]e\/m\/d;@\")&\"(\"&RIGHT(TEXT(B2,\"[$-404]aaaa;@\"),1)&\")\"a;@\u300d\u53c3\u6578\uff0c\u5c07\u65e5\u671f\u4ee5\u661f\u671f\uff2e\u986f\u793a\u3002<\/pre>\n","protected":false},"excerpt":{"rendered":"