Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date Calculations
The easiest solution to my problem would be to locate an Excel spreadsheet for Federal Government Retirement calculations (FERS) but I can’t seem to find one. Barring that, I need help with calculations on my retirement worksheet. First, I need the formula to correctly calculate my adjusted retirement service start date subtracting out Government time which counted for on-the job benefits but not retirement benefits. I’ve already calculated the time for each individual non-credit time period involved (years, months, days format). I now need to take these non-credit time period totals and subtract them from my original Service start date (M/DD/YY format) and come up with an a new, adjusted service start date (in MM/DD/YY format). I would also like right formula to use to calculate an accurate retirement eligibility date. I am having trouble with accuracy (related to the 30 day months used by Excel in its calculations). Any suggestions would be appreciated. -- Jinglepaws ------------------------------------------------------------------------ Jinglepaws's Profile: http://www.excelforum.com/member.php...o&userid=25983 View this thread: http://www.excelforum.com/showthread...hreadid=393500 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search for latest date | Excel Worksheet Functions | |||
Date Calculations | Excel Worksheet Functions | |||
date and bond calculations | Excel Discussion (Misc queries) | |||
date and bond calculations | Excel Worksheet Functions | |||
Problems with date calculations (bank hols etc) | Excel Discussion (Misc queries) |