可以用这个公式:IF(AND(MONTH(TODAY())>=MONTH($MF(出生日期)$), DAY(TODAY())>=DAY($MF(出生日期)$)),YEAR(TODAY())-YEAR($MF(出生日期)$) &"岁"&MONTH(TODAY())-MONTH($MF(出生日期)$)&"个月零"&DAY(TODAY())-DAY($MF(出生日期)$)&"天",IF(AND(MONTH(TODAY())>=MONTH($MF(出生日期)$),DAY(TODAY())<DAY($MF(出生日期)$)),IF(MONTH(TODAY())>MONTH($MF(出生日期)$),YEAR(TODAY())-YEAR($MF(出生日期)$)&"岁"&MONTH(TODAY())-MONTH($MF(出生日期)$)-1&"个月零"&30+DAY(TODAY())-DAY($MF(出生日期)$) &"天",YEAR(TODAY())-YEAR($MF(出生日期)$)-1&"岁"&11+MONTH(TODAY())-MONTH($MF(出生日期)$)&"个月零"&30+DAY(TODAY())-DAY($MF(出生日期)$)&"天"),IF(AND(MONTH(TODAY())<MONTH($MF(出生日期)$),DAY(TODAY())>=DAY($MF(出生日期)$)),YEAR(TODAY())-YEAR($MF(出生日期)$)-1&"岁"&12+MONTH(TODAY())-MONTH($MF(出生日期)$)&"个月零"&DAY(TODAY())-DAY($MF(出生日期)$)&"天",YEAR(TODAY())-YEAR($MF(出生日期)$)-1&"岁"&12+MONTH(TODAY())-MONTH($MF(出生日期)$)&"个月零"&30+DAY(TODAY())-DAY($MF(出生日期)$)&"天")))
这个是默认一个月30天算的 |