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
Unknown
AUTHOR
20 April 2013 at 15:35 delete

Very good job , it is easy to understand :)

Reply
avatar
Unknown
AUTHOR
3 May 2013 at 19:45 delete

Thanks Popov for your comment...!!

Reply
avatar