=IF(DATEDIF(A1,TODAY(),"ym")=11,(DATEDIF(A1,TODAY(),"y")+1)&"年零"&(DATEDIF(A1,TODAY(),"ym")-11)&"个月",DATEDIF(A1,TODAY(),"y")&"年零"&(DATEDIF(A1,TODAY(),"ym")+1)&"个月")
用下面的公式计算,如果是整1年的话,会变成0年12个月,请大侠帮忙改成1年0个月.
=IF(DATEDIF(A1,TODAY(),"ym")=11,(DATEDIF(A1,TODAY(),"y")+1)&"年零"&(DATEDIF(A1,TODAY(),"ym")-11)&"个月",DATEDIF(A1,TODAY(),"y")&"年零"&(DATEDIF(A1,TODAY(),"ym")+1)&"个月")