Retirement dates - How do I

Hi Peeps

Anyone know a quick and easy fromula to work out someones retirement date, i.e. if my date of birth is 15/06/1965 how do I add on 65years to show me retiring on 14/06/2030?

Many thanks if you can assist me

=DATE(YEAR(DoB)+65,MONTH(DoB),DAY(DoB))

Hi Bob

Thanks for your help, I don't know if its just me being thyick but I still can't get it to work.  Do I reference the bit where it says DATE to the cell where I put my Date of Birth?

Michael

No, DoB is the bit where you plug in your date of birth.

Another way of putting it, if your DOB is in cell A1 then

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