{"id":102133,"date":"2024-01-03T09:59:39","date_gmt":"2024-01-03T01:59:39","guid":{"rendered":"https:\/\/www.juejinka.com\/?p=102133"},"modified":"2024-01-03T09:59:47","modified_gmt":"2024-01-03T01:59:47","slug":"3%e4%b8%aa-excel%e5%bf%85%e5%ad%a6%e6%97%b6%e9%97%b4%e6%97%a5%e6%9c%9f%e5%87%bd%e6%95%b0%ef%bc%8c%e4%b8%8a%e7%8f%ad%e6%97%8f%e8%a1%a8%e6%a0%bc%e5%bf%85%e5%ad%a6%ef%bc%81","status":"publish","type":"post","link":"https:\/\/www.juejinka.com\/y\/102133.html","title":{"rendered":"3\u4e2a Excel\u5fc5\u5b66\u65f6\u95f4\u65e5\u671f\u51fd\u6570\uff0c\u4e0a\u73ed\u65cf\u8868\u683c\u5fc5\u5b66\uff01"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"750\" height=\"375\" src=\"https:\/\/www.juejinka.com\/news\/wp-content\/uploads\/2024\/01\/2024010108194484.png\" alt=\"\" class=\"wp-image-102134\"\/><\/figure>\n\n\n\n<p>\u8fd9\u7bc7\u5206\u4eab&nbsp;3\u4e2a\u5e38\u7528\u7684 Excel\u65f6\u95f4\u65e5\u671f\u51fd\u6570\uff0cExcel \u505a\u62a5\u8868\u65f6\u9700\u8981\u63d2\u5165\u5f53\u5929\u7684\u5e74\u6708\u65e5\u3001\u5236\u4f5c\u8868\u683c\u65f6\u95f4\u7684\u8bdd\uff0c\u4e00\u822c\u4eba\u90fd\u662f\u624b\u52a8\u8f93\u5165\u65e5\u671f\uff0c\u82e5\u6211\u4eec\u60f3\u8981\u6253\u5f00 Excel\u6587\u4ef6\u65f6\uff0c\u91cc\u9762\u7684\u65f6\u95f4\u5c31\u81ea\u52a8\u66f4\u65b0\uff0c\u8fd9\u53ef\u4ee5\u7528\u51fd\u6570\u6765\u5e2e\u5fd9\u8bbe\u7f6e\u5417\uff1f \u827e\u4f26\u6765\u5206\u4eab\u5982\u4f55\u5584\u7528 today\u3001text\u3001now \u6765\u5e2e\u5fd9\u62a5\u8868\u4e2d\u5feb\u901f\u52a0\u5165\u65e5\u671f\u3001\u65f6\u95f4\u3002<\/p>\n\n\n\n<h2>\u7b2c1\u4e2a Excel today\u51fd\u6570\uff1a\u663e\u793a\u5f53\u5929\u65e5\u671f<\/h2>\n\n\n\n<p>\u5728\u62a5\u8868\u4e2d\u9700\u8981\u4eca\u5929\u65e5\u671f\u65f6\uff0c\u53ea\u9700\u8981\u6253\u4e0a\u300c=TODAY\uff08\uff09 \u300d\u8fd9\u4e32\u51fd\u6570\uff0c\u5c31\u4f1a\u81ea\u52a8\u663e\u793a\u76ee\u524d\u7684\u65e5\u671f\uff0c\u4f7f\u7528 Today\u51fd\u6570\u8bbe\u7f6e\u7684\u65e5\u671f\uff0c\u7b49\u6211\u4eec\u660e\u5929\u518d\u5f00\u542f\u6587\u4ef6\u65f6\uff0c\u65e5\u671f\u5c31\u4f1a\u81ea\u52a8\u66f4\u65b0\u3002<br><img decoding=\"async\" class=\"alignnone size-full wp-image-102552\" src=\"https:\/\/www.juejinka.com\/news\/wp-content\/uploads\/2024\/01\/1jlf6.jpg\" width=\"781\" height=\"651\" alt=\"3\u4e2aExcel\u5fc5\u5b66\u65f6\u95f4\u65e5\u671f\u51fd\u6570-01\" \/><p>\u60f3\u5728 Excel\u8868\u683c\u4e2d\u8f93\u5165\u6628\u5929\u65e5\u671f\u65f6\uff0c\u53ea\u9700\u8981\u6253\u4e0a\u300c=TODAY\uff08\uff09-1 \u300d\u8fd9\u4e32\u51fd\u6570\u3002<br><img decoding=\"async\" class=\"alignnone size-full wp-image-102553\" src=\"https:\/\/www.juejinka.com\/news\/wp-content\/uploads\/2024\/01\/ef0ub.jpg\" width=\"781\" height=\"651\" alt=\"3\u4e2aExcel\u5fc5\u5b66\u65f6\u95f4\u65e5\u671f\u51fd\u6570-02\" \/><p>\u8868\u683c\u4e2d\u8f93\u5165\u300c=TODAY\uff08\uff09+1 \u300d\u8fd9\u4e32\u51fd\u6570\uff0c\u8868\u683c\u4e2d\u5c31\u4f1a\u51fa\u73b0\u660e\u5929\u7684\u65e5\u671f\u3002<br><img decoding=\"async\" class=\"alignnone size-full wp-image-102554\" src=\"https:\/\/www.juejinka.com\/news\/wp-content\/uploads\/2024\/01\/p32do.jpg\" width=\"781\" height=\"651\" alt=\"3\u4e2aExcel\u5fc5\u5b66\u65f6\u95f4\u65e5\u671f\u51fd\u6570-03\" \/><p>\u82e5\u60f3\u8f93\u5165\u591a\u5929\u540e\u7684\u65e5\u671f\u5462\uff1f \u4f8b\u5982 7\u5929\u540e\u7684\u65e5\u671f\uff0c\u8f93\u5165\u300c=TODAY\uff08\uff09+7 \u300d\u8fd9\u4e32\u51fd\u6570\uff0c\u8868\u683c\u4e2d\u5c31\u4f1a\u663e\u793a 7\u5929\u540e\u7684\u65e5\u671f\u3002<br><img decoding=\"async\" class=\"alignnone size-full wp-image-102555\" src=\"https:\/\/www.juejinka.com\/news\/wp-content\/uploads\/2024\/01\/l5trn.jpg\" width=\"781\" height=\"651\" alt=\"3\u4e2aExcel\u5fc5\u5b66\u65f6\u95f4\u65e5\u671f\u51fd\u6570-04\" \/><h2>\u7b2c2\u4e2a Excel text\u51fd\u6570<\/h2><p>text\u51fd\u6570\u6709\u4e24\u79cd\u7528\u6cd5\uff0c\u4e00\u79cd\u662f\u5728 2024\/01\/01 \u6539\u6210 2024\u5e7401\u670801\u65e5\uff0c\u53e6\u4e00\u79cd\u7528\u6cd5\u5c31\u662f\u67e5\u8be2\u6307\u5b9a\u65e5\u671f\u662f\u5f53\u65f6\u7684\u661f\u671f\u51e0\u3002<\/p>\n\n\n\n<p>\u4e0a\u9762\u4ecb\u7ecd\u7684 today\u51fd\u6570\u662f\u53ef\u4ee5\u663e\u793a\u4eca\u5929\u7684\u65e5\u671f\uff0c\u4f8b\u5982\uff1a2024\/01\/01\uff0c\u4f7f\u7528 text\u51fd\u6570\u5c31\u80fd\u8ba9\u65e5\u671f\u663e\u793a \u5e74\u3001\u6708\u3001\u65e5 \u7684\u5b57\u6837\uff0c\u8f93\u5165\u300c =TEXT\uff08B2\uff0c\u201cyyyy\u5e74mm\u6708dd\u65e5\u201d\uff09 \u300d\u8fd9\u4e32\u51fd\u6570\uff0cB2\u662f\u827e\u4f26\u5728\u6587\u4ef6\u4e2d\u7684\u65e5\u671f\u4f4d\u7f6e\uff0c\u4f7f\u7528\u8fd9\u51fd\u6570\u540e\u5c31\u4f1a\u53d8\u6210 2024\u5e7401\u670801\u65e5\u3002<br><img decoding=\"async\" class=\"alignnone size-full wp-image-102556\" src=\"https:\/\/www.juejinka.com\/news\/wp-content\/uploads\/2024\/01\/95t29.jpg\" width=\"781\" height=\"651\" alt=\"3\u4e2aExcel\u5fc5\u5b66\u65f6\u95f4\u65e5\u671f\u51fd\u6570-05\" \/>\n\n\n\n<p>text\u51fd\u6570\u8fd8\u53ef\u4ee5\u67e5\u8be2\u6211\u4eec\u6307\u5b9a\u65e5\u671f\u662f\u661f\u671f\u51e0\uff0c\u67e5\u8be2\u7684\u65e5\u671f\u8f93\u5165\u540e\uff0c\u8868\u683c\u4e2d\u8f93\u5165\u300c=TEXT\uff08A1\uff0c\u201cdddd\u201d\uff09 \u300d\uff0c\u827e\u4f26\u8981\u67e5\u8be2 2019\/8\/1 \u662f\u661f\u671f\u51e0\uff0c\u67e5\u8be2\u540e Thursday\uff0c\u8fd9\u51fd\u6570\u662f\u663e\u793a\u661f\u671f\u7684\u82f1\u6587\u7248\u3002<br><img decoding=\"async\" class=\"alignnone size-full wp-image-102557\" src=\"https:\/\/www.juejinka.com\/news\/wp-content\/uploads\/2024\/01\/oz9h1.jpg\" width=\"781\" height=\"651\" alt=\"3\u4e2aExcel\u5fc5\u5b66\u65f6\u95f4\u65e5\u671f\u51fd\u6570-07\" \/>\n\n\n\n<p>\u82e5\u8981\u8ba9\u661f\u671f\u663e\u793a\u4e2d\u6587\u7684\u8bdd\uff0c\u51fd\u6570\u4e2d\u6211\u4eec\u8981\u52a0\u5165 [$-404]\uff0c\u300c =TEXT\uff08A1\uff0c\u201c[$-404]dddd\u201d\uff09 \u300d\u8fd9\u6837\u5c31\u4f1a\u663e\u793a \u661f\u671f\u56db\u3002<br><img decoding=\"async\" class=\"alignnone size-full wp-image-102558\" src=\"https:\/\/www.juejinka.com\/news\/wp-content\/uploads\/2024\/01\/0dr4g.jpg\" width=\"781\" height=\"651\" alt=\"3\u4e2aExcel\u5fc5\u5b66\u65f6\u95f4\u65e5\u671f\u51fd\u6570-08\" \/>\n\n\n\n<h2>\u7b2c3\u4e2a Excel now\u51fd\u6570\uff1a\u663e\u793a\u65e5\u671f\u3001\u65f6\u95f4<\/h2>\n\n\n\n<p>\u62a5\u8868\u4fee\u6539\u65f6\uff0c\u60f3\u8981\u52a0\u4e0a\u4fee\u6539\u65e5\u671f\u3001\u65f6\u95f4\u7684\u8bdd\u5c31\u53ef\u4ee5\u4f7f\u7528 now\u51fd\u6570\uff0c\u300c=NOW\uff08\uff09 \u300d\u5c31\u53ef\u4ee5\u5728\u65e5\u671f\u540e\u9762\u52a0\u4e0a\u5f53\u4e0b\u7684\u65f6\u95f4\u3002<br><img decoding=\"async\" class=\"alignnone size-full wp-image-102559\" src=\"https:\/\/www.juejinka.com\/news\/wp-content\/uploads\/2024\/01\/vepeq.jpg\" width=\"781\" height=\"651\" alt=\"3\u4e2aExcel\u5fc5\u5b66\u65f6\u95f4\u65e5\u671f\u51fd\u6570-06\" \/>\n","protected":false},"excerpt":{"rendered":"<p>\u8fd9\u7bc7\u5206\u4eab&nbsp;3\u4e2a\u5e38\u7528\u7684 Excel\u65f6\u95f4\u65e5\u671f\u51fd\u6570\uff0cExcel \u505a\u62a5\u8868\u65f6\u9700\u8981\u63d2\u5165\u5f53\u5929\u7684\u5e74\u6708\u65e5\u3001\u5236\u4f5c\u8868\u683c\u65f6\u95f4\u7684\u8bdd\uff0c\u4e00\u822c\u4eba\u90fd\u662f\u624b\u52a8\u8f93\u5165\u65e5\u671f\uff0c\u82e5\u6211\u4eec\u60f3\u8981\u6253\u5f00 Excel\u6587\u4ef6\u65f6\uff0c\u91cc\u9762\u7684&#8230;<\/p>\n","protected":false},"author":7,"featured_media":102552,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"special":[],"_links":{"self":[{"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/posts\/102133"}],"collection":[{"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/comments?post=102133"}],"version-history":[{"count":4,"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/posts\/102133\/revisions"}],"predecessor-version":[{"id":102561,"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/posts\/102133\/revisions\/102561"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/media\/102552"}],"wp:attachment":[{"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/media?parent=102133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/categories?post=102133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/tags?post=102133"},{"taxonomy":"special","embeddable":true,"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/special?post=102133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}