IF function using a dates as the qualifier..

[Qaspec]

How do I write in a fomrula If (Jan 31st 2005 is greater than Today then
(-----) otherwise (------))

Thanks

 

[N Harkawat]

=if(date(2005,1,31)>today(),(---),(---))

N Harkawat

 

[Peo Sjoblom]

=IF(DATE(2005,1,31)>TODAY(),"Do This","DoThat")


Regards,

Peo Sjoblom