Calculate Age from Birthdate

Amanda MedinaIW · 09/11/24

Hello,

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

jmyzk_cloudsmart_jp · 09/12/24

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

jmyzk_cloudsmart_jp · 09/12/24

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

KPH · 09/13/24

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 · 09/13/24

Solved! Thank you!

Best Answer