Help

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

I need to create a formula for age based on date of birth

Topic Labels: Formulas
573 2
cancel
Showing results for 
Search instead for 
Did you mean: 

It’s pretty simple, but I’m new to this. I need a column that changes the age with the date of birth. So I know I have a columnn called AGE which should change when the child reaches a birthday in a roster. Any help so I can copy and paste a formula would be appreciated.

Thank you!

2 Replies 2

DATETIME_DIFF(TODAY(),{Birthday},'Year')

This formula outputs the age in years. You must have a field called Birthday where you have registered each persons birthdate.

Hope it helps.

//Martin

Thank you! That works!!

Antonia Lavender
310.803.6854
Antonia@AntoniaLavender.com