第1个回答 2008-06-05
=TEXT(YEAR(TODAY())-YEAR(A1)-(MONTH(A1)&TEXT(DAY(A1),"00")<MONTH(TODAY())&TEXT(DAY(TODAY()),"00"))*1,"#0")
或者
=TEXT(YEAR(TODAY())-YEAR(A1)-(MONTH(A1)&TEXT(DAY(A1),"00")<MONTH(TODAY())&TEXT(DAY(TODAY()),"00"))*1,"今年0岁")
解释:
今年年份-生日年份-(没有过生日的判断)
最后的"#0"、"今年0岁"是输出格式
对不起,没有用到IF函数。