I am trying to write a formula that will return the date at which a loan reaches a $1,500 threshold or less. The formula needs to look at column F, find the first dollar amount less than 1500 and return the date that is on the same line as that value.

My dates are in column B. My Loan Ending Balance is in column F. I figued this would be sooo easy, but I just can't seem to make anything work!

Does any one have an idea for me?
Thanks for any help!