Forum Discussion
Formula for calculating age
Looking for a formula to calculate someone's age given their birthday and current date. I am tracking program participants in an Excel worksheet and have their birthdays. I need to know their ages at given points in the year. Is there a formula that I could use to calculate their age every time the worksheet is opened?
Thanks for any advice!
Thanks - both ways worked!
AmyMi , you are welcome
AmyMi It depends a bit on how accurate you want to be. You could use a formula like:
=(TODAY()-birth_date)/365
or
=YEARFRAC(birth_date,TODAY())
Replace birth_date with the cell reference that contains the birthday.
I like this sample if only "Joe age is 72 years 3 months and 17 days" is practical.
It has the air of somewhat spurious accuracy and occupies 3 cells. Nevertheless, I thought it interesting to show that the formula works. Maybe
= TEXTJOIN("yrs, ",, DATEDIF(DoB, TODAY(), {"y","ym"}) )&"mths"giving "72yrs, 3mths" in a single cell would be more practical.
