Remaining Retirement Calculation [Solved/Closed]

Report
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
-
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
-
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

Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
6
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
761
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"
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
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
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
6
hehehe

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

Let Me Try This Sir :)
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
6
Awesome Sir...............

Too Good :)

Thanks Alot :)

Regards,
Naeem