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