IF function using a dates as the qualifier..

Qaspec · Jan 19, 2005

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

Thanks

N Harkawat · Jan 19, 2005

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

N Harkawat

Peo Sjoblom · Jan 19, 2005

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

Regards,

Peo Sjoblom