另:求助高人帮助：能在EXCEL中实现在“男50岁，女45岁时自动提示内退，男60岁，女55岁自动提示退休”的功能。如能解决，在下万分感谢！

先将英文句点"."替换为减号"-"
再将单元格格式设为"自定义"类型:
YYYY.MM

假定出生日期在B列,C列为性别,第一行为表头,在D2输入公式:
=IF(C2="男",IF(YEAR(NOW())-YEAR(B2)>=50,"内退",IF(YEAR(NOW())-YEAR(B2)>=60,"退休","")),IF(YEAR(NOW())-YEAR(B2)>=45,"内退",IF(YEAR(NOW())-YEAR(B2)>=55,"退休","")))

在你打的2008.03上右设置单元格格式,然后出现一个框,点日期,选择自己喜欢的.然后点确定,就OK了

至于第2个问题,没听明白,能不能在告诉我下,发我消息好了..希望我的答案对你有帮助

你目前有的资料是身份证还是什么？

在你输入生日的这格中右键,设置单元格格式,在分类这里选日期,日期格式在后面选你想要的.  OK

=IF(B1="男",IF(AND(DATEDIF(SUBSTITUTE(A1,".","-"),NOW(),"Y")>=50,DATEDIF(SUBSTITUTE(A1,".","-"),NOW(),"Y")<60),"内退",IF(DATEDIF(SUBSTITUTE(A1,".","-"),NOW(),"Y")>=60,"退休","")),IF(AND(DATEDIF(SUBSTITUTE(A1,".","-"),NOW(),"Y")>=45,DATEDIF(SUBSTITUTE(A1,".","-"),NOW(),"Y")<55),"内退",IF(DATEDIF(SUBSTITUTE(A1,".","-"),NOW(),"Y")>=55,"退休","")))

上面的公式，A1是生日，B1是性别，

假设你的日期在A列
在B1或对应的空白列输入
=SUBSTITUTE(A1&".01",".","-")
然后向下填充公式.然后复制这列,选择性粘贴-数值到A列,将其覆盖.

假设你B列为性别列,增设的这栏在C列
在C1输入
=IF(DATEDIF(A1,TODAY(),"Y")>=LOOKUP(B1,{"男","女"},{60,55}),"退休",IF(DATEDIF(A1,TODAY(),"Y")>=LOOKUP(B1,{"男","女"},{50,45}),"内退",""))

A列是出生年月,B列是性别,在C1输入公式
=INDEX({"","内退","退休"},MATCH(DATEDIF(SUBSTITUTE(A1,".","-"),TODAY(),"Y")+(B1="男")*5,{-5,45,55}+(B1="男")*5))