Excel根据出生日期和身份证使用公式计算年龄

根据身份证计算年龄，并且出生月份大于当前月份，则年龄加1

=IF(MONTH(DATE(MID(D1,7,4),MID(D1,11,2),MID(D1,13,2))) < MONTH(NOW()),
YEAR(NOW())-MID(D1,7,4),
YEAR(NOW())-MID(D1,7,4)+1)

根据短日期计算年龄，并且出生月份大于当前月份，则年龄加1

=IF(MONTH(D1) < MONTH(NOW()),YEAR(NOW())-YEAR(D1),YEAR(NOW())-YEAR(D1)+1)