Calculate my retirement date

[Joenash]

Hello,

I am trying to figure out a formula to calculate the date at which i will be retired (Age of 60) given my birth date.
can any body help?

Thanks in advance

[Carim]

Hi,

Take a look at a previous thread ...
http://www.excelforum.com/showpost.p...55&postcount=6

HTH
Carim

[Joenash]

Sorry, I dont get it
I need something simple ,
I have a cell with my Date of Birth, I need a formula next to it to tell me when (date) i will be 60 years old ?

Thanks alot, and sorry once more

[jasoncw]

Assuming your DOB is in A1, here is the formula:

=DATE(YEAR(A1)+60,MONTH(A1),DAY(A1))

[oldchippy]

Or assuming your DOB is in A1, here is the formula:

=DATEDIF(A1,NOW( ),"y") & " years, " & DATEDIF(A1,NOW( ),"ym") & " months, " & DATEDIF(A1,NOW( ),"md") & " days"

[oldchippy]

Try this link as well, but don't wish your life away!

http://www.fontstuff.com/excel/exltut01.htm

[Joenash]

Thanks alot for you all,

That really worked fine , you are the best

[oldchippy]

Glad to be of help - thanks for the feedback

[istiaque]

Assuming your DOB is in A1, here is the formula:

=DATE(YEAR(A1)+60,MONTH(A1),DAY(A1))

Thanks. It is working.