
Hi @Samantha Winyard ,
Based on your description, I tested and there are a few cases where the calculated value only returns 54, please check that you don't have any of the following:
1.I suggest you check that you added JSON to the Age column. I accidentally added JSON to the date column and found that the return value was 54.
2.If you didn't fill in the date of your birthday first, you added JSON to the age column. Age will only return to 54. Not even if you add a date value later.
Second, if the column is okay, please try this JSON:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"elmType": "div",
"txtContent": "=floor((Number(@now)-Number([$DOB]))/(1000*60*60*24*365))"
}
Note: My DOB column is a date and time column that doesn't include time. Add JSON to the Age column.
This JSON works fine in my environment:
Third, if SharePoint JSON still doesn't work, we can try using calculated columns to show the age.
Column Settings > Columns > Create a new column:
Formula:
=DATEDIF([DOB], TODAY(), "Y")
It also returns the correct 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.