excel计算两个日期间隔

[[{"txt": "excel\u600e\u4e48\u8ba1\u7b97\u4e24\u4e2a\u65e5\u671f\u95f4\u9694\u7684\u5929\u6570\u3001\u6708\u6570\u3001\u5e74\u6570\uff0c\u8fd9\u4e2a\u662f\u975e\u5e38\u6709\u7528\u7684\u529f\u80fd\uff0c\u4eba\u5de5\u8ba1\u7b97\u6709\u65f6\u5019\u4f1a\u51fa\u9519\u7684\uff0c\u7535\u8111\u5c31\u4e0d\u4f1a\u5566\u3002\u975e\u65e0\u79c1\u5949\u732e\uff0c\u62d2\u7edd\u770b\u7ecf\u9a8c\u4e0d\u56de\u590d\uff0c\u5b66\u61c2\u4e86\u8bb0\u5f97\u6309\u7167\u4e0b\u9762\u505a\uff1a\u5728\u5e95\u90e8\u70b9\u51fb\u76f8\u5173\u6309\u94ae\uff0c\u7ed9\u6211\u6295\u7968\u548c\u70b9\u8d5e\u3002\u6709\u5fc3\u5f97\u6216\u8005\u7591\u95ee\uff0c\u70b9\u51fb\u76f8\u5173\u6309\u94ae\u53cd\u9988\u3002\u5177\u4f53\u64cd\u4f5c\u8bf7\u770b\u56fe\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/cfadcdd96975f2c4eb07def68f0148fe1f420637.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "wps2019"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "wps\u65b0\u5efa\u4e00\u4e2aexcel\u8868\u683c\u5e76\u6253\u5f00"}, {"img": ["https://exp-picture.cdn.bcebos.com/edd84743040148fe15dcdade8fd149299b880237.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u8ba1\u7b97\u4e24\u65e5\u671f\u95f4\u9694\u9700\u8981\u7528\u5230=DATEDIF()\u51fd\u6570\u6211\u4eec\u5728a1\u8f93\u5165"}, {"img": ["https://exp-picture.cdn.bcebos.com/5c2a1ad149299a88298d6f5067eeadbcbf2f7f37.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u8fd9\u4e2a\u51fd\u6570\u67093\u4e2a\u53c2\u6570\u524d2\u4e2a\u662f\u65e5\u671f\u6700\u540e\u4e00\u4e2a\u662f\u7c7b\u578b"}, {"img": ["https://exp-picture.cdn.bcebos.com/e9a4f2eeadbcbe2f52eec1ad54dae43b3a867837.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u6211\u4eec\u91cd\u70b9\u89e3\u91ca\u6700\u540e\u4e00\u4e2a\u53c2\u6570\u5b83\u6bd4\u8f83\u590d\u6742\u67096\u4e2a\u9009\u9879\u5206\u522b\u662fY,M,D,YD,MD,YMY,M,D\u5206\u522b\u5bf9\u5e94\u5e74\u6708\u65e5 \u8fd9\u4e2a\u7b80\u5355 \u5177\u4f53\u7528\u6cd5\u5982\u56fe\u56fe\u5c31\u6c42\u7684\u95f4\u9694\u5e74\u4efd \u628aY\u66ff\u6362\u6210M\uff0cD\u5c31\u53ef\u4ee5\u6c42\u6708\u4efd\u3001\u5929\u6570"}, {"img": ["https://exp-picture.cdn.bcebos.com/46315818dfdae43b22188594c457935652bb7437.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u6211\u4eec\u8fd9\u91cc\u91cd\u70b9\u8bb2\u89e3 YD,MD,YM\"YD\"\uff1a\u4e0d\u770b\u5e74\u6570\u5dee\uff0c\u4e24\u4e2a\u65e5\u671f\u95f4\u9694\u7684\u5929\u6570\"MD\"\uff1a\u4e0d\u770b\u5e74\u6570\u5dee\u548c\u6708\u4efd\u5dee\uff0c\u4e24\u4e2a\u65e5\u671f\u95f4\u9694\u7684\u5929\u6570\"YM\"\uff1a\u4e0d\u770b\u76f8\u5dee\u5e74\u6570\uff0c\u4e24\u4e2a\u65e5\u671f\u95f4\u9694\u7684\u6708\u4efd\u6570\u6211\u4eec\u4f7f\u7528YD\uff0c\u770b\u770b\u7ed3\u679c \u53d1\u73b0\u8ba1\u7b97\u7684\u5929\u6570\u6ca1\u6709\u8003\u8651\u5e74\u4efd"}, {"img": ["https://exp-picture.cdn.bcebos.com/e57a258602214f578fc8d40e732064fb970b7337.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u4f9d\u6b21\u5c1d\u8bd5MD,YM\u7ed3\u679c\u5982\u56fe"}, {"img": ["https://exp-picture.cdn.bcebos.com/4e168d5653bbf8207b6511beba21056105a36e37.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/f9617afb960b312127ff8316dee983aee9d76d37.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}]]