View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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?