I'm trying to return new salary information based on a hire date. The
criteria is if you were hired on or before Jan. 1, 2005, you get 3% of the
mid-point of your current salary range. I have the spreadsheet set up as
follows:

A1 B1 C1 D1 E1
Current sal hire date PG mid-point new salary
40,950.00 12/15/03 15 52,460.00 ????

I was using the formula in E1:
=If(B11/1/05,(D1*.03)+A1,A1)

But when I entered a hire date that was after 1/1/05, it was still adding
the 3%. What am I doing wrong?