Here's the formula:

=IF(B6<DATE(2006,6,1),IF(G6<=40,G6*35,(40*35+((G6-40)*35*1.5))),IF(G6<=40,G6*$F$2,(40*37+((G6-40)*$F$2*1.5))))

This formula calculates correctly, so that's not the issue. I'm wondering
if there is a clearer (more concise) way to accomplish the calculation I'm
trying to do, without using helper columns.

Here's the scenario: for dates prior to 6/1/2006 the client's billing rate
is $35/hr, with 1.5x for any hours over 40 hrs per week, and, for all dates
after 6/1/2006 the client's billing rate is $37 per hour with 1.5x for any
hours over 40 hours per week.

Any ideas?