I put 1/18/1945 in B18, and =TODAY() in C18 and =67-(YEAR(C18)-YEAR(B18)) in
another cell and got 7.00 (with the right formatting)
--
Gary''s Student


"cdu311" wrote:


Hi Folks,

this is my first post here, could anyone help me out a bit, basically
what i am trying to do is to use excel to calculate maximum mortgage
term available to someone, for example, i want to input the persons
date of birth (23/07/75) and i want it to calculate the maximum term
they can have a mortgage for up to the maximum age 67. Do i make any
sense here. Whether the response comes through for excel or excel vb i
am willing to try anything.

Many Thanks

Lee Elliot



--
cdu311
------------------------------------------------------------------------
cdu311's Profile: http://www.excelforum.com/member.php...o&userid=27051
View this thread: http://www.excelforum.com/showthread...hreadid=468258