Comparing 2 Dates

  • Thread starter Thread starter JWeaver
  • Start date Start date
J

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!!
 
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.
 
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
 
Back
Top