=IF(INT(that_date)=another_date,"good","bad")

--
HTH

Bob Phillips

"Todd F." wrote in message
...
I have a date time value in a cell

It appears in cell as "1/1/04 18:00

In formula bar it appears as " 1/1/2004 6:00:55 PM

I need to do calcs on this in excel - if date is = " another date I try
toi enter" then good, bad

not having any luck

thanks for your time.