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.
Related Topics
PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com