Find Age Of A Person Based On DOB In Excel

Sunday, April 14, 2013 2 Comments A+ a-

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.

2 comments

Write comments