假设A1为:19890306 B1为:19891230
时间差为:=VALUE(LEFT(A1,4)&"/"&MID(A1,5,2)&"/"&RIGHT(A1,2))-VALUE(LEFT(B1,4)&"/"&MID(B1,5,2)&"/"&RIGHT(B1,2))
如果是绝对值则是:=abs(VALUE(LEFT(A1,4)&"/"&MID(A1,5,2)&"/"&RIGHT(A1,2))-VALUE(LEFT(B1,4)&"/"&MID(B1,5,2)&"/"&RIGHT(B1,2)))
温馨提示:答案为网友推荐,仅供参考