{"id":342,"date":"2019-03-30T11:28:56","date_gmt":"2019-03-30T03:28:56","guid":{"rendered":"http:\/\/alisonyip.viekee.com\/?p=342"},"modified":"2019-03-30T11:28:57","modified_gmt":"2019-03-30T03:28:57","slug":"excel%e5%8e%9f%e6%9c%89%e6%97%a5%e6%9c%9f%e6%95%b0%e6%8d%ae%e4%b8%8a%ef%bc%8c%e5%a6%82%e4%bd%95%e8%87%aa%e5%8a%a8%e5%8a%a01%e4%b8%aa%e6%9c%88","status":"publish","type":"post","link":"https:\/\/alisonyip.viekee.com\/?p=342","title":{"rendered":"Excel\u539f\u6709\u65e5\u671f\u6570\u636e\u4e0a\uff0c\u5982\u4f55\u81ea\u52a8\u52a01\u4e2a\u6708"},"content":{"rendered":"\n<p> \u6700\u8fd1\u9700\u8981\u8ba1\u7b97\u65e5\u671f\uff0c\u56e0\u4e3a\u6709\u5224\u65ad\uff0c\u9700\u8981\u8ba1\u7b97\u4e00\u4e2a\u65e5\u671f\u540e1\u4e2a\u6708\u7684\u622a\u6b62\u65e5\u671f<\/p>\n\n\n\n<p>\u600e\u4e48\u8ba1\u7b97\u5462<\/p>\n\n\n\n<p class=\"has-background has-vivid-cyan-blue-background-color\">\u53ef\u4ee5\u7528\u4e00\u4e0b\u7b80\u5355\u7684\u516c\u5f0f\uff0c\u8ba1\u7b97\u6708\u4efd\u5dee<\/p>\n\n\n\n<p>=DATE(YEAR(A3),MONTH(A3)+1,DAY(A3)) <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"576\" height=\"158\" src=\"https:\/\/alisonyip.viekee.com\/wp-content\/uploads\/2019\/03\/QQ\u622a\u56fe20190330113656.png\" alt=\"\" class=\"wp-image-343\" srcset=\"https:\/\/alisonyip.viekee.com\/wp-content\/uploads\/2019\/03\/QQ\u622a\u56fe20190330113656.png 576w, https:\/\/alisonyip.viekee.com\/wp-content\/uploads\/2019\/03\/QQ\u622a\u56fe20190330113656-300x82.png 300w\" sizes=\"(max-width: 576px) 100vw, 576px\" \/><\/figure>\n\n\n\n<p>\u5982\u679c\u662f\u8ba1\u7b972\u4e2a\u6708\uff0c\u5c31\u628a MONTH\uff08\u6708\u4efd\uff09\u540e \u6570\u5b571\u6539\u4e3a2<\/p>\n\n\n\n<p class=\"has-text-color has-vivid-red-color\">\u5c31\u6539\u4e3a =DATE(YEAR(A3),MONTH(A3)+2,DAY(A3))  <\/p>\n\n\n\n<p>\u5982\u6b64\u7c7b\u63a8\uff0c\u8ba1\u7b97\u51e0\u591a\u6708\u7684\u5dee\u5c31\u52a0<\/p>\n\n\n\n<p class=\"has-background has-vivid-cyan-blue-background-color\">\u5982\u679c\u662f\u8ba1\u7b97\u5e74\u4efd\u5dee\uff0c\u53ef\u4ee5\u628a\u516c\u5f0f\u5728YEAR\uff08\u5e74\u4efd\uff09\u540e\u6539\u4e3a\uff1a<\/p>\n\n\n\n<p> =DATE(YEAR(A3)+1,MONTH(A3),DAY(A3))   <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"542\" height=\"175\" src=\"https:\/\/alisonyip.viekee.com\/wp-content\/uploads\/2019\/03\/QQ\u622a\u56fe20190330114119.png\" alt=\"\" class=\"wp-image-344\" srcset=\"https:\/\/alisonyip.viekee.com\/wp-content\/uploads\/2019\/03\/QQ\u622a\u56fe20190330114119.png 542w, https:\/\/alisonyip.viekee.com\/wp-content\/uploads\/2019\/03\/QQ\u622a\u56fe20190330114119-300x97.png 300w\" sizes=\"(max-width: 542px) 100vw, 542px\" \/><\/figure>\n\n\n\n<p class=\"has-background has-vivid-cyan-blue-background-color\">\u5982\u8ba1\u7b97\u5929\u6570\u5dee\uff0c\u5c31\u628a\u516c\u5f0f\u5728DAY\uff08\u5929\u6570\uff09\u540e\u6539\u4e3a<\/p>\n\n\n\n<p>  =DATE(YEAR(A3),MONTH(A3),DAY(A3) +1 )     <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"531\" height=\"156\" src=\"https:\/\/alisonyip.viekee.com\/wp-content\/uploads\/2019\/03\/QQ\u622a\u56fe20190330114125.png\" alt=\"\" class=\"wp-image-345\" srcset=\"https:\/\/alisonyip.viekee.com\/wp-content\/uploads\/2019\/03\/QQ\u622a\u56fe20190330114125.png 531w, https:\/\/alisonyip.viekee.com\/wp-content\/uploads\/2019\/03\/QQ\u622a\u56fe20190330114125-300x88.png 300w\" sizes=\"(max-width: 531px) 100vw, 531px\" \/><\/figure>\n\n\n\n<p>\u662f\u4e0d\u662f\u975e\u5e38\u7b80\u5355\u5462\uff01<\/p>\n\n\n\n<p><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6700\u8fd1\u9700\u8981\u8ba1\u7b97\u65e5\u671f\uff0c\u56e0\u4e3a\u6709\u5224\u65ad\uff0c\u9700\u8981\u8ba1\u7b97\u4e00\u4e2a\u65e5\u671f\u540e1\u4e2a\u6708\u7684\u622a\u6b62\u65e5\u671f \u600e\u4e48\u8ba1\u7b97\u5462 \u53ef\u4ee5\u7528\u4e00\u4e0b\u7b80\u5355\u7684\u516c\u5f0f\uff0c\u8ba1\u7b97\u6708\u4efd\u5dee =DATE(YEAR(A3),MONTH(A3)&#8230;<\/p>\n<p class=\"read-more\"><a class=\"btn btn-default\" href=\"https:\/\/alisonyip.viekee.com\/?p=342\"> Read More<span class=\"screen-reader-text\">  Read More<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/posts\/342"}],"collection":[{"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=342"}],"version-history":[{"count":1,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/posts\/342\/revisions"}],"predecessor-version":[{"id":346,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/posts\/342\/revisions\/346"}],"wp:attachment":[{"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}