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
305 2
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

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
18 - Pluto

`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.

2 Replies 2
18 - Pluto

`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.

5 - Automation Enthusiast

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