Previous Topic Next Topic

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 responses

Answer 1 / 4
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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
Answer 2 / 4
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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
Answer 3 / 4
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
Answer 4 / 4
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
calculating fuel surcharge
Nancy -
xpcman -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response