Calculate Age from Birthdate

Amanda MedinaIW

Hello,

How do I calculate a person's age from their birthdate?

jmyzk_cloudsmart_jp

Hi @Amanda MedinaIW

=YEAR(TODAY()) - YEAR(Birthdate@row)

https://app.smartsheet.com/b/publish?EQBCT=e70b76df9b0149bcb3307119f6652946

jmyzk_cloudsmart_jp

Hi @Amanda MedinaIW

=YEAR(TODAY()) - YEAR(Birthdate@row)

https://app.smartsheet.com/b/publish?EQBCT=e70b76df9b0149bcb3307119f6652946

KPH

I typically use

=INT((TODAY() - Birthdate@row) / 365.25)

TODAY() - Birthdate@row

takes today's date and subtracts the birthdate to return the age in days.

/ 365.25

divides the days by 365.25 to get ages in years.

INT

returns the integer (whole years).

This is not perfect as each year is not 365.25 days but is close enough for most needs.

Amanda MedinaIW

Solved! Thank you!