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

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!

1 Like

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