# Determining AGE OF DEATH

Topic Labels: Scripting extentions
1142 5
cancel
Showing results for
Did you mean:  4 - Data Explorer

I have a formula that calculate’s a person’s age. The problem that I’m having is that when information is entered for ‘Died’, nothing is entered for 'Age of Death’.![Actors|690x225]

What can I do to correct this?

5 Replies 5  10 - Mercury

Please share the formula. Your image didn’t post - probably because you’re new to the community.  4 - Data Explorer

Here is the formula in question:
IF( {BORN}, DATETIME_DIFF( IF( {DIED}, {DIED}, TODAY() ), {BORN}, ‘years’ ))  13 - Mars

Hi @Rod_Myers1,

You don’t need the first IF statement. So the formula would just be

``````DATETIME_DIFF( IF( {DIED}, {DIED}, TODAY() ), {BORN}, 'years')
``````

This will do the following:

If there is a date in Died, the IF formula will return Died and will calculate the difference between Died and Born.

If Died field is empty, the IF will return Today() and will calculate the difference between Born and Today.

BR,
Mo  4 - Data Explorer

It worked well–thank you very much. I have a problem of using a field for AGE OF DEATH. Is there a formula that would fill that field when DIED is filled?  13 - Mars

The above formula is already calculating that. I don’t understand? 