Comparing Dates in EXCEL IF STMT..HARD ONE!!

[WOWO10]

I am using a specified date in a cell (C3) and comparing it to set dates to deterimine which rate table to use. However, I am not able to get C3 to be read as a date and compared as a date.
I have tried formating the cell as a date

any tips?


=IF($C3<&quot;#7/1/2002#&quot;,VLOOKUP($H3,SFY2002_Rates,4,FALSE),IF($C3<&quot;#6/30/2003#&quot;, VLOOKUP($H3,SFY2003_Rates,4,FALSE),&quot;CHECK WARRANT DATE&quot)

 

[RickSpr]

This forum is for VBA coding in Microsoft Access. You should probably post this in the Microsoft Office forum.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein