如何在Excel中以每年固定月份来计算年龄?

2024-11-27 10:26:15
推荐回答(3个)
回答1:

当然可以。如出生在A列,则=datedif(A1,TEXT(YEAR(TODAY())&"0831","0000-00-00"),"y")

回答2:

=INT((DAYS360(A1,B1)/360))

回答3:

=DATEDIF(A1,DATE(YEAR(TODAY()),8,31),"Y")
或=DATEDIF(A1,DATE(YEAR(B1),8,31),"Y")