Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Table - Entering Value not in a table | Excel Discussion (Misc queries) | |||
days360 | Excel Discussion (Misc queries) | |||
Entering Variable in a Pivot Table | Excel Discussion (Misc queries) | |||
=DAYS360 | Excel Discussion (Misc queries) | |||
entering data to table | Excel Worksheet Functions |