Excel两个日期相减输出几年几个月(大写,比如,十年十个月)答:=IF(INT((B1-A1)/365)=0,"",TEXT(INT((B1-A1)/365),"[DBNUM1]")&"年")&IF(INT(MOD((B1-A1),365)/30)=0,"",TEXT(INT(MOD((B1-A1),365)/30),"[DBNUM1]")&"个月") 一十一年 =SUBSTITUTE(IF(INT((B1-A1)/365)=0,"",TEXT(INT((B1-A1)/365),"[DBNUM1]")&"...