Start Free Trial

asked on

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!

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial