I am trying to categorize data within 2 dates.

For example, if date is on or before 7/18/13, I want to categorize it as "Past Due".

I've tried the following formulas but it's not calculating all my data correctly:

=If(X2>7/18/2013,"Past Due","Other")

=IF(X2>"7/18/2013","Past Due","Other")

I've even tried TEXT(X2,"MMDDYYYY") for the X2 value.

What am I doing wrong?

It's categorizing dates after 7/18 as "Past Due" and vice versa.