Entering Days360 in Table formula
 

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?

Entering Days360 in Table formula
 

I don't believe "ISDATE" is a true function (unless this is an update in xl
2007?).
Based on what your goal is, I would recommend:

=DATEDIF(Table1[[#This Row],[DOB]],IF(ISNUMBER(Table1[[#This Row],
[DEATH]]),Table1[[#This Row],[DEATH]],TODAY()),"y")


--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Bob Arnett" wrote:

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?

Entering Days360 in Table formula
 

You are right Luke,

ISDATE() is not a built-in worksheet function in Excel 2007

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Luke M" wrote in message
...
I don't believe "ISDATE" is a true function (unless this is an update in xl
2007?).
Based on what your goal is, I would recommend:

=DATEDIF(Table1[[#This Row],[DOB]],IF(ISNUMBER(Table1[[#This Row],
[DEATH]]),Table1[[#This Row],[DEATH]],TODAY()),"y")


--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Bob Arnett" wrote:

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?