如图:C2单元格为足月差公式:=DATEDIF(A2,B2,"y")&"年"&DATEDIF(A2,B2,"ym")&"月"多一天则入一月公式为:=TEXT(B2-A2,"y年m月")如图:=TEXT(B2-A2,"y年m月")