I have a problem with if statement using date data.

today() = 8/5/2005

I put a formula =if(today()=8/5/2005,true,false)

it's displaying a false answer when it should be displaying true

Hope somebody help me with this. thanks!


--
japorms
------------------------------------------------------------------------
japorms's Profile: http://www.excelforum.com/member.php...fo&userid=6544
View this thread: http://www.excelforum.com/showthread...hreadid=393200