View original (French)

If one date is later than another

Solved
cindy -  
 cindy -
Hello,

I have two dates in two different columns.
I want to indicate if one is greater than the other.
My idea was:
=IF(A1>A2,"FALSE","")

Let’s assume:

A1: 12/06/2013
A2: 15/08/2010

What do you suggest?

Thank you in advance.

Configuration: Windows Vista / Firefox 35.0

2 answers

  1.
    tyranausor Posted messages 3501 Registration date   Status Member Last intervention   2 060
     
    Hello, your formula is good but you're missing dateval. You can set it like this example
    2
    1. cindy
       
      I don't understand the example. Should I write:
      =IF(DATEVALUE(A1)>DATEVALUE(A2),"FALSE","")?

      If that's the case, it's false because it shows #VALUE, just like
      =IF(A1>DATEVALUE(A2),"FALSE","")

      To be honest, I have 1086 rows, so I don't plan to rewrite the dates.
      0