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?