thanks now I am going to try an nested if
"Bob Phillips" wrote:
=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.
|