Using Dates in IF statements

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.

Try it like this:

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

The double-minus converts the text string into a date for the comparison, but it would be more robust if you did this:

=If(X2<=DATE(2013,7,18),"Past Due","Other")

Hope this helps.

Pete

I tried using a cell to hold the date but it didn't work.

Thank you, I think I have it working now

Your comparisons are the wrong way round if you want dates before X2 to return "Past Due" - i.e. the date is less than X2's date.

Hope this helps.

Pete