时间

[neoflying]

A2 毕业时间
B2 当前时间
E2=DATE(YEAR(B2),MONTH(1),DAY(1))
F2=DATE(YEAR(B2),MONTH(A2),DAY(A2))

=IF(B2-F2<0,(IF(DATEDIF(A2,B2,"Y")<10,5,IF(DATEDIF(A2,B2,"Y")<20,10,15)))(B2-E2)/365,(IF(DATEDIF(A2,F2-1,"Y")<10,5,IF(DATEDIF(A2,F2-1,"Y")<20,10,15)))(F2-E2+1)/365+(IF(DATEDIF(A2,B2,"Y")<10,5,IF(DATEDIF(A2,B2,"Y")<20,10,15)))*(B2-F2)/365)