Retirement formula

Hi all. I’m a little rusty in math so I have question. I’m trying to figure out a formula that will calculate how many years I have to work with a company before I can retire.

Now the catch is the company uses the 85 factor which is age at retirement + years of service = 85

I’d like to be able to put in age that a person started working with company and get the formula to calculate for me at what age I can retire to meet the 85 factor

If you wanted to enter the person's age when they started working at the company, you'd also need to include what date they started at the company. So if you entered their age when they started in A1, the date they started in B1, in C1 you could try:
=85-A1-(TODAY()-B1)/365

I tried that formula for myself but it doesn’t seem to work. It show me a number that’s def not the age when I would be able to retire

I kind of misread your original post, plus it says 2 things - you first said, to figure out a formula that will calculate how many years I have to work with a company before I can retire and then said, formula to calculate for me at what age I can retire to meet the 85 factor.

it seems based on what you are saying, if you want to know what age you can be to retire, you don't need to know what age you were when you started working there, just what date you started working there. So if you enter your hire date in cell A1, in cell B1 you could enter:
=85-(TODAY()-A1)/365

So if you started working on Jan 1, 2012, you could retire at age 76.84.

Am I understanding correctly?

I've also placed some conditioning on the retirement age as I did not want it to go past 65 as that is the official retirement age here. So the formulas account for the fact that if you would have to work past 65 to complete the factor 85 it stops at 65 and it also accounts and reduces the years to work up to age of 65.