Finding the date in a table when one value first exceeds another.

[Rich P]

I have a table with three columns which show a date, balance owed and savings
respectively. I’m trying to find a cell formula that returns the date of the
first instance where the savings exceeds the balance, i.e. gives me the date
I could pay the balance off. In this example it would be 01/05/08.

01/01/08 65000 62000
01/02/08 64500 62260
01/03/08 64000 62520
01/04/08 63500 62780
01/05/08 63000 63040
01/06/08 62500 63300

At present I have a formula in a fourth column saying =if(Cn>Bn,An,"") then
in my cell put the formula =min(D1100). This works but is there a neater
way without having the fourth column?

 

[Max]

Assuming data within A2:C7
Try, array-entered (press CTRL+SHIFT+ENTER) in say, D2:
=MIN(IF(C2:C7>B2:B7,A2:A7))