working with amortization table. i am plugging in various payments greater
than minimum ot amortize. I have a formula, that places the row number in
col g, where the ending balance is <=$0. I then want to use that row number
and go over two rows to pick up the date field.

e.g., if loan in paid off on payment 148 and that date is 8/01/2009, that
date is what I want to place at the top of the form for "Payoff Date..."

can not seem to get the correct date returned?