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
Aug 29, 2021 05:11 AM
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!
Aug 29, 2021 06:43 AM
If the birth year is a number field …
YEAR(TODAY()) - {birth year}