How to do Excel date comparison

Hi,

I am trying to do a  date comparison in Excel 2010. I have a column of order dates. I am trying to determine if the order date is before 4/14/2014.  If column  A2 has an order date 6/10/2010 and I do the following formula in cell B2:   =A2<4/14/2014, I get FALSE.  If I change the formula in B2 to: = A2< Today()  I get TRUE. How can that be when both TODAY() and 4/14/2014 are both later than  6/10/2010?

Is this a date formatting issue?

Please advise.

Thanks!