Type your birth date in suppose say cell A1.
Use the below formula in any other cell: –
=DATEDIF(A1, TODAY(), “Y”)This formula is a secret formula so it won’t appear in the in-built formula list.
Age from date of birth

Age from date of birth


=TODAY() helps in dynamic update everyday.

Use can use “M” to calculate months and “D” to calculate days also!Better, isn’t it?!