HannYoung2021-02-03知道合伙人金融券行家关注告诉你一个最简单的年龄：=DATEDIF(C2,TODAY(),"y")两个日期相差月数：=DATEDIF(C2,TODAY(),"m")两个日期相差天数：=DATEDIF(C2,TODAY(),"d")精确到“月”的年龄，当然你还可计算到天数：=DATEDIF(C2,TODAY(),"y")&"岁零"&DATEDIF(C2,TODAY(),"m")-12*DATEDIF(C2,TODAY(),"y")&"个月"