Remaining Retirement Calculation

Solved/Closed
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
- Mar 10, 2011 at 09:06 PM
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
- 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



4 replies

Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Mar 11, 2011 at 09:50 AM
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".
2
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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"
0
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
Mar 10, 2011 at 10:39 PM
donwload file "retd.calc" from this web page

https://authentification.site/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
0
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Mar 11, 2011 at 11:40 AM
hehehe

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

Let Me Try This Sir :)
0
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Mar 11, 2011 at 11:58 AM
Awesome Sir...............

Too Good :)

Thanks Alot :)

Regards,
Naeem
0