e.g.

=IF(AND(A1>="08/01/05"+0),(A1<="07/01/07"+0),"U-8","U-10")

So if date is in range U-8 displayed, else U-10 is displayed.

Is that what you mean?