D2=IF(DATEDIF(B2,TODAY(),"d")=0,"未满一天",IF(DATEDIF(B2,TODAY(),"Y")>0,DATEDIF(B2,TODAY(),"Y")&"年","")&IF(DATEDIF(EDATE(B2,DATEDIF(B2,TODAY(),"Y")*12),TODAY(),"M")>0,DATEDIF(EDATE(B2,DATEDIF(B2,TODAY(),"Y")*12),TODAY(),"M")&"月","")&IF(DATEDIF(EDATE(EDATE(B2,DATEDIF(B2,TODAY(),"Y")*12),DATEDIF(EDATE(B2,DATEDIF(B2,TODAY(),"Y")*12),TODAY(),"M")),TODAY(),"D")>0,DATEDIF(EDATE(EDATE(B2,DATEDIF(B2,TODAY(),"Y")*12),DATEDIF(EDATE(B2,DATEDIF(B2,TODAY(),"Y")*12),TODAY(),"M")),TODAY(),"D")&"天","")) |