B
Bob Arnett
I have a table in which there is a column that has the persons date of birth
and another with their date of death (if they have died). I'm trying to have
a column that shows the persons current age or their age at death. The
formula I have entered is:
=IF(ISDATE(Table1[[#This Row],[DEATH]]),DAYS360(Table1[[#This
Row],[DOB]],Table1[[#This Row],[DEATH]]),DAYS360(Table1[[#This
Row],[DOB]],TODAY())/360)
but it only gives the result " #NAME? " for each record.
What would be the correct formula for this field?
and another with their date of death (if they have died). I'm trying to have
a column that shows the persons current age or their age at death. The
formula I have entered is:
=IF(ISDATE(Table1[[#This Row],[DEATH]]),DAYS360(Table1[[#This
Row],[DOB]],Table1[[#This Row],[DEATH]]),DAYS360(Table1[[#This
Row],[DOB]],TODAY())/360)
but it only gives the result " #NAME? " for each record.
What would be the correct formula for this field?