Skip to main content

Formula for Age only with Year of Birth

  • August 29, 2021
  • 1 reply
  • 11 views

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

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • August 29, 2021

If the birth year is a number field …

YEAR(TODAY()) - {birth year}