We use SharePoint Online and need a simple way to display the age of our clients based on the entered birth date in a Date Time Field. I have tried this "Work Around" https://abstractspaces.wordpress.com/2008/05/19/use-today-and-me-in-calculated-column with no luck.

Does anyone have a simple way to accomplish this?


TRY THIS on your Calculated Column Age

=ROUND(((TODAY()-[Column Name])/365),0)&" Years"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.