Awwww mannn!!! You're so awesome!!! I finally have an answer to share with the Captain before it's too late. Thaaaannnnk yooouuuu sir!! Much appreciated.Please see flow points, below.
View attachment 20971
You will hit mandatory retirement at age 62 per Title 10, U.S. Code, Section 14509, 14703, 12308.
You will also get kicked out at 28 years of commissioned service which also gets some people. Because of my age, I can stay in the Reserve as an O4 until I reach 62
If you 2XFOS for O4 you will be ADSEP'd but can request a Continuation Board. I know at least two people (both 1835's) who have been ADSEP'd from the Reserve because they did not make O4 after their second try.
Best way to track all this this is with a spreadsheet (See attached). Download. In B2 enter your commission date (YYYY-MM-DD). Then, drag that value down to B30 so that B3, B4, etc. increment by one year. Enter your age in D2 and drag that value down to D30. In E2 enter your current total years of qualifying service as of your commissioning date. Drag that value down to E30. After this, adjust the yellow row at row 30 and instead highlight the row where you are 62.
This will give you an idea of how old you will be at certain time frames as well as when you will be eligible for promotion to O4.
I took a swag at your age and assumed you will get commissioned in 2020. Based on those, I filled in the spreadsheet for you as a good swag. The only thing that will change is your commission date for O3/LT. Mine changed by a month or so, but this is still good swag.
Looks like you will hit ~25 years of commissioned service before mando retirement at 62.
View attachment 20973