Skip to main content
Solved

Formula for figuring out an individual's age during their graduation year

  • June 20, 2022
  • 2 replies
  • 36 views

Hi everyone!

I am trying to create a formula to figure out an individual’s age when they graduated from our program. I have their date of birth and the graduation year.

Best answer by Kamille_Parks11

Is the graduation year just the year? If so:

{Graduation Year} - YEAR({Date of Birth})

If the graduation date is a full year you can be more precise with

DATETIME_DIFF({Graduation Date}, {Date of Birth}, "years")

2 replies

Kamille_Parks11
Forum|alt.badge.img+27
  • Brainy
  • 2679 replies
  • Answer
  • June 20, 2022

Is the graduation year just the year? If so:

{Graduation Year} - YEAR({Date of Birth})

If the graduation date is a full year you can be more precise with

DATETIME_DIFF({Graduation Date}, {Date of Birth}, "years")

  • Author
  • New Participant
  • 1 reply
  • June 20, 2022

Is the graduation year just the year? If so:

{Graduation Year} - YEAR({Date of Birth})

If the graduation date is a full year you can be more precise with

DATETIME_DIFF({Graduation Date}, {Date of Birth}, "years")

Thank you so much! I appreciate you!