Harlan Grove wrote:
....
If the Yes/No(/Other?) were in A3, the two dates in B3 and C3, and the
result in D3, then use the following formula in cell D3.

=IF(AND(A3="Yes",MIN(B3,D3)DATE(2008,7,5)),"GO", "NO GO")

Sorry, typo, should be

=IF(AND(A3="Yes",MIN(B3,C3)DATE(2008,7,5)),"GO"," NO GO")

If you also want to trap blank cells, change this to

=IF(AND(A3="Yes",MIN(N(B3),N(C3))DATE(2008,7,5)), "GO","NO GO")