Question: how to calculate age in excel using date of birth?
Answer: The formula is obvious and easy-to-remember, however, there is a tiny problem. ...  =INT((TODAY()-B2)/365) =YEARFRAC(B2, TODAY(), 1) =ROUNDDOWN(YEARFRAC(B2, TODAY(), 1), 0) =DATEDIF(B2, TODAY(), "y")