Hi, I'm creating a database of ages on people. What I need is to create a formula that will tell me how old they are on the current day; i.e. if a Person A's birthday is 2/27/80, then the Age Column will read "25" today (2/26/06). But when I open the file tomorrow (2/27/06) it will change to "26".
I.e. I don't want to manually have to update the Age Column. Is there a formula to do this?
So far I've come up with Column A=Birthday, Column B=Today's date (with the formula "TODAY()") and when I subtract A from B, it gives me a year, where the age is the last 2 digits. How can I take that number and convert it into the person's age?
Ex. 2/26/2006 - 8/18/1967 = 7/11/38. While the 7/11 is superfulous, 38 is the age. But how do I convert that number to state that?
Bookmarks