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")