Help calculating age (since date)

[ianonline]

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.

[kuovonne · Accepted solution]

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.

[ianonline]

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