How do i set up a sheet to count the years to retirement?

[dee29]

I'm currently rying to put together a work sheet which will allow me to input
a date of birth and todays date to give me age today to the nearest 1/2 year
and the number of years to retirement aswell as the retirement date if i
input the anticipated age of retirement

 

[Bob Phillips]

See http://www.cpearson.com/excel/datedif.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)