=YEAR(Today)-YEAR(birth)-IF(OR(MONTH(Today)<MONTH(birth),AND(MONTH(Today)=MONTH(birth),DAY(Today)<DAY(birth))),1,0)&" years, "&MONTH(Today)-MONTH(birth)+IF(AND(MONTH(Today)<=MONTH(birth),DAY(Today)<DAY(birth)),11,IF(AND(MONTH(Today)<MONTH(birth),DAY(Today)>=DAY(birth)),12,IF(AND(MONTH(Today)>MONTH(birth),DAY(Today)<DAY(birth)),-1)))&" months,
"&Today-DATE(YEAR(Today),MONTH(Today)-IF(DAY(Today)<DAY(birth),1,0),DAY(birth))&" days"
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。