I need TO calculate: [DOB] + 85 YEARS - NOW() * [ANNUAL PAYMENT]
LIKE: 4/8/1951 +85 YEARS - 3/18/2017 = 19 (ROUNDED TO WHOLE YEARS) * $1,000.00 = $19,000.00
i CAN'T QUITE GET THE STRING RIGHT. I THINK I HAVE TO CONVERT [DOB].
thanks for your help.
John