How do add columns showing dob and years to work to give a retire.

[Claire Le Monnier]

I have a column showing date of birth and a column showing at what age they
retire, 50, 55, 60. How do I add up the two to get a retirement date?
Many thanks
Claire

 

[Frank Kabel]

Hi
something like
=DATE(YEAR(A1)+50,MONTH(A1),DAY(A1))

--
Regards
Frank Kabel
Frankfurt, Germany

im Newsbeitrag
news:[email protected]...