Wm Allen Smith

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!

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

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**