Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula that defines age at given day

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

Hey!

I´m new in this and also not much of a nerd :slightly_smiling_face:

I’m trying to create a database for recording athletes test results. I have one table for athletes and another for results. I want to determine the age of Athlete at the time of the test. In “results” table I have a testing day field

The “age at testing day” field should show the age in years or if possible the years + months (example
13 years 4 months)

I´m grateful for all the help

2 Replies 2

Hi @Mikko_Mantere - here’s how to do this:

Screenshot 2019-04-10 at 14.44.52.png

I’ve got 4 formula fields (you can hide the fields you don’t want to see):

Months:

DATETIME_DIFF({Date of Test}, {Date of Birth}, 'months')

Whole Years:

INT(Months/12)

Remainder Months:

MOD(Months, 12)

Age at test:

{Whole Years} & ' years ' & {Remainder Months} & ' months'

JB

SUPER!

thanks @JonathanBowen !