Comparing 2 Dates

[JWeaver]

Hi All,

I need to compare a date in "Driver's License Expires" column to a specific
date like, 10/31/08, and if the expiration date is less than this date to put
an "X" in a separate column. I want to mark those rows where an employee's
driver's license has expired or will expire by 10/31/08.

I've tried using an IF statement but the results are not correct. It
doesn't appear that the full date is being compared.

Any help would be appreciated!!

 

[Gary''s Student]

=IF(A1<DATEVALUE("10/31/2008"),"X","")

 

[JWeaver]

I tried your formula but it resulted in a blank cell. The date being
compared to 10/31/2008 is 2/16/2007 and should have resulted in a X in the
cell but it is blank.

 

[Duke Carey]

Is A1 a real date or is it text?

Format the cell as a date, then press F2 followed by the Enter key and see
what happens