Entering Days360 in Table formula

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?
 
L

Luke M

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")
 
N

Niek Otten

You are right Luke,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Luke M said:
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 said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top