Excel Functions in EAC ToolsExcel Functions in EAC Tools\Life expectancy and survival functionsLife expectancy and survival functions\EAAD

EAAD

EAAD calculates the expected age at death for a life 𝑥 based on the mortality assumption. Expected age at death = current age + life expectancy.

Syntax

EAAD (CurrentAge, MortalityTable, [AgeSetback], [TypeOfCalc])

Parameter Name

Description

CurrentAge

Current age 𝑥. May be provided as an integer, or as a fractional amount (e.g. years & months).

MortalityTable

Mortality table definition text string.

AgeSetback

Mortality table age set-back. A negative number is a set-forward.
Note that you can also define a setback using the "/sb" option in the table definition (or "/sf").
Optional, default = 0.

TypeOfCalc

Type of life expectancy calculation.
Optional, default = 0.

Type

Description

0

complete life expectancy

curtate life expectancy + 1/2

 + 1/2

1

curtate life expectancy