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 réponses

Réponse 1 / 2
tyranausor Posted messages 3501 Registration date   Status Membre Last intervention   2 060
 
Hello, your formula is good but you're missing dateval. You can set it like this example
2
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