Calculating days old in number format

Question

Hello,

I have a SharePoint List with the "Created" default column and I would like another calculated column "Days Old", that calculates the difference in days: [Today]-[Created]. I have found a solution for that (JSON column formatting) that works fine but the type of information is text. Is there any suggestion where I can calculate Days Old in a number format?

thank you in advance

Answer 1

@Eleni Kalkantzi

You could create a number type column, then use following formula in the number column JSON formatting.

{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "=floor((Number(@now )-Number([$Created]))/(1000*60*60*24))"
}

Result:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.