ProAdmin has many different parameters for the calculation of ages for annuity factors and payment forms. Each of the available options is described below, using the notation Y, M, D for year, month, day and the subscripts 1 for the date of birth, and 2 for the calculation (i.e., “as of”) date.

 

Age Nearest calculates age in whole years based on this formula:

Step 1: (Y2 – Y1)

Step 2: If D2 < D1 Then {(M2 – M1 – 1)/12} Else {(M2 – M1)/12}

Step 3: Step 1 + Step 2 + .5

Step 4: Truncate the result of Step 3

For example, using 09/15/1960 as the date of birth and 03/01/2011 as the commencement date, age nearest would be calculated as:

Step 1: (2011 – 1960) = 51

Step 2: (3 – 9 – 1) / 12 = -0.5833

Step 3: 51 + -0.5833 + .5 = 50.9167

Step 4: 50

50 years old as of 03/01/2011

 

Last Birthday (only available if no Interpolation of annuity factors/payment forms) calculates age in whole years based on this formula:

Step 1: Y2 – Y1

Step 2: If M1D1 > M2D2 Then Step 1 – 1 Else Step 1

For example, using 09/15/1960 as the date of birth and 03/01/2011 as the commencement date, integral age last birthday would be calculated as:

Step 1: 2011 – 1960 = 51

Step 2: 09/15 > 03/01 (51 – 1) = 50

50 years old as of 03/01/2011

​

Options available with linear interpolation of annuity factors/payment forms:

Years and Completed Months calculates age in whole years and months based on this formula:

Step 1: (Y2 – Y1)

Step 2: (M2 – M1)

Step 3: (D2 – D1) / 365.25

Step 4: If Step 3 < 0 Then (Step 2 – 1) / 12 Else (Step 2 / 12)

Step 5: Step 1 + Step 4

For example, using 09/15/1960 as the date of birth and 03/01/2011 as the commencement date, age in years and completed months would be calculated as:

Step 1: (2011 – 1960) = 51

Step 2: (3 – 9) = -6

Step 3: 1 – 15 / 365.25 = -0.03833

Step 4: (-6 – 1) / 12 = -0.58333

Step 5: 51 + -0.58333 = 50.41667

50 years and 5 months old as of 03/01/2011

 

Years and Nearest Months has two optional methodologies: Assume 30 days per month or Use exact days in the month (the default). You can select the methodology in Plan Definition > Plan Attributes > Miscellaneous Parameters. 

  i.  Assume 30 days per month calculates age in whole years and months based on this formula:

Step 1: Y2 – Y1

Step 2: M2 – M1 – 1

Step 3: 31 - MIN(30, D1)

Step 4: MIN(30,D2) – 1

Step 5: Step 3 + Step 4

Step 6: If Step 5< 15 Then Step 2 Else If Step 5 > 14 and < 45 Then Step 2 + 1 Else Step 2 + 2

Step 7: Step 6 / 12

Step 8: Step 1 + Step 7

NOTE: One day is subtracted in Step 4 to be consistent with the assumption that you are exactly N years and 0 days old on your birthday.

For example, using 09/15/1960 as the date of birth and 03/01/2011 as the commencement date age in years and nearest months, assuming 30 days per month, would be calculated as:

Step 3: 31 – 15 = 16

Step 4: 1 – 1 = 0

Step 5: 16 + 0 = 16

Step 6: -7 + 1 = -6

Step 7: -6 / 12 = -0.5000

Step 8: 51 + -0.5000 = 50.5000

50 years and 6 months old as of 03/01/2011

  ii.  Use exact days in month calculates age in whole years and months based on this formula:

Step 1: Y2 – Y1

Step 2: If D1 > D2 Then M2 – 1 And D2 + Days in previous month Else M2 and D2

Step 3: M2 – M1

Step 4: If (D2 – D1) > 14 Then Step 3 + 1 Else Step 3

Step 5: Step 4 / 12

Step 6: Step 1 + Step 5

For example, using 09/15/1960 as the date of birth and 03/01/2011 as the commencement date, age in years and nearest months using the exact number of days in the month would be calculated as:

Step 1: (2011 – 1960) = 51

Step 2: (9 > 3) THEN (3 – 1) And (1 + 28) =

Step 3: 2 – 9 = -7

Step 4: (29 – 15) = 14

Step 5: -7 / 12 = -0.5833

Step 6: 51 + -0.5833 = 50.4167

50 years and 5 months old as of 03/01/2011

 

Years and Started Months calculates age in whole years and months based on this formula:

Step 1: (Y2 – Y1)

Step 2: (M2 – M1)

Step 3: If (D1 >= D2) or ((D2 = End of Month And D1 = End of Month)) Then Step 2 Else Step 2 + 1

Step 4: Step 3 / 12

Step 5: Step 1 + Step 4

For example, using 09/15/1960 as the date of birth and 03/01/2011 as the commencement date, age in years and started months would be calculated as:

Step 1: (2011 – 1960) = 51

Step 2: (3 – 9) = -6

Step 3: (1 < 15) = -6

Step 4: -6 / 12 = -0.5000

Step 5: 51 + -0.5000 = 50.5000

50 years and 6 months old as of 03/01/2011

 

Years and Full Months calculates age in whole years and months based on this formula:

Step 1: (Y2 – Y1)

Step 2: (M2 + 1 – M1) / 12

Step 3: Step 1 + Step 2

For example, using 09/15/1960 as the date of birth and 03/01/2011 as the commencement date, age in years and full months would be calculated as:

Step 1: (2011 – 1960) = 51

Step 2: (3 + 1 – 9) / 12 = -0.4167

Step 3: 51 + -0.4167 = 50.5833

50 years and 7 months old as of 03/01/2011

​

Exact Age calculates age in whole years, months and days based on this formula:

Step 1: (Y2 – Y1)

Step 2: (M2 – M1) / 12

Step 3: (D2 – D1) / 365.25

Step 4: Step 1 + Step 2 + Step 3

For example, using 09/15/1960 as the date of birth and 03/01/2011 as the commencement date, exact age would be calculated as:

Step 1: (2011 – 1960) = 51

Step 2: (3 – 9) / 12 = -0.5000

Step 3: (1 – 15) / 365.25 = -.03833

Step 4: 51 + -0.5000 + - .03833 = 50.46167

50 years, 5 months and 14 days old as of 03/01/2011