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?

1 Answer 1


TRY THIS on your Calculated Column Age

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

  • You are most welcome ;) Mar 4, 2016 at 12:04
  • 1
    FYI - putting in date of birth as 01/07/1979 as at 13/04/2020 returns 41 (it should be 40) Apr 13, 2020 at 0:43

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.