comparing dates cells

[ben]

I'm comparing a date from one cell to a date within my
formula. I've tried using datevalue but that doesn't work
either. How do you do this?

My formula reads as:

=IF(A2>1/1/2003, "yes", "no")

Where A2 is an entered date ie: 5/1/2003

Thanks,
Ben

 

[EZ Money]

=IF(A2>"1/1/2003","yes","no")

 

[ben]

I tried doing the example you gave but that is not working.

thanks

ben

 

[Lance]

=IF(A2>DATEVALUE("01/01/2003"),"yes","no")

-----Original Message-----
I tried doing the example you gave but that is not working.
.

 

[EZ Money]

I meant to say"...Copy an empty cell, then your SELECT data..."

 

[Dave Peterson]

One more way:

=if(a2>date(2003,1,1),"yes","no")

I like date(year,month,day). It's unambiguous and I don't want excel guessing
at my dates. (especially if I share the workbooks with others.)