Calculating age between two dates

I am trying to calculate the age for an actor based on their date of birth and their date of death. For actors who are still living, I want to use today’s date as a variable for their current age. For actors who are no longer living, their date of death is the determinant for their final age. What do I do?

This formula will use today’s date if the {Date of Death} field is left blank.

IF(
   {Date of Birth},
   DATETIME_DIFF(
      IF(
         {Date of Death},
         {Date of Death},
         TODAY()
      ),
      {Date of Birth},
      'years'
   )
)
1 Like

This formula worked very well for most records except for one thing: when the field {DIED} is filled, I need a formula to take care of one field {AGE @ DEATH}. How would I do this?

Rod Myers

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.