Lists Formulas For Calculate Age From Date of Birth

Hi, In the below list I have a column labeled 'DoB (Date of Birth)' and another column labeled 'Age". How do I make the calculated age based on the date of birth automatically populate the 'age' ...

formula

Lists

jinibob

Copper Contributor

Aug 09, 2022

Hi,

Thanks for the info. Where do I need to paste the above code that you have kindly provided?

Thanks

ganeshsanap

MVP

Aug 10, 2022

jinibob Addition to above all responses, Here's Microsoft official documentation on this topic which might help you:

Use column formatting to customize SharePoint

Note: column (JSON) formatting only customizes display of list view to show the formatted value. It does not store/save actual value in column. So, you will not be able to apply sort/filter based on these values in list view.

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Forum Discussion

Lists Formulas For Calculate Age From Date of Birth

Resources