Question: how do you change date of birth to age in excel?
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")