Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula for Age only with Year of Birth

Topic Labels: Formulas
220 1
Showing results for 
Search instead for 
Did you mean: 

Hello all,

I see a lot of answers for a formula to calculate the age with the DOB. but on my forms, I only ask people their Year of birth. Tried different formulas but can’t get one that works to calculate the age when I have available only the year of birth.

Any advice?

Thank you!

1 Reply 1

If the birth year is a number field …

YEAR(TODAY()) - {birth year}