Excel Functions in EAC ToolsExcel Functions in EAC Tools\Regulatory limits and other functionsRegulatory limits and other functions\Social Security functionsSocial Security functions\SSDOBofSSNRAinYear

SSDOBofSSNRAinYear

SSDOBofSSNRAinYear returns the year of birth for which a person attains Social Security NRA in given year. The result is expressed as a date equal to January 2 of the year. This may look like a useless function, but it is used in the construction of the “Social Security Maximum Benefit Table” and in the SSMAx function.

A screenshot of a computer

Description automatically generated with medium confidence

Syntax

SSDOBofSSNRAinYear (RetirementYear)

Parameter Name

Description

RetirementYear

Year of Social Security benefit commencement, as a 4 digit number.