Remaining Retirement Calculation [Solved/Closed]

Game Start Now 135 Posts Thursday January 21, 2010Registration date January 7, 2017 Last seen - Mar 10, 2011 at 09:06 PM - Latest reply: Game Start Now 135 Posts Thursday January 21, 2010Registration date January 7, 2017 Last seen
- Mar 11, 2011 at 11:58 AM
Hello Sir,

I Wanna Calculate Few Things

A1 Is My Date Of Birth
A2 Is My Date Of Joining


I Want Few Formulas Using These Two.

First Thing Is, Right Now How Old I Am. Like Formula Show The Answer That
24 Year 6 Months 3 Days.

And I Want The Second Thing.

How To Calculate Remaining Retirement Years, Days & Months From The Date Of Birth.

After 60 of Age Employee Retired.

And How To Calculate How Long He Worked From The Date Of Joining. Like I Want That Formula Shows

Current Date Minus Date Of Joining Then Formula Shows "3 Years 2 Months 12 Days.



Thanks In Advance



See more 

5 replies

Best answer
Game Start Now 135 Posts Thursday January 21, 2010Registration date January 7, 2017 Last seen - Mar 11, 2011 at 09:50 AM
2
Thank you
Not Working Proper...........

Suppose My Joining Is 11-Feb-2011

Then Worked So Far Should Show Me "00 Years 1 Month 00 Days"

But your formula shows me "00 years 1 months 28 days".

Thank you, Game Start Now 2

Something to say? Add comment

CCM has helped 1665 users this month

rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Mar 11, 2011 at 10:24 AM
Naeem, since you are not Bill Gate, I have to say that you are too young to retire. Get back to work like most of us and live pay check to pay check.

A1: DOB
B1: Join Date

This formula should tell you your age
=DATEDIF(A1,today(),"Y") & " Years, " & DATEDIF(A1,today(),"ym") & " months and " & DATEDIF(A1,today(),"md") & " days"

This should tell you retirement day (i am presuming that retirement date is one day before DOB ( else remove -1 from formula)
=DATE(YEAR(A1) +60, MONTH(A1), DAY(A1) -1)

This is how long you have to work before retirement date
=DATEDIF(TODAY(),DATE(YEAR(A1) +60, MONTH(A1), DAY(A1) -1),"Y") & " Years, " & DATEDIF(TODAY(),DATE(YEAR(A1) +60, MONTH(A1), DAY(A1) -1),"ym") & " months and " & DATEDIF(TODAY(),DATE(YEAR(A1) +60, MONTH(A1), DAY(A1) -1),"md") & " days"

This is how long you have already worked
=DATEDIF(B1,TODAY(),"Y") & " Years, " & DATEDIF(B1,TODAY(),"ym") & " months and " & DATEDIF(B1,TODAY(),"md") & " days"
venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Mar 10, 2011 at 10:39 PM
0
Thank you
donwload file "retd.calc" from this web page

http://www.speedyshare.com/files/27331897/retd_calc.xls

A1 and B1 are input data(so far they are sample data). change them

you get other information. see formulas in C1 and to right.

enter dates in A1 andB1 according to your regional configuration. in my area the dates are entered as m/d/yy
Game Start Now 135 Posts Thursday January 21, 2010Registration date January 7, 2017 Last seen - Mar 11, 2011 at 11:40 AM
0
Thank you
hehehe

Thanks Alot Sir, But My Boss Gave Me This Task.

Let Me Try This Sir :)
Game Start Now 135 Posts Thursday January 21, 2010Registration date January 7, 2017 Last seen - Mar 11, 2011 at 11:58 AM
0
Thank you
Awesome Sir...............

Too Good :)

Thanks Alot :)

Regards,
Naeem