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