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.

Help calculating age (since date)

Topic Labels: Formulas
Solved
Jump to Solution
305 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello, I’m trying to get a formula working to determine age in years with one decimal place. The date is in a column called “Created”, the formula I’ve got is:

DATETIME_DIFF(TODAY(), Created,'years') & ' years'

Can anyone help add the decimal place so the result for example is “1.2 years”?

Thank you.

1 Solution

Accepted Solutions

DATETIME_DIFF will only return whole years. It will not return a decimal. If you want a decimal, you should find the age in months or days, and then convert the result to years manually.

See Solution in Thread

2 Replies 2

DATETIME_DIFF will only return whole years. It will not return a decimal. If you want a decimal, you should find the age in months or days, and then convert the result to years manually.

Thanks for the suggestion, if possible I’ll avoid overcomplicating it, so I decided to just make it count the number of months.