Date Formula Question

[lilsnoop]

I'm attaching a file that has comments to explain better than I can just in paragraph form. But I'm trying to locate a formula I could use to compare individually a column of dates (A6 thru A50) with constant date (G3) and depending if the individual dates in Column A are less that G3, to provide me with a result on one of two wages. My formula doesn't seem to work though.

Any suggestions would be greatly appreciated!

[Paul]

Unless I'm missing something, you're formula just needs a slight tweaking.. you're testing to see if G3 is less than your column A values.. but you stated that you want to see if your column A values are less than G3.. so, change your formulas in column B to:

=IF(A6<$G$3,$D$3,$E$3)

Yours was =IF($G$3<A6,$D$3,$E$3), which would work if you switched around the $D$3 and $E$3.