GETSSRD

Determines a Person’s Social Security Retirement Date (SSRD), based upon type and law year in accordance with the following:

For law years prior to 1984: age 65

For law years on or after 1984: full retirement age is based on calendar year of birth as follows:

  • 1937 or earlier: 65
  • 1938: 65 and 2 months
  • 1939: 65 and 4 months
  • 1940: 65 and 6 months
  • 1941: 65 and 8 months
  • 1942: 65 and 10 months
  • 1943-1954: 66
  • 1955: 66 and 2 months
  • 1956: 66 and 4 months
  • 1957: 66 and 6 months
  • 1958: 66 and 8 months
  • 1959: 66 and 10 months
  • 1960: 67
Formula Syntax

GETSSRD(CalcType, LawYear)

CalcType: this indicates how Social Security Retirement Date is to be calculated as follows:

  • 0: if a person is born on January 1, use the prior year for determining the retirement age (this is the method used by the Social Security Administration).
  • 1: only look at year of birth (regardless of whether or not that Person was born January 1) when calculating SSRD.

LawYear: the law year to be used in the determination of SSRD (see above).

Examples

GETSSRD(0, YEAR(CALCDATE)) calculates SSRD using the method used by the Social Security Administration using the law in effect as of the calculation date.

GETSSRD(0, MAX(1984,YEAR(CALCDATE))) calculates SSRD using the method used by the Social Security Administration always using at least the current law.

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com