If I put the date 31/12/2013 in A1 and another date 1/1/2014 in A2 then a formula like <pre class="prettyprint"><code> =A1<A2 </code></pre> gives the expected result, TRUE. If I put the formula <pre class="prettyprint"><code>=A1<1/1/2014 </code></pre> in another cell, it gives the result FALSE. The question is how to adjust the second formula to make it give the correct result, and why it doesn't work as it stands. I've been looking at this for a while and have found some related posts like Comparing computed dates with entered dates but not one which directly answers the question.

<code>1/1/2014</code> is 1 <code>divided</code> by 1 <code>divided</code> by 2014. Instead; <code>=A1<DATEVALUE("1/1/2014")</code>

Date comparison not working in Excel formula

If I put the date 31/12/2013 in A1 and another date 1/1/2014 in A2 then a formula like

 =A1<A2

gives the expected result, TRUE.

If I put the formula

=A1<1/1/2014

in another cell, it gives the result FALSE.

The question is how to adjust the second formula to make it give the correct result, and why it doesn't work as it stands.

I've been looking at this for a while and have found some related posts like

Comparing computed dates with entered dates

but not one which directly answers the question.

260

asked Oct 09 '14 12:10

1/1/2014 is 1 divided by 1 divided by 2014.

Instead; =A1<DATEVALUE("1/1/2014")

141

answered Oct 18 '22 23:10

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!