On Thu, 22 Sep 2005 09:56:02 -0700, "Todd F." <ToddF@discussions.microsoft.com>
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