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