Question: what is the excel formula to calculate age from a birth date?
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")