{"id":29,"date":"2016-12-29T09:06:55","date_gmt":"2016-12-29T01:06:55","guid":{"rendered":"http:\/\/limitironbox.frog.tw\/?p=29"},"modified":"2020-05-22T16:27:17","modified_gmt":"2020-05-22T08:27:17","slug":"excel%e5%87%bd%e6%95%b8datedif%e7%94%a8%e6%b3%95","status":"publish","type":"post","link":"https:\/\/limitironbox.myds.me\/wordpress\/excel%e5%87%bd%e6%95%b8datedif%e7%94%a8%e6%b3%95\/","title":{"rendered":"EXCEL\u51fd\u6578DATEDIF\u7528\u6cd5"},"content":{"rendered":"<p><a href=\"http:\/\/limitironbox.myds.me\/wordpress\/wp-content\/uploads\/2016\/12\/2016-12-29_163607.jpg\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-26\" src=\"http:\/\/limitironbox.myds.me\/wordpress\/wp-content\/uploads\/2016\/12\/2016-12-29_163607-300x176.jpg\" alt=\"\" width=\"300\" height=\"176\" \/><\/a><\/p>\n<p>\u5982\u4e0a\u5716\uff0c\u5df2\u77e5\u5230\u8077\u65e5\u662f84\/3\/13(\u8868\u683cC4)\uff0c\u5982\u4f55\u8a08\u7b97\u5230\u8077\u4e86\u591a\u5c11\u5e74?<\/p>\n<p>\u516c\u5f0f\u5982\u4e0b\uff1a<\/p>\n<p>=DATEDIF(C4,$I$4,&#8221;Y&#8221;)&#8212;&#8212;&#8212;&#8212;&#8212;-\u8a08\u7b97\u51fa\u5e74<\/p>\n<p>=DATEDIF(C4,$I$4,&#8221;YM&#8221;)&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;\u8a08\u7b97\u51fa\u6708<\/p>\n<table style=\"height: 468px;\" width=\"517\">\n<tbody>\n<tr>\n<td width=\"538\">DATEDIF\u51fd\u6578\u8aaa\u660e<\/td>\n<\/tr>\n<tr>\n<td width=\"538\">\u8a9e\u6cd5\uff1aDATEDIF(start_date,end_date,unit)<\/p>\n<p>&#8220;Y&#8221;\uff1a\u9031\u671f\u4e2d\u7684\u6574\u5e74\u6578<\/p>\n<p>&#8220;M&#8221;\uff1a\u9031\u671f\u4e2d\u7684\u6574\u6708\u6578<\/p>\n<p>&#8220;D&#8221;\uff1a\u9031\u671f\u4e2d\u7684\u5929\u6578<\/p>\n<p>&#8220;MD&#8221;\uff1astart_date\u8207end_date\u9593\u7684\u5929\u6578\u5dee\u3002(\u5ffd\u7565\u65e5\u671f\u4e2d\u7684\u6708\u548c\u5e74)<\/p>\n<p>&#8220;YM&#8221;\uff1astart_date\u8207end_date\u9593\u7684\u6708\u6578\u5dee\u3002(\u5ffd\u7565\u65e5\u671f\u4e2d\u7684\u65e5\u548c\u5e74)<\/p>\n<p>&#8220;YD&#8221;\uff1astart_date\u8207end_date\u9593\u7684\u5929\u6578\u5dee\u3002(\u5ffd\u7565\u65e5\u671f\u4e2d\u7684\u5e74)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u5982\u9700\u8981$I$4\u7d55\u5c0d\u5f15\u7528\u7684\u8aaa\u660e\u8acb\u9ede<a href=\"http:\/\/limitironbox.frog.tw\/it%E9%9B%9C%E7%89%A9%E5%B7%A5\/excel%E4%B8%AD%E7%9A%84%E7%B5%95%E5%B0%8D%E5%BC%95%E7%94%A8\/\">\u9019\u88e1<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5982\u4e0a\u5716\uff0c\u5df2\u77e5\u5230\u8077\u65e5\u662f84\/3\/13(\u8868\u683c&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pmpro_default_level":""},"categories":[6],"tags":[],"_links":{"self":[{"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/posts\/29"}],"collection":[{"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/comments?post=29"}],"version-history":[{"count":1,"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/posts\/29\/revisions"}],"predecessor-version":[{"id":274,"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/posts\/29\/revisions\/274"}],"wp:attachment":[{"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/media?parent=29"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/categories?post=29"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/limitironbox.myds.me\/wordpress\/wp-json\/wp\/v2\/tags?post=29"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}