On Thu, 22 Sep 2005 09:56:02 -0700, "Todd F."
wrote:

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.

Assume your date is in A1 and the date you are comparing it to is in A2 and is
just a date (i.e. -- no time portion).

=IF(INT(A1)A2,"good","bad")


--ron