EXCEL公式的一个问题,日期或者小数点后面一位数的差(月份差)答:H1输入 =DATEDIF(SUBSTITUTE(LEFT(E1,FIND("-",E1)-1),".","-"),SUBSTITUTE(RIGHT(E1,LEN(E1)-FIND("-",E1)),".","-"),"m")回车并向下填充。若E1之间要算3个月,公式+1:=DATEDIF(SUBSTITUTE(LEFT(E1,FIND("-",E1)-1),".","-"),SUBSTITUTE(RIGHT(E1,LEN(E1)-FIND("-",...