Problem with formula

[saulco]

I have the version 3 and I have a problem with this it formulates =if(date(21/11/01)=today ();A5=10;B5=-10)
It doesn't work, that that if it works it is
=if(date(21/11/01)=today () ;10;-10)
being that 10 are the true value and -10 is the false value. does it always put me the false value, what is it bad?

[MoonCactus]

Hmm, warning: DATE function syntax is described as DATE(day,month,year)... the expression "11/2/2001" may be is computed as two divisions?!

[saulco]

I change the " = " for " > " because never the number is exactly.

Now the formula work!!