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...
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.