Find Age Of A Person Based On DOB In Excel

Today, I am going to share with you an interesting set of formula which can be used to find the exact age of a person based on DOB.

You can used below excel formula exactly on your excel sheet to find the age of a person.

=TEXT((NOW()-B2)&""," yy ""Years"" m ""Months"" dd ""Days""")

In above example you can assume that you have mentioned your DOB in B2 column. To enter current date in your excel sheet you can use CTRL+; shortcut key. It will insert current date in system format after that you change this date in your DOB.