第1个回答 2011-04-25
=IF(DATEDIF(A1,TODAY(),"y")=0,DATEDIF(A1,TODAY(),"ym")&"个月",DATEDIF(A1,TODAY(),"y")&"年"&DATEDIF(A1,TODAY(),"ym")&"个月")本回答被提问者采纳
第2个回答 2011-04-25
B1=TEXT(TODAY()-A1,"yy年mm个月")
B2=TEXT(TODAY()-A2,"mm个月")
第3个回答 2011-04-25
=DATEDIF(A1,TODAY(),"y")&"年零"&DATEDIF(A1,TODAY(),"ym")&"个月"&DATEDIF(A1,TODAY(),"md")&"天"
第4个回答 2011-04-25
=IF(YEAR(A1)=YEAR(NOW()),"",DATEDIF(A1,NOW(),"y")&"年")&DATEDIF(A1,NOW(),"ym")+1*(DATEDIF(A1,NOW(),"md")>0)&"个月"
第5个回答 2011-04-25
=IF(YEAR(NOW())-YEAR(A1)<1,MONTH(NOW()-MONTH(A1))&"个月",(YEAR(NOW())-YEAR(A1))&"年"&MONTH(NOW()-MONTH(A1))&"个月")