日期说明2/1/2005起始日期5/2/2005结束日期函数结果=YEARFRAC(A2,A3)0.2527778=YEARFRAC(A2,A3,2)0.25=YEARFRAC(A2,A3,3)0.2465753