{"id":1313,"date":"2020-06-28T11:38:02","date_gmt":"2020-06-28T03:38:02","guid":{"rendered":"http:\/\/www.fyndpro.com\/?p=1313"},"modified":"2020-06-28T11:44:54","modified_gmt":"2020-06-28T03:44:54","slug":"10dateformulas","status":"publish","type":"post","link":"https:\/\/www.fyndpro.com\/cn\/10dateformulas\/","title":{"rendered":"\u4e00\u5716\u770b\u6e0510\u500b\u8d85\u5be6\u7528Excel\u65e5\u671f\u51fd\u6578\u7528\u6cd5"},"content":{"rendered":"

\"\"<\/p>\n

\u5047\u8a2dA2\u662f\u5b58\u653e\u65e5\u671f\u7684\u5132\u5b58\u683c\uff1bA5\u81f3A6\u662f\u5b58\u653e\u5047\u671f\u7684\u5132\u5b58\u683c<\/p>\n

    \n
  1. \u6839\u64da\u51fa\u751f\u5e74\u6708\u8a08\u7b97\u5e74\u9f61\uff1a=DATEDIF(A2,TODAY(),”y”)&”\u6b72”<\/li>\n
  2. \u67d0\u500b\u65e5\u671f\u662f\u661f\u671f\u5e7e\uff1a=TEXT(A2,”aaaa”)<\/li>\n
  3. \u67d0\u500b\u65e5\u671f\u6240\u5728\u6708\u6709\u5e7e\u5929\uff1a=DAY(EOMONTH(A2,0))<\/li>\n
  4. \u4e0b\u4e00\u500b\u5de5\u4f5c\u65e5\u662f\u54ea\u5929\uff1a=WORKDAY(A2,1,A5:A6)<\/li>\n
  5. \u5340\u5206\u6307\u5b9a\u65e5\u671f\u662f\u4e0a\u4e2d\u4e0b\u65ec\uff1a=LOOKUP(DAY(A2),{0,11,21},{ “\u4e0a\u65ec”,”\u4e2d\u65ec”,”\u4e0b\u65ec” })<\/li>\n
  6. \u5c07\u65e5\u671f\u8f49\u63db\u70ba\u201c20001006\u201d\u683c\u5f0f\uff1a=TEXT(A2,”emmdd”)<\/li>\n
  7. \u5224\u65b7\u6307\u5b9a\u65e5\u671f\u6240\u5728\u7684\u5b63\u5ea6\uff1a=LEN(2^MONTH(A2))<\/li>\n
  8. \u8a08\u7b972000\u5e74\u6709\u591a\u5c11\u500b\u661f\u671f\u4e00\uff1a=NETWORKDAYS.INTL(“2000-1-1″,”2000-12-31″,”0111111”)<\/li>\n
  9. \u8a08\u7b97\u7576\u524d\u662f\u5e7e\u9ede\u5e7e\u5206\uff1a=NOW()-TODAY()<\/li>\n
  10. \u8a08\u7b97\u4eca\u5e74\u662f\u4e0d\u662f\u958f\u5e74\uff1a=IF(COUNT(-“2-29″),”\u662f”,”\u5426”)<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    \u5047\u8a2dA2\u662f\u5b58\u653e\u65e5\u671f\u7684\u5132\u5b58\u683c\uff1bA5\u81f3A6\u662f\u5b58\u653e\u5047\u671f\u7684\u5132\u5b58\u683c \u6839\u64da\u51fa\u751f\u5e74\u6708\u8a08\u7b97\u5e74\u9f61\uff1a=DATEDIF(A2,TOD […]<\/p>\n","protected":false},"author":1,"featured_media":1317,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[49,8,7,20],"tags":[170,161,163,164,27,157,92,166,167,168,162,169,165],"class_list":["post-1313","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-date","category-excel","category-excel-formulas","category-onlinesupport","tag-count","tag-datedif","tag-day","tag-eomonth","tag-if","tag-len","tag-lookup","tag-month","tag-networkdays-intl","tag-now","tag-text","tag-today","tag-workday"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/06\/%E4%B8%80%E5%9C%96%E7%9C%8B%E6%B8%8510%E5%80%8B%E8%B6%85%E5%AF%A6%E7%94%A8Excel%E6%97%A5%E6%9C%9F%E5%87%BD%E6%95%B8%E7%94%A8%E6%B3%953.png?fit=1083%2C681&ssl=1","_links":{"self":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/1313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/comments?post=1313"}],"version-history":[{"count":2,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/1313\/revisions"}],"predecessor-version":[{"id":1316,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/1313\/revisions\/1316"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/media\/1317"}],"wp:attachment":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/media?parent=1313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/categories?post=1313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/tags?post=1313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}