Help

Formula for Age only with Year of Birth

Topic Labels: Formulas
1140 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jennifer_Carmo
4 - Data Explorer
4 - Data Explorer

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}