Create an 'Age/Days old' column in SharePoint List

Hello Everyone is the issue already resolved? if not kindly reply my comment i wish to assist you all on this specific issue: you can email me in my outlook account: email address removed for privacy reasons

Please check below if this is the result you all need?

This is the formula i Used:

My source for the Service Years is my Date Installed Column.

Here's the formula:

=IF([Date Installed]="","",INT((TODAY()-[Date Installed])/365.25)&" Year(s)"&INT(MOD((TODAY()-[Date Installed])/365.25,1)*12)&"month(s) and "&INT(MOD((TODAY()-[Date Installed])/30.4375,1)*30.4375)&"day(s)")

Note: Please change the Date Installed for the column name that you want to formulate.

testio2 

If anyone still interested in getting the Age (in years) to display, here is the formatting that I've used

The Age column is a DateField in SharePoint and I specify the birthday in that field.

The column formatting then uses the following:

{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "=substring(toString(Number(@now-@currentField)/86400000/365),0,indexOf(toString(Number(@now-@currentField)/86400000/365),'.'))"
}

The value returned is a number with long decimal e.g: 41.17125147541258

I then use the substring and indexOf method to display a trimmed value e.g: 41

Hope it helps

Update

Have corrected the incorrect substring parameter used of 1

The correct parameter to use is: 0

Thanks to Norman Young for highlighting the error

testio2 you cannot do this using a calculated column, as it stores static information.

If you are using the modern experience in SharePoint Online, check out column formatting and view formatting. You'll need to use @now, which resolves to the current date/time.

Here are two references to get you started:

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#apply-formatting-based-on-date-ranges

https://techcommunity.microsoft.com/t5/SharePoint/Calculate-a-duration-in-column-formatting/td-p/293488

Hello testio2,

---

Is there anyway to have this automatic column that just shows a number of how old the item is?

Not using out of the box functionality. Consider using a Flow to update the Age column on a daily basis.

I hope this helps.

Norm