Greater Than in an IF(AND forumula

[kleeb03]

I know this should be easy, but i'm having no luck.

I want to say If column A is "N" and Column B is greater than 10-July-2011 display a Y

I would think it should be something like:

=If(And(A1="N",B1>10-JUL-11),"Y","N")

but this results in #NAME?
I know the problem is with my date, but i've tried everything i can come up with.

Please Help! Thanks

 

[Scott Huish]

=if(and(a1="n",b1>date(2011,7,10)),"y","n")

 

[kleeb03]

Thank you...I'm an idiot...I forgot the "" around the N.....too many hours on this computer.

Thanks again