Get the Age of a person in Excel formula
Posted on 2002-06-07
Here is a neat little task that I need:
I have a persons Date of birth 06/29/70.
And I have todays date, lets say 06/07/02.
I need a formula that would return an Integer
that shows a persons Age - in this case 32 years old.
So, in A1 - DOB, in B1 Today's Date, in C1 - Formula.
You can give me few ways of doing it if you wish.
The most elegant formula wins.
Thanks a lot,